Setting Up a Dynamic Coupon Program to Reward Loyal Customers

One component of building a successful and engaging e-commerce brand is rewarding your most loyal customers. With Segment Warehouses and SQL, you can retrieve a table of your most valuable customers, then reward them.

This guide will walk you through setting up a dynamic and automated coupon program based on conditions that define your most valuable customers, as well as how to measure the program’s performance.

Talk to a product specialist today about using data to tailor your brand experience.

Tools used

  • Emails with Customer.io: Customer.io is a flexible email provider that allows you to create cohorts based on customer actions. You can build complex onboarding emails, nurture email campaigns, as well as marketing automation workflows.

  • Retention Analytics with Amplitude: Amplitude is an analytics tool that focuses on understanding retention and funnel analysis.

It’s important to register for these tools and enable them on your Segment source project. When Segment collects tracking data, it routes it to all of your enabled tools, meaning that they get a single consistent data set. Most importantly, the data generated by users interacting with emails is sent through Segment so you can analyze email performance, and how it impacts conversion with Amplitude.

Not using Customer.io or Amplitude? Check out the other Segment Supported Email Marketing and Analytics tools.

The Loyalty Program

Say, as the marketing manager of our fictitious, on-demand artisanal toast company, Toastmates, you want to experiment with a coupon program to retain your best customers.

Through a combination of SQL and statistical analysis on a set of historical data, you’ve identified the conditions for our most valuable customers as:

  • shops over twice a month
  • pays over $20 per order

Learn how to define these conditions in How to Forecast LTV for e-commerce with Excel and SQL.

Will rewarding a $5 coupon to this cohort after they make the second purchase a month lead to higher engagement and LTV? Set up this program using Customer.io as the email provider and measure it’s performance on engagement and LTV with Amplitude.

Conduct a split test (half of the cohort will represent the control group and will not receive any emails; the other half will receive an email with the $5 coupon) for one month. After which, use Amplitude to see if there were any correlations between the coupon email and conversions.

Set it up

First, register for an account with Customer.io and Amplitude. Then, enable Customer.io and enable Amplitude on your Segment project. Finally, go into your Customer.io account and enable “sending data to Segment”:

Screenshot of the Streaming Data Out page in Customer.io, with an enabled Segment.com option.

You can find those destination settings in Customer.io here.

When everything is enabled, customer event data such as Order Completed and Product Added, as well as their properties, will all be sent to your configured destinations, including Customer.io and Amplitude. Then you can define cohorts based on these events in Customer.io to add to email campaigns or conduct funnel analytics in Amplitude.

Talk to a product specialist to learn what else you can accomplish with these tools.

Define the cohort in Customer.io

Now define the specific cohort in Customer.io as per our conditions listed earlier: someone who spends over $20 per order and shops over twice a month. In Customer.io, go to “Segments” and “Create Segment”:

Screenshot of the Segment builder in Customer.io, with the title "Coupon Loyalty Experiment".

After this cohort is created, then when a customer makes the third purchase in a month and it’s over $20, they will be added to this segment.

Next, create a “segment trigger campaign”, where Customer.io will send a message the first time someone enters a segment. The segment in this case will be the one you just created: Coupon Loyalty Experiment.

Screenshot of the Segment Trigger Campaign page in Customer.io, with a sample email ready to send to customers in the segment.

Save the changes and enable the campaign. Then, make sure that your e-commerce backend is set up properly to handle the coupons. If it’s available in your system, create a coupon that only works for a specific set of customers.

Measure performance

After a month has passed for the split test, you can measure the performance of the email coupon program to see whether it’s making a material impact on conversions.

In Amplitude, create a funnel that compares the two cohorts—one who received this coupon email vs. the control group who did not—and see its impact on conversions and revenue generated.

First, define a behavioral cohort with the conditions of being loyal customers so you can use it when analyzing the conversion funnel:

Screenshot of a Loyal Customers segment in Amplitude, comprised of users who spent at least $20 and purchased more than two times in the last 30 days

You’ll also have to create a second identical cohort, except with the only difference that these customers did not receive the coupon email. You need this cohort to create the conversion funnel with the control group.

Screenshot of a Loyal Customers (Control) segment in Amplitude, comprised of users who spent at least $20 and purchased more than two times in the last 30 days, but did not get the loyal customer email.

After you’ve created these two cohorts, create two funnel charts. The first funnel will look at the control group. The second funnel will look at the group that received the coupon email.

Screenshot of the Funnel Analysis page in Amplitude showing the Loyal Customers (Control) segment.

Resulting in:

A bar chart showing 233 visits to the main landing screen, 98 products added to cart, and 66 purchases.

The control group that did not receive the email for the coupon resulted in 233 people visiting the store, with 66 conversions.

The funnel for the group who did receive the emails can be created with these parameters:

Screenshot of the Funnel Analysis page in Amplitude showing the Loyal Customers segment.

Resulting in:

A bar chart showing 758 emails delivered, 560 emails opened, 168 visits to the main landing screen, 134 products added to cart, and 95 purchases.

The email itself drove 168 customers to the store, which also saw higher conversions to Product Added and ultimately Order Completed.

Note that this funnel is only looking customers who went through these events in this specific order. This analysis doesn’t consider customers who are part of the emailed cohort, yet didn’t open the email, but still visited the site and/or made a purchase.

At first glance, it appears that the group that was emailed did receive an absolute number of more conversions. However, these funnels are still inconclusive, given that you haven’t explored the impact on the top line revenue, as well as overall engagement with the brand. Fortunately, you can continue to use Amplitude to analyze impact on revenue itself.

Find new ways and channels to retain your most valuable customers

Retaining and rewarding your customers is paramount to a strong and engaging brand. This example is just one of millions that you can employ to find new ways to delight and excite your customer base.

Other ideas can be to send messages to your customers with a referral code to invite their friends. Or set up a coupon for customers who are just shy of entering your most valuable customers cohort. Or, if you’re hosting a pop up shop event, sending a special and personalized invite to your strongest users first, as a way to thank them for their business.

The possibilities are endless when you use your customer data to drive sales.

Talk to a product specialist today about using data to tailor your brand experience.

This page was last modified: 25 Oct 2023



Get started with Segment

Segment is the easiest way to integrate your websites & mobile apps data to over 300 analytics and growth tools.
or
Create free account