I'm interested in a method to identify the price of an individual item within an order total and then return the number of orders where the item in order was $x.
We have items generally for sale on the site, but depending on a promo code applied, discount, etc. that individual item could be $19.99 in the cart or sell for $24.99 for example. Even though the order total could include accessories, warranty, and assembly I'd like to know if the SPECIFIC ITEM in the order sold for $19.99 or not.
Custom segment, metric using a canned formula, other ideas?
You could use merchandising eVars in your product notation to store things like promo code applied, discount, actual purchase price, etc. Setting these eVars up to stored as text, you would be able to break down the individual values per product separate from the revenue collected as a whole.