Re: performance for Google Ads shopping_performance_view

2022-02-23 Thread 'Hao Long' via Google Ads API and AdWords API Forum 
Thanks Kevin,

i will split the request into 9(5 days data per request).

Thanks
Hao

On Wednesday, February 23, 2022 at 10:09:40 PM UTC+8 Hao Long wrote:

> yes we have retry logic in our program(once failed it will retry after 
> 10mins) but still get the same failed result.
> i just confused we could one time download 45 days data but could not 
> achieve this in new Google Ads API.
>
> On Monday, February 21, 2022 at 5:37:14 PM UTC+8 adsapi wrote:
>
>> Hi Hao Long,
>>
>>  
>>
>> I suggest you implement exponential backoff pattern 
>> 
>>  in 
>> your retry logic, if you haven't already tried this yet. Also, I suggest to 
>> split the report into smaller date ranges in order to improve the 
>> performance of the API. You can do some post-processing on your end to 
>> merge the reports into a single one once you have all the data you need.
>>
>>  
>>
>> If you are still consistently encountering issues after following my 
>> suggestions, please provide the complete request 
>> 
>>  and response 
>> 
>>  logs 
>> with request ID 
>> 
>>  so 
>> we can further investigate. You may send the requested information via 
>> *Reply 
>> privately to author* option. If this option is not available, you may 
>> send the details directly to our googleadsa...@google.com alias instead.
>>
>>  
>>
>> Regards,
>> [image: Google Logo] 
>> Kevin Gil 
>> Google Ads API Team 
>>   
>>
>> ref:_00D1U1174p._5004Q2WxQjP: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/0c4980b9-f7a6-4809-b996-0cbf1cb5c345n%40googlegroups.com.

Re: performance for Google Ads shopping_performance_view

2022-02-23 Thread 'Hao Long' via Google Ads API and AdWords API Forum 
yes we have retry logic in our program(once failed it will retry after 
10mins) but still get the same failed result.
i just confused we could one time download 45 days data but could not 
achieve this in new Google Ads API.

On Monday, February 21, 2022 at 5:37:14 PM UTC+8 adsapi wrote:

> Hi Hao Long,
>
>  
>
> I suggest you implement exponential backoff pattern 
> 
>  in 
> your retry logic, if you haven't already tried this yet. Also, I suggest to 
> split the report into smaller date ranges in order to improve the 
> performance of the API. You can do some post-processing on your end to 
> merge the reports into a single one once you have all the data you need.
>
>  
>
> If you are still consistently encountering issues after following my 
> suggestions, please provide the complete request 
> 
>  and response 
> 
>  logs 
> with request ID 
> 
>  so 
> we can further investigate. You may send the requested information via *Reply 
> privately to author* option. If this option is not available, you may 
> send the details directly to our googleadsa...@google.com alias instead.
>
>  
>
> Regards,
> [image: Google Logo] 
> Kevin Gil 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2WxQjP: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/924ef647-c441-4395-8f35-97d23ca5fdf5n%40googlegroups.com.

performance for Google Ads shopping_performance_view

2022-02-19 Thread 'Hao Long' via Google Ads API and AdWords API Forum 
Hi Team,


we are facing performance issue when download data from shopping 
performance view. the case is we are downloading latest 45 days data from 
shopping performance report from Google Adwords API account by account, but 
it failed when we migrate to Google Ads API. could you please help identify 
the root cause?


Exception Message:
[2022-02-18 19:53:33,134] {bash.py:173} INFO - MethodName: 
google.ads.googleads.v9.services.GoogleAdsService/SearchStream
[2022-02-18 19:53:33,134] {bash.py:173} INFO - Endpoint: 
googleads.googleapis.com:443
[2022-02-18 19:53:33,134] {bash.py:173} INFO - Headers: 
{developer-token=REDACTED, login-customer-id=5749847778, 
x-goog-api-client=gl-java/1.8.0_275 gccl/0.0.0 gapic/ gax/2.6.1 grpc/}
[2022-02-18 19:53:33,134] {bash.py:173} INFO - Body: customer_id: 
"7740555995"
[2022-02-18 19:53:33,134] {bash.py:173} INFO - query: "select 
segments.date,segments.product_item_id,ad_group.id,campaign.id,segments.product_merchant_id,segments.product_custom_attribute0,segments.product_custom_attribute1,segments.product_custom_attribute2,segments.product_custom_attribute3,segments.product_custom_attribute4,segments.device,metrics.conversions_value
 
