UserAdDistance

The User Ad Distance Report provides statistics aggregated by the user's distance from your location extensions.

Columns

Name

Type

Behavior

DisplayName

Description

AccountCurrencyCode

String

Attribute

Currency

Currency for the UserAdDistance report.

AccountDescriptiveName

String

Attribute

Account

Account for the UserAdDistance report.

AccountTimeZone

String

Attribute

Time Zone

Time Zone for the UserAdDistance report.

CampaignId

Long

Attribute

Campaign ID

Campaign ID for the UserAdDistance report.

CampaignName

String

Attribute

Campaign

Campaign for the UserAdDistance report.

CampaignStatus

String

Attribute

Campaign State

Campaign State for the UserAdDistance report.

The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.

CustomerDescriptiveName

String

Attribute

Client Name

Client Name for the UserAdDistance report.

DistanceBucket

String

Attribute

Distance From Location Extensions

Distance From Location Extensions for the UserAdDistance report.

The allowed values are DISTANCE_BUCKET_WITHIN_200M, DISTANCE_BUCKET_WITHIN_500M, DISTANCE_BUCKET_WITHIN_700M, DISTANCE_BUCKET_WITHIN_1KM, DISTANCE_BUCKET_WITHIN_5KM, DISTANCE_BUCKET_WITHIN_10KM, DISTANCE_BUCKET_WITHIN_15KM, DISTANCE_BUCKET_WITHIN_20KM, DISTANCE_BUCKET_WITHIN_25KM, DISTANCE_BUCKET_WITHIN_30KM, DISTANCE_BUCKET_WITHIN_35KM, DISTANCE_BUCKET_WITHIN_40KM, DISTANCE_BUCKET_WITHIN_45KM, DISTANCE_BUCKET_WITHIN_50KM, DISTANCE_BUCKET_WITHIN_55KM, DISTANCE_BUCKET_WITHIN_60KM, DISTANCE_BUCKET_WITHIN_65KM, DISTANCE_BUCKET_BEYOND_65KM, DISTANCE_BUCKET_WITHIN_0_2MILES, DISTANCE_BUCKET_WITHIN_0_5MILES, DISTANCE_BUCKET_WITHIN_0_7MILES, DISTANCE_BUCKET_WITHIN_1MILE, DISTANCE_BUCKET_WITHIN_5MILES, DISTANCE_BUCKET_WITHIN_10MILES, DISTANCE_BUCKET_WITHIN_15MILES, DISTANCE_BUCKET_WITHIN_20MILES, DISTANCE_BUCKET_WITHIN_25MILES, DISTANCE_BUCKET_WITHIN_30MILES, DISTANCE_BUCKET_WITHIN_35MILES, DISTANCE_BUCKET_WITHIN_40MILES, DISTANCE_BUCKET_BEYOND_40MILES, UNKNOWN.

ExternalCustomerId

Long

Attribute

Customer ID

Customer ID for the UserAdDistance report.

AdNetworkType1

String

Segment

Network

Network for the UserAdDistance report.

The allowed values are UNKNOWN, SEARCH, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.

AdNetworkType2

String

Segment

Network (with Search Partners)

Network (with Search Partners) for the UserAdDistance report.

The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.

ConversionCategoryName

String

Segment

Conversion Category

Conversion Category for the UserAdDistance report.

ConversionTrackerId

Long

Segment

Conversion Tracker Id

Conversion Tracker Id for the UserAdDistance report.

ConversionTypeName

String

Segment

Conversion Name

Conversion Name for the UserAdDistance report.

Date

Date

Segment

Day

Day for the UserAdDistance report.

DayOfWeek

String

Segment

Day Of Week

Day Of Week for the UserAdDistance report.

The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.

Device

String

Segment

Device

Device for the UserAdDistance report.

The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET.

ExternalConversionSource

String

Segment

Conversion Source

Conversion Source for the UserAdDistance report.

The allowed values are UNKNOWN, WEBPAGE, ANALYTICS, UPLOAD, AD_CALL_METRICS, OFFERS, ENGAGEMENT, WEBSITE_CALL_METRICS, STORE_VISITS, ANDROID_IN_APP, ANDROID_DOWNLOAD, IOS_IN_APP, IOS_FIRST_OPEN, APP_UNSPECIFIED, ANDROID_FIRST_OPEN, UPLOAD_CALLS, FIREBASE, CLICK_TO_CALL, SALESFORCE, STORE_SALES_CRM, STORE_SALES_PAYMENT_NETWORK, GOOGLE_PLAY, THIRD_PARTY_APP_ANALYTICS, GOOGLE_ATTRIBUTION, STORE_SALES_DIRECT.

Month

String

Segment

Month

Month for the UserAdDistance report.

MonthOfYear

String

Segment

Month Of Year

Month Of Year for the UserAdDistance report.

The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.

Quarter

String

Segment

Quarter

Quarter for the UserAdDistance report.

Week

String

Segment

Week

Week for the UserAdDistance report.

Year

Integer

Segment

Year

Year for the UserAdDistance report.

AllConversionRate

Double

Metric

All Conv Rate

All Conv Rate for the UserAdDistance report.

AllConversions

Double

Metric

All Conv

All Conv for the UserAdDistance report.

AllConversionValue

Double

Metric

All Conv Value

All Conv Value for the UserAdDistance report.

AverageCpc

Decimal

Metric

Avg CPC

Avg CPC for the UserAdDistance report.

AverageCpm

Decimal

Metric

Avg CPM

Avg CPM for the UserAdDistance report.

AveragePosition

Double

Metric

Avg Position

Avg Position for the UserAdDistance report.

Clicks

Long

Metric

Clicks

Clicks for the UserAdDistance report.

ConversionRate

Double

Metric

Conv Rate

Conv Rate for the UserAdDistance report.

Conversions

Double

Metric

Conversions

Conversions for the UserAdDistance report.

ConversionValue

Double

Metric

Total Conv Value

Total Conv Value for the UserAdDistance report.

Cost

Decimal

Metric

Cost

Cost for the UserAdDistance report.

CostPerAllConversion

Decimal

Metric

Cost Per All Conv

Cost Per All Conv for the UserAdDistance report.

CostPerConversion

Decimal

Metric

Cost Per Conv

Cost Per Conv for the UserAdDistance report.

CrossDeviceConversions

Double

Metric

Cross-device Conv

Cross-device Conv for the UserAdDistance report.

Ctr

Double

Metric

CTR

CTR for the UserAdDistance report.

Impressions

Long

Metric

Impressions

Impressions for the UserAdDistance report.

ValuePerAllConversion

Double

Metric

Value Per All Conv

Value Per All Conv for the UserAdDistance report.

ValuePerConversion

Double

Metric

Value Per Conv

Value Per Conv for the UserAdDistance report.

ViewThroughConversions

Long

Metric

View-through Conv

View-through Conv for the UserAdDistance report.

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

StartDate

String

Start date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.

EndDate

String

End date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.

Last updated