Shopping Performance Report

The Shopping Performance report provides shopping campaign statistics aggregated at the product (OfferId field) level. Product dimension values from Merchant Center such as brand, category, custom attributes, product condition and product type will reflect the state of each dimension as of the date and time when AdWords recorded the corresponding event.

 Attribute

 Segment

 Metric

Ctr

Download this table in CSV format

SHOPPING_PERFORMANCE_REPORT

AccountDescriptiveName

The descriptive name of the Customer account.

TypeString
Display NameAccount
XML Attributeaccount
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AdGroupId

The ID of the AdGroup.

TypeLong
Display NameAd group ID
XML AttributeadGroupID
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AdGroupName

The name of the AdGroup.

TypeString
Display NameAd group
XML AttributeadGroup
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AdGroupStatus

Status of the ad group.

TypeAdGroupStatus
Display NameAd group state
XML AttributeadGroupState
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

AdNetworkType1

First level network type.

TypeAdNetworkType1
Display NameNetwork
XML Attributenetwork
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsTrue

AdNetworkType2

Second level network type (includes search partners).

TypeAdNetworkType2
Display NameNetwork (with search partners)
XML AttributenetworkWithSearchPartners
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsTrue

AggregatorId

The multi-client account ID from Merchant Center.

TypeLong
Display NameMCA Id
XML AttributemCAId
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AllConversionRate

AllConversions divided by total clicks that can be conversion-tracked. This is how often a click on your ad resulted in a conversion. Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameAll conv. rate
XML AttributeallConvRate
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

AllConversions

Best estimate of the total number of conversions that Google Ads drives. Includes website, cross-device, and phone call conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameAll conv.
XML AttributeallConv
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

AllConversionValue

The total value of all of your conversions, including those that are estimated. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameAll conv. value
XML AttributeallConvValue
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

AverageCpc

The total cost of all clicks divided by the total number of clicks received. Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.

TypeMoney
Display NameAvg. CPC
XML AttributeavgCPC
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

Brand

The ProductBrand value of the product.

TypeString
Display NameBrand
XML Attributebrand
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CampaignId

The ID of the Campaign.

TypeLong
Display NameCampaign ID
XML AttributecampaignID
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CampaignName

The name of the Campaign.

TypeString
Display NameCampaign
XML Attributecampaign
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CampaignStatus

The status of the Campaign.

TypeCampaignStatus
Display NameCampaign state
XML AttributecampaignState
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

CategoryL1

The ProductBiddingCategory level 1 value of the product.

TypeString
Display NameCategory (1st level)
XML Attributecategory1stLevel
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CategoryL2

The ProductBiddingCategory level 2 value of the product.

TypeString
Display NameCategory (2nd level)
XML Attributecategory2ndLevel
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CategoryL3

The ProductBiddingCategory level 3 value of the product.

TypeString
Display NameCategory (3rd level)
XML Attributecategory3rdLevel
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CategoryL4

The ProductBiddingCategory level 4 value of the product.

TypeString
Display NameCategory (4th level)
XML Attributecategory4thLevel
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CategoryL5

The ProductBiddingCategory level 5 value of the product.

TypeString
Display NameCategory (5th level)
XML Attributecategory5thLevel
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Channel

Channel of the product.

TypeShoppingProductChannel
Display NameChannel
XML Attributechannel
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

ChannelExclusivity

Channel exclusivity of the product.

TypeShoppingProductChannelExclusivity
Display NameChannel Exclusivity
XML AttributechannelExclusivity
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

Clicks

The number of clicks.

TypeLong
Display NameClicks
XML Attributeclicks
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

ClickType

Indicates the click type for metric fields such as Impressions. Since ads that serve can be attributed to multiple click types, metric fields may be double-counted and thus totals may not be accurate, especially for Display network campaigns.

TypeClickType
Display NameClick type
XML AttributeclickType
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

ConversionCategoryName

A category that describes the action the user will take to complete a conversion. Prevents zero-conversion rows from being returned. Values: "Download", "Lead", "Purchase/Sale", "Signup", "View of a key page", and "Other".

TypeString
Display NameConversion category
XML AttributeconversionCategory
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

ConversionRate

The number of conversions divided by total clicks that can be tracked to conversions. Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameConv. rate
XML AttributeconvRate
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

Conversions

The number of conversions for all conversion actions that you have opted into optimization. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameConversions
XML Attributeconversions
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

ConversionTrackerId

ID of the conversion tracker.

TypeLong
Display NameConversion Tracker Id
XML AttributeconversionTrackerId
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

ConversionTypeName

The name of the conversion type. Prevents zero-conversion rows from being returned.

TypeString
Display NameConversion name
XML AttributeconversionName
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

ConversionValue

The sum of conversion values for all conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameTotal conv. value
XML AttributetotalConvValue
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

Cost

The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.

TypeMoney
Display NameCost
XML Attributecost
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

CostPerAllConversion

Total cost divided by all conversions. Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.

TypeMoney
Display NameCost / all conv.
XML AttributecostAllConv
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

CostPerConversion

The Cost attributable to conversion-tracked clicks divided by the number of conversions. Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.

TypeMoney
Display NameCost / conv.
XML AttributecostConv
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

