Google Sheets

Jump to bottom

MrLou edited this page Sep 22, 2022 · 6 revisions

Using Google Sheets:

Make a copy of the Sheets template
In the "Intro" sheet provide Account IDs for Google Ads, Analytics, CM360, etc.
Configure source/input data in the "Sources" sheet
Configure destinations in the "Destinations" sheet

The "Help" sheet has a chart to document the required metadata for each use case.

Configure connections from Sources to Destinations in the "Connect" sheet
Make note of the Sheet's ID in the URL: docs.google.com/spreadsheets/d/EXAMPLEIDHERE/edit

Spreadsheet Configuration

All data upload rules are defined in a single configuration spreadsheet. The trix contains four tabs: Intro, Sources, Destinations, Connector:

Intro Tab: Holds basic, common information across upload rules
Sources tab: Holds the bigQuery location of each data source. Important: The schema of each bigQuery source table needs to perfectly match the expected schema of the destination type that will be used with:

Source Name: A friendly name for that source
Dataset: BigQuery dataset name
Table: BigQuery table name

Destinations Tab: Defines where the data should be send to - according to the destination type and expected metadata information

Destination Name: Friendly name of each destination
Type: The type of upload, limited to supported upload destinations
Metadata[1-6]: Additional required pieces of information expected by each destination type (details can be found at the corresponding destination type's wiki page)

Connect Tab: Responsible for mapping a source to a destination

Enabled (Yes/No): Disabled lines are ignored at runtime
Source: The friendly name of a Megalista source
Destination: The friendly name of a Megalista destination