Hello,
since 2024-01-10 multiple accounts of our clients stopped delivering data
via API.
When debugging we could pinpoint the problem to the following query:
SELECT segments.date campaign.id ad_group.id
ad_group_criterion.criterion_id, ad_group_criterion.criterion_id,
segments.ad_network_type, segments.device, metrics.cost_micros,
metrics.clicks, metrics.impressions, metrics.impressions
FROM product_group_view WHERE segments.date BETWEEN
'2024-01-10' AND '2024-01-15' AND campaign.status
IN(ENABLED, PAUSED, REMOVED) AND ad_group.status
IN(ENABLED, PAUSED, REMOVED) AND
ad_group_criterion.status IN(ENABLED, PAUSED, REMOVED)
AND ad_group_criterion.listing_group.type = 'UNIT' AND
metrics.impressions > 0 AND segments.date = '2024-01-10'
Here is an example request, response with Ids, query log etc.
-------
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=6122809176",
"developer-token": "REDACTED",
"login-customer-id": "4554523147"
}
Request:
{"customerId":"6122809176","query":"\n SELECT
segments.date,\ncampaign.id,\nad_group.id,\nad_group_criterion.criterion_id,\nad_group_criterion.criterion_id,\nsegments.ad_network_type,\nsegments.device,\nmetrics.cost_micros,\nmetrics.clicks,\nmetrics.impressions,\nmetrics.impressions\n
FROM product_group_view\n WHERE
segments.date BETWEEN '2024-01-10' AND '2024-01-15'\n
AND campaign.status IN(ENABLED, PAUSED, REMOVED)\n AND
ad_group.status IN(ENABLED, PAUSED, REMOVED)\n AND
ad_group_criterion.status IN(ENABLED, PAUSED, REMOVED)\n
AND ad_group_criterion.listing_group.type = 'UNIT'\n AND
metrics.impressions > 0 AND segments.date = '2024-01-10' "}
Response
-------
Headers: {
"request-id": "e31ZJDPF02Xfo145qZnyaA",
"date": "Tue, 16 Jan 2024 21:56:59 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":"e31ZJDPF02Xfo145qZnyaA"}
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/0ea5f8c2-3794-4d0d-b0b7-7bd632e04570n%40googlegroups.com.
