Google Ads API segmentation

[Greg Whyte]

Is there anyway to mimic the AdWords reporting segmentation with the Google Ads API? My original AdWords query works great, something like:

SELECT HourOfDay, Cost FROM ACCOUNT_PERFORMANCE_REPORT DURING TODAY

I get a row back for each hour of the day that has data. My attempt at replicating this with the Ads API:

SELECT segments.hour, metrics.cost_micros FROM customer WHERE segments.date DURING TODAY

Only returns one row for the whole day. My search of the documentation hasn't turned up anything helpful. Basically looking for a GROUP BY? Is what I want even possible with the new API, or am I just out of luck? Will I need to issue 24 requests to get the days data now?

[googleadsapi...@google.com]

Hi Greg,

Upon checking this on my end, I was also able to replicate the same results wherein the results only returns 1 row. I have filed a bug regarding this and will update you with further information once available.

Regards,

Dannison

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/adwords_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@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+unsubscribe@googlegroups.com.
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/2e5dda14-f1ad-436b-8464-ef93af84594e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[googleadsapi...@google.com]

Hi Greg,

Bumping on this thread for insights. Could you confirm if the account you are using has metrics > 0 generated for more than 1 hour? The API will only return rows for segments.hour values with nonzero metrics values.

Regards,

Dannison

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:

    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

On 03/29/19 03:20:28 greg.a...@gmail.com wrote:

--

[Greg Whyte]

Hey Dannison! I can confirm that the account has metrics generated for more than 1 hour. Any other info I can provide?

--Greg

On Tuesday, April 23, 2019 at 1:08:31 AM UTC-4, googleadsapi-forumadvisor wrote:

Hi Greg,

Bumping on this thread for insights. Could you confirm if the account you are using has metrics > 0 generated for more than 1 hour? The API will only return rows for segments.hour values with nonzero metrics values.

Regards,

Dannison

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

[googleadsapi...@google.com]

Hi Greg,

Thank you for confirming this. Could you provide your clientCustomerId using the reply privately to author option so I could have the team investigate this further?

Regards,

Dannison

Google Ads API Team 

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ccd5a99b-5c70-4f9d-a545-c115bb8e1d22%40googlegroups.com.