Identifying win-back customers using the Second Last Order: Date attribute

Identifying win-back customers

An important part of any marketer’s job is being able to identify customers in your database who are lapsing (or lost) and re-market to them in an attempt to win them back. Why is it important? Because retaining customers is around seven-times cheaper than acquiring new ones!

When your win-back campaigns are running, you need to be able to establish in what part of a customer’s “funnel” they have been “won-back” from. For example, were they in a lost, or lapsing segment? Or, did they move up into a high-value segment?

In this article we’ll walk through how to set up some segments and a Track dashboard that can do just this!

Setting the groundwork

The best place to start is by creating and saving a win-back lapsed customers segment.

One of the key attributes to include in this segment is Second Last Order: Date, which searches for a customer’s second to last order. We include this attribute because it helps us to see where our customers are moving across the funnel, which means we can tailor our marketing communications depending on this information.

To create this segment, navigate to Understand > Segment in the Lexer Hub (top navigation bar).

Working in the Segment Builder, include the following attributes in the MUST HAVE section of the builder:

  • All customers
  • Last Order: Date

The Last Order: Date attribute should be set to in the last 30 days, as this is how we’re going to define our sales conversion window. But you can change the date depending on your own definition.

Then, in the BUT NOT HAVE section of the builder, include the Second Last Order: Date attribute, and set this to in the last 18 months, as this is how we’re going to define our lapsed customers.

So, in other words, this segment is looking for previously lapsed customers who have made a purchase in the last 30 days.

Once you have added these attributes, hit SAVE AS NEW SEGMENT and fill in the following details:

  1. Name: The name you would like this segment to have. It should reflect what the segment is, so in this example, win-back lapsed customers.
  2. Category: Choose which category this segment falls under. It could be Retention, for example. Your company might have some guidelines around this that you can follow.
  3. Description: Create a short description that makes it clear what the purpose of this segment is.
  4. Color: You can choose a color for your segment. Your company might group all segments in a particular category under one particular color, but it’s up to you!
  5. Choose whether or not you want this segment to show in your Segment Builder by default any time you log into the Hub.
  6. Action: Choose whether you want this segment to show as an action on the profiles throughout the Hub.
  7. Population metric: Choose whether you want to track the population of this segment (whether it grows in profiles or decreases in profiles) over time. As our overall goal in this use case is to create a Track dashboard using this segment, we highly recommend you tick this option.
  8. Groups: who has permission to view and edit this segment.

Then hit SAVE.

You could also create a win-back churned customers segment. It would be very similar to the lapsed customer segment, the only difference would be in the Second Last Order: Date attribute. You would set this to in the last 24 months, as this is how we would define our churned customers.

Finally, you can add your win-back campaign to the segment as well. Simply search for the cumulative audience attribute, and add your campaign to the filter. This will show you profiles who have purchased during your campaign.

Hit SAVE, and your segments are ready for tracking!

Creating your Track dashboard

As mentioned a little earlier in the article, you can also use Track to monitor your win-back campaigns and see where in the funnel your customers have been “won-back”.

You can create your Track dashboards using the win-back lapsed customers and win-back churned customers segments we walked through earlier.

Some metrics you might like to set up could include:

  • Total lapsed customers
  • Total converted customers
  • Average customer lifetime value
  • Average order value

To learn more about creating metrics and dashboards, see our Track overview article here.

Win-back, and track!

We all know the value of win-back customer strategies, and using Lexer, tracking the success of these campaigns is even easier! Simply create your win-back segments and then monitor their effectiveness using Track.

If you have any questions once you get started, please reach out to your Success Manager, or Lexer Support (support@lexer.io).

