Using Google Sheets data source is a universal way to import any type of data even if you didn’t find appropriate data source inside the SegmentStream admin panel.
Creating a costs sheet
In order to be able to import custom costs into SegmentStream you need to create a Google Sheet with custom costs with the following format:
Please use this template.
Name | Type | Required | Description | Example |
date | DATE | required | Reporting date YYYY-MM-DD format YYYY-MM-DD | 2020-04-03 |
currency | STRING | required | Currency code | USD |
cost | FLOAT | required | Total spendings for the reporting date. | 460.5 |
impressions | INTEGER | optional | Total number of impressions during the day. | 12500 |
clicks | INTEGER | optional | Total number of impressions during the day. | 284 |
utmMedium | STRING | required | utm_medium URL parameter attributed to the costs entry | cpa |
utmSource | STRING | required | utm_source URL parameter attributed to the costs entry | partner1 |
utmCampaign | STRING | optional | utm_campaign URL parameter attributed to the costs entry | campaign1 |
utmTerm | STRING | optional | utm_term URL parameter attributed to the costs entry | black_shoes |
utmContent | STRING | optional | utm_content URL parameter attributed to the costs entry | bottom_cta_button |
campaign | STRING | optional | The name of the campaign as it will be reported inside SegmentStream | Example Campaign |
Monthly costs import
Sometimes it might be required to import monthly costs (subscriptions, salaries) and attribute them to specific set of UTM parameters, for example:
- SEO costs
- CDP/ESP costs
- PR costs
- etc
For example, if you spent $3000 each month of the first quarter of 2024 on your favorite ESP platform and would like to attribute these costs to
utm_source=my_esp
and utm_medium=email
, you can use the following approach.Please use this template for uploading monthly costs.
month | currency | cost | impressions | clicks | utmSource | utmMedium |
2024-01-01 | USD | 3000 | email | my_esp | ||
2024-02-01 | USD | 3000 | email | my_esp | ||
2024-03-01 | USD | 3000 | email | my_esp |
Enabling Google Sheets data source
- Go to SegmentStream admin panel ▸.
- Go to the Data Sources section and click + NEW.
- Select Google Sheets.
- Click Authenticate with Google and go through the authentication flow.
- In the Google Spreadsheet URL field specify the URL of the sheet that you want to import.
- Select report type (in most cases you would need either Daily cost data group by UTM or Monthly cost data grouped by UTM)
- Map sheet columns to proper data types in case you decided to use custom report type:
- date ->
DATE
- cost ->
FLOAT
- impressions ->
INTEGER
- clicks ->
INTEGER
By default, all other columns will by imported as String.
- In the Destination table name field specify the BigQuery table name that will contain imported sheet data.
What’s next
During the next 24 hours your data will be uploaded to the corresponding BigQuery table.