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

Network Filter Issue

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I am having an issue adding a Network Filter to my report.  I want to be able to toggle between Search and Display views but the filter breaks a lot of my datasets with an error saying it cannot aggregate the ratio metrics (CPA, CTR, CPC etc)

Enlightium_PPC_Report.jpg

 

1 Expert replyverified_user

Re: Network Filter Issue

Google Employee
# 2
Google Employee
Hi Dave,

That looks like it's going to a very cool report! Sorry you're having troubles with the aggregations. I'll see if I can find out what that rather cryptic error code means :/

Rick

Re: Network Filter Issue

Google Employee
# 3
Google Employee

Hi Dave

I think I might have found out the cause of the issue you described: it turns out that for AdWords connector-based charts, if you're going to include ration metrics like CTR, CPC, etc., you need to make sure you are also including a required field. This field depends on which AdWords report you've connected to. Here's the list:

 

AdWords report               Required field

ACCOUNT_PERFORMANCE_REPORT - none
CAMPAIGN_PERFORMANCE_REPORT - CampaignId
ADGROUP_PERFORMANCE_REPORT - AdGroupId
AD_PERFORMANCE_REPORT - AdGroupId, Id
KEYWORDS_PERFORMANCE_REPORT - Id, AdGroupId
AUDIENCE_PERFORMANCE_REPORT - Id, AdGroupId
GEO_PERFORMANCE_REPORT - CountryCriteriaId
DISPLAY_KEYWORD_PERFORMANCE_REPORT - Id, AdGroupId
SEARCH_QUERY_PERFORMANCE_REPORT - Query
DISPLAY_TOPICS_PERFORMANCE_REPORT - Id, AdGroupId

 

Hope this helps!

 

Rick