Get ready! An upgraded Experience League Community experience is coming in January.
A custom metrics question
I would like to create a full price revenue % metrics. Currently, our implementation capture product full price or discounted as an eVar in the s.products. When I apply definition below at hit level, it is capturing entire order revenue not just the full price product revenue. It makes sense as s.product captures the entire basket of products (full price or not) in the order confirmation hit.
So is there way to create the metrics? Is there additional steps/implementation that can enable the metrics?
Thank you!
Hi,
I want to first be sure I understand all your details and what you are trying to achieve.
So first, in your tracking (s.products), you have your standard revenue, and a merchandising eVar that specifies on each product if it was "discounted" or "full price", right? Something like:
s.products = "category 1;product 1;1;9.99;;eVar1=true,category 2;product 2;1;5.97;;eVar1=false";(2 products, one at full and one at a discounted price)
Next, what is the actual math of your "full price revenue %"?
- Are you looking at "full priced item revenue / all revenue"?
- Are you looking at "purchases that had any full priced item revenue / all revenue"?
- Are you looking at "only purchases that had no marked down items revenue / all revenue"?
Now, I do have some mixed news for you....
Currently, segments don't work well on s.products... the nature of "multiple items in a single field" are a bit of a problem... whether you look for "equals" or "contains" on the category, product or any of the merchandising emails, ANY matching product will result in the entire s.products being returned. So, if any product is not marked down (as per your screenshot), all products (marked down and not marked down) will all be returned by that segment.
So, if you are looking at purchases as a whole (as in purchases with any full priced item, or only full priced items), then you should be able to get that, but by using exclusion logic, rather than inclusion... but I suspect you are trying to look at the item level....
There is a new "sub-item" logic coming to Adobe Analytics (I am not sure when) that will allow us to target sub items in our segments (individual products, individual items in list dimensions, etc)... I don't know when it will be released.
In the meantime, if you do need to get this down to item level, you can't do it with segments.... what you can do, it pull in the dimension values as columns to get proper values this way...
In this example, my pulled up all Revenue, and then I have a revenue column that I stacked individual values from the merchandising eVar. Then I divided the "eVar1 false" revenue by the total revenue:
While "segments" don't work, stacking your dimension values directly does work.
You don't even need to have it split by day, you can use the provided "All Visits" segment to just get the total for your reporting period, if that works better.
Or you can break it down by product or category to see for each product, what percentage was bought at full price or at a discount.
I hope this helps.
Hi Jen,
This is great info! Confirming your assumption on the merchandising eVar is exactly what it is. Also, I am looking for full price item revenue of total revenue (scenario 1), but it is good to know with exclusion, I can achieve scenario 2 and 3.
Can you explain more how you create % column, dividing the "eVar1 false" revenue by the total revenue? Is it through calculated metrics? How do I update the calculation below to achieve the results? Right now, the formula is still capturing all products in the basket at the order confirmation hit.
Hi,
mine looks exactly like yours... maybe it's in how it's created?
I selected the two columns I wanted to divide, right clicked and selected "create metric from selection" > "divide"
Then, Adobe had the division in the wrong order (but I also wanted to ensure it was displayed as percent and with 2 decimal places)... so once it was created, I just made the tweaks....
It's possible that I just don't have the right data to replicate this in my suite....
The problem is that our purchases are subscriptions, so you can only buy one at a time... I can't really properly represent a multi-product purchase in my current data....
I checked this again with some different multi-item data...While the columns are correct; once it goes into the calculation, it falls victim to the same "segment issue" as other multi-item segments....
I don't think that you will be able to achieve this until the sub-item release, unfortunately...
You might have to take this outside of Adobe for the time being to achieve this... sorry... I was thinking this would work, but forgot that my revenue products don't overlap.. that was what was saving my example.
I'm sorry
