PlacementPerformance

The Placements Performance report includes all statistics aggregated at the placement level, one row per placement.

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 PlacementPerformance report.

AccountDescriptiveName

String

Attribute

Account

Account for the PlacementPerformance report.

AccountTimeZone

String

Attribute

Time Zone

Time Zone for the PlacementPerformance report.

AdGroupId

Long

Attribute

Ad Group ID

Ad Group ID for the PlacementPerformance report.

AdGroupName

String

Attribute

Ad Group

Ad Group for the PlacementPerformance report.

AdGroupStatus

String

Attribute

Ad Group State

Ad Group State for the PlacementPerformance report.

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

BaseAdGroupId

Long

Attribute

Base Ad Group ID

Base Ad Group ID for the PlacementPerformance report.

BaseCampaignId

Long

Attribute

Base Campaign ID

Base Campaign ID for the PlacementPerformance report.

BiddingStrategyId

Long

Attribute

Bid Strategy ID

Bid Strategy ID for the PlacementPerformance report.

BiddingStrategyName

String

Attribute

Bid Strategy Name

Bid Strategy Name for the PlacementPerformance report.

BiddingStrategyType

String

Attribute

Bid Strategy Type

Bid Strategy Type for the PlacementPerformance 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.

BidModifier

Double

Attribute

Bid Adj

Bid Adj for the PlacementPerformance report.

CampaignId

Long

Attribute

Campaign ID

Campaign ID for the PlacementPerformance report.

CampaignName

String

Attribute

Campaign

Campaign for the PlacementPerformance report.

CampaignStatus

String

Attribute

Campaign State

Campaign State for the PlacementPerformance report.

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

CpcBid

Decimal

Attribute

Max CPC

Max CPC for the PlacementPerformance report.

CpcBidSource

String

Attribute

Max CPC Source

Max CPC Source for the PlacementPerformance report.

The allowed values are ADGROUP, CRITERION, ADGROUP_BIDDING_STRATEGY, CAMPAIGN_BIDDING_STRATEGY.

CpmBid

Decimal

Attribute

Max CPM

Max CPM for the PlacementPerformance report.

CpmBidSource

String

Attribute

Max CPM Source

Max CPM Source for the PlacementPerformance report.

The allowed values are ADGROUP, CRITERION, ADGROUP_BIDDING_STRATEGY, CAMPAIGN_BIDDING_STRATEGY.

Criteria

String

Attribute

Placement

Placement for the PlacementPerformance report.

CriteriaDestinationUrl

String

Attribute

Destination URL

Destination URL for the PlacementPerformance report.

CustomerDescriptiveName

String

Attribute

Client Name

Client Name for the PlacementPerformance report.

DisplayName

String

Attribute

Criteria Display Name

Criteria Display Name for the PlacementPerformance report.

ExternalCustomerId

Long

Attribute

Customer ID

Customer ID for the PlacementPerformance report.

FinalAppUrls

String

Attribute

App Final URL

App Final URL for the PlacementPerformance report.

FinalMobileUrls

String

Attribute

Mobile Final URL

Mobile Final URL for the PlacementPerformance report.

FinalUrls

String

Attribute

Final URL

Final URL for the PlacementPerformance report.

Id

Long

Attribute

Criterion ID

Criterion ID for the PlacementPerformance report.

IsNegative

String

Attribute

Is Negative

Is Negative for the PlacementPerformance report.

The allowed values are TRUE, FALSE.

IsRestrict

String

Attribute

Is Restricting

Is Restricting for the PlacementPerformance report.

The allowed values are TRUE, FALSE.

Status

String

Attribute

Placement State

Placement State for the PlacementPerformance report.

The allowed values are ENABLED, REMOVED, PAUSED.

TrackingUrlTemplate

String

Attribute

Tracking Template

Tracking Template for the PlacementPerformance report.

UrlCustomParameters

String

Attribute

Custom Parameter

Custom Parameter for the PlacementPerformance report.

AdNetworkType1

String

Segment

Network

Network for the PlacementPerformance 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 PlacementPerformance report.

The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.

ClickType

String

Segment

Click Type

Click Type for the PlacementPerformance 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.

ConversionCategoryName

String

Segment

Conversion Category

Conversion Category for the PlacementPerformance report.

ConversionTrackerId

Long

Segment

Conversion Tracker Id

Conversion Tracker Id for the PlacementPerformance report.

ConversionTypeName

String

Segment

Conversion Name

Conversion Name for the PlacementPerformance report.

Date

Date

Segment

Day

Day for the PlacementPerformance report.

DayOfWeek

String

Segment

Day Of Week

Day Of Week for the PlacementPerformance report.

The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.

Device

String

Segment

Device

Device for the PlacementPerformance report.

The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET.

ExternalConversionSource

String

Segment

Conversion Source

Conversion Source for the PlacementPerformance 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.

Month

String

Segment

Month

Month for the PlacementPerformance report.

MonthOfYear

String

Segment

Month Of Year

Month Of Year for the PlacementPerformance report.

The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.

Quarter

String

Segment

Quarter

Quarter for the PlacementPerformance report.

Week

String

Segment

Week

Week for the PlacementPerformance report.

Year

Integer

Segment

Year

Year for the PlacementPerformance report.

ActiveViewCpm

Decimal

Metric

Active View Avg CPM

Active View Avg CPM for the PlacementPerformance report.

ActiveViewCtr

Double

Metric

Active View Viewable CTR

Active View Viewable CTR for the PlacementPerformance report.

ActiveViewImpressions

Long

Metric

Active View Viewable Impressions

Active View Viewable Impressions for the PlacementPerformance report.

ActiveViewMeasurability

Double

Metric

Active View Measurable Impr Per Impr

Active View Measurable Impr Per Impr for the PlacementPerformance report.

ActiveViewMeasurableCost

Decimal

Metric

Active View Measurable Cost

Active View Measurable Cost for the PlacementPerformance report.

ActiveViewMeasurableImpressions

Long

Metric

Active View Measurable Impr

Active View Measurable Impr for the PlacementPerformance report.

ActiveViewViewability

Double

Metric

Active View Viewable Impr Per Measurable Impr

Active View Viewable Impr Per Measurable Impr for the PlacementPerformance report.

AllConversionRate

Double

Metric

All Conv Rate

All Conv Rate for the PlacementPerformance report.

AllConversions

Double

Metric

All Conv

All Conv for the PlacementPerformance report.

AllConversionValue

Double

Metric

All Conv Value

All Conv Value for the PlacementPerformance report.

AverageCost

Decimal

Metric

Avg Cost

Avg Cost for the PlacementPerformance report.

AverageCpc

Decimal

Metric

Avg CPC

Avg CPC for the PlacementPerformance report.

AverageCpe

Double

Metric

Avg CPE

Avg CPE for the PlacementPerformance report.

AverageCpm

Decimal

Metric

Avg CPM

Avg CPM for the PlacementPerformance report.

AverageCpv

Double

Metric

Avg CPV

Avg CPV for the PlacementPerformance report.

Clicks

Long

Metric

Clicks

Clicks for the PlacementPerformance report.

ConversionRate

Double

Metric

Conv Rate

Conv Rate for the PlacementPerformance report.

Conversions

Double

Metric

Conversions

Conversions for the PlacementPerformance report.

ConversionValue

Double

Metric

Total Conv Value

Total Conv Value for the PlacementPerformance report.

Cost

Decimal

Metric

Cost

Cost for the PlacementPerformance report.

CostPerAllConversion

Decimal

Metric

Cost Per All Conv

Cost Per All Conv for the PlacementPerformance report.

CostPerConversion

Decimal

Metric

Cost Per Conv

Cost Per Conv for the PlacementPerformance report.

CrossDeviceConversions

Double

Metric

Cross-device Conv

Cross-device Conv for the PlacementPerformance report.

Ctr

Double

Metric

CTR

CTR for the PlacementPerformance report.

EngagementRate

Double

Metric

Engagement Rate

Engagement Rate for the PlacementPerformance report.

Engagements

Long

Metric

Engagements

Engagements for the PlacementPerformance report.

GmailForwards

Long

Metric

Gmail Forwards

Gmail Forwards for the PlacementPerformance report.

GmailSaves

Long

Metric

Gmail Saves

Gmail Saves for the PlacementPerformance report.

GmailSecondaryClicks

Long

Metric

Gmail Clicks To Website

Gmail Clicks To Website for the PlacementPerformance report.

Impressions

Long

Metric

Impressions

Impressions for the PlacementPerformance report.

InteractionRate

Double

Metric

Interaction Rate

Interaction Rate for the PlacementPerformance report.

Interactions

Long

Metric

Interactions

Interactions for the PlacementPerformance report.

InteractionTypes

String

Metric

Interaction Types

Interaction Types for the PlacementPerformance report.

ValuePerAllConversion

Double

Metric

Value Per All Conv

Value Per All Conv for the PlacementPerformance report.

ValuePerConversion

Double

Metric

Value Per Conv

Value Per Conv for the PlacementPerformance report.

VideoQuartile100Rate

Double

Metric

Video Played To 100Percent

Video Played To 100Percent for the PlacementPerformance report.

VideoQuartile25Rate

Double

Metric

Video Played To 25Percent

Video Played To 25Percent for the PlacementPerformance report.

VideoQuartile50Rate

Double

Metric

Video Played To 50Percent

Video Played To 50Percent for the PlacementPerformance report.

VideoQuartile75Rate

Double

Metric

Video Played To 75Percent

Video Played To 75Percent for the PlacementPerformance report.

VideoViewRate

Double

Metric

View Rate

View Rate for the PlacementPerformance report.

VideoViews

Long

Metric

Views

Views for the PlacementPerformance report.

ViewThroughConversions

Long

Metric

View-through Conv

View-through Conv for the PlacementPerformance 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