Get shopping_performance_view including zero impressions

[kenneth hung]

Hi,

I'm trying to get shopping performance view using GAQL , 

but the result doesn't include the product is zero impressions.

Is it possible to get the performance that include zero impressions?

[Google Ads API Forum Advisor]

Hi Kenneth,

Thank you for reaching out to our team.

You may try not including segment fields in the report as zero impressions are always excluded when segmenting a report, provided all selected metrics are zero according to this document.

Let me know how it goes after.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2VNjbP:ref

[kenneth hung]

Hi, here is my GASQL:

SELECT segments.product_item_id,metrics.clicks,metrics.cost_micros,metrics.impressions,metrics.conversions,metrics.all_conversions FROM shopping_performance_view  WHERE segments.date DURING YESTERDAY ORDER BY metrics.impressions ASC

adsapi 在 2022年1月20日 星期四下午5:49:28 [UTC+8] 的信中寫道：

[Google Ads API Forum Advisor]

Hello Kenneth,

Thanks for reaching out. With regards to your concern, it looks like we have a duplicate thread for this issue. We can keep correspondence related to this issue on the other thread to limit any confusion. Also, it has more context than this thread.

Best regards,

Jakeia Sabrina Google Ads API Team

 

ref:_00D1U1174p._5004Q2VNjbP:ref