Hi!
after updating to v6 we are getting* this error:*
error_code {
query_error: EXPECTED_FILTERS_ON_DATE_RANGE
}
message: "Expects filters on the following field to limit a finite date
range: \'segments.month\'"
}
this was working fine before v6 can you help? more details below.
*whole message:*
Traceback (most recent call last):
File
"C:\Python\Python38\lib\site-packages\google\ads\google_ads\interceptors\exception_interceptor.py",
line 92, in __next__
return next(self._underlay_call)
File "C:\Python\Python38\lib\site-packages\grpc\_channel.py", line 416,
in __next__
return self._next()
File "C:\Python\Python38\lib\site-packages\grpc\_channel.py", line 620,
in _next
return self._next_response()
File "C:\Python\Python38\lib\site-packages\grpc\_channel.py", line 607,
in _next_response
raise self
grpc._channel._SingleThreadedRendezvous: <_SingleThreadedRendezvous of RPC
that terminated with:
status = StatusCode.INVALID_ARGUMENT
details = "Request contains an invalid argument."
debug_error_string =
"{"created":"@1613133429.474000000","description":"Error received from peer
ipv4:172.217.6.170:443","file":"src/core/lib/surface/call.cc","file_line":1068,"grpc_message":"Request
contains an invalid argument.","grpc_status":3}"
>
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File ".\campaign_report.py", line 525, in <module>
run_app()
File ".\campaign_report.py", line 522, in run_app
write_campaign_reports(non_az_account_list)
File ".\campaign_report.py", line 492, in write_campaign_reports
raw_batch_list = get_batch_list(account['account_id'],
campaign_info["api_query"])
File ".\campaign_report.py", line 178, in get_batch_list
response = ga_service.search_stream(str(customer_id), query)
File
"C:\Python\Python38\lib\site-packages\google\ads\google_ads\v6\services\google_ads_service_client.py",
line 326, in search_stream
return self._inner_api_calls['search_stream'](request, retry=retry,
timeout=timeout, metadata=metadata)
File
"C:\Python\Python38\lib\site-packages\google\api_core\gapic_v1\method.py",
line 143, in __call__
return wrapped_func(*args, **kwargs)
File "C:\Python\Python38\lib\site-packages\google\api_core\retry.py",
line 281, in retry_wrapped_func
return retry_target(
File "C:\Python\Python38\lib\site-packages\google\api_core\retry.py",
line 184, in retry_target
return target()
File "C:\Python\Python38\lib\site-packages\google\api_core\timeout.py",
line 214, in func_with_timeout
return func(*args, **kwargs)
File
"C:\Python\Python38\lib\site-packages\google\api_core\grpc_helpers.py",
line 144, in error_remapped_callable
return _StreamingResponseIterator(result)
File
"C:\Python\Python38\lib\site-packages\google\api_core\grpc_helpers.py",
line 72, in __init__
self._stored_first_result = six.next(self._wrapped)
File
"C:\Python\Python38\lib\site-packages\google\ads\google_ads\interceptors\exception_interceptor.py",
line 100, in __next__
raise e
File
"C:\Python\Python38\lib\site-packages\google\ads\google_ads\interceptors\exception_interceptor.py",
line 97, in __next__
self._failure_handler(self._underlay_call)
File
"C:\Python\Python38\lib\site-packages\google\ads\google_ads\interceptors\exception_interceptor.py",
line 141, in _handle_grpc_failure
raise self._get_error_from_response(response)
google.ads.google_ads.errors.GoogleAdsException:
(<_SingleThreadedRendezvous of RPC that terminated with:
status = StatusCode.INVALID_ARGUMENT
details = "Request contains an invalid argument."
debug_error_string =
"{"created":"@1613133429.474000000","description":"Error received from peer
ipv4:172.217.6.170:443","file":"src/core/lib/surface/call.cc","file_line":1068,"grpc_message":"Request
contains an invalid argument.","grpc_status":3}"
>, <_SingleThreadedRendezvous of RPC that terminated with:
status = StatusCode.INVALID_ARGUMENT
details = "Request contains an invalid argument."
debug_error_string =
"{"created":"@1613133429.474000000","description":"Error received from peer
ipv4:172.217.6.170:443","file":"src/core/lib/surface/call.cc","file_line":1068,"grpc_message":"Request
contains an invalid argument.","grpc_status":3}"
>, errors {
error_code {
query_error: EXPECTED_FILTERS_ON_DATE_RANGE
}
message: "Expects filters on the following field to limit a finite date
range: \'segments.month\'"
}
, '66siKic13KIzYPhoHLbG-Q')
*here's our query:*
SELECT
campaign.id,
campaign.name,
campaign.status,
campaign.start_date,
campaign.end_date,
campaign_budget.total_amount_micros,
campaign.vanity_pharma.vanity_pharma_display_url_mode,
campaign.vanity_pharma.vanity_pharma_text,
bidding_strategy.name,
bidding_strategy.type,
metrics.impressions,
metrics.clicks,
metrics.impressions,
metrics.ctr,
metrics.cost_micros,
metrics.interactions,
metrics.engagements,
metrics.conversions,
metrics.all_conversions,
metrics.absolute_top_impression_percentage,
metrics.all_conversions_value,
metrics.search_impression_share,
metrics.search_budget_lost_impression_share,
metrics.search_rank_lost_impression_share,
metrics.value_per_all_conversions,
metrics.cross_device_conversions,
metrics.active_view_viewability,
metrics.active_view_impressions,
metrics.active_view_measurable_impressions,
metrics.all_conversions,
metrics.all_conversions_value,
metrics.content_budget_lost_impression_share,
metrics.content_impression_share,
metrics.content_rank_lost_impression_share,
metrics.search_absolute_top_impression_share,
metrics.search_budget_lost_absolute_top_impression_share,
metrics.search_budget_lost_top_impression_share,
metrics.search_click_share,
metrics.search_exact_match_impression_share,
metrics.search_impression_share,
metrics.search_rank_lost_absolute_top_impression_share,
metrics.search_rank_lost_top_impression_share,
metrics.search_top_impression_share,
metrics.top_impression_percentage,
metrics.video_quartile_p100_rate,
metrics.video_quartile_p25_rate,
metrics.video_quartile_p50_rate,
metrics.video_quartile_p75_rate,
metrics.video_view_rate,
metrics.video_views,
metrics.view_through_conversions,
metrics.active_view_measurable_impressions,
metrics.active_view_impressions,
segments.month
FROM campaign
WHERE segments.month >= '{}-01-01'
ORDER BY campaign.id
'''.format(current_year)
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/16f48cfb-3e6b-4cdf-b973-41c7e3a76590n%40googlegroups.com.
