Re: Querying aggregated metrics for custom intervals

Hi Антон, Thank you for reaching out. The segmentation in the GAQL and AWQL is basically behaving the same as 'GROUP BY' in SQL language. I’m very confident that it will work for your use case. Thanks and regards, Xiaoming, Google Ads API Team Xiaoming Google Ads API Team ref:_00D1U1174p._500

Re: Querying aggregated metrics for custom intervals

I realised I don't actually have data to test this with (don't think test ads accounts can have any data on them and my app is not yet allowed to work with live accouts). So I will just assume that this works as expected (the docs seem pretty convincing) and close this. tl;dr If you want to ha

Re: Querying aggregated metrics for custom intervals

Hi Антон, Thank you for reaching out. Yes, this is correct. Please let us know if you have any further concerns. Thanks and regards, Xiaoming, Google Ads API Team Xiaoming Google Ads API Team ref:_00D1U1174p._5004Q27ulap:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find u

Re: Querying aggregated metrics for custom intervals

Hello, thank you for the answer! Ah so this looks to me like I can effectively do `SELECT segments.date` to achieve the `GROUP BY` functionality I want. Will test later and post if this helped. On Wednesday, 18 November 2020 at 20:39:21 UTC adsapiforumadvisor wrote: > Hi Антон, > > Thank you fo

RE: Querying aggregated metrics for custom intervals

Hi Антон, Thank you for reaching out. You could actually fetch data for a date range in one query via the Google Ads API. You could use date-related segment fields to implement the query. Thanks and regards, Xiaoming, Google Ads API Team Xiaoming Google Ads API Team ref:_00D1U1174p._5004Q27ul