Re: Get shopping_performance_view including zero impressions

2022-01-20 Thread 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+

Get shopping_performance_view including zero impressions

2022-01-20 Thread 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? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdev

Shopping ads products

2022-01-19 Thread kenneth hung
Hi, I'm trying to get the shopping ads products performance, but it seems that I can only get the products that the impressions is greater then zero. Is it possible to get all products performance? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://google