AdPerformance
The Ad Performance report includes all statistics aggregated at the ad level, one row per ad.
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. For example, the following query uses ClickType instead of the default Date segment to query Ad Performance data:\
|
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. All filters must be joined by the AND keyword as OR is not supported by the AdWords API. For example, this query will return only Ads that are enabled with a conversion rate greater than 0:\
|
Columns
Name | Type | Behavior | DisplayName | Description |
AccentColor | String | Attribute | Accent Color (responsive) | Accent Color (responsive) for the AdPerformance report. |
AccountCurrencyCode | String | Attribute | Currency | Currency for the AdPerformance report. |
AccountDescriptiveName | String | Attribute | Account | Account for the AdPerformance report. |
AccountTimeZone | String | Attribute | Time Zone | Time Zone for the AdPerformance report. |
AdGroupId | Long | Attribute | Ad Group ID | Ad Group ID for the AdPerformance report. |
AdGroupName | String | Attribute | Ad Group | Ad Group for the AdPerformance report. |
AdGroupStatus | String | Attribute | Ad Group State | Ad Group State for the AdPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED. |
AdStrengthInfo | String | Attribute | Ad Strength | Ad Strength for the AdPerformance report. |
AdType | String | Attribute | Ad Type | Ad Type for the AdPerformance report. The allowed values are DEPRECATED_AD, IMAGE_AD, PRODUCT_AD, TEMPLATE_AD, TEXT_AD, THIRD_PARTY_REDIRECT_AD, DYNAMIC_SEARCH_AD, CALL_ONLY_AD, EXPANDED_TEXT_AD, RESPONSIVE_DISPLAY_AD, SHOWCASE_AD, GOAL_OPTIMIZED_SHOPPING_AD, EXPANDED_DYNAMIC_SEARCH_AD, GMAIL_AD, RESPONSIVE_SEARCH_AD, MULTI_ASSET_RESPONSIVE_DISPLAY_AD, UNKNOWN. |
AllowFlexibleColor | String | Attribute | Allow Flexible Color (responsive) | Allow Flexible Color (responsive) for the AdPerformance report. The allowed values are TRUE, FALSE. |
Automated | String | Attribute | Auto-applied Ad Suggestion | Auto-applied Ad Suggestion for the AdPerformance report. The allowed values are TRUE, FALSE. |
BaseAdGroupId | Long | Attribute | Base Ad Group ID | Base Ad Group ID for the AdPerformance report. |
BaseCampaignId | Long | Attribute | Base Campaign ID | Base Campaign ID for the AdPerformance report. |
BusinessName | String | Attribute | Business Name | Business Name for the AdPerformance report. |
CallOnlyPhoneNumber | String | Attribute | Call-only Ad Phone Number | Call-only Ad Phone Number for the AdPerformance report. |
CallToActionText | String | Attribute | Call To Action Text (responsive) | Call To Action Text (responsive) for the AdPerformance report. |
CampaignId | Long | Attribute | Campaign ID | Campaign ID for the AdPerformance report. |
CampaignName | String | Attribute | Campaign | Campaign for the AdPerformance report. |
CampaignStatus | String | Attribute | Campaign State | Campaign State for the AdPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED. |
CombinedApprovalStatus | String | Attribute | Approval Status | Approval Status for the AdPerformance report. The allowed values are UNKNOWN, APPROVED, APPROVED_LIMITED, ELIGIBLE, UNDER_REVIEW, DISAPPROVED, SITE_SUSPENDED. |
ConversionAdjustment | String | Attribute | Conversion Adjustment | Conversion Adjustment for the AdPerformance report. The allowed values are TRUE, FALSE. |
CreativeDestinationUrl | String | Attribute | Destination URL | Destination URL for the AdPerformance report. |
CreativeFinalAppUrls | String | Attribute | App Final URL | App Final URL for the AdPerformance report. |
CreativeFinalMobileUrls | String | Attribute | Mobile Final URL | Mobile Final URL for the AdPerformance report. |
CreativeFinalUrls | String | Attribute | Final URL | Final URL for the AdPerformance report. |
CreativeFinalUrlSuffix | String | Attribute | Final URL Suffix | Final URL Suffix for the AdPerformance report. |
CreativeTrackingUrlTemplate | String | Attribute | Tracking Template | Tracking Template for the AdPerformance report. |
CreativeUrlCustomParameters | String | Attribute | Custom Parameter | Custom Parameter for the AdPerformance report. |
CriterionType | String | Attribute | Criteria Type | Criteria Type for the AdPerformance report. The allowed values are UNKNOWN, AD_SCHEDULE, AGE_RANGE, APP_PAYMENT_MODEL, CARRIER, CONTENT_LABEL, CUSTOM_AFFINITY, GENDER, LOCATION_GROUPS, IP_BLOCK, KEYWORD, LANGUAGE, LOCATION, MOBILE_APPLICATION, MOBILE_APP_CATEGORY, MOBILE_DEVICE, OPERATING_SYSTEM_VERSION, PARENT, PLACEMENT, PLATFORM, PREFERRED_CONTENT, PRODUCT_PARTITION, PRODUCT_SCOPE, PROXIMITY, USER_INTEREST, USER_LIST, VERTICAL, WEBPAGE, YOUTUBE_CHANNEL, YOUTUBE_VIDEO, CUSTOM_IN_MARKET. |
CustomerDescriptiveName | String | Attribute | Client Name | Client Name for the AdPerformance report. |
Description | String | Attribute | Description | Description for the AdPerformance report. |
Description1 | String | Attribute | Description Line 1 | Description Line 1 for the AdPerformance report. |
Description2 | String | Attribute | Description Line 2 | Description Line 2 for the AdPerformance report. |
DevicePreference | Long | Attribute | Device Preference | Device Preference for the AdPerformance report. |
DisplayUrl | String | Attribute | Display URL | Display URL for the AdPerformance report. |
EnhancedDisplayCreativeLandscapeLogoImageMediaId | Long | Attribute | Landscape Logo ID (responsive) | Landscape Logo ID (responsive) for the AdPerformance report. |
EnhancedDisplayCreativeLogoImageMediaId | Long | Attribute | Logo ID (responsive) | Logo ID (responsive) for the AdPerformance report. |
EnhancedDisplayCreativeMarketingImageMediaId | Long | Attribute | Image ID (responsive) | Image ID (responsive) for the AdPerformance report. |
EnhancedDisplayCreativeMarketingImageSquareMediaId | Long | Attribute | Square Image ID (responsive) | Square Image ID (responsive) for the AdPerformance report. |
ExpandedDynamicSearchCreativeDescription2 | String | Attribute | Expanded Dynamic Search Ad Description 2 | Expanded Dynamic Search Ad Description 2 for the AdPerformance report. |
ExpandedTextAdDescription2 | String | Attribute | Expanded Text Ad Description 2 | Expanded Text Ad Description 2 for the AdPerformance report. |
ExpandedTextAdHeadlinePart3 | String | Attribute | Expanded Text Ad Headline 3 | Expanded Text Ad Headline 3 for the AdPerformance report. |
ExternalCustomerId | Long | Attribute | Customer ID | Customer ID for the AdPerformance report. |
FormatSetting | String | Attribute | Ad Format Preference (responsive) | Ad Format Preference (responsive) for the AdPerformance report. The allowed values are UNKNOWN, ALL_FORMATS, NON_NATIVE, NATIVE. |
GmailCreativeHeaderImageMediaId | Long | Attribute | Gmail Ad Header Image Media Id | Gmail Ad Header Image Media Id for the AdPerformance report. |
GmailCreativeLogoImageMediaId | Long | Attribute | Gmail Ad Logo Image Media Id | Gmail Ad Logo Image Media Id for the AdPerformance report. |
GmailCreativeMarketingImageMediaId | Long | Attribute | Gmail Ad Marketing Image Media Id | Gmail Ad Marketing Image Media Id for the AdPerformance report. |
GmailTeaserBusinessName | String | Attribute | Gmail Ad Business Name | Gmail Ad Business Name for the AdPerformance report. |
GmailTeaserDescription | String | Attribute | Gmail Ad Description | Gmail Ad Description for the AdPerformance report. |
GmailTeaserHeadline | String | Attribute | Gmail Ad Headline | Gmail Ad Headline for the AdPerformance report. |
Headline | String | Attribute | Ad | Ad for the AdPerformance report. |
HeadlinePart1 | String | Attribute | Headline 1 | Headline 1 for the AdPerformance report. |
HeadlinePart2 | String | Attribute | Headline 2 | Headline 2 for the AdPerformance report. |
Id | Long | Attribute | Ad ID | Ad ID for the AdPerformance report. |
ImageAdUrl | String | Attribute | Image Ad URL | Image Ad URL for the AdPerformance report. |
ImageCreativeImageHeight | Integer | Attribute | Image Height | Image Height for the AdPerformance report. |
ImageCreativeImageWidth | Integer | Attribute | Image Width | Image Width for the AdPerformance report. |
ImageCreativeMimeType | String | Attribute | Image Mime Type | Image Mime Type for the AdPerformance report. |
ImageCreativeName | String | Attribute | Image Ad Name | Image Ad Name for the AdPerformance report. |
IsNegative | String | Attribute | Is Negative | Is Negative for the AdPerformance report. The allowed values are TRUE, FALSE. |
LabelIds | String | Attribute | Label IDs | Label IDs for the AdPerformance report. |
Labels | String | Attribute | Labels | Labels for the AdPerformance report. |
LongHeadline | String | Attribute | Long Headline | Long Headline for the AdPerformance report. |
MainColor | String | Attribute | Main Color (responsive) | Main Color (responsive) for the AdPerformance report. |
MarketingImageCallToActionText | String | Attribute | Gmail Ad Marketing Image Call To Action Text | Gmail Ad Marketing Image Call To Action Text for the AdPerformance report. |
MarketingImageCallToActionTextColor | String | Attribute | Gmail Ad Marketing Image Call To Action Text Color | Gmail Ad Marketing Image Call To Action Text Color for the AdPerformance report. |
MarketingImageDescription | String | Attribute | Gmail Ad Marketing Image Description | Gmail Ad Marketing Image Description for the AdPerformance report. |
MarketingImageHeadline | String | Attribute | Gmail Ad Marketing Image Headline | Gmail Ad Marketing Image Headline for the AdPerformance report. |
MultiAssetResponsiveDisplayAdAccentColor | String | Attribute | Accent Color (multi Asset Responsive Display) | Accent Color (multi Asset Responsive Display) for the AdPerformance report. |
MultiAssetResponsiveDisplayAdAllowFlexibleColor | String | Attribute | Allow Flexible Color (multi Asset Responsive Display) | Allow Flexible Color (multi Asset Responsive Display) for the AdPerformance report. The allowed values are TRUE, FALSE. |
MultiAssetResponsiveDisplayAdBusinessName | String | Attribute | Business Name (multi Asset Responsive Display) | Business Name (multi Asset Responsive Display) for the AdPerformance report. |
MultiAssetResponsiveDisplayAdCallToActionText | String | Attribute | Call To Action Text (multi Asset Responsive Display) | Call To Action Text (multi Asset Responsive Display) for the AdPerformance report. |
MultiAssetResponsiveDisplayAdDescriptions | String | Attribute | Descriptions (multi Asset Responsive Display) | Descriptions (multi Asset Responsive Display) for the AdPerformance report. |
MultiAssetResponsiveDisplayAdDynamicSettingsPricePrefix | String | Attribute | Price Prefix (multi Asset Responsive Display) | Price Prefix (multi Asset Responsive Display) for the AdPerformance report. |
MultiAssetResponsiveDisplayAdDynamicSettingsPromoText | String | Attribute | Promotion Text (multi Asset Responsive Display) | Promotion Text (multi Asset Responsive Display) for the AdPerformance report. |
MultiAssetResponsiveDisplayAdFormatSetting | String | Attribute | Ad Format Preference (multi Asset Responsive Display) | Ad Format Preference (multi Asset Responsive Display) for the AdPerformance report. The allowed values are UNKNOWN, ALL_FORMATS, NON_NATIVE, NATIVE. |
MultiAssetResponsiveDisplayAdHeadlines | String | Attribute | Headlines (multi Asset Responsive Display) | Headlines (multi Asset Responsive Display) for the AdPerformance report. |
MultiAssetResponsiveDisplayAdLandscapeLogoImages | String | Attribute | Landscape Logos (multi Asset Responsive Display) | Landscape Logos (multi Asset Responsive Display) for the AdPerformance report. |
MultiAssetResponsiveDisplayAdLogoImages | String | Attribute | Logos (multi Asset Responsive Display) | Logos (multi Asset Responsive Display) for the AdPerformance report. |
MultiAssetResponsiveDisplayAdLongHeadline | String | Attribute | Long Headline (multi Asset Responsive Display) | Long Headline (multi Asset Responsive Display) for the AdPerformance report. |
MultiAssetResponsiveDisplayAdMainColor | String | Attribute | Main Color (multi Asset Responsive Display) | Main Color (multi Asset Responsive Display) for the AdPerformance report. |
MultiAssetResponsiveDisplayAdMarketingImages | String | Attribute | Images (multi Asset Responsive Display) | Images (multi Asset Responsive Display) for the AdPerformance report. |
MultiAssetResponsiveDisplayAdSquareMarketingImages | String | Attribute | Square Images (multi Asset Responsive Display) | Square Images (multi Asset Responsive Display) for the AdPerformance report. |
MultiAssetResponsiveDisplayAdYouTubeVideos | String | Attribute | Youtube Videos (multi Asset Responsive Display) | Youtube Videos (multi Asset Responsive Display) for the AdPerformance report. |
Path1 | String | Attribute | Path 1 | Path 1 for the AdPerformance report. |
Path2 | String | Attribute | Path 2 | Path 2 for the AdPerformance report. |
PolicySummary | String | Attribute | Policy | Policy for the AdPerformance report. |
PricePrefix | String | Attribute | Price Prefix (responsive) | Price Prefix (responsive) for the AdPerformance report. |
PromoText | String | Attribute | Promotion Text (responsive) | Promotion Text (responsive) for the AdPerformance report. |
ResponsiveSearchAdDescriptions | String | Attribute | Responsive Search Ad Descriptions | Responsive Search Ad Descriptions for the AdPerformance report. |
ResponsiveSearchAdHeadlines | String | Attribute | Responsive Search Ad Headlines | Responsive Search Ad Headlines for the AdPerformance report. |
ResponsiveSearchAdPath1 | String | Attribute | Responsive Search Ad Path 1 | Responsive Search Ad Path 1 for the AdPerformance report. |
ResponsiveSearchAdPath2 | String | Attribute | Responsive Search Ad Path 2 | Responsive Search Ad Path 2 for the AdPerformance report. |
ShortHeadline | String | Attribute | Short Headline | Short Headline for the AdPerformance report. |
Status | String | Attribute | Ad State | Ad State for the AdPerformance report. The allowed values are ENABLED, PAUSED, DISABLED. |
SystemManagedEntitySource | String | Attribute | System Managed Entity Source | System Managed Entity Source for the AdPerformance report. The allowed values are UNKNOWN, AD_VARIATIONS. |
AdNetworkType1 | String | Segment | Network | Network for the AdPerformance 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 AdPerformance report. The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED. |
ClickType | String | Segment | Click Type | Click Type for the AdPerformance report. The allowed values are URL_CLICKS, CALLS, OTHER, PRODUCT_EXTENSION_CLICKS, SITELINKS, PRODUCT_LISTING_AD_CLICKS, GET_DIRECTIONS, OFFER_PRINTS, BREADCRUMBS, CALL_TRACKING, MOBILE_CALL_TRACKING, LOCATION_EXPANSION, STORE_LOCATOR, PRODUCT_LISTING_AD_LOCAL, APP_DEEPLINK, PRODUCT_LISTING_AD_MULTICHANNEL_LOCAL, PRODUCT_LISTING_AD_MULTICHANNEL_ONLINE, PRODUCT_LISTING_ADS_COUPON, PRODUCT_LISTING_AD_TRANSACTABLE, PRODUCT_AD_APP_DEEPLINK, SHOWCASE_AD_CATEGORY_LINK, SHOWCASE_AD_LOCAL_STOREFRONT_LINK, SHOWCASE_AD_ONLINE_PRODUCT_LINK, SHOWCASE_AD_LOCAL_PRODUCT_LINK, PRICE_EXTENSION, VIDEO_WEBSITE_CLICKS, VIDEO_CALL_TO_ACTION_CLICKS, VIDEO_APP_STORE_CLICKS, VIDEO_CARD_ACTION_HEADLINE_CLICKS, VIDEO_END_CAP_CLICKS, CLICK_ON_ENGAGEMENT_AD, LOCATION_FORMAT_MAP, LOCATION_FORMAT_LANDING_PAGE, LOCATION_FORMAT_STORE_INFO, LOCATION_FORMAT_DIRECTIONS, LOCATION_FORMAT_CALL, LOCATION_FORMAT_TEXT, LOCATION_FORMAT_IMAGE, BROADBAND_PLAN, WIRELESS_PLAN, VISUAL_SITELINKS, PROMOTION_EXTENSION, SWIPEABLE_GALLERY_AD_HEADLINE, SWIPEABLE_GALLERY_AD_SWIPES, SWIPEABLE_GALLERY_AD_SEE_MORE, SWIPEABLE_GALLERY_AD_SITELINK_ONE, SWIPEABLE_GALLERY_AD_SITELINK_TWO, SWIPEABLE_GALLERY_AD_SITELINK_THREE, SWIPEABLE_GALLERY_AD_SITELINK_FOUR, SWIPEABLE_GALLERY_AD_SITELINK_FIVE, UNKNOWN. |
ConversionAdjustmentLagBucket | String | Segment | Days To Conversion Or Adjustment | Days To Conversion Or Adjustment for the AdPerformance report. The allowed values are UNKNOWN, CONVERSION_0_TO_1_DAY, CONVERSION_1_TO_2_DAYS, CONVERSION_2_TO_3_DAYS, CONVERSION_3_TO_4_DAYS, CONVERSION_4_TO_5_DAYS, CONVERSION_5_TO_6_DAYS, CONVERSION_6_TO_7_DAYS, CONVERSION_7_TO_8_DAYS, CONVERSION_8_TO_9_DAYS, CONVERSION_9_TO_10_DAYS, CONVERSION_10_TO_11_DAYS, CONVERSION_11_TO_12_DAYS, CONVERSION_12_TO_13_DAYS, CONVERSION_13_TO_14_DAYS, CONVERSION_14_TO_21_DAYS, CONVERSION_21_TO_30_DAYS, CONVERSION_30_TO_45_DAYS, CONVERSION_45_TO_60_DAYS, CONVERSION_60_TO_90_DAYS, ADJUSTMENT_0_TO_1_DAY, ADJUSTMENT_1_TO_2_DAYS, ADJUSTMENT_2_TO_3_DAYS, ADJUSTMENT_3_TO_4_DAYS, ADJUSTMENT_4_TO_5_DAYS, ADJUSTMENT_5_TO_6_DAYS, ADJUSTMENT_6_TO_7_DAYS, ADJUSTMENT_7_TO_8_DAYS, ADJUSTMENT_8_TO_9_DAYS, ADJUSTMENT_9_TO_10_DAYS, ADJUSTMENT_10_TO_11_DAYS, ADJUSTMENT_11_TO_12_DAYS, ADJUSTMENT_12_TO_13_DAYS, ADJUSTMENT_13_TO_14_DAYS, ADJUSTMENT_14_TO_21_DAYS, ADJUSTMENT_21_TO_30_DAYS, ADJUSTMENT_30_TO_45_DAYS, ADJUSTMENT_45_TO_60_DAYS, ADJUSTMENT_60_TO_90_DAYS, ADJUSTMENT_90_TO_145_DAY, CONVERSION_UNKNOWN, ADJUSTMENT_UNKNOWN. |
ConversionCategoryName | String | Segment | Conversion Category | Conversion Category for the AdPerformance report. |
ConversionLagBucket | String | Segment | Days To Conversion | Days To Conversion for the AdPerformance report. The allowed values are UNKNOWN, CONVERSION_0_TO_1_DAY, CONVERSION_1_TO_2_DAYS, CONVERSION_2_TO_3_DAYS, CONVERSION_3_TO_4_DAYS, CONVERSION_4_TO_5_DAYS, CONVERSION_5_TO_6_DAYS, CONVERSION_6_TO_7_DAYS, CONVERSION_7_TO_8_DAYS, CONVERSION_8_TO_9_DAYS, CONVERSION_9_TO_10_DAYS, CONVERSION_10_TO_11_DAYS, CONVERSION_11_TO_12_DAYS, CONVERSION_12_TO_13_DAYS, CONVERSION_13_TO_14_DAYS, CONVERSION_14_TO_21_DAYS, CONVERSION_21_TO_30_DAYS, CONVERSION_30_TO_45_DAYS, CONVERSION_45_TO_60_DAYS, CONVERSION_60_TO_90_DAYS. |
ConversionTrackerId | Long | Segment | Conversion Tracker Id | Conversion Tracker Id for the AdPerformance report. |
ConversionTypeName | String | Segment | Conversion Name | Conversion Name for the AdPerformance report. |
CriterionId | Long | Segment | Keyword ID | Keyword ID for the AdPerformance report. |
Date | Date | Segment | Day | Day for the AdPerformance report. |
DayOfWeek | String | Segment | Day Of Week | Day Of Week for the AdPerformance report. The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY. |
Device | String | Segment | Device | Device for the AdPerformance report. The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET. |
ExternalConversionSource | String | Segment | Conversion Source | Conversion Source for the AdPerformance 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 AdPerformance report. |
MonthOfYear | String | Segment | Month Of Year | Month Of Year for the AdPerformance report. The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER. |
Quarter | String | Segment | Quarter | Quarter for the AdPerformance report. |
Slot | String | Segment | Top Vs Other | Top Vs Other for the AdPerformance report. The allowed values are SEARCHRHS, SEARCHTOP, SEARCHOTHER, CONTENT, AFSTOP, AFSOTHER, MIXED, UNKNOWN. |
Week | String | Segment | Week | Week for the AdPerformance report. |
Year | Integer | Segment | Year | Year for the AdPerformance report. |
AbsoluteTopImpressionPercentage | Double | Metric | Impr Abs Top | The percent of add impressions shown as the very first ad. |
ActiveViewCpm | Decimal | Metric | Active View Avg CPM | Active View Avg CPM for the AdPerformance report. |
ActiveViewCtr | Double | Metric | Active View Viewable CTR | Active View Viewable CTR for the AdPerformance report. |
ActiveViewImpressions | Long | Metric | Active View Viewable Impressions | Active View Viewable Impressions for the AdPerformance report. |
ActiveViewMeasurability | Double | Metric | Active View Measurable Impr Per Impr | Active View Measurable Impr Per Impr for the AdPerformance report. |
ActiveViewMeasurableCost | Decimal | Metric | Active View Measurable Cost | Active View Measurable Cost for the AdPerformance report. |
ActiveViewMeasurableImpressions | Long | Metric | Active View Measurable Impr | Active View Measurable Impr for the AdPerformance report. |
ActiveViewViewability | Double | Metric | Active View Viewable Impr Per Measurable Impr | Active View Viewable Impr Per Measurable Impr for the AdPerformance report. |
AllConversionRate | Double | Metric | All Conv Rate | All Conv Rate for the AdPerformance report. |
AllConversions | Double | Metric | All Conv | All Conv for the AdPerformance report. |
AllConversionValue | Double | Metric | All Conv Value | All Conv Value for the AdPerformance report. |
AverageCost | Decimal | Metric | Avg Cost | Avg Cost for the AdPerformance report. |
AverageCpc | Decimal | Metric | Avg CPC | Avg CPC for the AdPerformance report. |
AverageCpe | Double | Metric | Avg CPE | Avg CPE for the AdPerformance report. |
AverageCpm | Decimal | Metric | Avg CPM | Avg CPM for the AdPerformance report. |
AverageCpv | Double | Metric | Avg CPV | Avg CPV for the AdPerformance report. |
AveragePageviews | Double | Metric | Pages Per Session | Pages Per Session for the AdPerformance report. |
AveragePosition | Double | Metric | Avg Position | Avg Position for the AdPerformance report. |
AverageTimeOnSite | Double | Metric | Avg Session Duration (seconds) | Avg Session Duration (seconds) for the AdPerformance report. |
BounceRate | Double | Metric | Bounce Rate | Bounce Rate for the AdPerformance report. |
ClickAssistedConversions | Long | Metric | Click Assisted Conv | Click Assisted Conv for the AdPerformance report. |
ClickAssistedConversionsOverLastClickConversions | Double | Metric | Click Assisted Conv Per Last Click Conv | Click Assisted Conv Per Last Click Conv for the AdPerformance report. |
ClickAssistedConversionValue | Double | Metric | Click Assisted Conv Value | Click Assisted Conv Value for the AdPerformance report. |
Clicks | Long | Metric | Clicks | Clicks for the AdPerformance report. |
ConversionRate | Double | Metric | Conv Rate | Conv Rate for the AdPerformance report. |
Conversions | Double | Metric | Conversions | Conversions for the AdPerformance report. |
ConversionValue | Double | Metric | Total Conv Value | Total Conv Value for the AdPerformance report. |
Cost | Decimal | Metric | Cost | Cost for the AdPerformance report. |
CostPerAllConversion | Decimal | Metric | Cost Per All Conv | Cost Per All Conv for the AdPerformance report. |
CostPerConversion | Decimal | Metric | Cost Per Conv | Cost Per Conv for the AdPerformance report. |
CostPerCurrentModelAttributedConversion | Double | Metric | Cost Per Conv (current Model) | Cost Per Conv (current Model) for the AdPerformance report. |
CrossDeviceConversions | Double | Metric | Cross-device Conv | Cross-device Conv for the AdPerformance report. |
Ctr | Double | Metric | CTR | CTR for the AdPerformance report. |
CurrentModelAttributedConversions | Double | Metric | Conversions (current Model) | Conversions (current Model) for the AdPerformance report. |
CurrentModelAttributedConversionValue | Double | Metric | Conv Value (current Model) | Conv Value (current Model) for the AdPerformance report. |
EngagementRate | Double | Metric | Engagement Rate | Engagement Rate for the AdPerformance report. |
Engagements | Long | Metric | Engagements | Engagements for the AdPerformance report. |
GmailForwards | Long | Metric | Gmail Forwards | Gmail Forwards for the AdPerformance report. |
GmailSaves | Long | Metric | Gmail Saves | Gmail Saves for the AdPerformance report. |
GmailSecondaryClicks | Long | Metric | Gmail Clicks To Website | Gmail Clicks To Website for the AdPerformance report. |
ImpressionAssistedConversions | Long | Metric | Impr Assisted Conv | Impr Assisted Conv for the AdPerformance report. |
ImpressionAssistedConversionsOverLastClickConversions | Double | Metric | Impr Assisted Conv Per Last Click Conv | Impr Assisted Conv Per Last Click Conv for the AdPerformance report. |
ImpressionAssistedConversionValue | Double | Metric | Impr Assisted Conv Value | Impr Assisted Conv Value for the AdPerformance report. |
Impressions | Long | Metric | Impressions | Impressions for the AdPerformance report. |
InteractionRate | Double | Metric | Interaction Rate | Interaction Rate for the AdPerformance report. |
Interactions | Long | Metric | Interactions | Interactions for the AdPerformance report. |
InteractionTypes | String | Metric | Interaction Types | Interaction Types for the AdPerformance report. |
PercentNewVisitors | Double | Metric | Percent New Sessions | Percent New Sessions for the AdPerformance report. |
TopImpressionPercentage | Double | Metric | Impr Top | The percent of add impressions that are shown anywhere above the organic search results. |
ValuePerAllConversion | Double | Metric | Value Per All Conv | Value Per All Conv for the AdPerformance report. |
ValuePerConversion | Double | Metric | Value Per Conv | Value Per Conv for the AdPerformance report. |
ValuePerCurrentModelAttributedConversion | Double | Metric | Value Per Conv (current Model) | Value Per Conv (current Model) for the AdPerformance report. |
VideoQuartile100Rate | Double | Metric | Video Played To 100Percent | Video Played To 100Percent for the AdPerformance report. |
VideoQuartile25Rate | Double | Metric | Video Played To 25Percent | Video Played To 25Percent for the AdPerformance report. |
VideoQuartile50Rate | Double | Metric | Video Played To 50Percent | Video Played To 50Percent for the AdPerformance report. |
VideoQuartile75Rate | Double | Metric | Video Played To 75Percent | Video Played To 75Percent for the AdPerformance report. |
VideoViewRate | Double | Metric | View Rate | View Rate for the AdPerformance report. |
VideoViews | Long | Metric | Views | Views for the AdPerformance report. |
ViewThroughConversions | Long | Metric | View-through Conv | View-through Conv for the AdPerformance 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