GoogleAdsAPI V16 geographic_view

[ryo]

I'm currently using GoogleAdsAPI V16 and ASP.NET Core RazorPages to create a process that captures the number of impressions and clicks over a period of time.

However, I don't know how to get the number of impressions and clicks by region.

I am creating a query to retrieve data from the geographic_view table, but I was only able to retrieve country information for Japan.

If anyone has created a similar process, please let me know.

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

By reviewing your query, I understand that you are looking for geographical location dimension data via API. Please refer to this example GAQL query on how to retrieve Locations using the Google Ads API.

You may use the geographic_view report. Geographic View includes all metrics aggregated at the country level, one row per country. It reports metrics at either the actual physical location of the user or an area of interest. If other segment fields are used, you may get more than one row per country using the user_location_view report. It reports metrics at the actual physical location of the user by targeted or not targeted location. 

Also, you can use Query Builder to create your query and Query Validator to validate your query. 

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02rzyq0:ref" (ADR-00227399)

Thanks,
 

Google Ads API Team

[ryo]

This problem was resolved with the following query. SELECT
                                campaign.id,
                                ad_group.id,
                                segments.ad_network_type,
                                geographic_view.country_criterion_id,
                                segments.geo_target_most_specific_location,
                                segments.geo_target_city,
                                segments.date,
                                metrics.impressions,
                                metrics.clicks,
                                metrics.cost_micros,
                                metrics.conversions,
                                metrics.interactions
                            FROM geographic_view However, I would like to obtain data linked to the area currently set for targeting, rather than information for each city.

2024年3月15日金曜日 16:49:37 UTC+9 ryo:

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

Please refer to this example GAQL query on how to retrieve Locations using the Google Ads API. You may use the geographic_view report. Geographic View includes all metrics aggregated at the country level, one row per country. It reports metrics at either the actual physical location of the user or an area of interest. If other segment fields are used, you may get more than one row per country.

Also, you can use the user_location_view resource, it reports metrics at the actual physical location of the user by targeted or not targeted location. If other segment fields are used, you may get more than one row per country.