feed_item

A feed item.

Attributed resources
customer
feed

Fields from the above resources may be selected along with this resource in your SELECT and WHERE clauses. These fields will not segment metrics in your SELECT clause.

Segmenting resources
ad_group
ad_group_ad
campaign

Fields from the above resources, when selected along with this resource in your SELECT and WHERE clauses, will segment metrics.

Fields/Segments/Metrics

This page shows all metrics and segments that can be put in the same SELECT clause as the fields of feed_item. However, when you specify feed_item in the FROM clause, some metrics and segments cannot be used. Use the following filter to show only the fields that can be used when feed_item is specified in the FROM clause.

Is feed_item specified in the FROM clause of your query?

 Resource fields
attribute_values
end_date_time
feed
geo_targeting_restriction
id
policy_infos
resource_name
start_date_time
status
url_custom_parameters
 Segments
ad_network_type
click_type
conversion_action
conversion_action_category
conversion_action_name
date
day_of_week
device
external_conversion_source
interaction_on_this_extension
month
month_of_year
placeholder_type
quarter
slot
week
year
 Metrics
absolute_top_impression_percentage
all_conversions
all_conversions_from_interactions_rate
all_conversions_value
average_cost
average_cpc
average_cpe
average_cpm
average_cpv
clicks
conversions
conversions_from_interactions_rate
conversions_value
cost_micros
cost_per_all_conversions
cost_per_conversion
cross_device_conversions
ctr
engagement_rate
engagements
impressions
interaction_event_types
interaction_rate
interactions
top_impression_percentage
value_per_all_conversions
value_per_conversion
video_view_rate
video_views

feed_item.attribute_values

Field descriptionThe feed item's attribute values.
CategoryATTRIBUTE
Data TypeMESSAGE
Type URLgoogle.ads.googleads.v16.resources.FeedItemAttributeValue
FilterableFalse
SelectableTrue
SortableFalse
RepeatedTrue

feed_item.end_date_time

Field descriptionEnd time in which this feed item is no longer effective and will stop serving. The time is in the customer's time zone. The format is "YYYY-MM-DD HH:MM:SS". Examples: "2018-03-05 09:15:00" or "2018-02-01 14:34:30"
CategoryATTRIBUTE
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

feed_item.feed

Field descriptionImmutable. The feed to which this feed item belongs.
CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

feed_item.geo_targeting_restriction

Field descriptionGeo targeting restriction specifies the type of location that can be used for targeting.
CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.googleads.v16.enums.GeoTargetingRestrictionEnum.GeoTargetingRestriction
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

feed_item.id

Field descriptionOutput only. The ID of this feed item.
CategoryATTRIBUTE
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

feed_item.policy_infos

Field descriptionOutput only. List of info about a feed item's validation and approval state for active feed mappings. There will be an entry in the list for each type of feed mapping associated with the feed, for example, a feed with a sitelink and a call feed mapping would cause every feed item associated with that feed to have an entry in this list for both sitelink and call. This field is read-only.
CategoryATTRIBUTE
Data TypeMESSAGE
Type URLgoogle.ads.googleads.v16.resources.FeedItemPlaceholderPolicyInfo
FilterableFalse
SelectableTrue
SortableFalse
RepeatedTrue

feed_item.resource_name

Field descriptionImmutable. The resource name of the feed item. Feed item resource names have the form: customers/{customer_id}/feedItems/{feed_id}~{feed_item_id}
CategoryATTRIBUTE
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableFalse
RepeatedFalse

feed_item.start_date_time

Field descriptionStart time in which this feed item is effective and can begin serving. The time is in the customer's time zone. The format is "YYYY-MM-DD HH:MM:SS". Examples: "2018-03-05 09:15:00" or "2018-02-01 14:34:30"
CategoryATTRIBUTE
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

feed_item.status

Field descriptionOutput only. Status of the feed item. This field is read-only.
CategoryATTRIBUTE
Data Type
Type URLgoogle.ads.googleads.v16.enums.FeedItemStatusEnum.FeedItemStatus
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

feed_item.url_custom_parameters

Field descriptionThe list of mappings used to substitute custom parameter tags in a tracking_url_template, final_urls, or mobile_final_urls.
CategoryATTRIBUTE
Data TypeMESSAGE
Type URLgoogle.ads.googleads.v16.common.CustomParameter
FilterableFalse
SelectableTrue
SortableFalse
RepeatedTrue

segments.ad_network_type

