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