ClickPerformance

The Click Performance report includes stats aggregated at each click level, and includes both valid and invalid clicks. The KeywordId field will return any criteria that triggered the click, not just

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.

Note that this table only supports queries for a specific day within the past 90 days. You will need to set the StartDate and EndDate to the same value in the WHERE clause.

Columns

Name	Type	Behavior	DisplayName	Description
AccountDescriptiveName	String	Attribute	Account	Account for the ClickPerformance report.
AdFormat	String	Attribute	Ad Type	Ad Type for the ClickPerformance report. The allowed values are UNKNOWN, TEXT, IMAGE, DYNAMIC_IMAGE, FLASH, VIDEO, HTML, AUDIO, COMPOSITE, PRINT.
AdGroupId	Long	Attribute	Ad Group ID	Ad Group ID for the ClickPerformance report.
AdGroupName	String	Attribute	Ad Group	Ad Group for the ClickPerformance report.
AdGroupStatus	String	Attribute	Ad Group State	Ad Group State for the ClickPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
AdNetworkType1	String	Attribute	Network	Network for the ClickPerformance report. The allowed values are UNKNOWN, SEARCH, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.
AdNetworkType2	String	Attribute	Network (with Search Partners)	Network (with Search Partners) for the ClickPerformance report. The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.
AdVariationControlTrialArmId	Long	Attribute	Ad Variation Control Trial Arm ID	Ad Variation Control Trial Arm ID for the ClickPerformance report.
AdVariationTreatmentTrialArmId	Long	Attribute	Ad Variation Treatment Trial Arm ID	Ad Variation Treatment Trial Arm ID for the ClickPerformance report.
AdVariationTrialId	Long	Attribute	Ad Variation Trial ID	Ad Variation Trial ID for the ClickPerformance report.
AoiCityCriteriaId	Integer	Attribute	City (Location Of Interest)	City (Location Of Interest) for the ClickPerformance report.
AoiCountryCriteriaId	Integer	Attribute	Country Per Territory (Location Of Interest)	Country Per Territory (Location Of Interest) for the ClickPerformance report.
AoiMetroCriteriaId	Integer	Attribute	Metro Area (Location Of Interest)	Metro Area (Location Of Interest) for the ClickPerformance report.
AoiMostSpecificTargetId	Long	Attribute	Most Specific Location Target (Location Of Interest)	Most Specific Location Target (Location Of Interest) for the ClickPerformance report.
AoiRegionCriteriaId	Integer	Attribute	Region (Location Of Interest)	Region (Location Of Interest) for the ClickPerformance report.
CampaignId	Long	Attribute	Campaign ID	Campaign ID for the ClickPerformance report.
CampaignLocationTargetId	Long	Attribute	Campaign Location Target	Campaign Location Target for the ClickPerformance report.
CampaignName	String	Attribute	Campaign	Campaign for the ClickPerformance report.
CampaignStatus	String	Attribute	Campaign State	Campaign State for the ClickPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
Clicks	Long	Attribute	Clicks	Clicks for the ClickPerformance report.
ClickType	String	Attribute	Click Type	Click Type for the ClickPerformance 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.
CreativeId	Long	Attribute	Ad ID	Ad ID for the ClickPerformance report.
CriteriaId	Long	Attribute	Keyword ID	Keyword ID for the ClickPerformance report.
CriteriaParameters	String	Attribute	Keyword Per Placement	Keyword Per Placement for the ClickPerformance report.
Date	Date	Attribute	Day	Day for the ClickPerformance report.
Device	String	Attribute	Device	Device for the ClickPerformance report. The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET.
ExternalCustomerId	Long	Attribute	Customer ID	Customer ID for the ClickPerformance report.
GclId	String	Attribute	Google Click ID	Google Click ID for the ClickPerformance report.
KeywordMatchType	String	Attribute	Match Type	Match Type for the ClickPerformance report. The allowed values are UNKNOWN, EXACT, PHRASE, BROAD.
LopCityCriteriaId	Integer	Attribute	City (Physical Location)	City (Physical Location) for the ClickPerformance report.
LopCountryCriteriaId	Integer	Attribute	Country Per Territory (Physical Location)	Country Per Territory (Physical Location) for the ClickPerformance report.
LopMetroCriteriaId	Integer	Attribute	Metro Area (Physical Location)	Metro Area (Physical Location) for the ClickPerformance report.
LopMostSpecificTargetId	Long	Attribute	Most Specific Location Target (Physical Location)	Most Specific Location Target (Physical Location) for the ClickPerformance report.
LopRegionCriteriaId	Integer	Attribute	Region (Physical Location)	Region (Physical Location) for the ClickPerformance report.
MonthOfYear	String	Attribute	Month Of Year	Month Of Year for the ClickPerformance report. The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.
Page	Integer	Attribute	Page	Page for the ClickPerformance report.
Slot	String	Attribute	Top Vs Other	Top Vs Other for the ClickPerformance report. The allowed values are SEARCHRHS, SEARCHTOP, SEARCHOTHER, CONTENT, AFSTOP, AFSOTHER, MIXED, UNKNOWN.
UserListId	Long	Attribute	User List ID	User List ID for the ClickPerformance 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.