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