ProductPartition

The Product Partition report provides shopping campaign statistics aggregated at the product partition (Id 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 ProductPartition report.
AdGroupId	Long	Attribute	Ad Group ID	Ad Group ID for the ProductPartition report.
AdGroupName	String	Attribute	Ad Group	Ad Group for the ProductPartition report.
AdGroupStatus	String	Attribute	Ad Group State	Ad Group State for the ProductPartition report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
BiddingStrategyType	String	Attribute	Bid Strategy Type	Bid Strategy Type for the ProductPartition report. The allowed values are MANUAL_CPC, MANUAL_CPV, MANUAL_CPM, PAGE_ONE_PROMOTED, TARGET_SPEND, TARGET_CPA, TARGET_ROAS, MAXIMIZE_CONVERSIONS, MAXIMIZE_CONVERSION_VALUE, TARGET_OUTRANK_SHARE, NONE, UNKNOWN.
CampaignId	Long	Attribute	Campaign ID	Campaign ID for the ProductPartition report.
CampaignName	String	Attribute	Campaign	Campaign for the ProductPartition report.
CampaignStatus	String	Attribute	Campaign State	Campaign State for the ProductPartition report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CpcBid	Decimal	Attribute	Max CPC	Max CPC for the ProductPartition report.
CriteriaDestinationUrl	String	Attribute	Keyword Per Placement Destination URL	Keyword Per Placement Destination URL for the ProductPartition report.
ExternalCustomerId	Long	Attribute	Customer ID	Customer ID for the ProductPartition report.
FinalUrlSuffix	String	Attribute	Final URL Suffix	Final URL Suffix for the ProductPartition report.
Id	Long	Attribute	Criterion ID	Criterion ID for the ProductPartition report.
IsNegative	String	Attribute	Is Negative	Is Negative for the ProductPartition report. The allowed values are TRUE, FALSE.
ParentCriterionId	Long	Attribute	Parent Criterion ID	Parent Criterion ID for the ProductPartition report.
ProductGroup	String	Attribute	Product Group	Product Group for the ProductPartition report.
TrackingUrlTemplate	String	Attribute	Tracking Template	Tracking Template for the ProductPartition report.
UrlCustomParameters	String	Attribute	Custom Parameter	Custom Parameter for the ProductPartition report.
AdNetworkType1	String	Segment	Network	Network for the ProductPartition 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 ProductPartition report. The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.
ClickType	String	Segment	Click Type	Click Type for the ProductPartition 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 ProductPartition report.
ConversionTrackerId	Long	Segment	Conversion Tracker Id	Conversion Tracker Id for the ProductPartition report.
ConversionTypeName	String	Segment	Conversion Name	Conversion Name for the ProductPartition report.
Date	Date	Segment	Day	Day for the ProductPartition report.
DayOfWeek	String	Segment	Day Of Week	Day Of Week for the ProductPartition report. The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.
Device	String	Segment	Device	Device for the ProductPartition report. The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET.
ExternalConversionSource	String	Segment	Conversion Source	Conversion Source for the ProductPartition 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 ProductPartition report.
MonthOfYear	String	Segment	Month Of Year	Month Of Year for the ProductPartition report. The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.
PartitionType	String	Segment	Partition Type	Partition Type for the ProductPartition report. The allowed values are UNKNOWN, SUBDIVISION, UNIT.
Quarter	String	Segment	Quarter	Quarter for the ProductPartition report.
Week	String	Segment	Week	Week for the ProductPartition report.
Year	Integer	Segment	Year	Year for the ProductPartition report.
AllConversionRate	Double	Metric	All Conv Rate	All Conv Rate for the ProductPartition report.
AllConversions	Double	Metric	All Conv	All Conv for the ProductPartition report.
AllConversionValue	Double	Metric	All Conv Value	All Conv Value for the ProductPartition report.
AverageCpc	Decimal	Metric	Avg CPC	Avg CPC for the ProductPartition report.
AverageCpm	Decimal	Metric	Avg CPM	Avg CPM for the ProductPartition report.
BenchmarkAverageMaxCpc	Decimal	Metric	Benchmark Max CPC	Benchmark Max CPC for the ProductPartition report.
BenchmarkCtr	Double	Metric	Benchmark CTR	Benchmark CTR for the ProductPartition report.
Clicks	Long	Metric	Clicks	Clicks for the ProductPartition report.
ConversionRate	Double	Metric	Conv Rate	Conv Rate for the ProductPartition report.
Conversions	Double	Metric	Conversions	Conversions for the ProductPartition report.
ConversionValue	Double	Metric	Total Conv Value	Total Conv Value for the ProductPartition report.
Cost	Decimal	Metric	Cost	Cost for the ProductPartition report.
CostPerAllConversion	Decimal	Metric	Cost Per All Conv	Cost Per All Conv for the ProductPartition report.
CostPerConversion	Decimal	Metric	Cost Per Conv	Cost Per Conv for the ProductPartition report.
CrossDeviceConversions	Double	Metric	Cross-device Conv	Cross-device Conv for the ProductPartition report.
Ctr	Double	Metric	CTR	CTR for the ProductPartition report.
Impressions	Long	Metric	Impressions	Impressions for the ProductPartition report.
SearchAbsoluteTopImpressionShare	Double	Metric	Search Abs Top IS	Search Abs Top IS for the ProductPartition report.
SearchClickShare	Double	Metric	Click Share	Click Share for the ProductPartition report.
SearchImpressionShare	Double	Metric	Search Impr Share	Search Impr Share for the ProductPartition report.
ValuePerAllConversion	Double	Metric	Value Per All Conv	Value Per All Conv for the ProductPartition report.
ValuePerConversion	Double	Metric	Value Per Conv	Value Per Conv for the ProductPartition report.
ViewThroughConversions	Long	Metric	View-through Conv	View-through Conv for the ProductPartition report.

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
StartDate	String	Start date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.
EndDate	String	End date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.