Import Sync Spend
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.
date
2025-03-18
The date of the campaign / ad metric
campaign_name
SaaStr Booth
Name of your campaign
network
Field Marketing
Campaign or ad network to group the metrics by (i.e. Google Ads is also an ad network)
utm_campaign
saastr-booth-cm
Not required, but very helpful when included to be able to connect this to website pageviews
campaign_id
19928
ID of your campaign
spend
45300
Numerical value of spend without a currency symbol, or commas
currency
USD
Recommended if ingesting spend data. Three letter currency code
impressions
95380
Numerical value of impressions, without commas
clicks
3318
Numerical value of clicks, without commas
You are free to include additional utm_ columns, such as:  utm_source utm_medium utm_content utm_term
You can also include additional account_id, adgroup_id, adgroup_name, ad_id, and ad_name columns if you are importing data from a digital ad platform.
Last updated