Hi, The *PRODUCT_PARTITION_REPORT* that Umesh mentioned will give you stats based on the ProductPartition <https://developers.google.com/adwords/api/docs/reference/v201506/AdGroupCriterionService.ProductPartition>s you have set up in your ad group. Therefore, if you have your partitions set up using categories (ProductBiddingCategory <https://developers.google.com/adwords/api/docs/reference/v201506/AdGroupCriterionService.ProductBiddingCategory>), then you could use that report and only process rows where ProductGroup <https://developers.google.com/adwords/api/docs/appendix/reports/product-partition-report#productgroup> is for a category. Be careful, though -- that report shows stats at *every* level of your partition tree, so make sure you don't double count stats (see the report description <https://developers.google.com/adwords/api/docs/appendix/reports/product-partition-report#top_of_page> for more information).
In contrast, the *SHOPPING_PERFORMANCE_REPORT* gives you product (*OfferId*) level stats, but as Umesh mentioned, that report does not contain benchmark fields. At this time, that report does not have a *CriterionId*, which is what you would need to tie it back to the *PRODUCT_PARTITION_REPORT*. Therefore, you won't be able to tie the data from the two reports together. Best regards, Josh, AdWords API Team On Wednesday, July 22, 2015 at 1:16:16 AM UTC-4, Bala Murugan wrote: > > Thanks. How can i relate these two reports?. I could not find any common > fields to link these two reports to get combined report. > > And PRODUCT_PARTITION_REPORT > <https://developers.google.com/adwords/api/docs/appendix/reports/product-partition-report> > gives > report for categories of products, so we can not calculate correct > Benchmark CPC/CTR values for campaign or category level. > what should do for this? > > On Wednesday, July 22, 2015 at 3:34:39 AM UTC+5:30, Umesh Dengale wrote: >> >> Hello, >> >> The PRODUCT_PARTITION_REPORT >> <https://developers.google.com/adwords/api/docs/appendix/reports/product-partition-report> >> gives shopping >> campaign statistics aggregated at the product partition level. This >> report has the BenchmarkAverageMaxCpc >> <https://developers.google.com/adwords/api/docs/appendix/reports/product-partition-report#benchmarkaveragemaxcpc> >> , BenchmarkCtr >> <https://developers.google.com/adwords/api/docs/appendix/reports/product-partition-report#benchmarkctr> >> , AverageCpc >> <https://developers.google.com/adwords/api/docs/appendix/reports/product-partition-report#averagecpc> >> , Ctr >> <https://developers.google.com/adwords/api/docs/appendix/reports/product-partition-report#ctr> >> fields >> but does not have category information. The SHOPPING_PERFORMANCE_REPORT >> <https://developers.google.com/adwords/api/docs/appendix/reports/shopping-performance-report> >> gives >> the AverageCpc >> <https://developers.google.com/adwords/api/docs/appendix/reports/shopping-performance-report#averagecpc> >> , Ctr >> <https://developers.google.com/adwords/api/docs/appendix/reports/shopping-performance-report#ctr> >> and CategoryL1 >> <https://developers.google.com/adwords/api/docs/appendix/reports/shopping-performance-report#categoryl1> >> -L5 >> but does not have BenchmarkAverageMaxCpc, BenchmarkCtr fields. >> >> Thanks, >> Umesh, AdWords API Team. >> > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. Visit this group at http://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/e4a683a5-23cc-4b0f-88ce-c1df5a308b1d%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
