Google Sheets
Attention! The Google BigQuery integration has to be enabled to use this feature.
Importing custom costs from Google Sheets
After enabling this data source, Google Sheets costs information will be uploaded to BigQuery once every 24 hours.
Connecting and configuring
The process of connecting data sources is described in detail in the overview.
After authorization you need to set the data source parameters.
(1) The name of the data source. It is displayed in the interface in the list of sources.
(2) Link to to google spreadsheet. Just copy-paste it from browser URL of spreadsheet table.
To save and enable the data source, click “Save” (3).
The “Disconnect” button (5) is used to revoke the authorization data. The settings are saved.
You can enable or disable the data source at any time (4).
Required Google spreadsheet structure
To import a Google spreadsheet, you must use the following table structure:
Column order is important.
| Field name | Description |
|---|---|
| date | Date in YYYY-MM-DD format |
| currency | Currency of report |
| utmMedium | UTM medium |
| utmSource | UTM source |
| utmCampaign | UTM campaign |
| utmTerm | UTM term |
| utmContent | UTM content |
| impressions | Impressions count |
| clicks | Clicks count |
| cost | Cost count |
You can use our spreadsheet template as reference.
Where to get data on custom costs
Custom costs from Google Sheets will be uploaded to customCosts_{ID} table.
Old data will be overwritten.
Custom costs table structure
| Field name | Type | Mode |
|---|---|---|
| cost | FLOAT | REQUIRED |
| clicks | INTEGER | NULLABLE |
| impressions | INTEGER | NULLABLE |
| utmTerm | STRING | NULLABLE |
| utmCampaign | STRING | NULLABLE |
| utmContent | STRING | NULLABLE |
| utmMedium | STRING | NULLABLE |
| utmSource | STRING | NULLABLE |
| currency | STRING | NULLABLE |