Introduction
With this integration, you can either:
- Write data to an existing spreadsheet: Choose which sheet to write to (gid parameter)
- Create a completely new spreadsheet: New file 'Sheet1' will be created and written to (gid=0)
Note: due to the nature of Google Sheets, traditional overwriting based on date is not currently possible, instead Mode: Truncate and Mode: Append are supported.
- Mode: Truncate - The most recent extract will always replace the entire existing content.
- Mode: Append - The most recent extract will always be appended (added at the bottom) of existing content.
Since both these options are not practical for daily data that can be subject to retroactive changes, the recommended option is to create a BUNDLE stream first, which collects all daily extracts from a Datastream and then imports it using Mode: Truncate.
- The API stream (e.g. Facebook Ads) should be set to the necessary time range, e.g. "Last 7 Days".
- The Bundle stream should be set to the necessary time range, e.g. "This Year" or "Fixed" + no end.
- The API stream (e.g. Facebook Ads) should be set to retain extracts by date.
- The Bundle stream should be set to retain extracts by fetch, and only retain 1.
Alternatively, Mode: Append could be used for append-only data, where each new extract will be added to the existing data set.
Create A Destination
- Create a Google Sheets Connection.
- Destination -> Add -> Google Sheets -> Select Connection.
- Select Mode: Truncate (Default) or Mode: Append.
- Define an output folder (Optional).
- Define a spreadsheet name for a new spreadsheet OR choose an existing spreadsheet and sheet.
- Save.
Schema Mapping
- By default, you are prompted to use Schema Mapping. You can use the defaults or create your own Data Schema.
- If no schema mapping is needed, this option can be deselected as well.
Sheet Names
Note: Each Datastream will automatically generate a separate sheet in the destination. The default name of the output file is datastreamtype_datastream-id e.g. adwords_83. A hyperlink to the sheet will appear as well next to the name with the first 8 characters of the sheet ID.
- Go to Manage Organizations and select the Destination for the required Organization.
- To configure a custom sheet name of a Datastream, select the Datastream in the left column and put a value in the right column.
- Allowed characters for Sheet Name are "a-z", "A-Z", "0-9", and "_".
- You can use the placeholders in the right column to configure dynamic sheet names:
- {id} - Datastream ID
- {app_label} - Datastream Type Short Name
- {name} - Actual Extract's name
- %Y - Year (YYYY)
- %m - Month (MM)
- %d - Day (DD)
Comments
0 comments
Please sign in to leave a comment.