Understanding customers' purchasing habits: Order Sequence filter

Know what your customers are buying, and when!

Knowing what your customers are buying, where they’re buying, or how much they’re spending are important insights that will help you create meaningful relationships with your customers, and pairing this information with Order Sequence, and knowing not only what they’re buying, but when, is a powerful tool when it comes to creating campaigns for things like in-store events and replenishment.

With Lexer’s Order Sequence filter, you can add these insights to your arsenal!

We’ll walk through three, hands-on use cases for the Order Sequence filter, so let’s get into it!

Finding the Order Sequence filter in the Hub

Lexer’s Order Sequence filter is connected to your Smart Search attributes in the Hub.

To learn more about Smart Search, click here.

To find your Order Sequence filter, navigate to Understand > Segment and then click into the attribute picker. To the right, you’ll see your Smart Search attributes.

Select any of these attributes and add it to your Segment Builder. Then hover over the attribute and click the > symbol. This will bring up the attribute filters, and this is where you’ll find Order Sequence.

If you select this filter, you’ll have a number of options that will allow you to configure your search how you want.

  • ALL, which is all orders in any sequence.
  • IN A SPECIFIC ORDER, which allows you to select a customer’s first, second, second last, or last order.
  • WITHIN THE LAST, which allows you to specify a number of orders, for example, in the last 4 orders.
  • BETWEEN, which allows you to specify a sequence range, for example, between orders 2 and 4.

You’re now ready to pair this filter with the others available, and we’ll walk through some common use cases below!

Order Sequence and Store location

You can pair the Order Sequence filter with the Store filter to understand where your customers are making their purchases. This pairing has a number of use cases.

For example, your brand may have decided to close one of your “brick and mortar” stores, and before you do so, you’d like to invite all customers who have recently shopped at that store to a “closing down” sale.

To create this segment of customers, select the Product Purchased Smart Search attribute, and include the following filters:

  • Order Sequence > In the LAST order
  • Store > Select your location
  • Order Date > In the last > 6 months

What this query is searching for is customers whose last purchase was at the store that is closing down, and was within the last six months.

You can then save this segment and activate it to your chosen channels, inviting these customers to your closing down sale.

If you need a refresher on how to activate a segment, click here.

The same principles apply to the opposite scenario. Your brand may be opening a new store and you’d like to invite customers who have recently shopped at the closest store location to your grand opening.

This segment would use exactly the same filters as above, but in this scenario you would choose the store located closest to the new one opening:

  • Order Sequence > In the LAST order
  • Store > Select the store location closest to your new store
  • Order Date > In the last > 6 months

And there you have it! Another segment ready for activation.

And don’t forget in-store marketing events either! Same filters, but select the store you’re having the event at:

  • Order Sequence > In the LAST order
  • Store > Select the store hosting the event
  • Order Date > In the last > 6 months

You might like to make this customer segment even more specific and only invite your high-value shoppers. In which case, you can add the Price Paid filter too.

And that's a great segue because now, let’s walk through how to pair Price Paid with Order Sequence.

Order Sequence and Price Paid

Understanding how Price Paid and Order Sequence work together is great for when you want to track specific “spend” related promotions. For example, spend $100 or more in your first order and you’ll receive a 10% discount on your next one!

To create this segment, select the Order Smart Search attribute and add the following filters:

  • Order Sequence > In the FIRST order
  • Total Price Paid > Greater than or equal to > $100

This query is searching for customers who have spent $100 or more in their first purchase.

Then hit Search and Save your segment.

The great thing about this segment is that it’s dynamic, new customers who match these parameters will automatically be added.

The added benefit of this is that you can create an ongoing activation as well, which means that again, all new customers who match these parameters can automatically be sent their discount code.

For instructions on how to create an ongoing activation, click here.

Order Sequence and replenishment campaigns

For this last use case, you’ll see how the Order Sequence filter can be used when creating segments for replenishment campaigns. Replenishment campaigns are important because they’re a great way to encourage retention and repeat purchases.

