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.

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
currency	USD	optional	Recommended if ingesting spend data. Three letter currency code
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
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.

How to Connect

To get started, navigate to Atlas > Ingest > Custom Data Source.

1. Select Google Sheets as the Data Source

If you have the Data Syncs feature, you can select other Data Source destinations (ex. BigQuery, Snowflake, S3)

1. Configure the Sync settings

• Name

• Import Type: Custom Spend

• Schedule Options: One-time or Recurring (daily)

• Connection Details: Public (legacy) or Private (recommended)

1. Create the data source

• Copy our Google Sheets template to start populating it: HockeyStack Template - Sync Spend

  • The yellow marked columns are required.

  • If you need to use a different currency, you can do the following:

• Public sheets (legacy) require at least one UTM parameter to be included.

1. Connecting the sheet

   1. Private (recommended)

      1. Once the sheet has been created, share the sheet with [e-mail]

      2. Copy the URL (top search bar) and paste it into HockeyStack

   2. Public (legacy)

      1. Click File on the top left, hover over Share, and select Publish to Web

         

         On the screen that comes up, change “Web page” to “CSV”, and click Publish

         

         Then, copy this URL, and add it into HockeyStack

2. Click Test Connection. Once successful, click it again to create the sync

1. Configure Ingestion Settings

• For small files (< 10K rows) select "Changes to the same object overwrite existing rows"

  • For larger files select "Changes to same object are new rows"

  For "New Rows", an updatedAt date column is required.

• Map the ingestion date column (used to organize data sequentially)

• Map remaining columns

  • Note: UTMs (Source, Medium, etc) are automatically mapped— no action needed

1. Create Connection

• Syncs are paused by default. Click on the connection in Atlas and start the sync with the lightning icon