CampaignPerformance

The Campaigns Performance report includes all statistics aggregated by default at the campaign level, one row per campaign.

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 Device instead of the default Date segment to query Campaign Performance data:\

SELECT CampaignId, CampaignName, Device, Clicks, ConversionRate, Impressions FROM CampaignPerformance

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. For example, this query will return only Campaigns that are enabled (which is the default behavior in the AdWords console) with greater than 100 impressions:\

SELECT CampaignName, CampaignStatus, Impressions FROM CampaignPerformance WHERE CampaignStatus='ENABLED' AND Impressions > 100

Columns

Name	Type	Behavior	DisplayName	Description
AccountCurrencyCode	String	Attribute	Currency	Currency for the CampaignPerformance report.
AccountDescriptiveName	String	Attribute	Account	Account for the CampaignPerformance report.
AccountTimeZone	String	Attribute	Time Zone	Time Zone for the CampaignPerformance report.
AdvertisingChannelSubType	String	Attribute	Advertising Sub Channel	Advertising Sub Channel for the CampaignPerformance report. The allowed values are UNKNOWN, SEARCH_MOBILE_APP, DISPLAY_MOBILE_APP, SEARCH_EXPRESS, DISPLAY_EXPRESS, UNIVERSAL_APP_CAMPAIGN, DISPLAY_SMART_CAMPAIGN, SHOPPING_GOAL_OPTIMIZED_ADS, DISPLAY_GMAIL_AD.
AdvertisingChannelType	String	Attribute	Advertising Channel	Advertising Channel for the CampaignPerformance report. The allowed values are UNKNOWN, SEARCH, DISPLAY, SHOPPING, VIDEO, MULTI_CHANNEL, EXPRESS.
Amount	Decimal	Attribute	Budget	Budget for the CampaignPerformance report.
BaseCampaignId	Long	Attribute	Base Campaign ID	Base Campaign ID for the CampaignPerformance report.
BiddingStrategyId	Long	Attribute	Bid Strategy ID	Bid Strategy ID for the CampaignPerformance report.
BiddingStrategyName	String	Attribute	Bid Strategy Name	Bid Strategy Name for the CampaignPerformance report.
BiddingStrategyType	String	Attribute	Bid Strategy Type	Bid Strategy Type for the CampaignPerformance 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.
BudgetId	Long	Attribute	Budget ID	Budget ID for the CampaignPerformance report.
CampaignDesktopBidModifier	Double	Attribute	Desktop Bid Adj	Desktop Bid Adj for the CampaignPerformance report.
CampaignGroupId	Long	Attribute	Campaign Group ID	Campaign Group ID for the CampaignPerformance report.
CampaignId	Long	Attribute	Campaign ID	Campaign ID for the CampaignPerformance report.
CampaignMobileBidModifier	Double	Attribute	Mobile Bid Adj	Mobile Bid Adj for the CampaignPerformance report.
CampaignName	String	Attribute	Campaign	Campaign for the CampaignPerformance report.
CampaignStatus	String	Attribute	Campaign State	Campaign State for the CampaignPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CampaignTabletBidModifier	Double	Attribute	Tablet Bid Adj	Tablet Bid Adj for the CampaignPerformance report.
CampaignTrialType	String	Attribute	Campaign Trial Type	Campaign Trial Type for the CampaignPerformance report. The allowed values are UNKNOWN, BASE, DRAFT, TRIAL.
ConversionAdjustment	String	Attribute	Conversion Adjustment	Conversion Adjustment for the CampaignPerformance report. The allowed values are TRUE, FALSE.
CustomerDescriptiveName	String	Attribute	Client Name	Client Name for the CampaignPerformance report.
EndDate	Date	Attribute	End Date	End Date for the CampaignPerformance report.
EnhancedCpcEnabled	String	Attribute	Enhanced CPC Enabled	Enhanced CPC Enabled for the CampaignPerformance report. The allowed values are TRUE, FALSE.
ExternalCustomerId	Long	Attribute	Customer ID	Customer ID for the CampaignPerformance report.
FinalUrlSuffix	String	Attribute	Final URL Suffix	Final URL Suffix for the CampaignPerformance report.
HasRecommendedBudget	String	Attribute	Has Recommended Budget	Has Recommended Budget for the CampaignPerformance report. The allowed values are TRUE, FALSE.
IsBudgetExplicitlyShared	String	Attribute	Budget Explicitly Shared	Budget Explicitly Shared for the CampaignPerformance report. The allowed values are TRUE, FALSE.
LabelIds	String	Attribute	Label IDs	Label IDs for the CampaignPerformance report.
Labels	String	Attribute	Labels	Labels for the CampaignPerformance report.
MaximizeConversionValueTargetRoas	Double	Attribute	Target ROAS (Maximize Conversion Value)	Target ROAS (Maximize Conversion Value) for the CampaignPerformance report.
Period	String	Attribute	Budget Period	Budget Period for the CampaignPerformance report.
RecommendedBudgetAmount	Decimal	Attribute	Recommended Budget Amount	Recommended Budget Amount for the CampaignPerformance report.
ServingStatus	String	Attribute	Campaign Serving Status	Campaign Serving Status for the CampaignPerformance report. The allowed values are SERVING, NONE, ENDED, PENDING, SUSPENDED.
StartDate	Date	Attribute	Start Date	Start Date for the CampaignPerformance report.
TotalAmount	Decimal	Attribute	Total Budget Amount	Total Budget Amount for the CampaignPerformance report.
TrackingUrlTemplate	String	Attribute	Tracking Template	Tracking Template for the CampaignPerformance report.
UrlCustomParameters	String	Attribute	Custom Parameter	Custom Parameter for the CampaignPerformance report.
AdNetworkType1	String	Segment	Network	Network for the CampaignPerformance 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 CampaignPerformance report. The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.
ClickType	String	Segment	Click Type	Click Type for the CampaignPerformance 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 CampaignPerformance 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.
ConversionAttributionEventType	String	Segment	Ad Event Type	Ad Event Type for the CampaignPerformance report. The allowed values are UNKNOWN, IMPRESSION, INTERACTION.
ConversionCategoryName	String	Segment	Conversion Category	Conversion Category for the CampaignPerformance report.
ConversionLagBucket	String	Segment	Days To Conversion	Days To Conversion for the CampaignPerformance 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 CampaignPerformance report.
ConversionTypeName	String	Segment	Conversion Name	Conversion Name for the CampaignPerformance report.
Date	Date	Segment	Day	Day for the CampaignPerformance report.
DayOfWeek	String	Segment	Day Of Week	Day Of Week for the CampaignPerformance report. The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.
Device	String	Segment	Device	Device for the CampaignPerformance report. The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET.
ExternalConversionSource	String	Segment	Conversion Source	Conversion Source for the CampaignPerformance 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.
HourOfDay	Integer	Segment	Hour Of Day	Hour Of Day for the CampaignPerformance report.
Month	String	Segment	Month	Month for the CampaignPerformance report.
MonthOfYear	String	Segment	Month Of Year	Month Of Year for the CampaignPerformance report. The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.
Quarter	String	Segment	Quarter	Quarter for the CampaignPerformance report.
Slot	String	Segment	Top Vs Other	Top Vs Other for the CampaignPerformance report. The allowed values are SEARCHRHS, SEARCHTOP, SEARCHOTHER, CONTENT, AFSTOP, AFSOTHER, MIXED, UNKNOWN.
Week	String	Segment	Week	Week for the CampaignPerformance report.
Year	Integer	Segment	Year	Year for the CampaignPerformance 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 CampaignPerformance report.
ActiveViewCtr	Double	Metric	Active View Viewable CTR	Active View Viewable CTR for the CampaignPerformance report.
ActiveViewImpressions	Long	Metric	Active View Viewable Impressions	Active View Viewable Impressions for the CampaignPerformance report.
ActiveViewMeasurability	Double	Metric	Active View Measurable Impr Per Impr	Active View Measurable Impr Per Impr for the CampaignPerformance report.
ActiveViewMeasurableCost	Decimal	Metric	Active View Measurable Cost	Active View Measurable Cost for the CampaignPerformance report.
ActiveViewMeasurableImpressions	Long	Metric	Active View Measurable Impr	Active View Measurable Impr for the CampaignPerformance report.
ActiveViewViewability	Double	Metric	Active View Viewable Impr Per Measurable Impr	Active View Viewable Impr Per Measurable Impr for the CampaignPerformance report.
AllConversionRate	Double	Metric	All Conv Rate	All Conv Rate for the CampaignPerformance report.
AllConversions	Double	Metric	All Conv	All Conv for the CampaignPerformance report.
AllConversionValue	Double	Metric	All Conv Value	All Conv Value for the CampaignPerformance report.
AverageCost	Decimal	Metric	Avg Cost	Avg Cost for the CampaignPerformance report.
AverageCpc	Decimal	Metric	Avg CPC	Avg CPC for the CampaignPerformance report.
AverageCpe	Double	Metric	Avg CPE	Avg CPE for the CampaignPerformance report.
AverageCpm	Decimal	Metric	Avg CPM	Avg CPM for the CampaignPerformance report.
AverageCpv	Double	Metric	Avg CPV	Avg CPV for the CampaignPerformance report.
AverageFrequency	Double	Metric	Avg Impr Freq Per Cookie	Avg Impr Freq Per Cookie for the CampaignPerformance report.
AveragePageviews	Double	Metric	Pages Per Session	Pages Per Session for the CampaignPerformance report.
AveragePosition	Double	Metric	Avg Position	Avg Position for the CampaignPerformance report.
AverageTimeOnSite	Double	Metric	Avg Session Duration (seconds)	Avg Session Duration (seconds) for the CampaignPerformance report.
BounceRate	Double	Metric	Bounce Rate	Bounce Rate for the CampaignPerformance report.
ClickAssistedConversions	Long	Metric	Click Assisted Conv	Click Assisted Conv for the CampaignPerformance report.
ClickAssistedConversionsOverLastClickConversions	Double	Metric	Click Assisted Conv Per Last Click Conv	Click Assisted Conv Per Last Click Conv for the CampaignPerformance report.
ClickAssistedConversionValue	Double	Metric	Click Assisted Conv Value	Click Assisted Conv Value for the CampaignPerformance report.
Clicks	Long	Metric	Clicks	Clicks for the CampaignPerformance report.
ContentBudgetLostImpressionShare	Double	Metric	Content Lost IS (budget)	Content Lost IS (budget) for the CampaignPerformance report.
ContentImpressionShare	Double	Metric	Content Impr Share	Content Impr Share for the CampaignPerformance report.
ContentRankLostImpressionShare	Double	Metric	Content Lost IS (rank)	Content Lost IS (rank) for the CampaignPerformance report.
ConversionRate	Double	Metric	Conv Rate	Conv Rate for the CampaignPerformance report.
Conversions	Double	Metric	Conversions	Conversions for the CampaignPerformance report.
ConversionValue	Double	Metric	Total Conv Value	Total Conv Value for the CampaignPerformance report.
Cost	Decimal	Metric	Cost	Cost for the CampaignPerformance report.
CostPerAllConversion	Decimal	Metric	Cost Per All Conv	Cost Per All Conv for the CampaignPerformance report.
CostPerConversion	Decimal	Metric	Cost Per Conv	Cost Per Conv for the CampaignPerformance report.
CostPerCurrentModelAttributedConversion	Double	Metric	Cost Per Conv (current Model)	Cost Per Conv (current Model) for the CampaignPerformance report.
CrossDeviceConversions	Double	Metric	Cross-device Conv	Cross-device Conv for the CampaignPerformance report.
Ctr	Double	Metric	CTR	CTR for the CampaignPerformance report.
CurrentModelAttributedConversions	Double	Metric	Conversions (current Model)	Conversions (current Model) for the CampaignPerformance report.
CurrentModelAttributedConversionValue	Double	Metric	Conv Value (current Model)	Conv Value (current Model) for the CampaignPerformance report.
EngagementRate	Double	Metric	Engagement Rate	Engagement Rate for the CampaignPerformance report.
Engagements	Long	Metric	Engagements	Engagements for the CampaignPerformance report.
GmailForwards	Long	Metric	Gmail Forwards	Gmail Forwards for the CampaignPerformance report.
GmailSaves	Long	Metric	Gmail Saves	Gmail Saves for the CampaignPerformance report.
GmailSecondaryClicks	Long	Metric	Gmail Clicks To Website	Gmail Clicks To Website for the CampaignPerformance report.
ImpressionAssistedConversions	Long	Metric	Impr Assisted Conv	Impr Assisted Conv for the CampaignPerformance report.
ImpressionAssistedConversionsOverLastClickConversions	Double	Metric	Impr Assisted Conv Per Last Click Conv	Impr Assisted Conv Per Last Click Conv for the CampaignPerformance report.
ImpressionAssistedConversionValue	Double	Metric	Impr Assisted Conv Value	Impr Assisted Conv Value for the CampaignPerformance report.
ImpressionReach	Long	Metric	Unique Cookies	Unique Cookies for the CampaignPerformance report.
Impressions	Long	Metric	Impressions	Impressions for the CampaignPerformance report.
InteractionRate	Double	Metric	Interaction Rate	Interaction Rate for the CampaignPerformance report.
Interactions	Long	Metric	Interactions	Interactions for the CampaignPerformance report.
InteractionTypes	String	Metric	Interaction Types	Interaction Types for the CampaignPerformance report.
InvalidClickRate	Double	Metric	Invalid Click Rate	Invalid Click Rate for the CampaignPerformance report.
InvalidClicks	Long	Metric	Invalid Clicks	Invalid Clicks for the CampaignPerformance report.
NumOfflineImpressions	Long	Metric	Phone Impressions	Phone Impressions for the CampaignPerformance report.
NumOfflineInteractions	Long	Metric	Phone Calls	Phone Calls for the CampaignPerformance report.
OfflineInteractionRate	Double	Metric	PTR	PTR for the CampaignPerformance report.
PercentNewVisitors	Double	Metric	Percent New Sessions	Percent New Sessions for the CampaignPerformance report.
RelativeCtr	Double	Metric	Relative CTR	Relative CTR for the CampaignPerformance report.
SearchAbsoluteTopImpressionShare	Double	Metric	Search Abs Top IS	Search Abs Top IS for the CampaignPerformance report.
SearchBudgetLostImpressionShare	Double	Metric	Search Lost IS (budget)	Search Lost IS (budget) for the CampaignPerformance report.
SearchClickShare	Double	Metric	Click Share	Click Share for the CampaignPerformance report.
SearchExactMatchImpressionShare	Double	Metric	Search Exact Match IS	Search Exact Match IS for the CampaignPerformance report.
SearchImpressionShare	Double	Metric	Search Impr Share	Search Impr Share for the CampaignPerformance report.
SearchRankLostImpressionShare	Double	Metric	Search Lost IS (rank)	Search Lost IS (rank) for the CampaignPerformance report.
SearchTopImpressionShare	Double	Metric	Search top IS	Search Top IS for the CampaignPerformance 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 CampaignPerformance report.
ValuePerConversion	Double	Metric	Value Per Conv	Value Per Conv for the CampaignPerformance report.
ValuePerCurrentModelAttributedConversion	Double	Metric	Value Per Conv (current Model)	Value Per Conv (current Model) for the CampaignPerformance report.
VideoQuartile100Rate	Double	Metric	Video Played To 100Percent	Video Played To 100Percent for the CampaignPerformance report.
VideoQuartile25Rate	Double	Metric	Video Played To 25Percent	Video Played To 25Percent for the CampaignPerformance report.
VideoQuartile50Rate	Double	Metric	Video Played To 50Percent	Video Played To 50Percent for the CampaignPerformance report.
VideoQuartile75Rate	Double	Metric	Video Played To 75Percent	Video Played To 75Percent for the CampaignPerformance report.
VideoViewRate	Double	Metric	View Rate	View Rate for the CampaignPerformance report.
VideoViews	Long	Metric	Views	Views for the CampaignPerformance report.
ViewThroughConversions	Long	Metric	View-through Conv	View-through Conv for the CampaignPerformance report.