Here are some guidelines to create a custom Data Source from a CSV file
Here is an example of CSV File properly formatted for an import. Note that:
A date column is mandatory (with proper formatting such as 2024-01-01). It should contain the YEAR, MONTH and DAY information.
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).
Mandatory requirement: at least one Campaign, Adgroup or Ad dimension is mandatory.
If you choose not to include a Campaign dimension, you will need to decide how Campaign names will appear in dashboards. You have two options:
Replicate the Ad or Adgroup name as the Campaign name.
Use a Custom Value that remains consistent for this data source.
How to create a new Custom CSV Data Source
In Workspace Settings under the Integrations section, click on CSV Source and upload the first file you want to integrate
Match the CSV columns to spyne’s data model
Click on Connect button
Save the email address that has been generated to further feed the data source (you can still access it at all times by clicking ‘Edit’ on your custom source)
Important notes:
The initial file import can be configured (skip rows, thousand separator, … ) but the following files should all have the same format
CSV sources work in “Incremental” mode. This means that every time you send a CSV file on the provided email address, the new data will be added to the existing. If some records are overlapping, the record in the latest file sent will be picked.
When you send a CSV file during the day, expect to see the data updated the next morning.
Sub dimensions such as Device, Gender, Country, Site … are currently not supported for CSV imports
Campaigns pacing (with dimensions such as Budget, Start Date, End Date) are not yet supported for CSV imports