GAQL to Get Exact Headline & Description of a Responsive Ad that generated each Click

43 views
Skip to first unread message

Seva Baskin

unread,
May 15, 2024, 8:54:21 PM5/15/24
to Google Ads API and AdWords API Forum
Hi Google Ads API Team,

I'm trying to write a GAQL that fetches clicks for a specific date and returns the exact headline & description combination from a responsive ad that generated each click.

We have some unwanted leads generated from our responsive campaigns, and I'm just trying to drill down which specific combination of headlines and descriptions are generating these unwanted leads.

I'm able to retrieve specific clicks:

```sql
SELECT campaign.name, click_view.gclid, click_view.keyword, ad_group.name, ad_group.id, campaign.id, customer.id, click_view.ad_group_ad

FROM click_view

WHERE segments.date = '2024-05-08'
```

Which gives me information for a specific ad id that generated that click. However, when I query that ad id from a specific click, I'm only able to retrieve all the different headlines/descriptions for that ad, but unable to retrieve exact combination of headline + description that generated that specific click:
```sql
SELECT ad_group_ad.ad.responsive_search_ad.headlines, ad_group_ad.ad.responsive_search_ad.descriptions FROM ad_group_ad WHERE ad_group.id = 144629223745 AND ad_group_ad.ad.id = XYZ
```

Please let me know if there's a solution.

Google Ads API Forum Advisor

unread,
May 17, 2024, 4:43:10 PM5/17/24
to se...@campusboard.org, adwor...@googlegroups.com
Hi,

Thank you for reaching out to the Google Ads API support team.

Kindly note that only from the click_view resource you can get the gclid. I would recommend you to refer to this documentation to know more about the Fields/Segments/Metrics that can be used with the click_view resource. Also, from the ad_gorup_ad resource you can get the metrics.clicks this will provide the number of clicks. Hope this helps. Let us know if you have any further queries. 
 
This message is in relation to case "ref:!00D1U01174p.!5004Q02tIzrX:ref" (ADR-00235230)

Thanks,
 
Google Logo Google Ads API Team


Reply all
Reply to author
Forward
0 new messages