AdPerformance

The Ad Performance report includes all statistics aggregated at the ad level, one row per ad.

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

SELECT AdType, Headline, CampaignName, ClickType, Clicks, ConversionRate, Impressions FROM AdPerformance

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. 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 Ads that are enabled with a conversion rate greater than 0:\

SELECT AdType, Headline, CampaignName, Device, Clicks, ConversionRate, Impressions FROM AdPerformance WHERE Status='ENABLED' AND ConversionRate > 0

Columns

Name

Type

Behavior

DisplayName

Description

AccentColor

String

Attribute

Accent Color (responsive)

Accent Color (responsive) for the AdPerformance report.

AccountCurrencyCode

String

Attribute

Currency

Currency for the AdPerformance report.

AccountDescriptiveName

String

Attribute

Account

Account for the AdPerformance report.

AccountTimeZone

String

Attribute

Time Zone

Time Zone for the AdPerformance report.

AdGroupId

Long

Attribute

Ad Group ID

Ad Group ID for the AdPerformance report.

AdGroupName

String

Attribute

Ad Group

Ad Group for the AdPerformance report.

AdGroupStatus

String

Attribute

Ad Group State

Ad Group State for the AdPerformance report.

The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.

AdStrengthInfo

String

Attribute

Ad Strength

Ad Strength for the AdPerformance report.

AdType

String

Attribute

Ad Type

Ad Type for the AdPerformance report.

The allowed values are DEPRECATED_AD, IMAGE_AD, PRODUCT_AD, TEMPLATE_AD, TEXT_AD, THIRD_PARTY_REDIRECT_AD, DYNAMIC_SEARCH_AD, CALL_ONLY_AD, EXPANDED_TEXT_AD, RESPONSIVE_DISPLAY_AD, SHOWCASE_AD, GOAL_OPTIMIZED_SHOPPING_AD, EXPANDED_DYNAMIC_SEARCH_AD, GMAIL_AD, RESPONSIVE_SEARCH_AD, MULTI_ASSET_RESPONSIVE_DISPLAY_AD, UNKNOWN.

AllowFlexibleColor

String

Attribute

Allow Flexible Color (responsive)

Allow Flexible Color (responsive) for the AdPerformance report.

The allowed values are TRUE, FALSE.

Automated

String

Attribute

Auto-applied Ad Suggestion

Auto-applied Ad Suggestion for the AdPerformance report.

The allowed values are TRUE, FALSE.

BaseAdGroupId

Long

Attribute

Base Ad Group ID

Base Ad Group ID for the AdPerformance report.

BaseCampaignId

Long

Attribute

Base Campaign ID

Base Campaign ID for the AdPerformance report.

BusinessName

String

Attribute

Business Name

Business Name for the AdPerformance report.

CallOnlyPhoneNumber

String

Attribute

Call-only Ad Phone Number

Call-only Ad Phone Number for the AdPerformance report.

CallToActionText

String

Attribute

Call To Action Text (responsive)

Call To Action Text (responsive) for the AdPerformance report.

CampaignId

Long

Attribute

Campaign ID

Campaign ID for the AdPerformance report.

CampaignName

String

Attribute

Campaign

Campaign for the AdPerformance report.

CampaignStatus

String

Attribute

Campaign State

Campaign State for the AdPerformance report.

The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.

CombinedApprovalStatus

String

Attribute

Approval Status

Approval Status for the AdPerformance report.

The allowed values are UNKNOWN, APPROVED, APPROVED_LIMITED, ELIGIBLE, UNDER_REVIEW, DISAPPROVED, SITE_SUSPENDED.

ConversionAdjustment

String

Attribute

Conversion Adjustment

Conversion Adjustment for the AdPerformance report.

The allowed values are TRUE, FALSE.

CreativeDestinationUrl

String

Attribute

Destination URL

Destination URL for the AdPerformance report.

CreativeFinalAppUrls

String

Attribute

App Final URL

App Final URL for the AdPerformance report.

CreativeFinalMobileUrls

String

Attribute

Mobile Final URL

Mobile Final URL for the AdPerformance report.

CreativeFinalUrls

String

Attribute

Final URL

Final URL for the AdPerformance report.

CreativeFinalUrlSuffix

String

Attribute

Final URL Suffix

Final URL Suffix for the AdPerformance report.

CreativeTrackingUrlTemplate

String

Attribute

Tracking Template

Tracking Template for the AdPerformance report.

CreativeUrlCustomParameters

String

Attribute

Custom Parameter

Custom Parameter for the AdPerformance report.

CriterionType

String

Attribute

Criteria Type

Criteria Type for the AdPerformance report.

