AccountPerformance
The Account Performance report includes all statistics aggregated by default at the account level, one row per account.
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.
Columns
Name | Type | Behavior | DisplayName | Description |
AccountCurrencyCode | String | Attribute | Currency | Currency for the AccountPerformance report. |
AccountDescriptiveName | String | Attribute | Account | Account for the AccountPerformance report. |
AccountTimeZone | String | Attribute | Time Zone | Time Zone for the AccountPerformance report. |
CanManageClients | String | Attribute | Can Manage Clients | Can Manage Clients for the AccountPerformance report. The allowed values are TRUE, FALSE. |
ConversionAdjustment | String | Attribute | Conversion Adjustment | Conversion Adjustment for the AccountPerformance report. The allowed values are TRUE, FALSE. |
CustomerDescriptiveName | String | Attribute | Client Name | Client Name for the AccountPerformance report. |
ExternalCustomerId | Long | Attribute | Customer ID | Customer ID for the AccountPerformance report. |
IsAutoTaggingEnabled | String | Attribute | Auto Tagging Enabled | Auto Tagging Enabled for the AccountPerformance report. The allowed values are TRUE, FALSE. |
IsTestAccount | String | Attribute | Test Account | Test Account for the AccountPerformance report. The allowed values are TRUE, FALSE. |
AdNetworkType1 | String | Segment | Network | Network for the AccountPerformance 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 AccountPerformance report. The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED. |
ClickType | String | Segment | Click Type | Click Type for the AccountPerformance 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 AccountPerformance 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 AccountPerformance report. |
ConversionLagBucket | String | Segment | Days To Conversion | Days To Conversion for the AccountPerformance 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 AccountPerformance report. |
ConversionTypeName | String | Segment | Conversion Name | Conversion Name for the AccountPerformance report. |
Date | Date | Segment | Day | Day for the AccountPerformance report. |
DayOfWeek | String | Segment | Day Of Week | Day Of Week for the AccountPerformance report. The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY. |
Device | String | Segment | Device | Device for the AccountPerformance report. The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET. |
ExternalConversionSource | String | Segment | Conversion Source | Conversion Source for the AccountPerformance 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 AccountPerformance report. |
Month | String | Segment | Month | Month for the AccountPerformance report. |
MonthOfYear | String | Segment | Month Of Year | Month Of Year for the AccountPerformance report. The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER. |
Quarter | String | Segment | Quarter | Quarter for the AccountPerformance report. |
Slot | String | Segment | Top Vs Other | Top Vs Other for the AccountPerformance report. The allowed values are SEARCHRHS, SEARCHTOP, SEARCHOTHER, CONTENT, AFSTOP, AFSOTHER, MIXED, UNKNOWN. |
Week | String | Segment | Week | Week for the AccountPerformance report. |
Year | Integer | Segment | Year | Year for the AccountPerformance report. |
ActiveViewCpm | Decimal | Metric | Active View Avg CPM | Active View Avg CPM for the AccountPerformance report. |
ActiveViewCtr | Double | Metric | Active View Viewable CTR | Active View Viewable CTR for the AccountPerformance report. |
ActiveViewImpressions | Long | Metric | Active View Viewable Impressions | Active View Viewable Impressions for the AccountPerformance report. |
ActiveViewMeasurability | Double | Metric | Active View Measurable Impr Per Impr | Active View Measurable Impr Per Impr for the AccountPerformance report. |
ActiveViewMeasurableCost | Decimal | Metric | Active View Measurable Cost | Active View Measurable Cost for the AccountPerformance report. |
ActiveViewMeasurableImpressions | Long | Metric | Active View Measurable Impr | Active View Measurable Impr for the AccountPerformance report. |
ActiveViewViewability | Double | Metric | Active View Viewable Impr Per Measurable Impr | Active View Viewable Impr Per Measurable Impr for the AccountPerformance report. |
AllConversionRate | Double | Metric | All Conv Rate | All Conv Rate for the AccountPerformance report. |
AllConversions | Double | Metric | All Conv | All Conv for the AccountPerformance report. |
AllConversionValue | Double | Metric | All Conv Value | All Conv Value for the AccountPerformance report. |
AverageCost | Decimal | Metric | Avg Cost | Avg Cost for the AccountPerformance report. |
AverageCpc | Decimal | Metric | Avg CPC | Avg CPC for the AccountPerformance report. |
AverageCpe | Double | Metric | Avg CPE | Avg CPE for the AccountPerformance report. |
AverageCpm | Decimal | Metric | Avg CPM | Avg CPM for the AccountPerformance report. |
AverageCpv | Double | Metric | Avg CPV | Avg CPV for the AccountPerformance report. |
AveragePosition | Double | Metric | Avg Position | Avg Position for the AccountPerformance report. |
Clicks | Long | Metric | Clicks | Clicks for the AccountPerformance report. |
ContentBudgetLostImpressionShare | Double | Metric | Content Lost IS (budget) | Content Lost IS (budget) for the AccountPerformance report. |
ContentImpressionShare | Double | Metric | Content Impr Share | Content Impr Share for the AccountPerformance report. |
ContentRankLostImpressionShare | Double | Metric | Content Lost IS (rank) | Content Lost IS (rank) for the AccountPerformance report. |
ConversionRate | Double | Metric | Conv Rate | Conv Rate for the AccountPerformance report. |
Conversions | Double | Metric | Conversions | Conversions for the AccountPerformance report. |
ConversionValue | Double | Metric | Total Conv Value | Total Conv Value for the AccountPerformance report. |
Cost | Decimal | Metric | Cost | Cost for the AccountPerformance report. |
CostPerAllConversion | Decimal | Metric | Cost Per All Conv | Cost Per All Conv for the AccountPerformance report. |
CostPerConversion | Decimal | Metric | Cost Per Conv | Cost Per Conv for the AccountPerformance report. |
CrossDeviceConversions | Double | Metric | Cross-device Conv | Cross-device Conv for the AccountPerformance report. |
Ctr | Double | Metric | CTR | CTR for the AccountPerformance report. |
EngagementRate | Double | Metric | Engagement Rate | Engagement Rate for the AccountPerformance report. |
Engagements | Long | Metric | Engagements | Engagements for the AccountPerformance report. |
Impressions | Long | Metric | Impressions | Impressions for the AccountPerformance report. |
InteractionRate | Double | Metric | Interaction Rate | Interaction Rate for the AccountPerformance report. |
Interactions | Long | Metric | Interactions | Interactions for the AccountPerformance report. |
InteractionTypes | String | Metric | Interaction Types | Interaction Types for the AccountPerformance report. |
InvalidClickRate | Double | Metric | Invalid Click Rate | Invalid Click Rate for the AccountPerformance report. |
InvalidClicks | Long | Metric | Invalid Clicks | Invalid Clicks for the AccountPerformance report. |
SearchBudgetLostImpressionShare | Double | Metric | Search Lost IS (budget) | Search Lost IS (budget) for the AccountPerformance report. |
SearchExactMatchImpressionShare | Double | Metric | Search Exact Match IS | Search Exact Match IS for the AccountPerformance report. |
SearchImpressionShare | Double | Metric | Search Impr Share | Search Impr Share for the AccountPerformance report. |
SearchRankLostImpressionShare | Double | Metric | Search Lost IS (rank) | Search Lost IS (rank) for the AccountPerformance report. |
ValuePerAllConversion | Double | Metric | Value Per All Conv | Value Per All Conv for the AccountPerformance report. |
ValuePerConversion | Double | Metric | Value Per Conv | Value Per Conv for the AccountPerformance report. |
VideoViewRate | Double | Metric | View Rate | View Rate for the AccountPerformance report. |
VideoViews | Long | Metric | Views | Views for the AccountPerformance report. |
ViewThroughConversions | Long | Metric | View-through Conv | View-through Conv for the AccountPerformance 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