Re: Missing Image Ads in ad_group_ad view

[Marie P-Lavoie]

Hi,

So I investigated further my own issue and discovered that if I remove the field "segments.keyword.info.text" from my request, all the missing ads now show up in the response. Is this normal behaviour?

Thanks,

Marie

On Wednesday, April 27, 2022 at 11:26:17 AM UTC-4 Marie P-Lavoie wrote:

Hi!

One of my clients has Image Ads in her Google Ads account for the month of April. However, when I make a request to the ad_group_ad view in the Google Ads API, all the image ads seem to be missing from the response.

I provided the detailed request and response logs in the file attached. I can also provide the screenshot of the Image Ads from the Google Ads UI privately to whomever will take this issue in charge.

Thank you!

Marie

[Google Ads API Forum Advisor]

Hi Marie,

I reproduced this and it is working as intended. Any ad that doesn't have keywords will be excluded when adding segments.keyword.info.text to the report. When adding some segments, only metrics rows that fit in to the segment get reported. 

Regards,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2aO8ep:ref

[Google Ads API Forum Advisor]

Hi Marie,

I had to delete your first post as it contained a log.

[don....@gmail.com]

Hello Aryeh, I have follow up question regarding segmentation, could you advice how to to get full data without duplicates from the

ad_group_ad report?

1. I want to get all data which is segmented by segments.keyword.info.text
2. I want to get the rest of data which cant be segmented by segments.keyword.info.text

Expectation is to get as result data set where total sum(cost) and sum(clicks) will match the UI for the same period

For example 1st I do a call like

SELECT campaign.id, campaign.name, ad_group_ad.ad.id, ad_group_ad.ad.type, segments.ad_network_type, ad_group_ad.ad.type, metrics.cost_micros, metrics.clicks, segments.keyword.info.text 
FROM ad_group_ad
WHERE segments.date = '2022-04-25'

and I get only data where there is keyword

in the 2 I want to do

SELECT campaign.id, campaign.name, ad_group_ad.ad.id, ad_group_ad.ad.type, segments.ad_network_type, ad_group_ad.ad.type, metrics.cost_micros, metrics.clicks, segments.keyword.info.text 
FROM ad_group_ad
WHERE segments.date = '2022-04-25'
AND segments.keyword.info.text IS NULL

But second call gives me no data because if segment is added your api engine simply dont return data without keyword

So I think question is how to get ONLY data without segments.keyword ?

Hope it makes sense, thank you in advance!

[Google Ads API Forum Advisor]

Hi Don,

Thank you for commenting on this forum. I am also a member of the Google Ads API team and let me provide support to your concern.

To provide insights to your concern, I am afraid that it is not possible to get the ads data which can't be segmented by segments.keyword.info.text because of what is discussed in this document. The workaround here is to generate a separate report without keyword related segments such as segments.keyword.info.text so that the ad information will be returned for the ads that can not be segmented by the said field.

Let me know if you have further questions.

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2aO8ep:ref

[don....@gmail.com]

Hello Enrie, thank you for the reply, If I generate one report without segments.keyword.info.text  and another one with segments.keyword.info.text  for the same date

and sum up results of those two reports (e.g. sum(clicks) sum(cost) ) I wont get match with the Google Ads UI  because same ad may be represented in both reports.

How to make sure those two result don't overlap so that sum of the results will match with UI? If I got you answer correctly you are saying its impossible? I was hoping there is a was, as our clients would like cost breakdown per triggering criteria where is possible, and grouped per Ad where criteria breakdown is not possible. This is why I'm looking for the solution described above.

Thank you in advance!

[Google Ads API Forum Advisor]

Hi Don,

A report without segments will get all metrics for the filtered date, while a segmented report will only give metrics that match the segment. If your ads served to keywords and to non keywords, the segmented report will report the metrics for keywords served ads only, while the non segmented report will include everything. You may be able to go through the post processing surgery of subtracting totals at different levels within the non segmented report from the segmented report and making an 'other' row (of non keyword induced metrics per level) but we can only support a report that can be matched in the UI.

Regards,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2aO8ep:ref