If you have HubSpot analytics running on your website, your HubSpot account has website activity for known contacts that HockeyStack can pull to backfill website data.
- To get started you need to create a Google Sheet of emails that HockeyStack will pull website data for. The limit for the number of contacts you can pull website data for is 100k. We recommend pulling a list of contacts that might be relevant to your main KPIs. For example, any MQLs, SQLs, etc. within the past year should be included. Any contact related to any company that has an opportunity created within the past year should also be included. The Google Sheet should have the word “email” on the A1 cell, followed by a list of emails on the A column.
- 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
- Click Configure next to HubSpot in the HockeyStack Settings > API & Integrations. Paste the URL into the Sync Historical Website Data form, and click Sync.
Important:
- The spreadsheet must only have one column with emails
- The spreadsheet must not have any blank rows in between two emails. For example, if A2 is test@test.com, A3 is blank, A4 is test2@test2.com, this won’t work.
On the screen that comes up, change “Web page” to “CSV”, and click Publish
You will only be able to do this once, so double check that the URL is working and is up to the above specifications before submitting.