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

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

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.

stripe coupons

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

EMAIL

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

0:00
/
postgresql connection on valmi.io

Second, we add a Stripe connection with an API key. You can follow docs to understand how to get this API key.

0:00
/
stripe destination on valmi.io

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.

0:00
/
Discount Coupon Sync between postgresql and Stripe

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.

Rajashekar Varkala

Rajashekar Varkala

Co-Founder @valmi.io. Formerly, Director of Engineering & Product Management @RudderStack. Co-Founder @Regaltusk. Never gives up on the Tennis court.