Hello, I am trying to get campaign stats segmented by location. In some many cases I can do it but I have encountered some strange behaviors in the API about this.
First of all, I noticed that while in the user_location_view the available geo segments are: geo_target_airport geo_target_canton geo_target_city geo_target_county geo_target_district geo_target_metro geo_target_most_specific_location geo_target_postal_code geo_target_province geo_target_region geo_target_state In geo_target_constant the possibilities target types are (from last update in documentaiton: City Municipality Neighborhood District County Region City Region Borough Province University Airport State Country Department Territory Canton Autonomous Community Union Territory Prefecture Governorate Postal Code TV Region Okrug National Park Congressional DistrictCity Municipality Neighborhood District County Region City Region Borough Province University Airport State Country Department Territory Canton Autonomous Community Union Territory Prefecture Governorate Postal Code TV Region Okrug National Park Congressional District So we have so much different number of geo_target_constant type possibilities (depending on the country) than segments in user_location_view. I could undsertand it if it were any documentation about how to get different level of campaign stats based geo_target_constants and user_location_view possibilities depending on the country. But I cannot find anything about it. For example, For Netherlands, if I segments my query for campaign stats wby "geo_target_region", the results have provinces and regions segmentation, what is so confusing because I can obtain provinces asking with "geo_target_province". In Japan, I can get Prefectures segmentations asking by "geo_target_region" in the query. Is there any page to see this crearly? As I said, is so confussing. My main problem is that, in the case of Germany. I can see in the UI that it has different segmentation values at State and City levels, for example. And we have targeted States and Cities with applied bid modifiers in all of our campaign in a German account. But, when I try yo get this info by the API, there are no results. And I have tried it segmeting by "geo_target_region", "geo_target_state" and "geo_target_city" (separately). In all cases I have no results. This is the query I am doing: SELECT metrics.conversions, metrics.clicks, metrics.average_cpc, metrics.conversions_value, metrics.cost_micros, campaign.name, campaign.id, segments.geo_target_state FROM user_location_view WHERE segments.date BETWEEN '20230909' AND '20231009' """ And the same changing "segments.geo_target_state" by "segments.geo_target_region" and "segments.geo_target_city". Why I cannot get that results although I am seeing them through the UI? Thank you, Iván -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "Google Ads API and AdWords 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/d822f59d-edda-4954-ba58-8709808ad989n%40googlegroups.com.
