Product pricing in Adobe workspace

Question

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

David_Jerome · Accepted Answer

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

fsakjlfdsakljfd · Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded