ShoppingPerformance

The Shopping Performance report provides shopping campaign statistics aggregated at the product (OfferId field) level.

Table Specific Information

Select

Google AdWords 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 AdWords 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 AdWords API.

Columns

Name

Type

Behavior

DisplayName

Description

AccountDescriptiveName

String

Attribute

Account

Account for the ShoppingPerformance report.

AdGroupId

Long

Attribute

Ad Group ID

Ad Group ID for the ShoppingPerformance report.

AdGroupName

String

Attribute

Ad Group

Ad Group for the ShoppingPerformance report.

AggregatorId

Long

Attribute

MCA Id

MCA Id for the ShoppingPerformance report.

Brand

String

Attribute

Brand

Brand for the ShoppingPerformance report.

CampaignId

Long

Attribute

Campaign ID

Campaign ID for the ShoppingPerformance report.

CampaignName

String

Attribute

Campaign

Campaign for the ShoppingPerformance report.

CategoryL1

String

Attribute

Category (1st Level)

Category (1st Level) for the ShoppingPerformance report.

CategoryL2

String

Attribute

Category (2nd Level)

Category (2nd Level) for the ShoppingPerformance report.

CategoryL3

String

Attribute

Category (3rd Level)

Category (3rd Level) for the ShoppingPerformance report.

CategoryL4

String

Attribute

Category (4th Level)

Category (4th Level) for the ShoppingPerformance report.

CategoryL5

String

Attribute

Category (5th Level)

Category (5th Level) for the ShoppingPerformance report.

CountryCriteriaId

Integer

Attribute

Country Per Territory

Country Per Territory for the ShoppingPerformance report.

CustomAttribute0

String

Attribute

Custom Label 0

Custom Label 0 for the ShoppingPerformance report.

CustomAttribute1

String

Attribute

Custom Label 1

Custom Label 1 for the ShoppingPerformance report.

CustomAttribute2

String

Attribute

Custom Label 2

Custom Label 2 for the ShoppingPerformance report.

CustomAttribute3

String

Attribute

Custom Label 3

Custom Label 3 for the ShoppingPerformance report.

CustomAttribute4

String

Attribute

Custom Label 4

Custom Label 4 for the ShoppingPerformance report.

ExternalCustomerId

Long

Attribute

Customer ID

Customer ID for the ShoppingPerformance report.

LanguageCriteriaId

Integer

Attribute

Language

Language for the ShoppingPerformance report.

MerchantId

Long

Attribute

MC Id

MC Id for the ShoppingPerformance report.

OfferId

String

Attribute

Item Id

Item Id for the ShoppingPerformance report.

ProductTitle

String

Attribute

Product Title

Product Title for the ShoppingPerformance report.

ProductTypeL1

String

Attribute

Product Type (1st Level)

Product Type (1st Level) for the ShoppingPerformance report.

ProductTypeL2

String

Attribute

Product Type (2nd Level)

Product Type (2nd Level) for the ShoppingPerformance report.

ProductTypeL3

String

Attribute

Product Type (3rd Level)

Product Type (3rd Level) for the ShoppingPerformance report.

ProductTypeL4

String

Attribute

Product Type (4th Level)

Product Type (4th Level) for the ShoppingPerformance report.

ProductTypeL5

String

Attribute

Product Type (5th Level)

Product Type (5th Level) for the ShoppingPerformance report.

StoreId

String

Attribute

Store Id

Store Id for the ShoppingPerformance report.

AdGroupStatus

String

Segment

Ad Group State

Ad Group State for the ShoppingPerformance report.

The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.

AdNetworkType1

String

Segment

Network

Network for the ShoppingPerformance report.

The allowed values are UNKNOWN, SEARCH, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.

AdNetworkType2

String

Segment

Network (with Search Partners)

Network (with Search Partners) for the ShoppingPerformance report.

The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.

CampaignStatus

String

Segment

Campaign State

Campaign State for the ShoppingPerformance report.

The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.

Channel

String

Segment

Channel

Channel for the ShoppingPerformance report.

The allowed values are UNKNOWN, ONLINE, LOCAL.

ChannelExclusivity

String

Segment

Channel Exclusivity

Channel Exclusivity for the ShoppingPerformance report.

The allowed values are UNKNOWN, SINGLE_CHANNEL, MULTI_CHANNEL.

ClickType

String

Segment

Click Type

Click Type for the ShoppingPerformance report.

