Skip to main content
Picayune DataFree call
All posts
Getting customers · 4 min read

How to use your customer data to target your marketing

Sort customers by how recently, how often and how much they buy, then send each group a different message. Start with your best and lapsed customers.

Targeted marketing means sending different messages to different groups of customers instead of one blast to everyone. The easiest way for a small business to start is to sort customers by how recently they bought, how often and how much, then pick two groups: your best customers and the ones who've stopped coming. The data for this is already in your point of sale, booking or invoicing system.

Why not send everyone the same thing?

Because the same message means different things to different people. Example: a 15% off coupon sent to your weekly regulars gives away money they'd have spent anyway. Sent to someone who hasn't visited in four months, it might bring them back. Splitting the list lets you spend discounts where they change behavior and send thank-yous where they don't need one.

Which groups should you start with?

GroupHow to find themWhat to send
Best customersTop 10% to 20% by spend over the past yearThanks, early access, a referral ask
Lapsed customersGone about twice their normal gap between visitsA friendly "we miss you" with a reason to return
New customersFirst purchase in the last 30 daysWelcome, what else you offer, a second-visit nudge
One-time buyersBought once, more than 90 days agoA short survey or a small offer

These cutoffs are starting points. Adjust them to how often your customers normally buy. A lunch spot's regular comes weekly, a dental patient twice a year.

How do you build the lists?

You don't need special software. Use this method:

  1. Export your sales or visits to a spreadsheet: customer, date, amount. Most POS and booking systems have a customer or sales report you can download.
  2. Add three columns per customer: days since last purchase, number of purchases in the past year and total spent in the past year. This is the RFM method (recency, frequency, monetary value) that marketers have used for decades.
  3. Sort and label. Highest spend gets "best." Long gap since last visit gets "lapsed."
  4. Import each group into your email or texting tool as its own list or tag.

If spreadsheet formulas aren't your thing, an AI assistant can do steps 2 and 3 from your export. How to use AI to find insights in your sales data shows how, and what to remove from the file first.

What does a targeted message look like?

Short, and specific to the group. Examples:

Lapsed: "Hi Dana, it's been a while since your last tune-up at Corner Auto. We've got openings next week, and your next oil change is $10 off through the 30th."

Best customers: "You're one of our regulars, so you're first to hear: our holiday menu goes live Friday. Book before it opens to everyone else."

Send each one to its group only, and track who comes back. How to run a promotion that makes money explains how to tell whether the offer earned more than it cost.

How do you keep it going?

Rebuild the lists once a month, or set your software to tag customers automatically when they cross a line, like 60 days without a visit. Many POS and email tools, including Square, Shopify, Mailchimp and Klaviyo, can do this with built-in segments.

All of this depends on having the customer data in the first place, in a system you control. Why you should own your customer data covers that. We build these lists and the reports behind them through our reports and customer data service.

Common questions

What is customer segmentation in simple terms?
Sorting your customers into groups that should get different messages. A customer who visits every week and one who hasn't been in since spring need different reasons to come back.
What is RFM analysis?
A way to rank customers by Recency (how long since they last bought), Frequency (how often they buy) and Monetary value (how much they spend). It's a simple, long-standing method for finding your best and fading customers, and it works in a spreadsheet.
When is a customer considered lapsed?
When they've gone well past their normal gap between visits. A common rule is about twice their usual gap. A monthly haircut client who's been gone two months is lapsed, while an annual HVAC tune-up customer isn't lapsed until well past a year.
What data do I need to start?
A customer name or ID, a contact method, and the date and amount of each purchase. Most POS, booking and invoicing systems store exactly that and can export it as a spreadsheet.

Picayune Data

We set up and look after the tech that helps small businesses get more customers and spend less time on admin. About us

Related services: Reports & customer data, Booking & phones