The client needed to see a company visitor heatmap breakdown for Canadian companies, and CompanyTrackerFX only shows a breakdown for the US.
Exported the data from CompanyTrackerFX and created a heatmap in Excel to show these insights!
Step 1: Export data from CompanyTrackerFX (set any industry, date, etc., filters beforehand to set yourself up with the cleanest data from the start)
Step 2: For a location heatmap, the only columns you really need in your spreadsheet are City, state, zip code, and country
Step 3: Filter your data to the country/state/etc. you want to include in your heatmap (my example is for Canadian companies, so I filtered to country = CA/Canada)
Step 3: Follow the instructions outlined in this Excel HelpDoc
Even though a specific functionality wasn’t possible in RCFX, we were still able to deliver on the value of the data in the platform and take advantage of export options to customize reporting for CompanyTrackerFX.