Google Campaign Manager data source
Getting started
- Inside the admin panel navigate to the Data Sources page and click + NEW on the top right corner.
- Choose Google Campaign Manager from the list.
- Click Authenticate with Google and go through the authentication flow.
- Select Profile and a list of Sites whose cost data you would like to import.
- Click Save.
Additional transformation settings
SegmentStream allows to apply additional transformations for the data and help prepare cost data reports grouped by UTM.
This might be very handy if you need to stitch cost data with website sessions.
To enable this transformation use “Import cost data grouped by UTM” setting. Once enabled, a new table with cost data grouped by UTM will appear in your data warehouse.
Table name
googleCampaignManagerCosts_{YYYYMMDD}
Table schema
Field name | Type | Mode |
---|---|---|
cost | FLOAT | REQUIRED |
clicks | INTEGER | NULLABLE |
impressions | INTEGER | NULLABLE |
utmTerm | STRING | NULLABLE |
utmCampaign | STRING | NULLABLE |
utmContent | STRING | NULLABLE |
utmMedium | STRING | REQUIRED |
utmSource | STRING | REQUIRED |
currency | STRING | NULLABLE |
This document was last updated on October 6, 2020. If you notice any gaps, outdated information or simply want to leave some feedback to help us improve our documentation, please let us know!