Field descriptionAd network type.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v16.enums.AdNetworkTypeEnum.AdNetworkType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.click_type

Field descriptionClick type.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v16.enums.ClickTypeEnum.ClickType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.conversion_action

Field descriptionResource name of the conversion action.
CategorySEGMENT
Data TypeRESOURCE_NAME
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.conversion_action_category

Field descriptionConversion action category.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v16.enums.ConversionActionCategoryEnum.ConversionActionCategory
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.conversion_action_name

Field descriptionConversion action name.
CategorySEGMENT
Data TypeSTRING
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.date

Field descriptionDate to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.day_of_week

Field descriptionDay of the week, for example, MONDAY.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v16.enums.DayOfWeekEnum.DayOfWeek
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.device

Field descriptionDevice to which metrics apply.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v16.enums.DeviceEnum.Device
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.external_conversion_source

Field descriptionExternal conversion source.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v16.enums.ExternalConversionSourceEnum.ExternalConversionSource
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.interaction_on_this_extension

Field descriptionOnly used with feed item metrics. Indicates whether the interaction metrics occurred on the feed item itself or a different extension or ad unit.
CategorySEGMENT
Data TypeBOOLEAN
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.month

Field descriptionMonth as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.month_of_year

Field descriptionMonth of the year, for example, January.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v16.enums.MonthOfYearEnum.MonthOfYear
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.placeholder_type

Field descriptionPlaceholder type. This is only used with feed item metrics.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v16.enums.PlaceholderTypeEnum.PlaceholderType
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.quarter

Field descriptionQuarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, for example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.slot

Field descriptionPosition of the ad.
CategorySEGMENT
Data Type
Type URLgoogle.ads.googleads.v16.enums.SlotEnum.Slot
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.week

Field descriptionWeek as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
CategorySEGMENT
Data TypeDATE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

segments.year

Field descriptionYear, formatted as yyyy.
CategorySEGMENT
Data TypeINT32
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.absolute_top_impression_percentage

Field descriptionThe percent of your ad impressions that are shown as the very first ad above the organic search results.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.all_conversions

Field descriptionThe total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.all_conversions_from_interactions_rate

Field descriptionAll conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.all_conversions_value

Field descriptionThe value of all conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.average_cost

Field descriptionThe average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.average_cpc

Field descriptionThe total cost of all clicks divided by the total number of clicks received.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.average_cpe

Field descriptionThe average amount that you've been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.average_cpm

Field descriptionAverage cost-per-thousand impressions (CPM).
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.average_cpv

Field descriptionThe average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.clicks

Field descriptionThe number of clicks.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.conversions

Field descriptionThe number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.conversions_from_interactions_rate

Field descriptionConversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.conversions_value

Field descriptionThe value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.cost_micros

Field descriptionThe sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.cost_per_all_conversions

Field descriptionThe cost of ad interactions divided by all conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.cost_per_conversion

Field descriptionThe cost of ad interactions divided by conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.cross_device_conversions

Field descriptionConversions from when a customer clicks on a Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.ctr

Field descriptionThe number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.engagement_rate

Field descriptionHow often people engage with your ad after it's shown to them. This is the number of ad expansions divided by the number of times your ad is shown.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.engagements

Field descriptionThe number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.impressions

Field descriptionCount of how often your ad has appeared on a search results page or website on the Google Network.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.interaction_event_types

Field descriptionThe types of payable and free interactions.
CategoryMETRIC
Data TypeENUM
Type URLgoogle.ads.googleads.v16.enums.InteractionEventTypeEnum.InteractionEventType
FilterableTrue
SelectableTrue
SortableFalse
RepeatedTrue

metrics.interaction_rate

Field descriptionHow often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.interactions

Field descriptionThe number of interactions. An interaction is the main user action associated with an ad format-clicks for text and shopping ads, views for video ads, and so on.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.top_impression_percentage

Field descriptionThe percent of your ad impressions that are shown anywhere above the organic search results.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.value_per_all_conversions

Field descriptionThe value of all conversions divided by the number of all conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.value_per_conversion

Field descriptionThe value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.video_view_rate

Field descriptionThe number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads.
CategoryMETRIC
Data TypeDOUBLE
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse

metrics.video_views

Field descriptionThe number of times your video ads were viewed.
CategoryMETRIC
Data TypeINT64
Type URLN/A
FilterableTrue
SelectableTrue
SortableTrue
RepeatedFalse