CAMPAIGN_PERFORMANCE_REPORT filter by Labels (strings)

82 views
Skip to first unread message

Kristijan Novakovic

unread,
Jul 26, 2018, 9:34:09 AM7/26/18
to AdWords API and Google Ads API Forum
Hello,

Is it possible to filter data by Labels (string values)? Whenever I try to do that I get "Temporary problem with the server. Please retry the request after a few moments".
If I insert integers as values to filter by (ids)  then it works ok.

Sreelakshmi Sasidharan (AdWords API Team)

unread,
Jul 26, 2018, 4:29:01 PM7/26/18
to adwor...@googlegroups.com
Hello, 

As with other fields of type List, you can filter reporting results by LabelIds using CONTAINS_ANY, CONTAINS_ALL, or CONTAINS_NONE. You could check the guide on labels for more clarity. Please see a sample AWQL below :

SELECT CampaignId, LabelIds, Labels FROM CAMPAIGN_PERFORMANCE_REPORT WHERE Labels CONTAINS_ANY [926238056]

Let me know if you have any additional questions. 

Thanks,
Sreelakshmi, AdWords API Team

Kristijan Novakovic

unread,
Jul 26, 2018, 5:20:05 PM7/26/18
to AdWords API and Google Ads API Forum
Hi,

No, that's not what I want. I want to filter by Label (as in Label Name - String) not by Label IDs. Is that possible?

Sreelakshmi Sasidharan (AdWords API Team)

unread,
Jul 27, 2018, 11:53:18 AM7/27/18
to AdWords API and Google Ads API Forum
Hello, 

In the reports that supports Labels, you may only be able to filter using the LabelIds. If you are having trouble mapping the label names to the label ids, you could use the Label Report. This is a structure report and you will be able to filter using the LabelName in this report. I will raise a feature request to see if filtering based on Labels can be enabled in the supported reports. You could keep an eye on our blog for updates and announcement about future releases. 


Thanks,
Sreelakshmi, AdWords API Team

Kristijan Novakovic

unread,
Jul 27, 2018, 12:31:45 PM7/27/18
to AdWords API and Google Ads API Forum
Thanks for the answer and for the feature request. In the meanwhile, I will try the Label Report.
Reply all
Reply to author
Forward
0 new messages