Skip to main content
Using Google Sheets as a data source is a universal way to import any type of data even if you did not find an appropriate data source inside the SegmentStream admin panel.

​
Creating a costs sheet

To import costs into SegmentStream, you need to create a Google Sheet where the data is listed in the following format.
Use this template for daily costs.
NameTypeRequiredDescriptionExample
dateDATErequiredReporting date in YYYY-MM-DD format2020-04-03
currencySTRINGrequiredCurrency codeUSD
costFLOATrequiredTotal spendings for the reporting date460.5
impressionsINTEGERoptionalTotal number of impressions during the day12500
clicksINTEGERoptionalTotal number of clicks during the day284
utmMediumSTRINGrequiredutm_medium URL parameter attributed to the costs entrycpa
utmSourceSTRINGrequiredutm_source URL parameter attributed to the costs entrypartner1
utmCampaignSTRINGoptionalutm_campaign URL parameter attributed to the costs entrycampaign1
utmTermSTRINGoptionalutm_term URL parameter attributed to the costs entryblack_shoes
utmContentSTRINGoptionalutm_content URL parameter attributed to the costs entrybottom_cta_button
campaignSTRINGoptionalThe name of the campaign as it will be reported inside SegmentStreamExample Campaign
campaignIdSTRINGoptionalThe ID of the campaign that will allow SegmentStream to match it to URL parameters123123

​
Monthly costs import

Sometimes it might be required to import monthly costs (subscriptions, salaries) and attribute them to a specific set of UTM parameters, for example:
  • SEO costs
  • CDP/ESP costs
  • PR costs
Use this template for uploading monthly costs.
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 structure your sheet as follows:
monthcurrencycostimpressionsclicksutmSourceutmMedium
2024-01-01USD3000emailmy_esp
2024-02-01USD3000emailmy_esp
2024-03-01USD3000emailmy_esp

​
Enabling Google Sheets data source

1

Navigate to Data Sources

Go to the SegmentStream admin panel. Go to the Data Sources section and click + NEW.
2

Select Google Sheets

Select Google Sheets.
3

Authenticate

Click Authenticate with Google and go through the authentication flow.
4

Enter spreadsheet URL

In the Google Spreadsheet URL field specify the URL of the sheet that you want to import.
5

Select report type

Select the Daily cost data group by UTM or Monthly cost data grouped by UTM report type.
6

Set destination table

In the Destination table name field specify a unique BigQuery table name where you would like to store the data imported from the specified sheet, for example, daily_costs_platform_name.

​
Custom Google Sheets report type

Custom Google Sheets report types allow you to upload data that requires additional processing before being used in SegmentStream reports. Before using this feature, contact your SegmentStream manager. To enable a custom Google Sheets upload, follow steps 1 through 5 from the previous section, then:
  1. Select Custom report type.
  2. Map sheet columns to proper data types:
    • date -> DATE
    • cost -> FLOAT
    • impressions -> INTEGER
    • clicks -> INTEGER
By default, all other columns will be imported as String.

​
What’s next

During the next 24 hours your data will be uploaded to the corresponding BigQuery table.