AutomaticPlacementsPerformance

The Automatic 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 AutomaticPlacementsPerformance report.
AccountDescriptiveName	String	Attribute	Account	Account for the AutomaticPlacementsPerformance report.
AccountTimeZone	String	Attribute	Time Zone	Time Zone for the AutomaticPlacementsPerformance report.
AdGroupId	Long	Attribute	Ad Group ID	Ad Group ID for the AutomaticPlacementsPerformance report.
AdGroupName	String	Attribute	Ad Group	Ad Group for the AutomaticPlacementsPerformance report.
AdGroupStatus	String	Attribute	Ad Group State	Ad Group State for the AutomaticPlacementsPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CampaignId	Long	Attribute	Campaign ID	Campaign ID for the AutomaticPlacementsPerformance report.
CampaignName	String	Attribute	Campaign	Campaign for the AutomaticPlacementsPerformance report.
CampaignStatus	String	Attribute	Campaign State	Campaign State for the AutomaticPlacementsPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CriteriaParameters	String	Attribute	URL	URL for the AutomaticPlacementsPerformance report.
CustomerDescriptiveName	String	Attribute	Client Name	Client Name for the AutomaticPlacementsPerformance report.
DisplayName	String	Attribute	Criteria Display Name	Criteria Display Name for the AutomaticPlacementsPerformance report.
Domain	String	Attribute	Domain	Domain for the AutomaticPlacementsPerformance report.
ExternalCustomerId	Long	Attribute	Customer ID	Customer ID for the AutomaticPlacementsPerformance report.
IsBidOnPath	String	Attribute	Added	Added for the AutomaticPlacementsPerformance report.
IsPathExcluded	String	Attribute	Excluded	Excluded for the AutomaticPlacementsPerformance report.
AdFormat	String	Segment	Ad Type	Ad Type for the AutomaticPlacementsPerformance report. The allowed values are UNKNOWN, TEXT, IMAGE, DYNAMIC_IMAGE, FLASH, VIDEO, HTML, AUDIO, COMPOSITE, PRINT.
AdNetworkType1	String	Segment	Network	Network for the AutomaticPlacementsPerformance 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 AutomaticPlacementsPerformance report. The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.
ConversionCategoryName	String	Segment	Conversion Category	Conversion Category for the AutomaticPlacementsPerformance report.
ConversionTrackerId	Long	Segment	Conversion Tracker Id	Conversion Tracker Id for the AutomaticPlacementsPerformance report.
ConversionTypeName	String	Segment	Conversion Name	Conversion Name for the AutomaticPlacementsPerformance report.
Date	Date	Segment	Day	Day for the AutomaticPlacementsPerformance report.
DayOfWeek	String	Segment	Day Of Week	Day Of Week for the AutomaticPlacementsPerformance report. The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.
ExternalConversionSource	String	Segment	Conversion Source	Conversion Source for the AutomaticPlacementsPerformance 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.
IsAutoOptimized	String	Segment	Targeting Mode	Targeting Mode for the AutomaticPlacementsPerformance report. The allowed values are TRUE, FALSE.
Month	String	Segment	Month	Month for the AutomaticPlacementsPerformance report.
MonthOfYear	String	Segment	Month Of Year	Month Of Year for the AutomaticPlacementsPerformance report. The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.
Quarter	String	Segment	Quarter	Quarter for the AutomaticPlacementsPerformance report.
Week	String	Segment	Week	Week for the AutomaticPlacementsPerformance report.
Year	Integer	Segment	Year	Year for the AutomaticPlacementsPerformance report.
ActiveViewCpm	Decimal	Metric	Active View Avg CPM	Active View Avg CPM for the AutomaticPlacementsPerformance report.
ActiveViewCtr	Double	Metric	Active View Viewable CTR	Active View Viewable CTR for the AutomaticPlacementsPerformance report.
ActiveViewImpressions	Long	Metric	Active View Viewable Impressions	Active View Viewable Impressions for the AutomaticPlacementsPerformance report.
ActiveViewMeasurability	Double	Metric	Active View Measurable Impr Per Impr	Active View Measurable Impr Per Impr for the AutomaticPlacementsPerformance report.
ActiveViewMeasurableCost	Decimal	Metric	Active View Measurable Cost	Active View Measurable Cost for the AutomaticPlacementsPerformance report.
ActiveViewMeasurableImpressions	Long	Metric	Active View Measurable Impr	Active View Measurable Impr for the AutomaticPlacementsPerformance report.
ActiveViewViewability	Double	Metric	Active View Viewable Impr Per Measurable Impr	Active View Viewable Impr Per Measurable Impr for the AutomaticPlacementsPerformance report.
AllConversionRate	Double	Metric	All Conv Rate	All Conv Rate for the AutomaticPlacementsPerformance report.
AllConversions	Double	Metric	All Conv	All Conv for the AutomaticPlacementsPerformance report.
AllConversionValue	Double	Metric	All Conv Value	All Conv Value for the AutomaticPlacementsPerformance report.
AverageCost	Decimal	Metric	Avg Cost	Avg Cost for the AutomaticPlacementsPerformance report.
AverageCpc	Decimal	Metric	Avg CPC	Avg CPC for the AutomaticPlacementsPerformance report.
AverageCpe	Double	Metric	Avg CPE	Avg CPE for the AutomaticPlacementsPerformance report.
AverageCpm	Decimal	Metric	Avg CPM	Avg CPM for the AutomaticPlacementsPerformance report.
AverageCpv	Double	Metric	Avg CPV	Avg CPV for the AutomaticPlacementsPerformance report.
Clicks	Long	Metric	Clicks	Clicks for the AutomaticPlacementsPerformance report.
ConversionRate	Double	Metric	Conv Rate	Conv Rate for the AutomaticPlacementsPerformance report.
Conversions	Double	Metric	Conversions	Conversions for the AutomaticPlacementsPerformance report.
ConversionValue	Double	Metric	Total Conv Value	Total Conv Value for the AutomaticPlacementsPerformance report.
Cost	Decimal	Metric	Cost	Cost for the AutomaticPlacementsPerformance report.
CostPerAllConversion	Decimal	Metric	Cost Per All Conv	Cost Per All Conv for the AutomaticPlacementsPerformance report.
CostPerConversion	Decimal	Metric	Cost Per Conv	Cost Per Conv for the AutomaticPlacementsPerformance report.
CrossDeviceConversions	Double	Metric	Cross-device Conv	Cross-device Conv for the AutomaticPlacementsPerformance report.
Ctr	Double	Metric	CTR	CTR for the AutomaticPlacementsPerformance report.
EngagementRate	Double	Metric	Engagement Rate	Engagement Rate for the AutomaticPlacementsPerformance report.
Engagements	Long	Metric	Engagements	Engagements for the AutomaticPlacementsPerformance report.
Impressions	Long	Metric	Impressions	Impressions for the AutomaticPlacementsPerformance report.
InteractionRate	Double	Metric	Interaction Rate	Interaction Rate for the AutomaticPlacementsPerformance report.
Interactions	Long	Metric	Interactions	Interactions for the AutomaticPlacementsPerformance report.
InteractionTypes	String	Metric	Interaction Types	Interaction Types for the AutomaticPlacementsPerformance report.
ValuePerAllConversion	Double	Metric	Value Per All Conv	Value Per All Conv for the AutomaticPlacementsPerformance report.
ValuePerConversion	Double	Metric	Value Per Conv	Value Per Conv for the AutomaticPlacementsPerformance report.
VideoViewRate	Double	Metric	View Rate	View Rate for the AutomaticPlacementsPerformance report.
VideoViews	Long	Metric	Views	Views for the AutomaticPlacementsPerformance report.
ViewThroughConversions	Long	Metric	View-through Conv	View-through Conv for the AutomaticPlacementsPerformance 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.