v6 month segment not working

167 views
Skip to first unread message

INI GlobalOps

unread,
Feb 12, 2021, 7:41:50 AM2/12/21
to AdWords API and Google Ads API Forum
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)
Reply all
Reply to author
Forward
0 new messages