Data Studio
4.5K members online now
4.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Filtering by country/location doesn't work for some metrics (AdWords report)

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm trying to create an AdWords report in Data Studio that can be filtered by location. However, when I add the filter, some metrics stop working.

 

Example:

I have four scorecards set up for Clicks, CTR, Conversions and Conversion Rate. However, when I apply a country filter (either to the whole page/report, or to a specific scorecard), I get a configuration error:

Unable to aggregate ratio metrics in the request. Please select another metric.

 

 

The filter does work for clicks, but not for CTR, conversions or conversion rate.

 

Any ideas why? Is there a way around this or is there a limitation that prevents this from working?

Filtering by country/location doesn't work for some metrics (AdWords report)

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi Ben,

 

When you take a look at your data in the 'edit data source' screen, what does it say in the 'aggregation' column next to each metric?

Filtering by country/location doesn't work for some metrics (AdWords report)

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi Ben,

 

It either says 'Auto' or 'None'. In the case of Country/Territory and Country Code, the two dimensions I've tried filtering on, it says 'None'. It doesn't look like there's an option to change it for those fields.

 

Any thoughts?


Thanks!

Filtering by country/location doesn't work for some metrics (AdWords report)

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Hi,

 

I get the same error message and don't see an option to change those fields too.

Other fields like "Network (with search partners)" are not aggregated but filtering works.

 

Any new thoughts?

 

Thanks!

Filtering by country/location doesn't work for some metrics (AdWords report)

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Have the same issue on following KPIs :

CTR

Avg.CPM

Avg. CPC

Search terms.

 

Filter on country does not work

 

It does work on 

Clicks 

Cost

Impressions

Campaign

 

Did you have any feedback from Google ?

 

Thx

 

Filtering by country/location doesn't work for some metrics (AdWords report)

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

I've not heard back unfortunately. So I'm still not sure if it's something I'm doing wrong or a bug - if the latter, hopefully it'll be fixed soon.