Twitter data source
- Inside the admin panel go to Google BigQuery ▸ Data Sources page and click Add data source.
- Choose Twitter from the list.
- Click Click to authenticate with Twitter and go through the authentication flow.
- Select accounts which 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 or send cost data into Google Analytics.
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.
Twitter allows running ads that do not lead directly to your website (for example Twitter page promo, Twitter post promo, events promo, etc). This means that these types of campaigns can not have UTM-params and it is not possible to import them into Google Analytics or match them with website sessions due to limitations that require all imported costs to have campaign source and medium defined.
As a workaround, you can define default UTM-source and UTM-medium for your Twitter data source to manually attribute these costs to sessions with specified utm_source and utm_medium.
This document was last updated on October 2, 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!