I'm trying to create the following GAQL query: SELECT segments.product_item_id, ad_group.status, campaign.name, ad_group.name, segments.device, metrics.clicks, metrics.conversions, metrics.cost_micros, metrics.impressions, segments.date FROM shopping_performance_view WHERE segments.date DURING LAST_7_DAYS
However, both in my API calls and in the GAQL Query validator this query fails. Query validator gives the following error: "The filtering conditions in the WHERE clause must combine to form a valid, finite date range composed of the core date segments 'segments.date', 'segments.week', 'segments.month', 'segments.quarter', 'segments.year' if a core date segment is present in a query" Why is DURING LAST_7_DAYS not considered a "valid, finite date range"? I have tried other date ranges take from examples such as: "segments.date BETWEEN '2019-01-01' AND '2019-01-31'" and I'm still getting the same error. According to this blog post: https://ads-developers.googleblog.com/2021/05/the-query-builder-blog-series-part-7.html I would assume this to be a correct query. What am I missing? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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/69531de1-6c38-48c0-a257-e2504f37e471n%40googlegroups.com.
