Zero impressions in search results

[The Garden Shop Maya]

Hi! I'm currently trying to get a shopping_performance_view report to get basic information as clicks or impressions with the following query:

SELECT metrics.impressions, segments.product_item_id FROM shopping_performance_view

 As this page states, I understand that by default, rows with zero impressions are excluded when segmenting. However, is really important for me to also include those with 0 impressions in the report.

Is there any option to be included in the query in order to get those? Or is there any workaround you have in this case?

Thank you in advance.

[Google Ads API Forum Advisor]

Hi there,

You are correct, there's no way currently to get rows with zero impressions. Can you elaborate on this need to return rows with 0 impressions?

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2JXLLC:ref