So when you say "2:6:9" this represents 3 ages? "2", "6" and "9" right?
Is this a list variable, or a standard prop/eVar which holds all the values in one big string?
If this is the case (one string with multiple values) I think this might be a big part of the problem.
Also, when you track your "order" I assume it's one order for all the people in the flight? So this could be causing some unnatural totals...
Let's assume your segments were working perfectly, and you had three different age groups, you would expect to see:
| |
Orders |
| |
1 |
| 0-5 |
1 |
| 6-9 |
1 |
| 10--14 |
1 |
However, HUGE caveat here... when your breakdown is using segments the de-duplication doesn't apply, so you will actually see:
| |
Orders |
| |
3 |
| 0-5 |
1 |
| 6-9 |
1 |
| 10--14 |
1 |
This is likely why you orders seem inflated....
0-5 would be associated to an order, 6-9 would be associated to an order, and 10-14 would be associated to an order.... but they are the same order, and should be de-duplicated, but aren't... also, a similar issue... if you have two ages in the same order, they would only count once.... at each row...
I am not sure if you are on AA or CJA, but in AA, I have solved for such things by using my s.products to be used for multiple uses (because of the ability to have merchandising events and eVars).
I would be tempted to do one of two things... if my age groups won't change, to just track the age groups without trying to create a segment:
(so for one 4, one 7, and two 13)
s.products = "age-group;0-5;;;event1=1;eVar1=4,age-group;6-9;;;event1=1;eVar1=7,age-group;10-14;;;event1=2;eVar1=13"
(so for one 4, one 7, one
s.products = "age-group;0-5;;;event1=1;eVar1=4,age-group;6-9;;;event1=1;eVar1=7,age-group;6-9;;;event1=1;eVar1=8"
event1 counts the people in each age group, and I added eVar1 to hold the specific age (if I need to get the actuals).... so in the case of two different ages in the same group, I split it into two designations so that I could pass "7" and "8" as separate items... but for the two "13" I passed in the same, and incremented my event1 by 2.
This should create separate rows on which to pull reports... now, segments are difficult, because the problem is that if there are multiple values passed on the same row, they will all be returned by a segment...
But if you just use a standard breakdown by the product identify (which is your group), you can get a count of the people in the group, and still associate it to the orders, but with de-duplication
