Basically we use a merchandising eVar to capture product type on some product interactions.
Now since we have our reports in workspace built based on calculated metrics with segments, we want to create a segment that isolated revenue only for product type B.
Issue is if a customer purchase in the same order 2 products A and B, if we apply this logic on a hit level container, we will always get the segment to retrieve revenue for both products, not only for product B.
I guess we are talking about some sort of product scope in segments...i've seen some post regarding this topic but none with a solution.
It might not be possible to retrieve revenue associated to a particular Product when multiple products are passed in the same product syntax, reason being revenue passed during the purchase of multiple products is the “Total Revenue” for each product generated during the checkout process. It would not be possible to segment out revenue associated individually at the product level.
However the only way to analyze the revenue associated to a Product is by running Products report with Revenue metrics applied.