ExtensionFeedItem

An extension feed item.

Table Specific Information

Select

Google Ads 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 Ads 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 Ads API.

Columns

Name	Type	Behavior	Description
ExtensionFeedItemAdSchedules	String	Attribute	AdSchedules column for table ExtensionFeedItem
ExtensionFeedItemAffiliateLocationFeedItemAddressLine1	String	Attribute	AffiliateLocationFeedItemAddressLine1 column for table ExtensionFeedItem
ExtensionFeedItemAffiliateLocationFeedItemAddressLine2	String	Attribute	AffiliateLocationFeedItemAddressLine2 column for table ExtensionFeedItem
ExtensionFeedItemAffiliateLocationFeedItemBusinessName	String	Attribute	AffiliateLocationFeedItemBusinessName column for table ExtensionFeedItem
ExtensionFeedItemAffiliateLocationFeedItemChainId	Long	Attribute	AffiliateLocationFeedItemChainId column for table ExtensionFeedItem
ExtensionFeedItemAffiliateLocationFeedItemChainName	String	Attribute	AffiliateLocationFeedItemChainName column for table ExtensionFeedItem
ExtensionFeedItemAffiliateLocationFeedItemCity	String	Attribute	AffiliateLocationFeedItemCity column for table ExtensionFeedItem
ExtensionFeedItemAffiliateLocationFeedItemCountryCode	String	Attribute	AffiliateLocationFeedItemCountryCode column for table ExtensionFeedItem
ExtensionFeedItemAffiliateLocationFeedItemPhoneNumber	String	Attribute	AffiliateLocationFeedItemPhoneNumber column for table ExtensionFeedItem
ExtensionFeedItemAffiliateLocationFeedItemPostalCode	String	Attribute	AffiliateLocationFeedItemPostalCode column for table ExtensionFeedItem
ExtensionFeedItemAffiliateLocationFeedItemProvince	String	Attribute	AffiliateLocationFeedItemProvince column for table ExtensionFeedItem
ExtensionFeedItemAppFeedItemAppId	String	Attribute	AppFeedItemAppId column for table ExtensionFeedItem
ExtensionFeedItemAppFeedItemAppStore	String	Attribute	AppFeedItemAppStore column for table ExtensionFeedItem
ExtensionFeedItemAppFeedItemFinalMobileUrls	String	Attribute	AppFeedItemFinalMobileUrls column for table ExtensionFeedItem
ExtensionFeedItemAppFeedItemFinalUrlSuffix	String	Attribute	AppFeedItemFinalUrlSuffix column for table ExtensionFeedItem
ExtensionFeedItemAppFeedItemFinalUrls	String	Attribute	AppFeedItemFinalUrls column for table ExtensionFeedItem
ExtensionFeedItemAppFeedItemLinkText	String	Attribute	AppFeedItemLinkText column for table ExtensionFeedItem
ExtensionFeedItemAppFeedItemTrackingUrlTemplate	String	Attribute	AppFeedItemTrackingUrlTemplate column for table ExtensionFeedItem
ExtensionFeedItemCallFeedItemCallConversionAction	String	Attribute	CallFeedItemCallConversionAction column for table ExtensionFeedItem
ExtensionFeedItemCallFeedItemCallConversionReportingState	String	Attribute	CallFeedItemCallConversionReportingState column for table ExtensionFeedItem
ExtensionFeedItemCallFeedItemCallConversionTrackingDisabled	Bool	Attribute	CallFeedItemCallConversionTrackingDisabled column for table ExtensionFeedItem
ExtensionFeedItemCallFeedItemCallTrackingEnabled	Bool	Attribute	CallFeedItemCallTrackingEnabled column for table ExtensionFeedItem
ExtensionFeedItemCallFeedItemCountryCode	String	Attribute	CallFeedItemCountryCode column for table ExtensionFeedItem
ExtensionFeedItemCallFeedItemPhoneNumber	String	Attribute	CallFeedItemPhoneNumber column for table ExtensionFeedItem
ExtensionFeedItemCalloutFeedItemCalloutText	String	Attribute	CalloutFeedItemCalloutText column for table ExtensionFeedItem
ExtensionFeedItemDevice	String	Attribute	Device column for table ExtensionFeedItem
ExtensionFeedItemEndDateTime	Date	Attribute	EndDateTime column for table ExtensionFeedItem
ExtensionFeedItemExtensionType	String	Attribute	ExtensionType column for table ExtensionFeedItem
ExtensionFeedItemHotelCalloutFeedItemLanguageCode	String	Attribute	HotelCalloutFeedItemLanguageCode column for table ExtensionFeedItem
ExtensionFeedItemHotelCalloutFeedItemText	String	Attribute	HotelCalloutFeedItemText column for table ExtensionFeedItem
ExtensionFeedItemId	Long	Attribute	Id column for table ExtensionFeedItem
ExtensionFeedItemImageFeedItemImageAsset	String	Attribute	ImageFeedItemImageAsset column for table ExtensionFeedItem
ExtensionFeedItemLocationFeedItemAddressLine1	String	Attribute	LocationFeedItemAddressLine1 column for table ExtensionFeedItem
ExtensionFeedItemLocationFeedItemAddressLine2	String	Attribute	LocationFeedItemAddressLine2 column for table ExtensionFeedItem
ExtensionFeedItemLocationFeedItemBusinessName	String	Attribute	LocationFeedItemBusinessName column for table ExtensionFeedItem
ExtensionFeedItemLocationFeedItemCity	String	Attribute	LocationFeedItemCity column for table ExtensionFeedItem
ExtensionFeedItemLocationFeedItemCountryCode	String	Attribute	LocationFeedItemCountryCode column for table ExtensionFeedItem
ExtensionFeedItemLocationFeedItemPhoneNumber	String	Attribute	LocationFeedItemPhoneNumber column for table ExtensionFeedItem
ExtensionFeedItemLocationFeedItemPostalCode	String	Attribute	LocationFeedItemPostalCode column for table ExtensionFeedItem
ExtensionFeedItemLocationFeedItemProvince	String	Attribute	LocationFeedItemProvince column for table ExtensionFeedItem
ExtensionFeedItemPriceFeedItemFinalUrlSuffix	String	Attribute	PriceFeedItemFinalUrlSuffix column for table ExtensionFeedItem
ExtensionFeedItemPriceFeedItemLanguageCode	String	Attribute	PriceFeedItemLanguageCode column for table ExtensionFeedItem
ExtensionFeedItemPriceFeedItemPriceOfferings	String	Attribute	PriceFeedItemPriceOfferings column for table ExtensionFeedItem
ExtensionFeedItemPriceFeedItemPriceQualifier	String	Attribute	PriceFeedItemPriceQualifier column for table ExtensionFeedItem
ExtensionFeedItemPriceFeedItemTrackingUrlTemplate	String	Attribute	PriceFeedItemTrackingUrlTemplate column for table ExtensionFeedItem
ExtensionFeedItemPriceFeedItemType	String	Attribute	PriceFeedItemType column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemDiscountModifier	String	Attribute	PromotionFeedItemDiscountModifier column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemFinalMobileUrls	String	Attribute	PromotionFeedItemFinalMobileUrls column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemFinalUrlSuffix	String	Attribute	PromotionFeedItemFinalUrlSuffix column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemFinalUrls	String	Attribute	PromotionFeedItemFinalUrls column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemLanguageCode	String	Attribute	PromotionFeedItemLanguageCode column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemMoneyAmountOffAmountMicros	Long	Attribute	PromotionFeedItemMoneyAmountOffAmountMicros column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemMoneyAmountOffCurrencyCode	String	Attribute	PromotionFeedItemMoneyAmountOffCurrencyCode column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemOccasion	String	Attribute	PromotionFeedItemOccasion column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemOrdersOverAmountAmountMicros	Long	Attribute	PromotionFeedItemOrdersOverAmountAmountMicros column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemOrdersOverAmountCurrencyCode	String	Attribute	PromotionFeedItemOrdersOverAmountCurrencyCode column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemPercentOff	Long	Attribute	PromotionFeedItemPercentOff column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemPromotionCode	String	Attribute	PromotionFeedItemPromotionCode column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemPromotionEndDate	Date	Attribute	PromotionFeedItemPromotionEndDate column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemPromotionStartDate	Date	Attribute	PromotionFeedItemPromotionStartDate column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemPromotionTarget	String	Attribute	PromotionFeedItemPromotionTarget column for table ExtensionFeedItem
ExtensionFeedItemPromotionFeedItemTrackingUrlTemplate	String	Attribute	PromotionFeedItemTrackingUrlTemplate column for table ExtensionFeedItem
ExtensionFeedItemResourceName	String	Attribute	ResourceName column for table ExtensionFeedItem
ExtensionFeedItemSitelinkFeedItemFinalMobileUrls	String	Attribute	SitelinkFeedItemFinalMobileUrls column for table ExtensionFeedItem
ExtensionFeedItemSitelinkFeedItemFinalUrlSuffix	String	Attribute	SitelinkFeedItemFinalUrlSuffix column for table ExtensionFeedItem
ExtensionFeedItemSitelinkFeedItemFinalUrls	String	Attribute	SitelinkFeedItemFinalUrls column for table ExtensionFeedItem
ExtensionFeedItemSitelinkFeedItemLine1	String	Attribute	SitelinkFeedItemLine1 column for table ExtensionFeedItem
ExtensionFeedItemSitelinkFeedItemLine2	String	Attribute	SitelinkFeedItemLine2 column for table ExtensionFeedItem
ExtensionFeedItemSitelinkFeedItemLinkText	String	Attribute	SitelinkFeedItemLinkText column for table ExtensionFeedItem
ExtensionFeedItemSitelinkFeedItemTrackingUrlTemplate	String	Attribute	SitelinkFeedItemTrackingUrlTemplate column for table ExtensionFeedItem
ExtensionFeedItemStartDateTime	Date	Attribute	StartDateTime column for table ExtensionFeedItem
ExtensionFeedItemStatus	String	Attribute	Status column for table ExtensionFeedItem
ExtensionFeedItemStructuredSnippetFeedItemHeader	String	Attribute	StructuredSnippetFeedItemHeader column for table ExtensionFeedItem
ExtensionFeedItemStructuredSnippetFeedItemValues	String	Attribute	StructuredSnippetFeedItemValues column for table ExtensionFeedItem
ExtensionFeedItemTargetedAdGroup	String	Attribute	TargetedAdGroup column for table ExtensionFeedItem
ExtensionFeedItemTargetedCampaign	String	Attribute	TargetedCampaign column for table ExtensionFeedItem
ExtensionFeedItemTargetedGeoTargetConstant	String	Attribute	TargetedGeoTargetConstant column for table ExtensionFeedItem
ExtensionFeedItemTargetedKeywordMatchType	String	Attribute	TargetedKeywordMatchType column for table ExtensionFeedItem
ExtensionFeedItemTargetedKeywordText	String	Attribute	TargetedKeywordText column for table ExtensionFeedItem
ExtensionFeedItemTextMessageFeedItemBusinessName	String	Attribute	TextMessageFeedItemBusinessName column for table ExtensionFeedItem
ExtensionFeedItemTextMessageFeedItemCountryCode	String	Attribute	TextMessageFeedItemCountryCode column for table ExtensionFeedItem
ExtensionFeedItemTextMessageFeedItemExtensionText	String	Attribute	TextMessageFeedItemExtensionText column for table ExtensionFeedItem
ExtensionFeedItemTextMessageFeedItemPhoneNumber	String	Attribute	TextMessageFeedItemPhoneNumber column for table ExtensionFeedItem
ExtensionFeedItemTextMessageFeedItemText	String	Attribute	TextMessageFeedItemText column for table ExtensionFeedItem
CustomerId	Long	Attribute	ClientCustomerId column for table ExtensionFeedItem
AbsoluteTopImpressionPercentage	Double	Metric	AbsoluteTopImpressionPercentage column for table Metrics
AllConversions	Double	Metric	AllConversions column for table Metrics
AllConversionsFromClickToCall	Double	Metric	AllConversionsFromClickToCall column for table Metrics
AllConversionsFromDirections	Double	Metric	AllConversionsFromDirections column for table Metrics
AllConversionsFromInteractionsRate	Double	Metric	AllConversionsFromInteractionsRate column for table Metrics
AllConversionsFromMenu	Double	Metric	AllConversionsFromMenu column for table Metrics
AllConversionsFromOrder	Double	Metric	AllConversionsFromOrder column for table Metrics
AllConversionsFromOtherEngagement	Double	Metric	AllConversionsFromOtherEngagement column for table Metrics
AllConversionsFromStoreVisit	Double	Metric	AllConversionsFromStoreVisit column for table Metrics
AllConversionsFromStoreWebsite	Double	Metric	AllConversionsFromStoreWebsite column for table Metrics
AllConversionsValue	Double	Metric	AllConversionsValue column for table Metrics
AverageCpc	Double	Metric	AverageCpc column for table Metrics
AverageCpm	Double	Metric	AverageCpm column for table Metrics
AverageCpv	Double	Metric	AverageCpv column for table Metrics
Clicks	Long	Metric	Clicks column for table Metrics
Conversions	Double	Metric	Conversions column for table Metrics
ConversionsFromInteractionsRate	Double	Metric	ConversionsFromInteractionsRate column for table Metrics
ConversionsValue	Double	Metric	ConversionsValue column for table Metrics
CostMicros	Long	Metric	CostMicros column for table Metrics
CostPerAllConversions	Double	Metric	CostPerAllConversions column for table Metrics
CostPerConversion	Double	Metric	CostPerConversion column for table Metrics
CrossDeviceConversions	Double	Metric	CrossDeviceConversions column for table Metrics
Ctr	Double	Metric	Ctr column for table Metrics
Impressions	Long	Metric	Impressions column for table Metrics
MessageChatRate	Double	Metric	MessageChatRate column for table Metrics
MessageChats	Long	Metric	MessageChats column for table Metrics
MessageImpressions	Long	Metric	MessageImpressions column for table Metrics
PhoneCalls	Long	Metric	PhoneCalls column for table Metrics
PhoneImpressions	Long	Metric	PhoneImpressions column for table Metrics
PhoneThroughRate	Double	Metric	PhoneThroughRate column for table Metrics
TopImpressionPercentage	Double	Metric	TopImpressionPercentage column for table Metrics
ValuePerAllConversions	Double	Metric	ValuePerAllConversions column for table Metrics
ValuePerConversion	Double	Metric	ValuePerConversion column for table Metrics
VideoViewRate	Double	Metric	VideoViewRate column for table Metrics
VideoViews	Long	Metric	VideoViews column for table Metrics
AdNetworkType	String	Segment	AdNetworkType column for table Segments
ClickType	String	Segment	ClickType column for table Segments
ConversionAction	String	Segment	ConversionAction column for table Segments
ConversionActionCategory	String	Segment	ConversionActionCategory column for table Segments
ConversionActionName	String	Segment	ConversionActionName column for table Segments
Date	Date	Segment	Date column for table Segments
DayOfWeek	String	Segment	DayOfWeek column for table Segments
Device	String	Segment	Device column for table Segments
ExternalConversionSource	String	Segment	ExternalConversionSource column for table Segments
InteractionOnThisExtension	Bool	Segment	InteractionOnThisExtension column for table Segments
Month	Date	Segment	Month column for table Segments
MonthOfYear	String	Segment	MonthOfYear column for table Segments
Quarter	Date	Segment	Quarter column for table Segments
Slot	String	Segment	Slot column for table Segments
Week	Date	Segment	Week column for table Segments
Year	Int	Segment	Year column for table Segments

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
ManagerId	Long	Id of the manager account on behalf of which you are requesting customer data.