GAQL date error
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.
Matching Shopping Data to the UI
Hello, I am noticing that the metrics, mainly clicks, conversions, cost, impressions, in my SHOPPING_PERFORMANCE_REPORT and the shopping campaigns from ADGROUP_PERFORMANCE_REPORT, pulled from the API no longer seems to be matching up with what I'm seeing in the Adwords UI when looking at Shopping campaigns. Focusing on the SHOPPING_PERFORMANCE_REPORT, clicks, cost, and conversions seem to be undercounting, while impressions are hugely overcounted, similar to this person: https://groups.google.com/g/adwords-api/c/rXhfyUpyBMA/m/IHwywfOPAQAJ Looking at the offer IDs returned by the SHOPPING_PERFORMANCE_REPORT I'm also seeing the issue of products which aren't in the merchant center showing up in the shopping_performance_report, similar to this person: https://groups.google.com/g/adwords-api/c/2Q-ICv-dMBU/m/ayW3GBEBAgAJ These are the fields I'm requesting for my SHOPPING_PERFORMANCE_REPORT: ['AccountDescriptiveName', 'OfferId', 'AdGroupId', 'AdGroupStatus', 'CampaignId', 'Device', 'Date', 'Clicks', 'Conversions','Cost','Impressions', 'ConversionValue'] -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/988ea364-8674-4c85-9b0f-622e623df1e7n%40googlegroups.com.