from shopping_performance_view  where segments.date between \"2021-12-28\" 
and \"2022-02-11\" and metrics.impressions > 0"
[2022-02-18 19:53:33,134] {bash.py:173} INFO - 
[2022-02-18 19:53:33,134] {bash.py:173} INFO - 
[2022-02-18 19:53:33,134] {bash.py:173} INFO - Response
[2022-02-18 19:53:33,134] {bash.py:173} INFO - 
[2022-02-18 19:53:33,134] {bash.py:173} INFO - Headers: null
[2022-02-18 19:53:33,134] {bash.py:173} INFO - Body: null
[2022-02-18 19:53:33,134] {bash.py:173} INFO - Failure message: null
[2022-02-18 19:53:33,134] {bash.py:173} INFO - Status: 
Status{code=DEADLINE_EXCEEDED, description=deadline exceeded after 
3599.997897730s. [closed=[], open=[[buffered_nanos=207933631, 
buffered_nanos=166584391, remote_addr=*]]], cause=null}.
[2022-02-18 19:53:33,134] {bash.py:173} INFO - 19:53:33.118 
[pool-9-thread-3] ERROR c.e.m.d.c.g.s.GoogleAdsAPIReportDownloadHelper - 
Donwload got exception: com.google.api.gax.rpc.DeadlineExceededException: 
io.grpc.StatusRuntimeException: DEADLINE_EXCEEDED: deadline exceeded after 
3599.997897730s. [closed=[], open=[[buffered_nanos=207933631, 
buffered_nanos=166584391, remote_addr=*]]]
[2022-02-18 19:53:33,134] {bash.py:173} INFO - 
com.google.api.gax.rpc.DeadlineExceededException: 
io.grpc.StatusRuntimeException: DEADLINE_EXCEEDED: deadline exceeded after 
3599.997897730s. [closed=[], open=[[buffered_nanos=207933631, 
buffered_nanos=166584391, remote_addr=*]]]
[2022-02-18 19:53:33,134] {bash.py:173} INFO -  at 
com.google.api.gax.rpc.ApiExceptionFactory.createException(ApiExceptionFactory.java:51)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
com.google.api.gax.grpc.GrpcApiExceptionFactory.create(GrpcApiExceptionFactory.java:72)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
com.google.api.gax.grpc.GrpcApiExceptionFactory.create(GrpcApiExceptionFactory.java:60)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
com.google.api.gax.grpc.ExceptionResponseObserver.onErrorImpl(ExceptionResponseObserver.java:82)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
com.google.api.gax.rpc.StateCheckingResponseObserver.onError(StateCheckingResponseObserver.java:86)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
com.google.api.gax.grpc.GrpcDirectStreamController$ResponseObserverAdapter.onClose(GrpcDirectStreamController.java:149)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
io.grpc.PartialForwardingClientCallListener.onClose(PartialForwardingClientCallListener.java:39)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
io.grpc.ForwardingClientCallListener.onClose(ForwardingClientCallListener.java:23)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
io.grpc.ForwardingClientCallListener$SimpleForwardingClientCallListener.onClose(ForwardingClientCallListener.java:40)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
com.google.ads.googleads.lib.logging.LoggingInterceptor$1$1.onClose(LoggingInterceptor.java:113)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
io.grpc.internal.DelayedClientCall$DelayedListener$3.run(DelayedClientCall.java:463)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
io.grpc.internal.DelayedClientCall$DelayedListener.delayOrExecute(DelayedClientCall.java:427)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
io.grpc.internal.DelayedClientCall$DelayedListener.onClose(DelayedClientCall.java:460)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
io.grpc.internal.ClientCallImpl.closeObserver(ClientCallImpl.java:557)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
io.grpc.internal.ClientCallImpl.access$300(ClientCallImpl.java:69)
[2022-02-18 19:53:33,135] {bash.py:173} INFO -  at 
io.grpc.internal.ClientCallImpl$ClientStreamListenerImpl$1StreamClosed.runInternal(ClientCallImpl.java:738)
[2022-02-18