Google Ads reporting for device segments doesn't return all values

[Skander Mansouri]

Hi,

When testing the request 

SELECT 

campaign.id

segments.device

metrics.impressions

metrics.clicks

metrics.cost_micros,

metrics.impressions FROM campaign WHERE campaign.id = x AND segments.date = '2022-02-24'
I was able to retrive the data relative to some device type and the others even though it was 0 in the UI but the API doesn't send them.

I was wondering if the API does only return non 0 values or is it a bug?

Thanks!
Skander

[Google Ads API Forum Advisor]

Hello Skander,

Thanks for reaching out to the Google Ads API support. For us to investigate, we will need a full log of request and response logs with request ID and request header generated on your end of API communications of the report pull.
Also could you please share a full screen screenshot of the UI where the specific device type shows 0 value?

Please note Zero metrics are always excluded when segmenting a report, provided all selected metrics are zero (see below). Segmenting a report is done by including any segments field in the search query. For example, if you segment a report by segments.date, metrics will be broken down with one row for each date. Any date that has no metrics will not be returned in such a report.

Please send the requested details via the Reply privately to the author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Jakeia Sabrina Google Ads API Team

 

ref:_00D1U1174p._5004Q2Xkh51:ref

[Skander Mansouri]

Thank you for your response, 

However what seemed weird to me is that for segmenting by devices, there are some values with all metrics in 0 for a Device Type. 

for example using my query above for a campaign id 123 the result I'm receiving
{"campaignId": 123   ,"deviceType":"DESKTOP","day":"2022-02-24","cost":0,"impressions":0,"clicks":0,"conversions":0.0}
{"campaignId":123 ,"deviceType":"MOBILE","day":"2022-02-24","cost":0,"impressions":1,"clicks":0,"conversions":0.0}
{"campaignId": 123   ,"deviceType":"TABLET","day":"2022-02-24","cost":3,"impressions":5,"clicks":0,"conversions":0.0}

Is it normal behavior that I receive the DESKTOP line? if so, why I'm not receiving OTHERS and TV device types with zero values too?

PS: the values are not from real data.

[Google Ads API Forum Advisor]

Hi Skander,

Thank you for your reply and for the additional information.

Segmenting the report may return fewer records, specifically when all selected metrics are 0. You may refer to this section from our zero metrics guide, and this section from our segmentation guide for more information regarding this behavior.

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2Xkh51:ref

[Google Ads API Forum Advisor]

Hi Skander,

In addition to my earlier response, could you confirm whether you indeed received records even though all metrics are 0? If yes, could you confirm if this was encountered when using the latest version?

Also, could you provide to our team the complete request and response logs, request-id, and login-customer-id used of an actual scenario where this was observed?

Furthermore, you may note that in the latest version (see update) it states that :

• Fixed inconsistencies where rows with zero metrics were returned when segments were selected in some reports. All reports will now follow the expected behavior of ignoring zero-metric rows in reports that select metrics and segments.

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

[Skander Mansouri]

the version I was using was v9 and now upgraded it to v10 and it worked. I'm no longer receiving the 0 values.

Thanks for the support!

[Google Ads API Forum Advisor]

Hello Skander,

Thank you for getting back to us, and I'm glad that you were able to resolved the issue.

Please let me know if you have any other concerns related to Google Ads API. We'll be happy to assist you.

Regards,

Teejay Wennie Google Ads API Team

ref:_00D1U1174p._5004Q2Xkh51:ref