Filtering ConversionCategoryName for 'Other' Is not working

23 views
Skip to first unread message

Pem Scorch

unread,
May 3, 2020, 9:53:27 PM5/3/20
to AdWords API and Google Ads API Forum

Hello, there is something weird when filtering reports with ConversionCategoryName segment field. I cant filter the using the 'Others' value.

The following works:
SELECT CampaignId, ConversionCategoryName, Conversions FROM CAMPAIGN_PERFORMANCE_REPORT Where ConversionCategoryName = 'Download'
SELECT CampaignId, ConversionCategoryName, Conversions FROM CAMPAIGN_PERFORMANCE_REPORT Where ConversionCategoryName = 'Lead'
SELECT CampaignId, ConversionCategoryName, Conversions FROM CAMPAIGN_PERFORMANCE_REPORT Where ConversionCategoryName In ['Lead', 'Download']


But when picking only Others, it doesn't work. It returns nothing...

The following doesnt work:
SELECT CampaignId, ConversionCategoryName, Conversions FROM CAMPAIGN_PERFORMANCE_REPORT Where ConversionCategoryName = 'Other'
SELECT CampaignId, ConversionCategoryName, Conversions FROM CAMPAIGN_PERFORMANCE_REPORT Where ConversionCategoryName In ['Other']

I even tried ths but it's just doesnt work.
SELECT CampaignId, ConversionCategoryName, Conversions FROM CAMPAIGN_PERFORMANCE_REPORT Where ConversionCategoryName In ['Other', 'other', 'Others', 'others']


I want to know why is that.

Google Ads API Forum Advisor Prod

unread,
May 4, 2020, 11:56:11 AM5/4/20
to scor...@gmail.com, adwor...@googlegroups.com
Hello,

I will need to take a closer look at this. Can you please reply privately to author your report definitions and CID?

Thanks,
Anthony
Google Ads API Team

ref:_00D1U1174p._5004Q1zJvgb:ref
Reply all
Reply to author
Forward
0 new messages