CountryCriteriaId

ID of the country Location associated with the impression. You can look up the corresponding name and other information using LocationCriterionService.

TypeInteger
Display NameCountry/Territory
XML AttributecountryTerritory
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CrossDeviceConversions

Conversions from when a customer clicks on an ad on one device, then converts on a different device or browser. Cross-device conversions are already included in your AllConversions column. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameCross-device conv.
XML AttributecrossDeviceConv
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

Ctr

The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameCTR
XML Attributectr
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

CustomAttribute0

The ProductCustomAttribute level 0 value of the product.

TypeString
Display NameCustom label 0
XML AttributecustomLabel0
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CustomAttribute1

The ProductCustomAttribute level 1 value of the product.

TypeString
Display NameCustom label 1
XML AttributecustomLabel1
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CustomAttribute2

The ProductCustomAttribute level 2 value of the product.

TypeString
Display NameCustom label 2
XML AttributecustomLabel2
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CustomAttribute3

The ProductCustomAttribute level 3 value of the product.

TypeString
Display NameCustom label 3
XML AttributecustomLabel3
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CustomAttribute4

The ProductCustomAttribute level 4 value of the product.

TypeString
Display NameCustom label 4
XML AttributecustomLabel4
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Date

The date formatted as yyyy-MM-dd.

TypeDate
Display NameDay
XML Attributeday
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsTrue

DayOfWeek

The name of the day of the week, e.g., "Monday".

TypeDayOfWeek
Display NameDay of week
XML AttributedayOfWeek
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsTrue

Device

Device type where the impression was shown.

TypeDeviceType
Display NameDevice
XML Attributedevice
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsTrue

ExternalConversionSource

The source of conversion such as website, import from calls.

TypeExternalConversionSource
Display NameConversion source
XML AttributeconversionSource
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

ExternalCustomerId

The Customer ID.

TypeLong
Display NameCustomer ID
XML AttributecustomerID
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Impressions

Count of how often your ad has appeared on a search results page or website on the Google Network.

TypeLong
Display NameImpressions
XML Attributeimpressions
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

LanguageCriteriaId

Language of the product information.

TypeInteger
Display NameLanguage
XML Attributelanguage
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

MerchantId

ID of the Google Merchant Center account associated with the products being advertised.

TypeLong
Display NameMC Id
XML AttributemCId
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Month

The first day of the month, formatted as yyyy-MM-dd.

TypeString
Display NameMonth
XML Attributemonth
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsTrue

OfferId

Offer/item ID of the product.

TypeString
Display NameItem Id
XML AttributeitemId
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

ProductCondition

The ProductCanonicalCondition of the product.

TypeShoppingProductCondition
Display NameCondition
XML Attributecondition
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

ProductTitle

The title of the product.

TypeString
Display NameProduct Title
XML AttributeproductTitle
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

ProductTypeL1

The ProductType level 1 value of the product.

TypeString
Display NameProduct type (1st level)
XML AttributeproductType1stLevel
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

ProductTypeL2

The ProductType level 2 value of the product.

TypeString
Display NameProduct type (2nd level)
XML AttributeproductType2ndLevel
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

ProductTypeL3

The ProductType level 3 value of the product.

TypeString
Display NameProduct type (3rd level)
XML AttributeproductType3rdLevel
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

ProductTypeL4

The ProductType level 4 value of the product.

TypeString
Display NameProduct type (4th level)
XML AttributeproductType4thLevel
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

ProductTypeL5

The ProductType level 5 value of the product.

TypeString
Display NameProduct type (5th level)
XML AttributeproductType5thLevel
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Quarter

The first day of the quarter, formatted as yyyy-MM-dd. Uses the calendar year for quarters, e.g., the second quarter of 2014 starts on 2014-04-01.

TypeString
Display NameQuarter
XML Attributequarter
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsTrue

SearchAbsoluteTopImpressionShare

The impressions you've received in the absolute top location (the very first ad above the organic search results) divided by the estimated number of impressions you were eligible to receive in the top location. See this Help Center article for details. A percentage returned as "xx.xx%", or the special value "< 10%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameSearch abs. top IS
XML AttributesearchAbsTopIS
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

SearchClickShare

The number of clicks you've received on the Search Network divided by the estimated number of clicks you were eligible to receive. A percentage returned as "xx.xx%", or the special value "< 10%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameClick share
XML AttributeclickShare
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

SearchImpressionShare

The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive. A percentage returned as "xx.xx%", or the special value "< 10%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameSearch Impr. share
XML AttributesearchImprShare
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

StoreId

Store ID of the product.

TypeString
Display NameStore Id
XML AttributestoreId
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

ValuePerAllConversion

The value, on average, of all conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameValue / all conv.
XML AttributevalueAllConv
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

ValuePerConversion

The total value of your conversions divided by the total number of conversions. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameValue / conv.
XML AttributevalueConv
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsTrue

Week

The date for the Monday of the week, formatted as yyyy-MM-dd.

TypeString
Display NameWeek
XML Attributeweek
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsTrue

Year

The year, formatted as yyyy.

TypeInteger
Display NameYear
XML Attributeyear
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsTrue