HockeyStack has native integrations to the most widely used advertising platforms. If there is an advertising platform you use that doesn’t have a native integration, you might benefit from syncing the spend on that platform using a CSV.

1. To get started, navigate to Settings > Reporting & Tracking.

   

2. Sync Spend will ask you to add the URL of a CSV file.

   <aside> 👉 You can copy our Google Sheets template to start populating it: HockeyStack Template - Sync Spend

   </aside>

   You can copy the below Google Sheets template to start populating it.

   https://docs.google.com/spreadsheets/d/16NHBul2BAU1sLilmZFtGFSMnm3zTTvCqli6S5zrhfC0/preview?usp=sharing

   The yellow marked columns are required.

   • Date needs to be in the YYYY-MM-DD format.

   • Cost needs to be a number in US Dollars, with no other characters. No Currency Symbols, no commas.

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

     

   • Impressions and Clicks also have to be numbers with no other characters.

   • You need to input at least one of the UTM parameters, regardless of the spend being connected to a website visit or not.

3. Once you create the Google Sheet, you should get the URL of the spreadsheet that you can plug into HockeyStack.

   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

   

4. Then, copy this URL, and add it into HockeyStack from the Add input:

   

How It Works

• The added spreadsheet is automatically synced to HockeyStack daily. Any changes made in past data is also reflected.

• The sync requires that the inputed spend is connected to a UTM parameter

• You can validate the sync by creating a table report like below:

  

• You can follow this guide to sync offline spend:

  Syncing spend from offline channels and campaigns

Caveats

• Deleted rows will not be deleted in HockeyStack, and modified rows will not be modified in HockeyStack. Therefore, we recommend creating a staging spreadsheet that is copied over to the master spreadsheet once it is completely validated.
  • If you need to reset your spend data, message or send an email to your Customer Advisor / CSM.