DistanceView
A distance view with metrics aggregated by the users distance from an advertisers location extensions. Each DistanceBucket includes all impressions that fall within its distance and a single impression will contribute to the metrics for all DistanceBuckets that include the users distance.
Table Specific Information
Select
Google Ads does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the Ads console.
To use the nondefault fields, explicitly select them in your query.
Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the Ads API.
Columns
Name | Type | Behavior | Description |
DistanceViewDistanceBucket | String | Attribute | DistanceBucket column for table DistanceView |
DistanceViewMetricSystem | Bool | Attribute | MetricSystem column for table DistanceView |
DistanceViewResourceName | String | Attribute | ResourceName column for table DistanceView |
CustomerId | Long | Attribute | ClientCustomerId column for table DistanceView |
AllConversions | Double | Metric | AllConversions column for table Metrics |
AllConversionsFromInteractionsRate | Double | Metric | AllConversionsFromInteractionsRate column for table Metrics |
AllConversionsValue | Double | Metric | AllConversionsValue column for table Metrics |
AverageCpc | Double | Metric | AverageCpc column for table Metrics |
AverageCpm | Double | Metric | AverageCpm column for table Metrics |
Clicks | Long | Metric | Clicks column for table Metrics |
Conversions | Double | Metric | Conversions column for table Metrics |
ConversionsFromInteractionsRate | Double | Metric | ConversionsFromInteractionsRate column for table Metrics |
ConversionsValue | Double | Metric | ConversionsValue column for table Metrics |
CostMicros | Long | Metric | CostMicros column for table Metrics |
CostPerAllConversions | Double | Metric | CostPerAllConversions column for table Metrics |
CostPerConversion | Double | Metric | CostPerConversion column for table Metrics |
CrossDeviceConversions | Double | Metric | CrossDeviceConversions column for table Metrics |
Ctr | Double | Metric | Ctr column for table Metrics |
Impressions | Long | Metric | Impressions column for table Metrics |
ValuePerAllConversions | Double | Metric | ValuePerAllConversions column for table Metrics |
ValuePerConversion | Double | Metric | ValuePerConversion column for table Metrics |
ViewThroughConversions | Long | Metric | ViewThroughConversions column for table Metrics |
AdNetworkType | String | Segment | AdNetworkType column for table Segments |
ConversionAction | String | Segment | ConversionAction column for table Segments |
ConversionActionCategory | String | Segment | ConversionActionCategory column for table Segments |
ConversionActionName | String | Segment | ConversionActionName column for table Segments |
Date | Date | Segment | Date column for table Segments |
DayOfWeek | String | Segment | DayOfWeek column for table Segments |
Device | String | Segment | Device column for table Segments |
ExternalConversionSource | String | Segment | ExternalConversionSource column for table Segments |
Month | Date | Segment | Month column for table Segments |
MonthOfYear | String | Segment | MonthOfYear column for table Segments |
Quarter | Date | Segment | Quarter column for table Segments |
Week | Date | Segment | Week column for table Segments |
Year | Int | Segment | Year column for table Segments |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |
Last updated