Hello, Thanks for the help. I was wondering if it is possible to retreive information from the last 90 days in the same way you can do it with 7, 14 and 30.
Regards, Jip Veerbeek On Wednesday, November 2, 2022 at 8:00:45 PM UTC+1 adsapi wrote: > Hi, > > Thank you for reaching out to the Google Ads API support team. > > Upon taking look at your query, I noticed that you are using incorrect > order by clause. Please see this > <https://developers.google.com/google-ads/api/docs/query/structure#order_by> > guide. > > Please find below query for example: > SELECT metrics.conversions, metrics.conversions_value, > metrics.cost_per_all_conversions, metrics.cost_per_conversion, > segments.date, ad_group.effective_target_cpa_micros, ad_group.id FROM > ad_group WHERE segments.date DURING LAST_7_DAYS ORDER BY segments.date ASC > > Let me know if you have any questions. > > Thanks, > [image: Google Logo] > Nirmita > Google Ads API Team > > > ref:_00D1U1174p._5004Q2fzMLL: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 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/ef447628-91e0-44c4-a0c1-357861419b29n%40googlegroups.com.