This is a specialized version of the Metadata import below and is available for all customers regardless of them having Data Syncs enabled or not. We suggest you use this option if you are specifically looking to import spend data into HockeyStack since it can behave differently than other data points.
To set it up, go to Settings → Data Syncs → Add Connection → Google Sheets. In the Data Options dropdown, select Custom Spend to start syncing your data.
Example Schema
Each row has a timestamp and the combination of campaign, ad group, ad, and UTM information.
Column Name
Example Value
Requirement
Description
date
2025-03-18
required
The date of the campaign / ad metric
campaign_name
SaaStr Booth
required
Name of your campaign
spend
45300.16
required
Numerical value of spend without a currency symbol, or commas
network
Field Marketing
recommended
Campaign or ad network to group the metrics by (i.e. Google Ads is also an ad network)
utm_campaign
saastr-booth-cm
recommended
Not required, but very helpful when included to be able to connect this to website pageviews
campaign_id
19928
recommended
ID of your campaign
adgroup_id
9898129
optional
ID of your Ad Group
adgroup_name
Retargeting F24
optional
Name of your Ad Group
account_id
001FKQN2DJA5
optional
ID from CRM
currency
USD
optional
Recommended if ingesting spend data. Three letter currency code
impressions
95380
optional
Numerical value of impressions, without commas
clicks
3318
optional
Numerical value of clicks, without commas
url
www.testurl.com/?open-page
optional
Page URL of campaign
Important:
Although spend, impressions and clicks by themselves are not required, it is mandatory to include at least one of them to be able to measure it as metrics.