Hi, I want to fetch product performance data. I've referred shopping ads reporting documentation
1. I used Shopping Performance View <https://developers.google.com/google-ads/api/fields/v20/shopping_performance_view>. but in that data isn't matching with google ads dashboard *Query we've used:* SELECT segments.product_item_id,segments.product_title, segments.product_channel, metrics.clicks, metrics.cost_micros, metrics.impressions, metrics.conversions, metrics.all_conversions, segments.month, segments.date FROM shopping_performance_view WHERE segments.date >='" . $start_date . "' and segments.date <='" . $end_date . "' and metrics.cost_micros > 0 ORDER BY segments.date DESC 2. I used Shopping Product <https://developers.google.com/google-ads/api/fields/v20/shopping_product>. in that I tested with campaign filter and date filter and we're getting correct result as per the dashboard *Query we've used:* SELECT shopping_product.resource_name, shopping_product.campaign, campaign.name, shopping_product.channel, shopping_product.item_id, shopping_product.status, shopping_product.title, metrics.clicks, metrics.cost_micros, metrics.impressions FROM shopping_product WHERE shopping_product.campaign = 'customers/3886993576/campaigns/22146800790' AND segments.date >= '2025-03-01' AND segments.date <= '2025-03-31' but in this there's issue like we're unable to segment data by date or month etc. Also it doesn't allow multiple campaign filteration Is there any other resources available which can provide product performance with segmentation by date or month and with multiple campaign filter.? Thanks. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/adwords-api/323c0884-9ff7-4de8-9779-d12d1155d022n%40googlegroups.com.
