Re: Querying aggregated metrics for custom intervals

2020-11-20 Thread Google Ads API Forum Advisor Prod
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

Re: Querying aggregated metrics for custom intervals

2020-11-20 Thread Антон Бендриков
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

Re: Querying aggregated metrics for custom intervals

2020-11-19 Thread Google Ads API Forum Advisor Prod
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

Re: Querying aggregated metrics for custom intervals

2020-11-19 Thread Антон Бендриков
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

RE: Querying aggregated metrics for custom intervals

2020-11-18 Thread Google Ads API Forum Advisor Prod
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

Querying aggregated metrics for custom intervals

2020-11-18 Thread Антон Бендриков
Description: for the purposes of an example, lets say I have an Ad Group. I want to know how many impressions/clicks/other metrics I received on this Ad Group in the last 7 days (or any other from X to Y interval) daily (or hourly, or any other aggregate criteria). Problem: as far as I can