Searching Text Ads using Google Ads Query Builder

116 views
Skip to first unread message

Chris Prijic

unread,
May 27, 2021, 12:23:09 PM5/27/21
to AdWords API and Google Ads API Forum
Hello all,

I wanted to ask if there was a way to search text ads (and extended text ads) using the query language? We are proxying Google Ads data into our systems using the API and want to allow customers to search their ads without us needing to synchronize with Google and build our own search layer.

I understand Google's UI supports this as an ad text filter, but does the query language support this somehow? I haven't found a solution via the docs so far.

Thanks!
Chris Prijic

Google Ads API Forum Advisor Prod

unread,
May 27, 2021, 10:20:42 PM5/27/21
to chris....@orbee.com, adwor...@googlegroups.com
Hi Chris,

Thank you for posting your concern.

If you are looking for a way to get data and statistics at ad level and you specifically want this information for text ads and expanded text ads only, then you can use the ad_group_ad report and filter the ad_group_ad.ad.type field by 'EXPANDED_TEXT_AD' / 'TEXT_AD'. You can utilize this Google Ads Query Builder to help you construct your query for ad_group_ad report with the filter that I suggested earlier.

Let me know if you have questions with the provided suggestion.

Regards,
Google Logo
Ernie John Blanca Tacata
Google Ads API Team
 


ref:_00D1U1174p._5004Q2HyMga:ref

Chris Prijic

unread,
May 28, 2021, 12:18:57 PM5/28/21
to AdWords API and Google Ads API Forum
Yes -- we already do filter for text/expanded text ads in our query. For many of our customers, that still has way too many rows for them to sort through and view. We did want to filter through the ads' text -- e.g. does any headline/description contain the text "vehicle". This would then return a much smaller set of fields.

E.g. something like this, which the current Google Ads UI supports:

Screenshot 2021-05-28 091721.png

Is this type of filter possible through the Google Ads Query Language?

Google Ads API Forum Advisor Prod

unread,
May 31, 2021, 12:02:22 AM5/31/21
to chris....@orbee.com, adwor...@googlegroups.com
Hi Chris,

Thank you for your follow up. I work with Ernie and allow me to assist you for now.

You can refer below for equivalent query OPERATORS you can use to mimic the filters in the attached screenshot :

ad_group_ad.status IN ['status values']
ad_group_ad.ad.type IN ['ad type value']

The above are just some of the fields and operators you can use. As for the CONTAINS filter in the screenshot, you can check out this guide and try out the query builder and query validator as well to help you more correctly construct your queries before applying them in your system.

Best regards,

Google Logo
Peter Laurence Napa Oliquino
Google Ads API Team
 


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