CampaignPerformance
The Campaigns Performance report includes all statistics aggregated by default at the campaign level, one row per campaign.
Last updated
The Campaigns Performance report includes all statistics aggregated by default at the campaign level, one row per campaign.
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. For example, the following query uses Device instead of the default Date segment to query Campaign 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. 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 CampaignId, CampaignName, Device, Clicks, ConversionRate, Impressions FROM CampaignPerformance
SELECT CampaignName, CampaignStatus, Impressions FROM CampaignPerformance WHERE CampaignStatus='ENABLED'
AND Impressions > 100
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.