Main shopping interface vs. product group editor vs. AWQL confusion

[Roy Steves]

Forgive the linked, rather than embedded, screenshots, but my first attempt to post this failed.  And while this isn't solely an API-level question, the moment I mention awql or the like, I'm always redirected here, as I'm sure you can understand.

Here's the root concern: https://www.evernote.com/l/ALmYwMP-sA9Hg7GLo2l8g5ciVOFaoGa6PZs

Generally, when I see a difference in the Product Group editor versus the main interface, I assumed it was due to changes in the membership of that product group, and that the PG editor was adding up the individual products currently in the group, whereas the main interface (and frankly, most of the Adwords platform) follows the performance of the product group itself, regardless of added or removed products from its membership.

But in this case, this is a product group of a single product, so that can't be the case!

My next hypothesis was that the PG editor was sitting on top of data from SHOPPING_PERFORMANCE_REPORT (or similar), and that it was including account-wide data for that product, which the main interface wouldn't.  

So, I checked AWQL:  https://www.evernote.com/l/ALk5TuHN6a5KApZs3TprvwkG5NMu0-uW8B0

And, as you can see, that hypothesis was disproven.

So, what is the right click count for this product, and how am I mis-reading the data I'm looking at?

Thanks for any help you can provide!

[Shwetha Vastrad (AdWords API Team)]

Hi Roy, 

Could you provide the clientCustomerId along with the date on which you generated the report so I can take a look? Please note that the Product Partition Report will reflect the current set of product partitions. Please use Reply privately to author when responding. 

Thanks,

Shwetha, AdWords API Team.