Placeholder
The Placeholder Report provides statistics for feed-based ad extensions, one row per placeholder type.
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 |
AccountDescriptiveName | String | Attribute | Account | Account for the Placeholder report. |
AdGroupId | Long | Attribute | Ad Group ID | Ad Group ID for the Placeholder report. |
AdGroupName | String | Attribute | Ad Group | Ad Group for the Placeholder report. |
AdGroupStatus | String | Attribute | Ad Group State | Ad Group State for the Placeholder report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED. |
CampaignId | Long | Attribute | Campaign ID | Campaign ID for the Placeholder report. |
CampaignName | String | Attribute | Campaign | Campaign for the Placeholder report. |
CampaignStatus | String | Attribute | Campaign State | Campaign State for the Placeholder report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED. |
ExtensionPlaceholderCreativeId | Long | Attribute | Ad ID | Ad ID for the Placeholder report. |
ExtensionPlaceholderType | String | Attribute | Feed Placeholder Type | Feed Placeholder Type for the Placeholder report. |
ExternalCustomerId | Long | Attribute | Customer ID | Customer ID for the Placeholder report. |
AdNetworkType1 | String | Segment | Network | Network for the Placeholder 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 Placeholder report. The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED. |
ClickType | String | Segment | Click Type | Click Type for the Placeholder 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 Placeholder report. |
ConversionTrackerId | Long | Segment | Conversion Tracker Id | Conversion Tracker Id for the Placeholder report. |
ConversionTypeName | String | Segment | Conversion Name | Conversion Name for the Placeholder report. |
Date | Date | Segment | Day | Day for the Placeholder report. |
DayOfWeek | String | Segment | Day Of Week | Day Of Week for the Placeholder report. The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY. |
Device | String | Segment | Device | Device for the Placeholder report. The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET. |
ExternalConversionSource | String | Segment | Conversion Source | Conversion Source for the Placeholder 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 Placeholder report. |
MonthOfYear | String | Segment | Month Of Year | Month Of Year for the Placeholder report. The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER. |
Quarter | String | Segment | Quarter | Quarter for the Placeholder report. |
Slot | String | Segment | Top Vs Other | Top Vs Other for the Placeholder report. The allowed values are SEARCHRHS, SEARCHTOP, SEARCHOTHER, CONTENT, AFSTOP, AFSOTHER, MIXED, UNKNOWN. |
Week | String | Segment | Week | Week for the Placeholder report. |
Year | Integer | Segment | Year | Year for the Placeholder report. |
AllConversionRate | Double | Metric | All Conv Rate | All Conv Rate for the Placeholder report. |
AllConversions | Double | Metric | All Conv | All Conv for the Placeholder report. |
AllConversionValue | Double | Metric | All Conv Value | All Conv Value for the Placeholder report. |
AverageCost | Decimal | Metric | Avg Cost | Avg Cost for the Placeholder report. |
AverageCpc | Decimal | Metric | Avg CPC | Avg CPC for the Placeholder report. |
AverageCpe | Double | Metric | Avg CPE | Avg CPE for the Placeholder report. |
AverageCpm | Decimal | Metric | Avg CPM | Avg CPM for the Placeholder report. |
AverageCpv | Double | Metric | Avg CPV | Avg CPV for the Placeholder report. |
AveragePosition | Double | Metric | Avg Position | Avg Position for the Placeholder report. |
Clicks | Long | Metric | Clicks | Clicks for the Placeholder report. |
ConversionRate | Double | Metric | Conv Rate | Conv Rate for the Placeholder report. |
Conversions | Double | Metric | Conversions | Conversions for the Placeholder report. |
ConversionValue | Double | Metric | Total Conv Value | Total Conv Value for the Placeholder report. |
Cost | Decimal | Metric | Cost | Cost for the Placeholder report. |
CostPerAllConversion | Decimal | Metric | Cost Per All Conv | Cost Per All Conv for the Placeholder report. |
CostPerConversion | Decimal | Metric | Cost Per Conv | Cost Per Conv for the Placeholder report. |
CrossDeviceConversions | Double | Metric | Cross-device Conv | Cross-device Conv for the Placeholder report. |
Ctr | Double | Metric | CTR | CTR for the Placeholder report. |
EngagementRate | Double | Metric | Engagement Rate | Engagement Rate for the Placeholder report. |
Engagements | Long | Metric | Engagements | Engagements for the Placeholder report. |
Impressions | Long | Metric | Impressions | Impressions for the Placeholder report. |
InteractionRate | Double | Metric | Interaction Rate | Interaction Rate for the Placeholder report. |
Interactions | Long | Metric | Interactions | Interactions for the Placeholder report. |
InteractionTypes | String | Metric | Interaction Types | Interaction Types for the Placeholder report. |
ValuePerAllConversion | Double | Metric | Value Per All Conv | Value Per All Conv for the Placeholder report. |
ValuePerConversion | Double | Metric | Value Per Conv | Value Per Conv for the Placeholder report. |
VideoViewRate | Double | Metric | View Rate | View Rate for the Placeholder report. |
VideoViews | Long | Metric | Views | Views for the Placeholder report. |
ViewThroughConversions | Long | Metric | View-through Conv | View-through Conv for the Placeholder 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