Not obtaining specific ad_groups with status = 'PAUSED'

[Emmanuel Martinez]

Good afternoon team,

We have certain Ad groups with paused status for today 2023-07-28 in the Google Ads UI that we need to get through the API, we had no problem until yesterday, when we made the request we did not specify what status to bring so we can bring all the adgroups. the query is as follows:

SELECT

ad_group.name,

ad_group.resource_name,

ad_group.status,

metrics.clicks,

metrics.cost_micros,

segments.hour,

segments.date

FROM ad_group WHERE segments.date BETWEEN '${startDate}' AND '${endDate}'

now to retrieve paused adgroups we have to specify it with
ad_group.status = 'PAUSED'
, but for some reason we can't retrieve some of today 2023-07-28, I can't show the adgroups we need to retrieve so we would appreciate if we could continue this chat by mail.

[Google Ads API Forum Advisor]

Hi,

Thanks for reaching out to the Google Ads API Forum.

Since you mentioned that you are unable to pull the paused ad groups in API, I can see that your GAQL contains 2 segments fields such as segments.hour,segments.date. When you add any segments field, then it tells the query to retrieve only the rows of data that have said segment fields and remove any row that is not associated with those segments. The closest document I can share is from the segmentation guide from this section. 

The general rules of reconciling a report from reports in the Ads UI with a report from the Ads API is to check that the "row fields" in the UI reflect the segmenting fields of the API and that the filters in the UI reflect "WHERE" clause in the API.

If you followed above, and still ad groups not getting pulled, then you may reply privately to author option with the full logs, and uncropped Ads UI screenshot showing the data so that we can investigate the issue. 

This message is in relation to case "ref:_00D1U1174p._5004Q2mx0Mw:ref"

Thanks,
 

Google Ads API Team