Hi, Thank you for reaching out to the Google Ads API support team.
Based on the information provided, it appears that you have specified the date range as '2024-01-01' to '2024-06-31'. Please be aware that June only has 30 days. To retrieve product performance data for a specific merchant center ID and period, you can try the following modified query: SELECT metrics.conversions, metrics.impressions, metrics.cost_micros, metrics.clicks, metrics.conversions_value, segments.device, segments.product_item_id, segments.product_merchant_id, segments.date FROM shopping_performance_view WHERE segments.date BETWEEN '2024-01-01' AND '2024-06-30' AND segments.product_merchant_id IN (12345678) Additionally, you can utilize the Query Builder and Query Validator to build and validate your queries. To retrieve Google Ads API entities and reporting data, you can use one of these Rest Interface methods like GoogleAdsService.SearchStream or GoogleAdsService.Search. This message is in relation to case "ref:!00D1U01174p.!5004Q02vGeYj:ref" (ADR-00271803) Thanks, Google Ads API Team -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/hCeSd000000000000000000000000000000000000000000000SLEROH00q-wFX0L1SAqz-FkCk_WTGg%40sfdc.net.