user_location_view

AI-generated Key Takeaways

outlined_flag

• The User Location View provides geographical insights into campaign performance by aggregating metrics at the country level, distinguishing between targeted and non-targeted locations.

• Marketers can leverage segments like ad network type, conversion details, date ranges, device, and geographical targets (city, metro, region) to analyze user location data.

• A wide array of metrics, including clicks, conversions, cost, impressions, and interaction rates, can be queried to understand user behavior and campaign effectiveness across different locations.

• Resources like customer data can be selected for analysis, while ad group and campaign data can be utilized to segment the metrics for deeper insights.

• The provided table outlines various fields, segments, and metrics available within the user_location_view , specifying their data types, filterability, selectability, and sortability for customized reporting.

A user location view. User Location View includes all metrics aggregated at the country level, one row per country. 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.

Fields from the above resources may be selected along with this resource in your SELECT and WHERE clauses. These fields will not segment metrics in your SELECT clause.

Fields from the above resources, when selected along with this resource in your SELECT and WHERE clauses, will segment metrics.

Fields/Segments/Metrics

This page shows all metrics and segments that can be put in the same SELECT clause as the fields of user_location_view . However, when you specify user_location_view in the FROM clause, some metrics and segments cannot be used. Use the following filter to show only the fields that can be used when user_location_view is specified in the FROM clause.

Is user_location_view specified in the FROM clause of your query?