PlaceholderFeedItem

The Placeholder Feed Item report includes all statistics at the feed-item level (e.g., a single sitelink).

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 PlaceholderFeedItem report.
AccountDescriptiveName	String	Attribute	Account	Account for the PlaceholderFeedItem report.
AccountTimeZone	String	Attribute	Time Zone	Time Zone for the PlaceholderFeedItem report.
AdId	Long	Attribute	Ad ID	Ad ID for the PlaceholderFeedItem report.
AttributeValues	String	Attribute	Attribute Values	Attribute Values for the PlaceholderFeedItem report.
Criteria	String	Attribute	Target Keyword Text	Target Keyword Text for the PlaceholderFeedItem report.
CustomerDescriptiveName	String	Attribute	Client Name	Client Name for the PlaceholderFeedItem report.
DevicePreference	String	Attribute	Device Preference	Device Preference for the PlaceholderFeedItem report.
DisapprovalShortNames	String	Attribute	Disapproval Reasons	Disapproval Reasons for the PlaceholderFeedItem report.
EndTime	String	Attribute	End Date	End Date for the PlaceholderFeedItem report.
ExternalCustomerId	Long	Attribute	Customer ID	Customer ID for the PlaceholderFeedItem report.
FeedId	Long	Attribute	Feed ID	Feed ID for the PlaceholderFeedItem report.
FeedItemId	Long	Attribute	Item ID	Item ID for the PlaceholderFeedItem report.
GeoTargetingCriterionId	Long	Attribute	Target Location	Target Location for the PlaceholderFeedItem report.
GeoTargetingRestriction	String	Attribute	Target Location Restriction	Target Location Restriction for the PlaceholderFeedItem report. The allowed values are UNKNOWN, LOCATION_OF_PRESENCE.
IsSelfAction	String	Attribute	This Extension Vs Other	This Extension Vs Other for the PlaceholderFeedItem report. The allowed values are TRUE, FALSE.
KeywordMatchType	String	Attribute	Target Keyword Match Type	Target Keyword Match Type for the PlaceholderFeedItem report. The allowed values are EXACT, PHRASE, BROAD.
KeywordTargetingId	Long	Attribute	Keyword ID	Keyword ID for the PlaceholderFeedItem report.
PlaceholderType	Integer	Attribute	Feed Placeholder Type	Feed Placeholder Type for the PlaceholderFeedItem report.
Scheduling	String	Attribute	Scheduling	Scheduling for the PlaceholderFeedItem report.
StartTime	String	Attribute	Start Date	Start Date for the PlaceholderFeedItem report.
Status	String	Attribute	Item State	Item State for the PlaceholderFeedItem report. The allowed values are ENABLED, REMOVED, UNKNOWN.
TargetingAdGroupId	Long	Attribute	Target Ad Group ID	Target Ad Group ID for the PlaceholderFeedItem report.
TargetingCampaignId	Long	Attribute	Target Campaign ID	Target Campaign ID for the PlaceholderFeedItem report.
UrlCustomParameters	String	Attribute	Custom Parameter	Custom Parameter for the PlaceholderFeedItem report.
ValidationDetails	String	Attribute	Approval Status	Approval Status for the PlaceholderFeedItem report.
AdGroupId	Long	Segment	Ad Group ID	Ad Group ID for the PlaceholderFeedItem report.
AdGroupName	String	Segment	Ad Group	Ad Group for the PlaceholderFeedItem report.
AdGroupStatus	String	Segment	Ad Group State	Ad Group State for the PlaceholderFeedItem report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
AdNetworkType1	String	Segment	Network	Network for the PlaceholderFeedItem 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 PlaceholderFeedItem report. The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.
CampaignId	Long	Segment	Campaign ID	Campaign ID for the PlaceholderFeedItem report.
CampaignName	String	Segment	Campaign	Campaign for the PlaceholderFeedItem report.
CampaignStatus	String	Segment	Campaign State	Campaign State for the PlaceholderFeedItem report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
ClickType	String	Segment	Click Type	Click Type for the PlaceholderFeedItem 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 PlaceholderFeedItem report.
ConversionTrackerId	Long	Segment	Conversion Tracker Id	Conversion Tracker Id for the PlaceholderFeedItem report.
ConversionTypeName	String	Segment	Conversion Name	Conversion Name for the PlaceholderFeedItem report.
Date	Date	Segment	Day	Day for the PlaceholderFeedItem report.
DayOfWeek	String	Segment	Day Of Week	Day Of Week for the PlaceholderFeedItem report. The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.
Device	String	Segment	Device	Device for the PlaceholderFeedItem report. The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET.
ExternalConversionSource	String	Segment	Conversion Source	Conversion Source for the PlaceholderFeedItem 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 PlaceholderFeedItem report.
MonthOfYear	String	Segment	Month Of Year	Month Of Year for the PlaceholderFeedItem report. The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.
Quarter	String	Segment	Quarter	Quarter for the PlaceholderFeedItem report.
Slot	String	Segment	Top Vs Other	Top Vs Other for the PlaceholderFeedItem report. The allowed values are SEARCHRHS, SEARCHTOP, SEARCHOTHER, CONTENT, AFSTOP, AFSOTHER, MIXED, UNKNOWN.
Week	String	Segment	Week	Week for the PlaceholderFeedItem report.
Year	Integer	Segment	Year	Year for the PlaceholderFeedItem report.
AllConversionRate	Double	Metric	All Conv Rate	All Conv Rate for the PlaceholderFeedItem report.
AllConversions	Double	Metric	All Conv	All Conv for the PlaceholderFeedItem report.
AllConversionValue	Double	Metric	All Conv Value	All Conv Value for the PlaceholderFeedItem report.
AverageCost	Decimal	Metric	Avg Cost	Avg Cost for the PlaceholderFeedItem report.
AverageCpc	Decimal	Metric	Avg CPC	Avg CPC for the PlaceholderFeedItem report.
AverageCpe	Double	Metric	Avg CPE	Avg CPE for the PlaceholderFeedItem report.
AverageCpm	Decimal	Metric	Avg CPM	Avg CPM for the PlaceholderFeedItem report.
AverageCpv	Double	Metric	Avg CPV	Avg CPV for the PlaceholderFeedItem report.
AveragePosition	Double	Metric	Avg Position	Avg Position for the PlaceholderFeedItem report.
Clicks	Long	Metric	Clicks	Clicks for the PlaceholderFeedItem report.
ConversionRate	Double	Metric	Conv Rate	Conv Rate for the PlaceholderFeedItem report.
Conversions	Double	Metric	Conversions	Conversions for the PlaceholderFeedItem report.
ConversionValue	Double	Metric	Total Conv Value	Total Conv Value for the PlaceholderFeedItem report.
Cost	Decimal	Metric	Cost	Cost for the PlaceholderFeedItem report.
CostPerAllConversion	Decimal	Metric	Cost Per All Conv	Cost Per All Conv for the PlaceholderFeedItem report.
CostPerConversion	Decimal	Metric	Cost Per Conv	Cost Per Conv for the PlaceholderFeedItem report.
CrossDeviceConversions	Double	Metric	Cross-device Conv	Cross-device Conv for the PlaceholderFeedItem report.
Ctr	Double	Metric	CTR	CTR for the PlaceholderFeedItem report.
EngagementRate	Double	Metric	Engagement Rate	Engagement Rate for the PlaceholderFeedItem report.
Engagements	Long	Metric	Engagements	Engagements for the PlaceholderFeedItem report.
Impressions	Long	Metric	Impressions	Impressions for the PlaceholderFeedItem report.
InteractionRate	Double	Metric	Interaction Rate	Interaction Rate for the PlaceholderFeedItem report.
Interactions	Long	Metric	Interactions	Interactions for the PlaceholderFeedItem report.
InteractionTypes	String	Metric	Interaction Types	Interaction Types for the PlaceholderFeedItem report.
ValuePerAllConversion	Double	Metric	Value Per All Conv	Value Per All Conv for the PlaceholderFeedItem report.
ValuePerConversion	Double	Metric	Value Per Conv	Value Per Conv for the PlaceholderFeedItem report.
VideoViewRate	Double	Metric	View Rate	View Rate for the PlaceholderFeedItem report.
VideoViews	Long	Metric	Views	Views for the PlaceholderFeedItem 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.