Product pricing in Adobe workspace

[David_Jerome]

Hi All,

I am trying to work out if it is possible to build a segment in work space to return the where a product Y was sold for more than EUR 0. Every single order on our site contains two or more products, the first (Product X - which should be noted is in a different category) is always chargeable, the second (Product Y) is chargeable around 50% of the time.

Annoyingly if I build a hit level segment that contains Product Y exists and Revenue > 0, all orders are returned because on that same hit Product X has revenue.

Thanks

Dave

[fsakjlfdsakljfd]

Do you need the segmentation to analyze the users or just to get the counts? If its the former you are in a tough spot because sub-hits are not yet available in segments.

If its the latter and you have something like purchaseID in an eVar you can do a row count for rows where the revenue was higher than a certain threshold - since you can do subhit filtering with a product name at a table level.

[David_Jerome · Accepted solution]

At the moment we can analyze the users in our data lake using the feeds if needed, so A count will do. We assign an evar for the purchaseID an evar so i will give that a try. Thanks

[jeff_bloomer]

If you haven't already voted on this idea, please do: https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-ideas/new-sub-hit-segment-container...