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.
Last updated