Redemption Tracking

[jeffsabre]

Anyone have some suggestions of how best to track products and purchases through a points redemption type flow? The products can be priced in dollars, points or a combination of points and dollars. A point is not 1:1 with 1 dollar and isn't really considered revenue.

Is the best solution to simply set up a numerical event to track the points component and set the product revenue to 0 or the balance amount if a combination? I'm assuming the product category and product should not be changed regardless of how its being purchased?

Any other ideas or suggestions would be appreciated

Jeff

[kater83492823 · Accepted solution]

Hi Jeff,

Have you considered capturing the following as separate Events:

• Revenue (straight revenue without points, where total value is all points, this would be 0)
• Points
• Revenue + Points (with Points being converted to equivalent cash amount)

This would allow you to measure them individually, but also see e.g. what percentage of potential revenue is being spent on points.

Thanks,

Kate

[Alexis_Cazes_]

you can send use s.products to send multiple events as per doc

Product-Specific Currency Events

If a currency event receives a value in the products variable instead of the events variable, it applies only to that value. This is useful to track product-specific discounts, product shipping, and similar values. For example, if you configured event 1 to track product shipping, a product with a "4.50" shipping charge might appear similar to the following:

1. s.events="event1"
2. s.products="Footwear;Running Shoes;1;99.99;event1=4.50"

https://marketing.adobe.com/resources/help/en_US/sc/implement/products.html#wh-view-code

class="p" style="color:rgb(75, 75, 75);font-family:AdobeClean;font-size:16px;background-color:rgb(245, 245, 245)"

• s.products="Footwear;Running Shoes;1;69.95;event1=7.59"

https://marketing.adobe.com/resources/help/en_US/sc/implement/products.html#wh-view-code

Example 2: Multiple Numeric/Currency Events

1. s.events="purchase,event1,event2"
2. s.products="Footwear;Running Shoes;1;69.95;event1=7.59|event2=19.45"

so send both the total revenue and the points (points as an event).

You can then use numeric 2 classification to create a new revenue metric based on the revenue and the points. Numeric 2 classification allows you create new metrics, like revenue and lets say that for jan 2017 revenue = revenue * (0.1 + points).

Advance example

Numeric 2 classifications provide multiple rows per time period to reflect multiple costs. Every item can have as many rows of costs for any arbitrary time periods that the report calls for.

In this example, you add a $500 shipping charge to Product1 for January, and a $600 shipping charge to February.

Key	MyText	~MyCost	~MyCost^~id~	~MyCost^~value~
Product1	Text1	Cost1_jan_var	1	.2
Product1	Text1	Cost2_jan_fixed		500
Product1	Text1	Cost1_feb_var	2	.15
Product1	Text1	Cost2_feb_fixed		600

~MyCost^~period~	~MyCost^~rate~	~MyCost^~hinge~
2010/01/01 - 2010/01/31	revenue	revenue
2010/01/01 - 2010/01/31	fixed	none
2010/02/01 - 2010/01/31	revenue	revenue
2010/02/01 - 2010/01/31	fixed	none

The rows that were previously imported have an ID, which indicates that they are not new costs.

Result

An example of output from the report is shown here:

Period: Jan 2010

Report: Products

Products	Revenue	MyCost
Product1	$10,000.23	$2500.05

You can also use calculated metrics to get what you want as well, but it won't allow you to do it per period.