geographic_view report duration

[Markus H.]

Hi,

we would like to retrieve one week of data using the "geographic_view Report".

Method:"/google.ads.googleads.v10.services.GoogleAdsService/SearchStream"

SELECT campaign.id,geographic_view.country_criterion_id,segments.geo_target_city,segments.geo_target_region,segments.date,metrics.cost_micros,metrics.clicks,metrics.conversions,metrics. impressions,metrics.ctr,metrics.all_conversions FROM geographic_view WHERE metrics.impressions > 0 AND segments.date >= '2022-04-25' AND segments.date <= '2022-05-01' AND campaign.id = xxxxxxx

Is it really possible that the query takes more than 2 hours for larger campaigns?

Best wishes
Markus

[Google Ads API Forum Advisor]

Hi Markus,

Thank you for raising this concern to the Google Ads API Forum.

To answer your question "Is it really possible that the query takes more than 2 hours for larger campaigns?", it can happen depending on the number of geo locations. However, to try this on our end, could you please provide complete logs within the format of the request and response logs with request-id and login-customer-id that generated on your end? For security purposes you can provide it via Reply privately to the author option. If this option is not available, then send it instead on this email address googleadsapi-support@google.com.

Best regards,

Jinky Google Ads API Team

ref:_00D1U1174p._5004Q2aPuce:ref