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.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.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'
'''.format(current_year)