Re: Google Ads API segmentation

[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/
> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
>
> On 03/29/19 03:20:28 greg@gmail.com  wrote:
>
> 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?
>
> -- 
> -- 
> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
> 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 
> "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+unsubscr...@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.
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@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/ccd5a99b-5c70-4f9d-a545-c115bb8e1d22%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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?

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@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.