Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Product Syntax Conversion Variable Segmentation

Avatar

Level 1

5/15/17

Feature request for a product syntax segment. Basically when you fire multiple products in a single hit and those products have product syntax variables, you can't use them in segments. Any hit level segment captures the entire hit, not just the specific product syntax value you're looking for.

 

For example, if you have one order with three products (two new, one used) and each new item is $11 and the used is $6, let's assume you're setting the condition as a product syntax variable. For the first two the value is "new" and the third is "used". If you build a hit level segment where this variable equals "used", you'll see $28 instead of $6 since all three products were set in the same hit.

3 Comments

Avatar

Level 1

5/15/17

What really kills me about this is that the functionality already exists.  Open Ad Hoc and break down the aforementioned variable, you'll see every value it's been set to.  Pull one of those into your report then throw Revenue under it and it'll display just fine.  You just can't get to those values in Segmentation (and, subsequently, claculated metrics).