Costs Data Sources overview
Available data sources
To set up the automatic cost data import you need to connect at least one data source.
There following built-in data sources are available for the Google Analytics projects within the SegmentStream platform:
- RTB House
- Microsoft Advertising
- Google Sheets
Connecting data source
To connect a data source you should follow the following steps:
Click Add Data Source button:
Select the ad patforrm you would like to import cost data from:
Go through the authentication flow depending on the selected data source:
Apply additional transformation settings following the instructions in the appropriate documentation of the specific data source.
Google Ads cost data import
There is no Google Ads data source inside the SegmentStream platform as Google Analytics has a built-in integration for the Google Ads costs import. Please, read moe about this feature using the following links:
- Link Google Analytics and Google Ads accounts
- Link Google Analytics and a Google Ads manager account (MCC)
SegmentStream automatically converts all currencies to the one used for your Google Analytics view. Note that SegmentStream will use the first view in the list to determine the cost data currency. This currency will be used to convert all cost data for all selected views.
You can always change the currency used to display ad costs in Google Analytics. To do so, change the currency setting for the Google Analytics view connected to the data set with cost data.
In this case, the new currency setting will be applied only to the data SegmentStream will import to Google Analytics after you’ve changed the setting. The currency won’t change for the previously imported data. However, you can contact our support team to run a backfill to update previously imported data.
As far as Google Analytics imports all cost data from Google Ads without VAT, SegmentStream follows the same logic for all other data sources to avoid cost data VAT inconsistency.
If you don’t exclude VAT for these services while importing cost data, you’ll end up overestimating the costs of your VK and Yandex.Market campaigns. As a result, you won’t be able to make correct conclusions on their efficiency comparing to other channels.
Note! Currently, there is no technical possibility to add VAT for the imported costs. If you want to analyze data with VAT included, you can create a custom report in Google Analytics adding calculated metrics to it.
Historical data import
In order to import historical cost data, please contact our support team. SegmentStream allows to backfill historical data depending on your pricing plan type:
- For monthly subscriptions we can backfill up to 30 days of historical data.
- For annual subscriptions we can backfill up to 6 months of historical data (depending on ad platforms allowance).
This document was last updated on June 19, 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!