The allowed values are URL_CLICKS, CALLS, OTHER, PRODUCT_EXTENSION_CLICKS, SITELINKS, PRODUCT_LISTING_AD_CLICKS, GET_DIRECTIONS, OFFER_PRINTS, BREADCRUMBS, CALL_TRACKING, MOBILE_CALL_TRACKING, LOCATION_EXPANSION, STORE_LOCATOR, PRODUCT_LISTING_AD_LOCAL, APP_DEEPLINK, PRODUCT_LISTING_AD_MULTICHANNEL_LOCAL, PRODUCT_LISTING_AD_MULTICHANNEL_ONLINE, PRODUCT_LISTING_ADS_COUPON, PRODUCT_LISTING_AD_TRANSACTABLE, PRODUCT_AD_APP_DEEPLINK, SHOWCASE_AD_CATEGORY_LINK, SHOWCASE_AD_LOCAL_STOREFRONT_LINK, SHOWCASE_AD_ONLINE_PRODUCT_LINK, SHOWCASE_AD_LOCAL_PRODUCT_LINK, PRICE_EXTENSION, VIDEO_WEBSITE_CLICKS, VIDEO_CALL_TO_ACTION_CLICKS, VIDEO_APP_STORE_CLICKS, VIDEO_CARD_ACTION_HEADLINE_CLICKS, VIDEO_END_CAP_CLICKS, CLICK_ON_ENGAGEMENT_AD, LOCATION_FORMAT_MAP, LOCATION_FORMAT_LANDING_PAGE, LOCATION_FORMAT_STORE_INFO, LOCATION_FORMAT_DIRECTIONS, LOCATION_FORMAT_CALL, LOCATION_FORMAT_TEXT, LOCATION_FORMAT_IMAGE, BROADBAND_PLAN, WIRELESS_PLAN, VISUAL_SITELINKS, PROMOTION_EXTENSION, SWIPEABLE_GALLERY_AD_HEADLINE, SWIPEABLE_GALLERY_AD_SWIPES, SWIPEABLE_GALLERY_AD_SEE_MORE, SWIPEABLE_GALLERY_AD_SITELINK_ONE, SWIPEABLE_GALLERY_AD_SITELINK_TWO, SWIPEABLE_GALLERY_AD_SITELINK_THREE, SWIPEABLE_GALLERY_AD_SITELINK_FOUR, SWIPEABLE_GALLERY_AD_SITELINK_FIVE, UNKNOWN.

ConversionCategoryName

String

Segment

Conversion Category

Conversion Category for the ShoppingPerformance report.

ConversionTrackerId

Long

Segment

Conversion Tracker Id

Conversion Tracker Id for the ShoppingPerformance report.

ConversionTypeName

String

Segment

Conversion Name

Conversion Name for the ShoppingPerformance report.

Date

Date

Segment

Day

Day for the ShoppingPerformance report.

DayOfWeek

String

Segment

Day Of Week

Day Of Week for the ShoppingPerformance report.

The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.

Device

String

Segment

Device

Device for the ShoppingPerformance report.

The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET.

ExternalConversionSource

String

Segment

Conversion Source

Conversion Source for the ShoppingPerformance report.

The allowed values are UNKNOWN, WEBPAGE, ANALYTICS, UPLOAD, AD_CALL_METRICS, OFFERS, ENGAGEMENT, WEBSITE_CALL_METRICS, STORE_VISITS, ANDROID_IN_APP, ANDROID_DOWNLOAD, IOS_IN_APP, IOS_FIRST_OPEN, APP_UNSPECIFIED, ANDROID_FIRST_OPEN, UPLOAD_CALLS, FIREBASE, CLICK_TO_CALL, SALESFORCE, STORE_SALES_CRM, STORE_SALES_PAYMENT_NETWORK, GOOGLE_PLAY, THIRD_PARTY_APP_ANALYTICS, GOOGLE_ATTRIBUTION, STORE_SALES_DIRECT.

Month

String

Segment

Month

Month for the ShoppingPerformance report.

ProductCondition

String

Segment

Condition

Condition for the ShoppingPerformance report.

The allowed values are UNKNOWN, NEW, REFURBISHED, USED.

Quarter

String

Segment

Quarter

Quarter for the ShoppingPerformance report.

Week

String

Segment

Week

Week for the ShoppingPerformance report.

Year

Integer

Segment

Year

Year for the ShoppingPerformance report.

AllConversionRate

Double

Metric

All Conv Rate

All Conv Rate for the ShoppingPerformance report.

AllConversions

Double

Metric

All Conv

All Conv for the ShoppingPerformance report.

AllConversionValue

Double

Metric

All Conv Value

All Conv Value for the ShoppingPerformance report.

AverageCpc

Decimal

Metric

Avg CPC

Avg CPC for the ShoppingPerformance report.

Clicks

Long

Metric

Clicks

Clicks for the ShoppingPerformance report.

ConversionRate

Double

Metric

Conv Rate

Conv Rate for the ShoppingPerformance report.

Conversions

Double

Metric

Conversions

Conversions for the ShoppingPerformance report.

ConversionValue

Double

Metric

Total Conv Value

Total Conv Value for the ShoppingPerformance report.

Cost

Decimal

Metric

Cost

Cost for the ShoppingPerformance report.

CostPerAllConversion

Decimal

Metric

Cost Per All Conv

Cost Per All Conv for the ShoppingPerformance report.

CostPerConversion

Decimal

Metric

Cost Per Conv

Cost Per Conv for the ShoppingPerformance report.

CrossDeviceConversions

Double

Metric

Cross-device Conv

Cross-device Conv for the ShoppingPerformance report.

Ctr

Double

Metric

CTR

CTR for the ShoppingPerformance report.