Firstly, do you have products in your range that you know people buy over and over again at an approximate cadence? For example, a certain shampoo that you know is used and then needs to be replenished within about 4 months of purchase?

This is the segment for you.

Select the Product Purchased Smart Search attribute and add it to the PROFILES MUST HAVE ALL OF THESE section of the builder, and then add the following filters:

  • Product Name > Name of product in your replenishment campaign
  • Order Sequence > In the LAST order
  • Order Date > In the last > 4 months (or whatever your replenishment cycle might be)

Next, select the Product Purchased attribute again, but this time drag and drop it into the BUT NOT HAVE ANY OF THESE section of the builder. Then add the following filters:

  • Product Name > Name of product in your replenishment campaign
  • Order Sequence > In the LAST order
  • Order Date > In the last > 3 months

What this query is looking for is customers who have purchased a certain product in the last 4 months, but haven’t purchased it again since.

Hit Search, and you have your replenishment segment! You can save this segment, and then activate to your chosen channels.

Order Sequence filter and purchasing behaviour

Using Lexer’s Order Sequence Smart Search filter is a great tool to use to help you understand your customers’ purchasing behaviors. You can then use these insights to create some great campaigns, including ones like “closing down” sales and replenishment campaigns.

Jump into your own Hubs and have a go, and if you have any questions, please reach out to your Success Manager, or Lexer Support (support@lexer.io).