The allowed values are UNKNOWN, AD_SCHEDULE, AGE_RANGE, APP_PAYMENT_MODEL, CARRIER, CONTENT_LABEL, CUSTOM_AFFINITY, GENDER, LOCATION_GROUPS, IP_BLOCK, KEYWORD, LANGUAGE, LOCATION, MOBILE_APPLICATION, MOBILE_APP_CATEGORY, MOBILE_DEVICE, OPERATING_SYSTEM_VERSION, PARENT, PLACEMENT, PLATFORM, PREFERRED_CONTENT, PRODUCT_PARTITION, PRODUCT_SCOPE, PROXIMITY, USER_INTEREST, USER_LIST, VERTICAL, WEBPAGE, YOUTUBE_CHANNEL, YOUTUBE_VIDEO, CUSTOM_IN_MARKET.

CustomerDescriptiveName

String

Attribute

Client Name

Client Name for the AdPerformance report.

Description

String

Attribute

Description

Description for the AdPerformance report.

Description1

String

Attribute

Description Line 1

Description Line 1 for the AdPerformance report.

Description2

String

Attribute

Description Line 2

Description Line 2 for the AdPerformance report.

DevicePreference

Long

Attribute

Device Preference

Device Preference for the AdPerformance report.

DisplayUrl

String

Attribute

Display URL

Display URL for the AdPerformance report.

EnhancedDisplayCreativeLandscapeLogoImageMediaId

Long

Attribute

Landscape Logo ID (responsive)

Landscape Logo ID (responsive) for the AdPerformance report.

EnhancedDisplayCreativeLogoImageMediaId

Long

Attribute

Logo ID (responsive)

Logo ID (responsive) for the AdPerformance report.

EnhancedDisplayCreativeMarketingImageMediaId

Long

Attribute

Image ID (responsive)

Image ID (responsive) for the AdPerformance report.

EnhancedDisplayCreativeMarketingImageSquareMediaId

Long

Attribute

Square Image ID (responsive)

Square Image ID (responsive) for the AdPerformance report.

ExpandedDynamicSearchCreativeDescription2

String

Attribute

Expanded Dynamic Search Ad Description 2

Expanded Dynamic Search Ad Description 2 for the AdPerformance report.

ExpandedTextAdDescription2

String

Attribute

Expanded Text Ad Description 2

Expanded Text Ad Description 2 for the AdPerformance report.

ExpandedTextAdHeadlinePart3

String

Attribute

Expanded Text Ad Headline 3

Expanded Text Ad Headline 3 for the AdPerformance report.

ExternalCustomerId

Long

Attribute

Customer ID

Customer ID for the AdPerformance report.

FormatSetting

String

Attribute

Ad Format Preference (responsive)

Ad Format Preference (responsive) for the AdPerformance report.

The allowed values are UNKNOWN, ALL_FORMATS, NON_NATIVE, NATIVE.

GmailCreativeHeaderImageMediaId

Long

Attribute

Gmail Ad Header Image Media Id

Gmail Ad Header Image Media Id for the AdPerformance report.

GmailCreativeLogoImageMediaId

Long

Attribute

Gmail Ad Logo Image Media Id

Gmail Ad Logo Image Media Id for the AdPerformance report.

GmailCreativeMarketingImageMediaId

Long

Attribute

Gmail Ad Marketing Image Media Id

Gmail Ad Marketing Image Media Id for the AdPerformance report.

GmailTeaserBusinessName

String

Attribute

Gmail Ad Business Name

Gmail Ad Business Name for the AdPerformance report.

GmailTeaserDescription

String

Attribute

Gmail Ad Description

Gmail Ad Description for the AdPerformance report.

GmailTeaserHeadline

String

Attribute

Gmail Ad Headline

Gmail Ad Headline for the AdPerformance report.

Headline

String

Attribute

Ad

Ad for the AdPerformance report.

HeadlinePart1

String

Attribute

Headline 1

Headline 1 for the AdPerformance report.

HeadlinePart2

String

Attribute

Headline 2

Headline 2 for the AdPerformance report.

Id

Long

Attribute

Ad ID

Ad ID for the AdPerformance report.

ImageAdUrl

String

Attribute

Image Ad URL

Image Ad URL for the AdPerformance report.

ImageCreativeImageHeight

Integer

Attribute

Image Height

Image Height for the AdPerformance report.

ImageCreativeImageWidth

Integer

Attribute

Image Width

Image Width for the AdPerformance report.

ImageCreativeMimeType

String

Attribute

Image Mime Type

Image Mime Type for the AdPerformance report.

ImageCreativeName

String

Attribute

Image Ad Name