Segment where product value is £0.00

[SamMa10]

We sell multiple additional products for customers to add to their policy and I measure these as a % penetration rate.

Order of optional extra / all Orders

For some of our brands and journeys we include these products for free which makes their penetration 100%, and brings up the rate of our combined metrics.

I do pass value of each product with my purchase tag, so was hoping to create a segment (or condition in custom metric) that excludes products where the value is £0 - is this possible?

[EurosIMS]

Hi @SamMa10, 

Is it all part of one product string? So something like:

;prod1;1;130,;prod2;1;0

Or are they in separate hits/some other setup?

[SamMa10]

All part of one string that fires at checkout

I seperate the main policy and optional extras with a category, then each product is listed within

[EurosIMS]

Hmm, I don't have access to an account I can check this right now, but I think that might make it tricky. You could try a hit-based exclusion segment where Product exists & Revenue is 0 or does not exist, but I think that will exclude the entire hit (so the 'paid for' product as well). I'm not sure if there's another way around that but you could give that a try initially & see what happens! 

[SamMa10]

Presuming this is what you meant, unfortunately I tried that earlier on and it didn't help it, actually didn't exclude anything
 

[EurosIMS]

Could you add an example of how the products are sent in the hit? I think I'm clear but just to be sure. 

For the above segment, yes that's pretty much it. Can you try & alter it so it's "product exists" & "revenue does not exist", & see if that excludes anything? 

[Jennifer_Dungan]

Yeah, the problem with this is if ANY product has revenue, the segment won't work....

Even trying to use calculated metrics to look for Revenue of 0 will only work in a table that is broken down by the product...

@SamMa10 you might want to use a merchandising eVar to flag each product as a that has a revenue value of 0... (something like true/false)

Then in your table, you can pull in only the eVar with a value of True, then do other breakdowns under that... this should restrict the data to only the items that were 0.

[SamMa10]

car;Essentials;1;610.96;event22=610.96;;,
Add-ons;Breakdown;1;73.99;;;,
Add-ons;Motor Legal;1;24.95;;;,
Add-ons;Hire Car;1;19.99;;;

This is a style of the string I'm sending

[Jennifer_Dungan · Accepted solution]

@SamMa10 right, and all of these have revenue associated to them.

But I imagine the way you were talking, you might also have some free optional items, so:

car;Essentials;1;610.96;event22=610.96;,
Add-ons;Breakdown;1;73.99;;,
Add-ons;Motor Legal;1;24.95;;,
Add-ons;Hire Car;1;19.99;;,
optional;something;1;0;;

For the record, you don't actually need to have all the ; at the end of each item (unless that's just the way your code is adding things regardless of values in those positions).

The problem here is that revenue isn't a dimension, it's not filterable.

What I was saying would be to add an "is free" merchandising eVar using true/false.

So:

car;Essentials;1;610.96;event22=610.96;eVarX=false,
Add-ons;Breakdown;1;73.99;;eVarX=false,
Add-ons;Motor Legal;1;24.95;;eVarX=false,
Add-ons;Hire Car;1;19.99;;;eVarX=false,
optional;something;1;0;;eVarX=true

Then you can filter based on eVarX being true... or rather, you can't use segments at this time to only get some of the products back, but you can do dimension breakdowns..

So in your table, you can pull in eVarX "true" as the top item, then break it down by products to only see the "free" ones:

				Metric
Is Free (eVarX)				10
	true			10
		Products		10
			Free Product 1	5
			Free Product 2	3
			Free Product 3	2

[SamMa10]

You've understood it perfectly, sometimes the products will send and the revenue will be £0.00

Probably the best I'm going to get, but at least I can filter on those free products using that eVar, I'll do that.

Thanks

[Jennifer_Dungan]

Other than that, until they add some sort of proper metrics filter (in theory this idea might be able to be used to find "0" revenue items: https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-ideas/add-the-ability-to-filter-fre... if Adobe actually picks it up)

However, the current options would be to try and process it outside of Adobe... possibly using Data Warehouse exports, or Raw Data...