Updated:
May 14, 2024
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
Lexi your AI companion
Fundamentals
Lexi
Browser guide
Fundamentals
Security
Corporate networks
Fundamentals
Security
Emergency contact
Fundamentals
Security
Multi-factor authentication
Fundamentals
Security
Single sign-on
Fundamentals
Security
Lexer's Identity Resolution
Fundamentals
Identity Resolution
Lexer's ultimate troubleshooting guide
Fundamentals
Troubleshooting
Troubleshooting tech issues
Fundamentals
Troubleshooting
Troubleshooting integrations
Fundamentals
Troubleshooting
Troubleshooting Activate
Fundamentals
Troubleshooting
Troubleshooting Respond
Fundamentals
Troubleshooting
Help! My data is missing from the Hub
Fundamentals
Troubleshooting
How data is ingested into the CDP
Data
Self Serve Onboarding
Getting started onboarding data
Data
Self Serve Onboarding
Understanding APIs
Data
Self Serve Onboarding
Providing JSON data to Lexer
Data
Self Serve Onboarding
Providing CSV data to Lexer
Data
Self Serve Onboarding
Upload using SFTP
Data
Self Serve Onboarding
Upload using S3
Data
Self Serve Onboarding
Lexer data specification
Data
Data Specification
Customer data specification
Data
Data Specification
Commerce data specification
Data
Data Specification
Marketing data specification
Data
Data Specification
Compliance data specification
Data
Data Specification
Rate limits
Data
APIs
Product imagery
Data
Formatting
Currency conversion
Data
Formatting
Dataset management
Data
Datasets
Chatbot API
Data
APIs
Activity API
Data
APIs
Visualize API
Hidden from nav
Read API
Data
APIs
Lexer Javascript Tag basics
Data
Javascript Tag
Export to CSV
Measure
Listen
Data in Lexer's CDXP
Data
Customer Data
Data source - CRM
Data
Customer Data
Data source - Email
Data
Customer Data
Experian
Data
Partner data
Secure file upload
Data
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
Lexer's attributes
Understand
Attributes
Predictive attributes
Understand
Attributes
Attribute value types
Understand
Attributes
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
Where do your best customers live? Use geographic insights to maximize media spend and conversion
Grow
Where do your best customers live? Use geographic insights to maximize media spend and conversion
Suppression audiences: How to use them and maximize your media effectiveness
Enrich
Suppression audiences: How to use them and maximize your media effectiveness
Measure campaign effectiveness: Track your KPIs and report on campaign performance
Enrich
Measure campaign effectiveness: Track your KPIs and report on campaign performance
Converting prospects: Acquire customers from your current, engaged prospect base (and save your ad spend!)
Acquire
Converting prospects: Acquire customers from your current, engaged prospect base (and save your ad spend!)
Understanding customer intent: Effective message personalization for buyers who shop outside their gender
Grow
Understanding customer intent: Effective message personalization for buyers who shop outside their gender
Deepen customer understanding: Use third-party data to identify insights for personalized messaging and increased engagement
Grow
Deepen customer understanding: Use third-party data to identify insights for personalized messaging and increased engagement
Basket analysis: Increasing customer lifetime value through targeted product bundling
Grow
Basket analysis: Increasing customer lifetime value through targeted product bundling
Persona building: Personalize your messaging for maximum return on your campaign investments
Grow
Persona building: Personalize your messaging for maximum return on your campaign investments
Driving customer loyalty: Identify, keep, and grow your most loyal customers
Retain
Driving customer loyalty: Identify, keep, and grow your most loyal customers
Increasing customer lifetime value: Upselling strategies
Grow
Increasing customer lifetime value: Upselling strategies
Reactivating lapsed customers: Retention and growth
Retain
Reactivating lapsed customers: Retention and growth
Welcome offer strategies: Using the Hub for analysis
Acquire
Welcome offer strategies: Using the Hub for analysis
Creating customer forms: Best practices
Enrich
Creating customer forms: Best practices
Connecting your MarTech stack with Lexer!
Enrich
Connecting your MarTech stack with Lexer!
Identifying win-back customers using the Second Last Order: Date attribute
Retain
Identifying win-back customers using the Second Last Order: Date attribute
Understanding customers' purchasing habits: Order Sequence filter
Grow
Understanding customers' purchasing habits: Order Sequence filter
Maximizing customer communications in Respond
Retain
Maximizing customer communications in Respond
Using Product Recommendation in the Hub to encourage repeat purchases
Grow
Using Product Recommendation in the Hub to encourage repeat purchases
Encouraging customer loyalty using birthday campaigns
Retain
Encouraging customer loyalty using birthday campaigns
Increasing customer lifetime value: Converting your one-time buyers into two-time buyers
Grow
Increasing customer lifetime value: Converting your one-time buyers into two-time buyers
Collecting zero-party data using Lexer Forms
Enrich
Collecting zero-party data using Lexer Forms
Measuring your data over time with Track
Enrich
Measuring your data over time with Track
UTM Creation Guidelines
UTM Creation Guidelines
UTM Creation Guidelines
Brand Assets
Brand Assets
Brand Assets
GTM guide to creating marketing materials with Lexer
GTM guide to creating marketing materials with Lexer
GTM guide to creating marketing materials with Lexer
How to use the Lexer Form Builder
How to use the Lexer Form Builder
How to use the Lexer Form Builder
Explore our standard integrations
Explore our standard integrations
Explore our standard integrations
Operating a CDP Practice LP
Operating a CDP Practice LP
Operating a CDP Practice LP
LP Sales Enablement
LP Sales Enablement
LP Sales Enablement
Video Training Courses LP
Video Training Courses LP
Video Training Courses LP
Purpose and Mission
Purpose and Mission
Purpose and Mission
Brand & Marketing LP
Brand & Marketing LP
Brand & Marketing LP
Stage 3 - QBRs and Customer insights
Stage 3 - QBRs and Customer insights
Stage 3 - QBRs and Customer insights
Client Onboarding Journey
Client Onboarding Journey
Client Onboarding Journey
Start your CDP Practice
Start your CDP Practice
Start your CDP Practice
Lexer Messaging
Lexer Messaging
Lexer Messaging
Pain point conversations
Pain point conversations
Pain point conversations
Lexer Ideal Customer Profile & Positioning
Lexer Ideal Customer Profile & Positioning
Lexer Ideal Customer Profile & Positioning
Referral Partner Program Overview
Referral Partner Program Overview
Referral Partner Program Overview
Demo Hub Guide
Demo Hub Guide
Demo Hub Guide