How to Build a VIP Outreach List From Your CRM Data

The most common question I get from operators trying to start a VIP program is some version of this: how do we decide who to reach out to?

It sounds simple. It is not. Most operators either pull a list that is too broad to be useful or get paralyzed trying to define the perfect criteria and never actually start.

Here is how I build a VIP outreach list from CRM data, and why the criteria matter more than the size.

Start With Behavior, Not Spend

The instinct for most operators is to sort by lifetime spend and start at the top. That gives you your highest spenders. It does not give you your most retainable customers.

Spend and retention are related but they are not the same thing. A customer who spent $3,000 last year across 40 visits is a fundamentally different retention target than a customer who spent $3,000 across 4 visits. The first customer is deeply habituated. The second customer is a high-value occasional buyer who could easily shift that spend to a competitor without you noticing for months.

The outreach list should prioritize customers who are worth retaining and at risk of not being retained. That means layering three signals together.

Visit frequency. How often does this customer come in relative to their own baseline? Not relative to your store average. Their individual cadence. A customer who visits weekly and suddenly drops to monthly is showing a signal. A customer who has always visited monthly and is still visiting monthly is not.

Spend trajectory. Is the customer's average order value stable, growing, or declining across their last several visits? Declining spend is often the first behavioral signal that a customer is beginning to shift their purchases elsewhere. It precedes a full lapse by weeks or months.

Recency relative to cadence. A customer who is 10 days overdue on a 7-day visit cycle is showing early lapse behavior. A customer who is 10 days overdue on a 30-day visit cycle is not. Recency only means something when measured against the individual's normal rhythm.

When you layer these three signals together, the customers who surface at the top of the list are not simply your biggest spenders. They are your highest-value customers showing behavioral signals that suggest the relationship needs attention.

That is who you want your managers reaching out to.

How Many Customers Per Manager

This is where most operators get it wrong. They build a list of 500 customers and hand it to a manager who is also running a store, handling staffing issues, and managing inventory. The list does not get worked.

A realistic VIP outreach list for a single store manager is 15 to 25 customers per month. That is a number a manager can actually contact personally, log meaningfully, and follow up on without it becoming a second job.

The goal is depth, not volume. One genuine personal interaction with a high-value customer is worth more than 50 generic check-ins. The list should be small enough that managers can actually remember who they contacted and what was said.

If you have multiple locations, each manager gets their own store-specific list. The lists are separate. The accountability is shared via a leaderboard that shows outreach volume and attributed revenue across all locations.

Building the List in Alpine IQ

If you are running Alpine IQ, here is a practical starting point for building the audience that feeds your VIP list.

Start with customers who meet all three of these criteria:

First, lifetime spend above your top 20% threshold. Pull 12 months of transaction data and find the spend level that captures your top quintile. That number is different for every store.

Second, at least 8 visits in the last 12 months. This filters for habituated buyers, not one-time high spenders.

Third, last visit within 60 days. You want customers who are still active. Anyone beyond 60 days has already drifted toward lapse and belongs in a win-back sequence, not a VIP program.

That audience gives you a starting pool. From there, rank by the behavioral signals above. Declining spend trajectory and extended recency relative to individual cadence surface to the top.

The top 15 to 25 of that ranked list is your monthly outreach list for that store.

What to Do With the List

Building the list is step one. The list is only valuable if it gets worked.

Every contact attempt should be logged. The channel, the date, what was said, and the outcome. This is not optional. Without logging, you have no way to know whether the program is working, which managers are actually doing the outreach, or which customers have already been contacted this month.

Revenue attribution comes from matching logged contacts to subsequent purchase activity. When a customer on the outreach list makes a purchase within a defined window after being contacted, that revenue gets flagged as program-attributed. Over time this gives you a clear picture of what the program is actually driving.

The leaderboard closes the loop on accountability. When every manager can see their own outreach volume and attributed revenue alongside every other manager in the organization, the behavior changes. The ones who are working the list rise to the top. The ones who are not have nowhere to hide.

The Shortcut

All of this can be built manually. It requires pulling data, building segments, tracking outreach in a spreadsheet, and maintaining the attribution logic yourself. Most operators who try it manually get about two months in before it falls apart.

VIP Concierge automates the list generation, the logging, the attribution, and the leaderboard. The list is ready at the start of every month. Managers log contacts directly in the tool. Revenue attribution runs automatically against purchase data.

The methodology is the same either way. The infrastructure determines whether it actually happens.

If you want to see how the list generation and outreach workflow work in practice, the live demo walks through it with synthetic dispensary data.

View the Live Demo