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.

​
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:

​
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.