Google Sheets

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 costs into SegmentStream you need to create a Google Sheet where the data is listed in 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
campaignId	STRING	optional	The ID of the campaign that will allow SegmentStream to match it to URL parameters	123123

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

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 the Daily cost data group by UTM or Monthly cost data grouped by UTM report type.

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, please contact your SegmentStream manager.

To enable a custom Google Sheets upload, follow steps 1 through 5 from the previous section, then:

Select Custom report type.

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.

What’s next

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