Hi Igor, Amol, I took a fresh look at this today, and I think I finally understand the issues here. To rephrase Igor's explanation, it seems that the issues are:
1. The *Product Partition Report* does not contain sufficient information to reconstruct the ProductPartition tree (*without* product detail). Possible solution: Use AdGroupCriterionService.get<https://developers.google.com/adwords/api/docs/reference/v201402/AdGroupCriterionService#get> instead as described in my last post. 2. It's difficult to tie the data in *Shopping Performance Report* back to specific products. Possible solution: Include the *MerchantId, StoreId* and *OfferId* columns in your report request. This will allow you to tie the report data back to the product-specific information you get via the Content API. 3. How can we determine the product partition for a specific product? Possible solution: Similar to item #2, you could run a *Shopping Performance Report* that includes: - The key fields for the different types of caseValue<https://developers.google.com/adwords/api/docs/reference/v201402/AdGroupCriterionService.ProductPartition#caseValue>, e.g., Brand (for ProductBrand), CategoryL1/CategoryL2/CategoryL3/CategoryL4/CategoryL5 for ProductBiddingCategory, ProductCondition for ProductCanonicalCondition, ProductTypeL1/ProductTypeL2/ProductTypeL3/ProductTypeL4/ProductTypeL5 for ProductType, etc. - *MerchantId, StoreId* and *OfferId* fields Here's an example using AWQL (to optimize report performance you should only bring in the fields you actually need): SELECT CampaignId, AdGroupId, Brand, CategoryL1, CategoryL2, CategoryL3, CategoryL4, CategoryL5, ProductCondition, ProductTypeL1, ProductTypeL2, ProductTypeL3, ProductTypeL4, ProductTypeL5, CustomAttribute0, CustomAttribute1, CustomAttribute2, CustomAttribute3, CustomAttribute4, StoreId, OfferId, Cost, Impressions FROM SHOPPING_PERFORMANCE_REPORT WHERE CampaignId = *xxx* AND AdGroupId = *yyy* DURING THIS_MONTH The combination of all of the various case values + the *StoreId* and *OfferId* fields would give you the partition for each product. Do the above suggestions help? Thanks, Josh, AdWords API Team On Wednesday, April 30, 2014 3:41:34 PM UTC-4, Josh Radcliff (AdWords API Team) wrote: > > Hi Amol, > > Regarding retrieving details about the ProductPartitions, you could do > this via > AdGroupCriterionService.get<https://developers.google.com/adwords/api/docs/reference/v201402/AdGroupCriterionService#get> > with > a selector similar to this: > > <serviceSelector> > <fields>*PartitionType*</fields> > <fields>Id</fields> > <fields>*ParentCriterionId*</fields> > <fields>*CaseValue*</fields> > <predicates> > <field>CriteriaType</field> > <operator>EQUALS</operator> > <values>PRODUCT_PARTITION</values> > </predicates> > <predicates> > <field>AdGroupId</field> > <operator>EQUALS</operator> > <values>*******</values> > </predicates> > </serviceSelector> > > The *CaseValue* and *PartitionType* should give you the details of > interest (let me know if that's not the case). The displayTree > method<https://github.com/googleads/googleads-java-lib/blob/master/examples/adwords_axis/src/main/java/adwords/axis/v201402/shoppingcampaigns/AddProductPartitionTree.java#L157> > in > our AddProductPartitionTree example shows one approach for doing this. You > could tie this information to the report information via the criteria ID. > > I'll pass on your request for including parent criterion ID in the report > -- I can see how that would be helpful. Would it also be helpful if the > report let you select CaseValue and PartitionType? > > Thanks, > Josh, AdWords API Team > > On Thursday, April 24, 2014 2:32:35 AM UTC-4, Amol Sharma wrote: >> >> Also, checked constructors of Product Partition. Even if i have Id, i >> cannot retrieve anything about the product partition. >> >> these are two constructors available in the java client library. >> >> public ProductPartition() { >> } >> >> public ProductPartition( >> java.lang.Long id, >> com.google.api.ads.adwords.axis.v201402.cm.CriterionType type, >> java.lang.String criterionType, >> >> com.google.api.ads.adwords.axis.v201402.cm.ProductPartitionType >> partitionType, >> java.lang.Long parentCriterionId, >> com.google.api.ads.adwords.axis.v201402.cm.ProductDimension >> caseValue) { >> super( >> id, >> type, >> criterionType); >> this.partitionType = partitionType; >> this.parentCriterionId = parentCriterionId; >> this.caseValue = caseValue; >> } >> >> >> -- >> Thanks and Regards, >> Amol Sharma >> >> >> >> On Thu, Apr 24, 2014 at 12:39 AM, Amol Sharma <> wrote: >> >>> +1 to Igor. this is a genuine issue according to me. >>> >>> In PRODUCT_PARTITION_REPORT, we don't know how the what is the >>> productPartitionType and what is the ProductDimension. >>> >>> Moreover, we it will also be good to have, parent product partition ID, >>> so that we can understand the actual hierarchy of the product partition. >>> >>> >>> >>> -- >>> Thanks and Regards, >>> Amol Sharma >>> >>> >>> >>> On Wed, Apr 23, 2014 at 2:53 PM, Igor Schut <> wrote: >>> >>>> Hi Josh, >>>> >>>> Let me clarify my problem for you. >>>> >>>> We pull in two reports, one for the shopping products and one for the >>>> product partitions. We wish to show and use both. >>>> >>>> We do understand that product partitions are categorization of one or >>>> more products, but how am I suppose to determine the actual product >>>> partition as shown in the AdWords UI based on the products itself? It does >>>> not say in what product partition its in or what type of product partition. >>>> >>>> Thanks, >>>> Igor >>>> >>>> -- >>>> -- >>>> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ >>>> Also find us on our blog and Google+: >>>> https://googleadsdeveloper.blogspot.com/ >>>> https://plus.google.com/+GoogleAdsDevelopers/posts >>>> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ >>>> >>>> You received this message because you are subscribed to the Google >>>> Groups "AdWords API Forum" group. >>>> To post to this group, send email to adwords-api@googlegroups.com >>>> To unsubscribe from this group, send email to >>>> adwords-api+unsubscr...@googlegroups.com >>>> For more options, visit this group at >>>> http://groups.google.com/group/adwords-api?hl=en >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "AdWords API Forum" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to adwords-api+unsubscr...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
