Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!
SOLVED

Product pricing in Adobe workspace

Avatar

Level 8

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

1 Accepted Solution

Avatar

Correct answer by
Level 8
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

View solution in original post

3 Replies

Avatar

Level 5

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.

Avatar

Correct answer by
Level 8
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