How I Did It: Creating a CompanyTrackerFX Visitor Heatmap for Non-US Countries

Posted by: Macenzi Barker Date Posted: September 25, 2025
Back to Case Studies

Issue

The client needed to see a company visitor heatmap breakdown for Canadian companies, and CompanyTrackerFX only shows a breakdown for the US.

Solution

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

  • Select your city/state/zip code/country columns
  • Data > Data Types > Geography
  • Navigate through the popup on the right to ignore any heading cells and update any unclear cells (screenshot)
  • Highlight the now geographic-type data and insert a pivot table
  • Select your dimension (city/state/zip) and input it as a row and as a value
  • Highlight the pivot table and copy/paste to a new section of the sheet (you can’t make a map of pivot table data) – screenshot
  • Highlight the copied data outside of the pivot table and insert > charts > maps > filled map
  • Click on the map area > series options > map area = only regions with data (to zoom in) & any other style preferences – screenshot

Achievement

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.

Snippet/Screenshot/Link

Screenshot of final output