I'm looking at an Internal Search Report created in workspace and I wanted to confirm that I'm interpreting it correctly. The attached image shows Onsite Search Terms, broken down by Product ID - the metric brought in is Onsite Search Term Instances.
Am I to believe that when Onsite Search Term Instances metric is broken down by Product ID, that those numbers correspond to the amount of times that Product ID showed up as a result for that Onsite Search Term?
Example: User searches "OPC" 326 times. Of those 326 times, Product ID "5658506" was a result 113 times?
So if the implementation is setting the product ID eVar every time the product is shown up (and not necessarily only when the product is clicked) as well as the Search Term eVar is also set every time a keyword was searched, the above report will also interpret in the same manner as you are expecting. It will be equivalent to the product being shown up those many times (as the number of Instances) when the search keyword was OPC.
I'd interpret the report in the following manner: There were 113 instances when the Product ID was "5658506" while the Onsite Search Term was "OPC". By "Instances", it means that the Product ID "5658506" was set 113 times when the Onsite Search Term was set as "OPC".
So if you were ultimately looking for a breakdown of products that showed up as a result of an internal search (assuming we're just dealing with an e-commerce site here), what would your advice be to create a more accurate report?
In other words, if I was looking to create the report I thought I was interpreting above, how would you suggest I go about doing so?