1. Does this occur every time this query is executed? No. It works for some date range and fails for another.
2. 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. I have found that the error goes away if I don't use metrics.all_conversions in the query for the date when it fails 3. For the date range an equality statement since you are only querying one day. Ideally, I want to query for date ranges so I am using this type of query pattern as an example. On Friday, October 13, 2023 at 6:41:47 PM UTC+5:30 Google Ads API Forum Advisor wrote: > > 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, > > [image: Google Logo] > 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/93eb7d02-622d-4e70-92d3-80e5bd253dafn%40googlegroups.com.
