Expand my Community achievements bar.

SOLVED

Redemption Tracking

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Level 2

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 2

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

Avatar

Community Advisor

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.

KeyMyText~MyCost~MyCost^~id~~MyCost^~value~
Product1Text1Cost1_jan_var1.2
Product1Text1Cost2_jan_fixed 500
Product1Text1Cost1_feb_var2.15
Product1Text1Cost2_feb_fixed 600

~MyCost^~period~~MyCost^~rate~~MyCost^~hinge~
2010/01/01 - 2010/01/31revenuerevenue
2010/01/01 - 2010/01/31fixednone
2010/02/01 - 2010/01/31revenuerevenue
2010/02/01 - 2010/01/31fixednone

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

ProductsRevenueMyCost
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.