AdGroupAd query returns different data comparing to UI report

27 views
Skip to first unread message

Stella

unread,
Dec 6, 2024, 2:14:40 AM12/6/24
to Google Ads API and AdWords API Forum
I've tried following query and ad_group_ad.primary_status always returns `ELIGIBLE` eventhough actually it was `LIMITED`on the UI report. How can I get the right data?

```
SELECT ad_group.id, ad_group.name, campaign.id, campaign.name, metrics.clicks, metrics.cost_micros, metrics.impressions, segments.date, segments.keyword.info.match_type, segments.keyword.info.text, segments.device, ad_group_ad.primary_status, ad_group_ad.primary_status_reasons FROM ad_group_ad WHERE ad_group.status IN ('ENABLED', 'PAUSED', 'REMOVED', 'UNKNOWN') AND campaign.status IN ('ENABLED', 'PAUSED', 'REMOVED', 'UNKNOWN') AND segments.date BETWEEN '2024-12-01' AND '2024-12-06'
```
Thanks

Google Ads API Forum Advisor

unread,
Dec 6, 2024, 3:02:16 AM12/6/24
to he...@wisebirds.com, adwor...@googlegroups.com
Hi,

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

I understand that when retrieving data from the ad_group_ad resource, the ad_group_ad.primary_status field always returns "ELIGIBLE," even though it appears as "LIMITED" in the UI report and you are seeking guidance on how to retrieve the correct status using the Google Ads API. Please note that the customer ID has not been provided for further investigation. To proceed further, I kindly request you to share an uncropped screenshot of the Google Ads account UI, ensuring the customer ID is visible. Additionally, kindly highlight the 'LIMITED' status for the ad you wish to retrieve via the Google Ads API.

You can send the details via Reply privately to the author option, or direct private reply to this email.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vGnhz:ref" (ADR-00277893)

Thanks,
 
Google Logo Google Ads API Team

Feedback
How was our support today?

rating1    rating2    rating3    rating4    rating5


 

 

Reply all
Reply to author
Forward
0 new messages