DisplayKeywordPerformance
The Display Keyword Performance report includes all display network statistics aggregated at the keyword level, one row per keyword.
Last updated
The Display Keyword Performance report includes all display network statistics aggregated at the keyword level, one row per keyword.
Last updated
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.
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
Behavior
DisplayName
Description
AccountCurrencyCode
String
Attribute
Currency
Currency for the DisplayKeywordPerformance report.
AccountDescriptiveName
String
Attribute
Account
Account for the DisplayKeywordPerformance report.
AccountTimeZone
String
Attribute
Time Zone
Time Zone for the DisplayKeywordPerformance report.
AdGroupId
Long
Attribute
Ad Group ID
Ad Group ID for the DisplayKeywordPerformance report.
AdGroupName
String
Attribute
Ad Group
Ad Group for the DisplayKeywordPerformance report.
AdGroupStatus
String
Attribute
Ad Group State
Ad Group State for the DisplayKeywordPerformance report.
The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
BaseAdGroupId
Long
Attribute
Base Ad Group ID
Base Ad Group ID for the DisplayKeywordPerformance report.
BaseCampaignId
Long
Attribute
Base Campaign ID
Base Campaign ID for the DisplayKeywordPerformance report.
BiddingStrategyId
Long
Attribute
Bid Strategy ID
Bid Strategy ID for the DisplayKeywordPerformance report.
BiddingStrategyName
String
Attribute
Bid Strategy Name
Bid Strategy Name for the DisplayKeywordPerformance report.
BiddingStrategyType
String
Attribute
Bid Strategy Type
Bid Strategy Type for the DisplayKeywordPerformance report.
The allowed values are MANUAL_CPC, MANUAL_CPV, MANUAL_CPM, PAGE_ONE_PROMOTED, TARGET_SPEND, TARGET_CPA, TARGET_ROAS, MAXIMIZE_CONVERSIONS, MAXIMIZE_CONVERSION_VALUE, TARGET_OUTRANK_SHARE, NONE, UNKNOWN.
CampaignId
Long
Attribute
Campaign ID
Campaign ID for the DisplayKeywordPerformance report.
CampaignName
String
Attribute
Campaign
Campaign for the DisplayKeywordPerformance report.
CampaignStatus
String
Attribute
Campaign State
Campaign State for the DisplayKeywordPerformance report.
The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CpcBid
Decimal
Attribute
Max CPC
Max CPC for the DisplayKeywordPerformance report.
CpcBidSource
String
Attribute
Max CPC Source
Max CPC Source for the DisplayKeywordPerformance report.
The allowed values are ADGROUP, CRITERION, ADGROUP_BIDDING_STRATEGY, CAMPAIGN_BIDDING_STRATEGY.
CpmBid
Decimal
Attribute
Max CPM
Max CPM for the DisplayKeywordPerformance report.
CpmBidSource
String
Attribute
Max CPM Source
Max CPM Source for the DisplayKeywordPerformance report.
The allowed values are ADGROUP, CRITERION, ADGROUP_BIDDING_STRATEGY, CAMPAIGN_BIDDING_STRATEGY.
CpvBid
Decimal
Attribute
Max CPV
Max CPV for the DisplayKeywordPerformance report.
CpvBidSource
String
Attribute
Max CPV Source
Max CPV Source for the DisplayKeywordPerformance report.
The allowed values are ADGROUP, CRITERION, ADGROUP_BIDDING_STRATEGY, CAMPAIGN_BIDDING_STRATEGY.
Criteria
String
Attribute
Keyword
Keyword for the DisplayKeywordPerformance report.
CriteriaDestinationUrl
String
Attribute
Destination URL
Destination URL for the DisplayKeywordPerformance report.
CustomerDescriptiveName
String
Attribute
Client Name
Client Name for the DisplayKeywordPerformance report.
ExternalCustomerId
Long
Attribute
Customer ID
Customer ID for the DisplayKeywordPerformance report.
FinalAppUrls
String
Attribute
App Final URL
App Final URL for the DisplayKeywordPerformance report.
FinalMobileUrls
String
Attribute
Mobile Final URL
Mobile Final URL for the DisplayKeywordPerformance report.
FinalUrls
String
Attribute
Final URL
Final URL for the DisplayKeywordPerformance report.
Id
Long
Attribute
Keyword ID
Keyword ID for the DisplayKeywordPerformance report.
IsNegative
String
Attribute
Is Negative
Is Negative for the DisplayKeywordPerformance report.
The allowed values are TRUE, FALSE.
IsRestrict
String
Attribute
Is Restricting
Is Restricting for the DisplayKeywordPerformance report.
The allowed values are TRUE, FALSE.
Status
String
Attribute
Keyword State
Keyword State for the DisplayKeywordPerformance report.
The allowed values are ENABLED, REMOVED, PAUSED.
TrackingUrlTemplate
String
Attribute
Tracking Template
Tracking Template for the DisplayKeywordPerformance report.
UrlCustomParameters
String
Attribute
Custom Parameter
Custom Parameter for the DisplayKeywordPerformance report.
AdNetworkType1
String
Segment
Network
Network for the DisplayKeywordPerformance 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 DisplayKeywordPerformance report.
The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.
ClickType
String
Segment
Click Type
Click Type for the DisplayKeywordPerformance 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.
ConversionCategoryName
String
Segment
Conversion Category
Conversion Category for the DisplayKeywordPerformance report.
ConversionTrackerId
Long
Segment
Conversion Tracker Id
Conversion Tracker Id for the DisplayKeywordPerformance report.
ConversionTypeName
String
Segment
Conversion Name
Conversion Name for the DisplayKeywordPerformance report.
Date
Date
Segment
Day
Day for the DisplayKeywordPerformance report.
DayOfWeek
String
Segment
Day Of Week
Day Of Week for the DisplayKeywordPerformance report.
The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.
Device
String
Segment
Device
Device for the DisplayKeywordPerformance report.
The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET.
ExternalConversionSource
String
Segment
Conversion Source
Conversion Source for the DisplayKeywordPerformance 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 DisplayKeywordPerformance report.
MonthOfYear
String
Segment
Month Of Year
Month Of Year for the DisplayKeywordPerformance report.
The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.
Quarter
String
Segment
Quarter
Quarter for the DisplayKeywordPerformance report.
Week
String
Segment
Week
Week for the DisplayKeywordPerformance report.
Year
Integer
Segment
Year
Year for the DisplayKeywordPerformance report.
ActiveViewCpm
Decimal
Metric
Active View Avg CPM
Active View Avg CPM for the DisplayKeywordPerformance report.
ActiveViewCtr
Double
Metric
Active View Viewable CTR
Active View Viewable CTR for the DisplayKeywordPerformance report.
ActiveViewImpressions
Long
Metric
Active View Viewable Impressions
Active View Viewable Impressions for the DisplayKeywordPerformance report.
ActiveViewMeasurability
Double
Metric
Active View Measurable Impr Per Impr
Active View Measurable Impr Per Impr for the DisplayKeywordPerformance report.
ActiveViewMeasurableCost
Decimal
Metric
Active View Measurable Cost
Active View Measurable Cost for the DisplayKeywordPerformance report.
ActiveViewMeasurableImpressions
Long
Metric
Active View Measurable Impr
Active View Measurable Impr for the DisplayKeywordPerformance report.
ActiveViewViewability
Double
Metric
Active View Viewable Impr Per Measurable Impr
Active View Viewable Impr Per Measurable Impr for the DisplayKeywordPerformance report.
AllConversionRate
Double
Metric
All Conv Rate
All Conv Rate for the DisplayKeywordPerformance report.
AllConversions
Double
Metric
All Conv
All Conv for the DisplayKeywordPerformance report.
AllConversionValue
Double
Metric
All Conv Value
All Conv Value for the DisplayKeywordPerformance report.
AverageCost
Decimal
Metric
Avg Cost
Avg Cost for the DisplayKeywordPerformance report.
AverageCpc
Decimal
Metric
Avg CPC
Avg CPC for the DisplayKeywordPerformance report.
AverageCpe
Double
Metric
Avg CPE
Avg CPE for the DisplayKeywordPerformance report.
AverageCpm
Decimal
Metric
Avg CPM
Avg CPM for the DisplayKeywordPerformance report.
AverageCpv
Double
Metric
Avg CPV
Avg CPV for the DisplayKeywordPerformance report.
Clicks
Long
Metric
Clicks
Clicks for the DisplayKeywordPerformance report.
ConversionRate
Double
Metric
Conv Rate
Conv Rate for the DisplayKeywordPerformance report.
Conversions
Double
Metric
Conversions
Conversions for the DisplayKeywordPerformance report.
ConversionValue
Double
Metric
Total Conv Value
Total Conv Value for the DisplayKeywordPerformance report.
Cost
Decimal
Metric
Cost
Cost for the DisplayKeywordPerformance report.
CostPerAllConversion
Decimal
Metric
Cost Per All Conv
Cost Per All Conv for the DisplayKeywordPerformance report.
CostPerConversion
Decimal
Metric
Cost Per Conv
Cost Per Conv for the DisplayKeywordPerformance report.
CrossDeviceConversions
Double
Metric
Cross-device Conv
Cross-device Conv for the DisplayKeywordPerformance report.
Ctr
Double
Metric
CTR
CTR for the DisplayKeywordPerformance report.
EngagementRate
Double
Metric
Engagement Rate
Engagement Rate for the DisplayKeywordPerformance report.
Engagements
Long
Metric
Engagements
Engagements for the DisplayKeywordPerformance report.
GmailForwards
Long
Metric
Gmail Forwards
Gmail Forwards for the DisplayKeywordPerformance report.
GmailSaves
Long
Metric
Gmail Saves
Gmail Saves for the DisplayKeywordPerformance report.
GmailSecondaryClicks
Long
Metric
Gmail Clicks To Website
Gmail Clicks To Website for the DisplayKeywordPerformance report.
Impressions
Long
Metric
Impressions
Impressions for the DisplayKeywordPerformance report.
InteractionRate
Double
Metric
Interaction Rate
Interaction Rate for the DisplayKeywordPerformance report.
Interactions
Long
Metric
Interactions
Interactions for the DisplayKeywordPerformance report.
InteractionTypes
String
Metric
Interaction Types
Interaction Types for the DisplayKeywordPerformance report.
ValuePerAllConversion
Double
Metric
Value Per All Conv
Value Per All Conv for the DisplayKeywordPerformance report.
ValuePerConversion
Double
Metric
Value Per Conv
Value Per Conv for the DisplayKeywordPerformance report.
VideoQuartile100Rate
Double
Metric
Video Played To 100Percent
Video Played To 100Percent for the DisplayKeywordPerformance report.
VideoQuartile25Rate
Double
Metric
Video Played To 25Percent
Video Played To 25Percent for the DisplayKeywordPerformance report.
VideoQuartile50Rate
Double
Metric
Video Played To 50Percent
Video Played To 50Percent for the DisplayKeywordPerformance report.
VideoQuartile75Rate
Double
Metric
Video Played To 75Percent
Video Played To 75Percent for the DisplayKeywordPerformance report.
VideoViewRate
Double
Metric
View Rate
View Rate for the DisplayKeywordPerformance report.
VideoViews
Long
Metric
Views
Views for the DisplayKeywordPerformance report.
ViewThroughConversions
Long
Metric
View-through Conv
View-through Conv for the DisplayKeywordPerformance report.
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.