Campaign breakdown by country

[squigglebit]

Has anyone figured out how to breakdown campaigns by country?

I'd like to see what the CTR is by country for an email campaign, but I can't seem to figure out how to report on this.

[RBozeman]

Hey @squigglebit ,

The easiest way to do this inside HubSpot would be to create a different campaign for each country, or at least the countries that you would like to view. 

For existing campaigns, it seems your only option is to export the data and calculate CTR on your own, based on country in Excel. I played around with the email reporting to see if I could find a workaround, but unfortunately wasn't able to sort by Country/CTR, as CTR isn't an option in the reporting suite. Hopefully in the future this is a reporting property that HubSpot will make available. 

Best,

Ryan

[karstenkoehler · Accepted solution]

Hi @squigglebit,

This is currently not possible, unless you create campaigns for each country or unless you export the data as Excel file and run that calculation within the spreadsheet, unfortunately.

Best regards!