Importing a Google Sheet for standard sources
Here are some guidelines to create a Custom Data Source using a Google Sheet:
Here is an example of Google Sheet properly formatted for an import. Note that:
Only one tab can be imported as a source (and the name of this tab should not be modified after your set up your integration)
A date column is mandatory (with proper formatting such as 2024-01-01)
Several dimensions can be present in your file, and will have to be mapped against spyne dimensions (including Account Name, Account Id, Campaign Name, Campaign Id, Adgroup Name, Adgroup Id, Ad Name, Ad Id)
In your Google Drive, add the email [email protected] as a Viewer for the Google Sheet you want to sync. Make sure it is actually a plain Google Sheet, and not an .xls file viewed as a Google Sheet.
In Workspace Settings under the Integrations section, click on Spreadsheet Source and paste the URL of the Google Sheet you want to connect
Select the proper tab (in this example the campaigns tab)
Match the Google Sheet columns to spyne’s data model
Click on Connect button
Important notes:
Google Sheet sources work in “Full refresh” mode: each day, previous values stored in spyne’s databases will be dropped, and values in the Google Sheet will be imported
Modification in a Google Sheet will not immediately impact data in your dashboard: data is updated and processed once a day, usually early in the morning before office hours
Sub dimensions such as Device, Gender, Country, Site … are currently not supported for Google Sheet imports
Campaigns pacing (with dimensions such as Budget, Start Date, End Date) are not yet supported for Google Sheet imports
The 'Refresh' button for a CSV/GSheet source is only available the day after creation, not on the day of its initial creation.
A campaign name field is strictly required for the file to be accepted.
Importing a Google Sheet for non-standard sources
Some data sources don't fit the standard digital format Spyne connectors expect : offline TV, radio, or other "non-classic" media. You can still bring this data into Spyne through a Google Sheet source, using the method below.
TV is used as an example throughout this article, but the same method applies to any source with a non-standard structure.
Why standard mapping doesn't work here
For digital sources, columns map naturally onto Spyne's standard dimensions (Campaign, Adgroup, Ad...). Some sources don't have this structure : a TV campaign, for instance, might be described by channel, time slot, target audience, and other attributes that don't correspond to any standard field available in spyne. Trying to map each of these individually rarely works cleanly, so a different approach is needed.
Step-by-step process
Identify the dimensions you need to analyze your performance (e.g. channel, time slot, target audience, media type).
Concatenate them into a single column, using a clear and consistent separator (e.g. //) This column should contain dimensions only, never metrics.
When importing your sheet in Spyne, map:
Date column → Date dimension
Concatenated column → Campaign Name dimension
Metrics → their matching Spyne measure, via the Measure menu (e.g. Budget → Spend)
If a metric has no native equivalent in Spyne, map it as Conversion instead (e.g. GRP)
Any other column can be left unmapped
After the import, extract each dimension from the imported campaign name using Dimension Mapping, splitting the string on //.
Example
TF1//Prime Time//25-49//TV Offline
Your concatenated column should look like this with the chosen dimension and the separator. Later, you will be able to extract each dimension via the dimension mapping :
Channel : TF1
Time slot : Prime Time
Target audience : 25-49
Media Type : TV Offline
To understand how Dimension Mapping works, click here.