Well, no. This query gets me good results:
1) SELECT metrics.cost_micros, campaign.name, *segments.month* FROM campaign WHERE *segments.date* >= '2018-07-01' AND *segments.date* <= '2018-08-07' whereas this query doesn't get any result: 2) SELECT metrics.cost_micros, campaign.name FROM campaign WHERE *segments.month* >= '2018-07-01' AND *segments.month* <= '2018-08-07' So obviously making sure "all the date segments are in the WHERE condition only" is not a correct answer. This query gives me the error message "Expects filters on the following field to limit a finite date range: 'segments.week'": 3) SELECT metrics.cost_micros, campaign.name, *segments.week* FROM campaign WHERE *segments.date* >= '2018-07-01' AND *segments.date* <= '2018-08-07' This is not consistent with the behavior of query #1, which makes us think of a bug. And this query doesn't get any result: 4) SELECT metrics.cost_micros, campaign.name FROM campaign WHERE *segments.week* >= '2018-07-01' AND *segments.week* <= '2018-08-07 Is there anyone at Google who can tell us how to get results by week? On Tuesday, May 21, 2019 at 11:49:47 PM UTC+2, adsapiforumadvisor wrote: > > Hello, > > While applying where condition for date segment in a query, you have to > make sure all the date segments are in the WHERE condition only. > > Regards, > Sai Teja, Google Ads API Team > > ref:_00D1U1174p._5001UAqFgy:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/bc3a4ac3-6336-456c-ba15-09658f8ca5c1%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
