Leverage your customer data to customize discount coupons and maximize the lift in your pricing experiments.

What if we could find how much customers are willing to pay for a product? And, what if we could personalize the price for each customer. This is what we are going to do in this use-case. We are going to nudge customers to convert by personalizing the price for each customer.
Stripe is a payment processor that allows you to create subscriptions. It also allows you to create coupons. What purpose does a discount coupon serve? It is equivalent to a Nudge, that Richard Thaler, a Nobel prize winning behavioral economist, has summarised it to be a gentle push in the right direction. It maximizes the utility for the customer and the revenue for the business.
In this use-case, we assume that we ran some data analysis on the warehouse and know that some customers are willing to utilise a 20% discount coupon, while others are willing to utilise a 10% discount coupon. These coupons are also created on stripe interface (picture included). We are going to use this information to personalize the price for each customer. We activate this coupon for customers through valmi.io reverse-ETL and we are going to do this in three steps.

First, we have two different discount coupons represented by their ids and they are assigned randomly to users in the database. The sample data is shown below. Then, we configure a postgresql database connection on valmi.io.
ID |
FIRST NAME |
LAST NAME |
|
DISCOUNT COUPON |
1 |
Robert |
Berg |
john11@example.com |
uLpRAxM4 |
2 |
Joseph |
Green |
yvonne22@example.org |
9F18dXvl |
3 |
Brian |
Hernandez |
riverakelsey@example.net |
uLpRAxM4 |
4 |
Lisa |
Lynch |
antonio79@example.net |
uLpRAxM4 |
5 |
Leah |
Silva |
johnsonmelissa@example.org |
9F18dXvl |
6 |
Angela |
Welch |
langallison@example.net |
uLpRAxM4 |
7 |
Eddie |
Smith |
johncain@example.com |
9F18dXvl |
8 |
Ryan |
Patel |
laurielevy@example.net |
uLpRAxM4 |
9 |
Joanna |
Lopez |
ndavis@example.com |
9F18dXvl |
10 |
Elizabeth |
Lewis |
tuckercourtney@example.org |
9F18dXvl |
Second, we add a Stripe connection with an API key. You can follow docs to understand how to get this API key.
Finally, we are ready to connect the warehouse and Stripe and create a Sync between the two. Here, one important aspect of mapping supported by valmi.io for Stripe is that the mapped fields can include jsonpath. In this usecase, we will also show you how to make a field within metadata
for a stripe object. For more information on jsonpath mapping for Stripe, please checkout docs. The video demonstrates the sync.
The following sync result and the stripe image confirm that the user Joseph
has received the 10% coupon and his country in metadata is set to Panama
.


This use-case demonstrates an easy-to-use experimentation layer with valmi.io that can customize your pricing pages to promote discount coupons and tilt user decision in your favour. This can lift your sales and maximize revenue by personalization.
valmi.io Open Source reverse ETL can activate data in many other use-cases. Please enable your organisation with reverse-ETL by simply deploying it from github. You can look at a sync live here. Alternatively, you can schedule a sync at cloud.valmi.io. Please contact us if you are looking for any information by joining our community on Slack. We are adding new features to make the platform more robust.