UrlPerformance
The URL Performance report includes all statistics aggregated at the URL and criterion level.
Table Specific Information
Select
Google AdWords 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 AdWords 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 AdWords API.
Columns
Name | Type | Behavior | DisplayName | Description |
AccountCurrencyCode | String | Attribute | Currency | Currency for the UrlPerformance report. |
AccountDescriptiveName | String | Attribute | Account | Account for the UrlPerformance report. |
AccountTimeZone | String | Attribute | Time Zone | Time Zone for the UrlPerformance report. |
AdGroupCriterionStatus | String | Attribute | Keyword Per Placement State | Keyword Per Placement State for the UrlPerformance report. The allowed values are ENABLED, REMOVED, PAUSED. |
AdGroupId | Long | Attribute | Ad Group ID | Ad Group ID for the UrlPerformance report. |
AdGroupName | String | Attribute | Ad Group | Ad Group for the UrlPerformance report. |
AdGroupStatus | String | Attribute | Ad Group State | Ad Group State for the UrlPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED. |
CampaignId | Long | Attribute | Campaign ID | Campaign ID for the UrlPerformance report. |
CampaignName | String | Attribute | Campaign | Campaign for the UrlPerformance report. |
CampaignStatus | String | Attribute | Campaign State | Campaign State for the UrlPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED. |
CriteriaParameters | String | Attribute | Keyword Per Placement | Keyword Per Placement for the UrlPerformance report. |
CustomerDescriptiveName | String | Attribute | Client Name | Client Name for the UrlPerformance report. |
DisplayName | String | Attribute | Criteria Display Name | Criteria Display Name for the UrlPerformance report. |
Domain | String | Attribute | Domain | Domain for the UrlPerformance report. |
ExternalCustomerId | Long | Attribute | Customer ID | Customer ID for the UrlPerformance report. |
IsBidOnPath | String | Attribute | Added | Added for the UrlPerformance report. |
IsPathExcluded | String | Attribute | Excluded | Excluded for the UrlPerformance report. |
Url | String | Attribute | URL | URL for the UrlPerformance report. |
AdFormat | String | Segment | Ad Type | Ad Type for the UrlPerformance report. The allowed values are UNKNOWN, TEXT, IMAGE, DYNAMIC_IMAGE, FLASH, VIDEO, HTML, AUDIO, COMPOSITE, PRINT. |
AdNetworkType1 | String | Segment | Network | Network for the UrlPerformance 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 UrlPerformance report. The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED. |
ConversionCategoryName | String | Segment | Conversion Category | Conversion Category for the UrlPerformance report. |
ConversionTrackerId | Long | Segment | Conversion Tracker Id | Conversion Tracker Id for the UrlPerformance report. |
ConversionTypeName | String | Segment | Conversion Name | Conversion Name for the UrlPerformance report. |
Date | Date | Segment | Day | Day for the UrlPerformance report. |
DayOfWeek | String | Segment | Day Of Week | Day Of Week for the UrlPerformance report. The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY. |
Device | String | Segment | Device | Device for the UrlPerformance report. The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET. |
ExternalConversionSource | String | Segment | Conversion Source | Conversion Source for the UrlPerformance 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. |
IsAutoOptimized | String | Segment | Targeting Mode | Targeting Mode for the UrlPerformance report. The allowed values are TRUE, FALSE. |
Month | String | Segment | Month | Month for the UrlPerformance report. |
MonthOfYear | String | Segment | Month Of Year | Month Of Year for the UrlPerformance report. The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER. |
Quarter | String | Segment | Quarter | Quarter for the UrlPerformance report. |
Week | String | Segment | Week | Week for the UrlPerformance report. |
Year | Integer | Segment | Year | Year for the UrlPerformance report. |
ActiveViewCpm | Decimal | Metric | Active View Avg CPM | Active View Avg CPM for the UrlPerformance report. |
ActiveViewCtr | Double | Metric | Active View Viewable CTR | Active View Viewable CTR for the UrlPerformance report. |
ActiveViewImpressions | Long | Metric | Active View Viewable Impressions | Active View Viewable Impressions for the UrlPerformance report. |
ActiveViewMeasurability | Double | Metric | Active View Measurable Impr Per Impr | Active View Measurable Impr Per Impr for the UrlPerformance report. |
ActiveViewMeasurableCost | Decimal | Metric | Active View Measurable Cost | Active View Measurable Cost for the UrlPerformance report. |
ActiveViewMeasurableImpressions | Long | Metric | Active View Measurable Impr | Active View Measurable Impr for the UrlPerformance report. |
ActiveViewViewability | Double | Metric | Active View Viewable Impr Per Measurable Impr | Active View Viewable Impr Per Measurable Impr for the UrlPerformance report. |
AllConversionRate | Double | Metric | All Conv Rate | All Conv Rate for the UrlPerformance report. |
AllConversions | Double | Metric | All Conv | All Conv for the UrlPerformance report. |
AllConversionValue | Double | Metric | All Conv Value | All Conv Value for the UrlPerformance report. |
AverageCost | Decimal | Metric | Avg Cost | Avg Cost for the UrlPerformance report. |
AverageCpc | Decimal | Metric | Avg CPC | Avg CPC for the UrlPerformance report. |
AverageCpe | Double | Metric | Avg CPE | Avg CPE for the UrlPerformance report. |
AverageCpm | Decimal | Metric | Avg CPM | Avg CPM for the UrlPerformance report. |
AverageCpv | Double | Metric | Avg CPV | Avg CPV for the UrlPerformance report. |
Clicks | Long | Metric | Clicks | Clicks for the UrlPerformance report. |
ConversionRate | Double | Metric | Conv Rate | Conv Rate for the UrlPerformance report. |
Conversions | Double | Metric | Conversions | Conversions for the UrlPerformance report. |
ConversionValue | Double | Metric | Total Conv Value | Total Conv Value for the UrlPerformance report. |
Cost | Decimal | Metric | Cost | Cost for the UrlPerformance report. |
CostPerAllConversion | Decimal | Metric | Cost Per All Conv | Cost Per All Conv for the UrlPerformance report. |
CostPerConversion | Decimal | Metric | Cost Per Conv | Cost Per Conv for the UrlPerformance report. |
CrossDeviceConversions | Double | Metric | Cross-device Conv | Cross-device Conv for the UrlPerformance report. |
Ctr | Double | Metric | CTR | CTR for the UrlPerformance report. |
EngagementRate | Double | Metric | Engagement Rate | Engagement Rate for the UrlPerformance report. |
Engagements | Long | Metric | Engagements | Engagements for the UrlPerformance report. |
Impressions | Long | Metric | Impressions | Impressions for the UrlPerformance report. |
InteractionRate | Double | Metric | Interaction Rate | Interaction Rate for the UrlPerformance report. |
Interactions | Long | Metric | Interactions | Interactions for the UrlPerformance report. |
InteractionTypes | String | Metric | Interaction Types | Interaction Types for the UrlPerformance report. |
ValuePerAllConversion | Double | Metric | Value Per All Conv | Value Per All Conv for the UrlPerformance report. |
ValuePerConversion | Double | Metric | Value Per Conv | Value Per Conv for the UrlPerformance report. |
VideoQuartile100Rate | Double | Metric | Video Played To 100Percent | Video Played To 100Percent for the UrlPerformance report. |
VideoQuartile25Rate | Double | Metric | Video Played To 25Percent | Video Played To 25Percent for the UrlPerformance report. |
VideoQuartile50Rate | Double | Metric | Video Played To 50Percent | Video Played To 50Percent for the UrlPerformance report. |
VideoQuartile75Rate | Double | Metric | Video Played To 75Percent | Video Played To 75Percent for the UrlPerformance report. |
VideoViewRate | Double | Metric | View Rate | View Rate for the UrlPerformance report. |
VideoViews | Long | Metric | Views | Views for the UrlPerformance report. |
ViewThroughConversions | Long | Metric | View-through Conv | View-through Conv for the UrlPerformance 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