https://developers.google.com/google-ads/api/docs/common-errors#internalerror
In this case, it looks like when trying to sum and aggregate the metrics that
the error occurs. This could be a question of volume or a data problem. So, I
have outlined some steps below for your to try. First, please verify the query
as we will use this as the basis for the comparison of results.
Base query:
Headers:
{
"developer-token": "REDACTED",
"login-customer-id": "REDACTED",
"x-goog-api-client": "gl-ruby/2.7.5 gccl/23.0.0 gax/0.6.1 gapic/23.0.0
grpc/1.54.3",
"x-goog-request-params": "customer_id=1250186013"
}
Payload:
{
"customerId": "1250186013",
"query": "SELECT campaign.id, metrics.all_conversions,
metrics.all_conversions_value, metrics.clicks, metrics.conversions,
metrics.conversions_value, metrics.cost_micros,
metrics.cross_device_conversions, metrics.engagements, metrics.impressions,
metrics.interactions, metrics.video_views, metrics.view_through_conversions,
campaign_criterion.criterion_id, segments.date
FROM location_view
WHERE segments.date
BETWEEN '2023-09-18'
AND '2023-09-18'
AND metrics.impressions > 0"
}
Things to report back on:
Does this occur every time this query is executed?
Remove all the metrics fields from the select statement. If that executes
successfully, ad them back one by one until you have duplicated the error.
For the date range an equality statement since you are only querying one day.
This message is in relation to case "ref:_00D1U1174p._5004Q2pQKaV:ref"
Thanks,
Bob Hancock
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/9a1B6000000000000000000000000000000000000000000000S2GXZ200cYt30PfzTQaruJiT5CaZ5w%40sfdc.net.