Updated:
November 30, 2022
Did this page help you?
Thank you! Your feedback has been received!
Oops! Something went wrong while submitting the form, for assistance please contact support@lexer.io
Welcome to Lexer!
Fundamentals
Getting started
Our glossary
Fundamentals
Getting started
Integrations
Fundamentals
Setup
My account
Fundamentals
Setup
Manage team
Fundamentals
Setup
Group permissions
Fundamentals
Setup
Classifications
Fundamentals
Setup
Out of the box segments
Fundamentals
Setup
Browser guide
Fundamentals
Security
Corporate networks
Fundamentals
Security
Emergency contact
Fundamentals
Security
Multi-factor authentication
Fundamentals
Security
Single sign-on
Fundamentals
Security
Trust and compliance
Fundamentals
Security
Lexer's Identity Resolution
Fundamentals
Identity Resolution
Troubleshooting tech issues
Fundamentals
Troubleshooting
Error code: 503 Service Unavailable
Fundamentals
Troubleshooting
Error code: 401 Unauthorized
Fundamentals
Troubleshooting
Error code: 403 Forbidden
Fundamentals
Troubleshooting
Troubleshooting Activate
Fundamentals
Troubleshooting
Troubleshooting Respond
Fundamentals
Troubleshooting
Help! My data is missing from the Hub
Fundamentals
Troubleshooting
Understanding APIs at Lexer
Data
Data Onboarding
Providing JSON data to Lexer
Data
Data Onboarding
Providing CSV data to Lexer
Data
Data Onboarding
Upload using SFTP
Data
Data Onboarding
Upload using S3
Data
Data Onboarding
Lexer data specification
Data
Lexer Data Specification
Customer data specification
Data
Lexer Data Specification
Commerce data specification
Data
Lexer Data Specification
Marketing data specification
Data
Lexer Data Specification
Compliance data specification
Data
Lexer Data Specification
Data Formatting and Validation
Data
Getting Started with APIs
Authentication and API token creation
Data
Getting Started with APIs
Rate Limits
Data
Getting Started with APIs
Response codes and common errors
Data
Getting Started with APIs
Product imagery
Data
Getting Started with APIs
Currency conversion
Data
Getting Started with APIs
Lexer’s APIs overview
Data
Lexer’s APIs
Dataset management in the Hub
Data
Dataset management
Chatbox user API
Data
Lexer’s APIs
Activity API
Data
Lexer’s APIs
Visualize API
Hidden from nav
Profile Read API
Data
Lexer’s APIs
Lexer Javascript Tag basics
Data
Lexer Javascript Tag
Lexer Javascript Tag technical guide
Data
Lexer Javascript Tag
Lexer Javascript Tag use cases
Data
Lexer Javascript Tag
dataLayer configuration: Shopify
Data
Lexer Javascript Tag
Customer segment CSV export
Data
Data off-boarding
Export to CSV
Data
Data off-boarding
Data in Lexer's CDXP
Understand
Customer Data
Lexer's attributes
Understand
Customer Data
Attribute value types
Understand
Customer Data
Data source - CRM
Understand
Customer Data
Data source - Transactions
Understand
Customer Data
Data source - Email
Understand
Customer Data
Partner data - Experian
Understand
Customer Data
Partner data - Mastercard
Understand
Customer Data
Partner data - Roy Morgan
Understand
Customer Data
GDPR and CCPA requests
Understand
Customer Data
Upload data files
Understand
Customer Data
File upload API
Understand
Customer Data
Data provision and schemas
Understand
Customer Data
Segment overview
Understand
Segment
Creating segments
Understand
Segment
Smart Search
Understand
Segment
Export attribute results
Understand
Segment
Contact a customer
Understand
Segment
Fixing a disabled segment
Understand
Segment
Profile tab
Understand
Segment
Compare segments
Understand
Compare
Compare attributes
Understand
Compare
Activate overview
Engage
Activate
Ongoing activations
Engage
Activate
Audience splits
Engage
Activate
A/B splits
Engage
Activate
Control group splits
Engage
Activate
Inbox filtering
Engage
Respond
Ignored Senders
Engage
Respond
Forms for service
Engage
Respond
Workflow states
Engage
Respond
Bulk changes
Engage
Respond
Scheduled replies
Engage
Respond
Message templates
Engage
Respond
Customer profiles
Engage
Respond
Grouped messages
Engage
Respond
Automation rules
Engage
Respond
Redact messages
Engage
Respond
Track overview
Measure
Track
Activity overview
Measure
Activity
Team report
Measure
Activity
Cases report
Measure
Activity
Listen overview
Measure
Listen
Searching in Listen
Measure
Listen
Tier filters
Measure
Listen
Boolean search
Measure
Listen
Saved dives
Measure
Listen
Email notifications
Measure
Listen
Twitter data
Measure
Listen
Facebook data
Measure
Listen
Instagram data
Measure
Listen
Visualize overview
Measure
Visualize
Curate feed
Measure
Visualize
Report overview
Measure
Report