Re: query on product_group_view with filter on segments.conversion_action_name always yields internal_error

2023-12-05 Thread 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum 
Hi,

Thank you for getting back to us.

I will check with our team regarding your issue and one of my team members will 
reach out to you once we have an update on this. Meanwhile, your patience is 
highly appreciated.
This message is in relation to case "ref:!00D1U01174p.!5004Q02qWVKW:ref"

Thanks,

Google Ads API Team

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/K2wZ50S57JYR00KPcQpEoKQISxvX8IoSmO9w%40sfdc.net.

Re: query on product_group_view with filter on segments.conversion_action_name always yields internal_error

2023-12-05 Thread Konstantin Tarassow 
Hello, this are the corresponding logs as output by the officials GoogleAds 
API SDK, incl. headers and request-id:

Method Name: 
/google.ads.googleads.v14.services.GoogleAdsService/SearchStream
Host: googleads.googleapis.com
Headers: {
"x-goog-api-client": "gl-php\/8.0.30 gccl\/19.2.0 gapic\/19.2.0 
gax\/1.18.2 grpc\/1.50.2 rest\/1.18.2 pb\/+n",
"x-goog-request-params": "customer_id=8875125139",
"developer-token": "REDACTED",
"login-customer-id": "4554523147"
}
Request:
{"customerId":"8875125139","query":"\nSELECT 
segments.date,\ncampaign.id,\nad_group.id,\nad_group_criterion.criterion_id,\nsegments.conversion_action_category,\nsegments.conversion_action_name,\nmetrics.all_conversions,\nsegments.ad_network_type,\nsegments.device,\nmetrics.conversions_value,\nmetrics.view_through_conversions\n
 
   FROM product_group_view\nWHERE 
segments.date BETWEEN '2023-10-23' AND '2023-12-02'\n   
 AND campaign.status IN(ENABLED, PAUSED, REMOVED)\nAND 
ad_group.status IN(ENABLED, PAUSED, REMOVED)\nAND 
ad_group_criterion.status IN(ENABLED, PAUSED, REMOVED)\n   
 AND *segments.conversion_action_name IN('store_visits', 'Ladenbesuche')*\n 
   AND metrics.all_conversions > 0.0\n   
 AND ad_group_criterion.listing_group.type = 'UNIT'\n   AND segments.date = 
'2023-12-02' "}

Response
---
Headers: {
"request-id": "XcBQeB5fCVrDCJq7idXwNQ",
"date": "Sun, 03 Dec 2023 05:54:20 GMT",
"alt-svc": "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
}

Fault
---
Status code: 13
Details: Internal error encountered.
Failure: 
{"errors":[{"errorCode":{"internalError":"INTERNAL_ERROR"},"message":"An 
internal error has occurred."}],"requestId":"XcBQeB5fCVrDCJq7idXwNQ"}
Exception in retryDecider: {
"message": "Internal error encountered.",
"code": 13,
"status": "INTERNAL",
"details": [
{
"@type": "google.ads.googleads.v14.errors.googleadsfailure-bin",
"data": ""
},
{
"@type": "grpc-status-details-bin",
"data": ""
},
{
"@type": "request-id",
"data": "XcBQeB5fCVrDCJq7idXwNQ"
}
]
}

On Tuesday, December 5, 2023 at 9:38:44 AM UTC+1 Google Ads API Forum 
Advisor wrote:

> Hi,
>
> Thank you for getting back to us.
>
> kindly provide us with the complete updated API logs * request* 
> 
>  and* response* 
> 
>  logs 
> with* request ID* 
> 
>  and* request header* 
> 
>  generated 
> on your end to better assist you further.
>
>
> If you are using a client library and haven't enabled the logging yet, I 
> would request you to enable logging for the specific client library that 
> you are using. You can refer to the guides *Java* 
> 
> , *.Net* 
> 
> , *PHP* 
> 
> , *Python* 
> 
> , *Ruby* 
> 
>  or *Perl* 
>  
> to 
> enable logging at your end. For REST interface requests, you can enable 
> logging via the curl command by using the -i flag.
>
> You can send the details via *Reply privately to the author option*, or 
> *direct 
> private reply* to this email.
>   
> This message is in relation to case "ref:!00D1U01174p.!5004Q02qWVKW:ref"
>
> Thanks,
>   
> [image: Google Logo] Google Ads API Team 
>
>
>  
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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

Re: query on product_group_view with filter on segments.conversion_action_name always yields internal_error

2023-12-04 Thread Konstantin Tarassow 
Hello, this happens on every request for the given client, since at least 
several weeks, regardless of time of the day or number of requests.
We are already using a backoff retry mechanism.

On Monday, December 4, 2023 at 8:28:02 PM UTC+1 Google Ads API Forum 
Advisor wrote:

> Hi,
>
> Thank you for reaching out to the Google Ads API support team.
>
> After reviewing your concern, I understand that you are getting an 
> Internal Error while trying to extract data from product_group_view. This 
> *error* 
> 
>  occurs 
> when something unexpected happens while processing the request. You can 
> refer to this help center article on how to handle the InternalError 
> .
>  
> When you retry requests, use an exponential backoff policy. For example, if 
> you first pause 5 seconds before the first retry, you could pause 10 
> seconds after the second and 20 seconds after the third retry. *Exponential 
> backoff* 
> 
>  helps 
> ensure you are not calling the API too many times.
>
> If the issue persists after trying the provided suggestion, then you may 
> provide us with the complete* request* 
> 
>  and* response* 
> 
>  logs 
> with* request ID* 
> 
>  and* request header* 
> 
>  generated 
> on your end to better assist you further.
>
> If you are using a client library and haven't enabled the logging yet, I 
> would request you to enable logging for the specific client library that 
> you are using. You can refer to the guides *Java* 
> 
> , *.Net* 
> 
> , *PHP* 
> 
> , *Python* 
> 
> , *Ruby* 
> 
>  or *Perl* 
>  
> to 
> enable logging at your end. For REST interface requests, you can enable 
> logging via the curl command by using the -i flag.
>
> You can send the details via *Reply privately to the author option*, or 
> *direct 
> private reply* to this email.
>
>   
> This message is in relation to case "ref:!00D1U01174p.!5004Q02qWVKW:ref"
>
> Thanks,
>   
> [image: Google Logo] Google Ads API Team 
>
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/d9a5daff-232a-464e-96a6-7a35b6620410n%40googlegroups.com.

Query on product_group_view with filter on segments.conversion_action_name always yields INTERNAL_ERROR

2023-12-04 Thread Konstantin Tarassow 
Hello,

for exactly 1 account when we run a query on *product_group_view* and use 
an *IN clause on segments.conversion_action_name* we always run into an 
*INTERNAL_ERROR*, at least since weeks. This is only the case for 1 
specific account, all other accounts from the same MCC and other customers 
are returning data just fine.

Here are the logs:

Method Name: 
/google.ads.googleads.v14.services.GoogleAdsService/SearchStream
Host: googleads.googleapis.com
Headers: {
"x-goog-api-client": "gl-php\/8.0.30 gccl\/19.2.0 gapic\/19.2.0 
gax\/1.18.2 grpc\/1.50.2 rest\/1.18.2 pb\/+n",
"x-goog-request-params": "customer_id=8875125139",
"developer-token": "REDACTED",
"login-customer-id": "4554523147"
}
Request:
{"customerId":"8875125139","query":"\nSELECT 
segments.date,\ncampaign.id,\nad_group.id,\nad_group_criterion.criterion_id,\nsegments.conversion_action_category,\nsegments.conversion_action_name,\nmetrics.all_conversions,\nsegments.ad_network_type,\nsegments.device,\nmetrics.conversions_value,\nmetrics.view_through_conversions\n
 
   FROM product_group_view\nWHERE 
segments.date BETWEEN '2023-10-23' AND '2023-12-02'\n   
 AND campaign.status IN(ENABLED, PAUSED, REMOVED)\nAND 
ad_group.status IN(ENABLED, PAUSED, REMOVED)\nAND 
ad_group_criterion.status IN(ENABLED, PAUSED, REMOVED)\n   
 AND *segments.conversion_action_name IN('store_visits', 'Ladenbesuche')*\n 
   AND metrics.all_conversions > 0.0\n   
 AND ad_group_criterion.listing_group.type = 'UNIT'\n   AND segments.date = 
'2023-12-02' "}

Response
---
Headers: {
"request-id": "XcBQeB5fCVrDCJq7idXwNQ",
"date": "Sun, 03 Dec 2023 05:54:20 GMT",
"alt-svc": "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
}

Fault
---
Status code: 13
Details: Internal error encountered.
Failure: 
{"errors":[{"errorCode":{"internalError":"INTERNAL_ERROR"},"message":"An 
internal error has occurred."}],"requestId":"XcBQeB5fCVrDCJq7idXwNQ"}
Exception in retryDecider: {
"message": "Internal error encountered.",
"code": 13,
"status": "INTERNAL",
"details": [
{
"@type": "google.ads.googleads.v14.errors.googleadsfailure-bin",
"data": ""
},
{
"@type": "grpc-status-details-bin",
"data": ""
},
{
"@type": "request-id",
"data": "XcBQeB5fCVrDCJq7idXwNQ"
}
]
}

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/8bdba458-2094-4af5-96f2-02fa2b260427n%40googlegroups.com.