Ad clicks per country report

Hi. I am trying to use the custom report builder to create a bar chart that allows me to see and compare which regions/countries are responding to ads and clicking on them. I want to do the same later for impressions, CTR and ROI. I was wondering how to do this because I couldn’t find a way to add country as a parameter under breakdown. If someone could help me with this, I would really appreciate it!

Hi @RVithani,

Thanks for reaching out to the Community!

Would you be able to please share a screenshot of your report in HubSpot? Can you show us the parameters you have added to the report so far? Is this a contacts and ad interactions report?

The more information you can include on your report, the better the community can assist with guidance.

Thank you!

Best,

Kristen

I want to add country in the X axis so I can see which countries are giving me the most ad clicks.

Hi @RVithani,

I believe you would need the “Country” contact property in order to get the desired outcome, however, it’s currently not possible to add Contacts and Ad Performance Metrics to a custom report.

I wanted to invite our subject matter experts to see if they have any workarounds.

Hi @danmoyle, @Franci, @Josh - Do you have any advice for @RVithani? Are you aware of a way to see the number of ads clicks per country in HubSpot?

Thank you!

Best,

Kristen

I agree @kvlschaefer I think the contact property of country can be used as a filter as long as it’s populated. Additionally, country IP address may be useful.