Book a walk-through

Prompt of the Week: The Database Wake-Up

Paste your customer states, get one email per state. The prompt behind the six-email morning, tuned for agents, team leaders, and any service business sitting on a quiet list.

Zack PetroccaOrigin, the right hand most owners never had · 2 min read
In this article
  1. The prompt
  2. How to use it

This is the prompt we used to draft the six emails in the dormant database playbook. One customer, one message. It works in ChatGPT, Claude, or Gemini. Paste it, fill the brackets, and you will have a first draft of every email your list needs in about two minutes.

The rule it enforces is the one worth keeping: every person on your list is in exactly one state, and each state gets exactly one message. Nobody gets two. Nobody with a problem gets a promotion.

The prompt

You are a direct-response email writer for an owner-led service business. Your job is to write ONE email for EACH customer state I give you, so that every person on my list gets exactly one message that fits where they are right now. Never two. Never a promotion to a customer with a problem.

About my business:
- What we do: [one sentence]
- Who we serve: [one sentence]
- Voice: warm, direct, first person, no hype, no exclamation points
- The one action I want most people to take this month: [book a call / take the free assessment / renew / refer a friend]

My customer states (edit these):
1. New: signed on in the last 30 days
2. Active: working with us now
3. Quiet: was active, no contact in 60+ days
4. Past: worked with us before, not now
5. Lead: raised a hand, never bought
6. Best: top 10 percent, the ones we would clone

If I am a real estate agent or team, use these states instead:
1. Under contract right now
2. Closed in the last 12 months
3. Sphere: knows me, has never transacted with me
4. Online lead gone quiet for 30+ days
5. Past client, two or more years since closing
6. Expired or withdrawn seller in my market

For each state, return:
- Subject line (under 45 characters, no clickbait)
- Preheader (under 80 characters)
- Body: 90 to 130 words, plain language, one idea, one clear next step, one link at most
- The single number I should check 7 days after sending

Rules:
- Match the message to the state. A past client gets "here is what changed since we last talked," not a pitch.
- The Best group gets a thank-you and a useful tip or resource. No offer.
- Anyone with a failed payment or an open complaint gets nothing promotional.
- Write as me, in first person. No em dashes.

How to use it

  1. Fill the four bracketed lines. Do not skip the voice line; it is what keeps the output from sounding like a marketing department.
  2. Replace the states with yours. Six is plenty. If you cannot list your states, that is the real finding, and the Origin Score (twenty-seven questions, about five minutes) will show where your business is narrowest right now.
  3. Send the one that is most overdue first. It is almost always Past or Quiet.
  4. Measure by who you mailed. Pull the list of who received it and check what they did in the seven days after.

Questions this usually raises

How do I use AI to write emails to my customer list?
Short answer

Give it your customer states and ask for one email per state. This prompt does that in ChatGPT, Claude, or Gemini: fill in what you do, who you serve, your voice, and the one action you want this month, and it returns a subject line, preheader, 90 to 130 word body, and the number to check seven days later for each state.

What customer states should I write emails for?
Short answer

The default six are New, Active, Quiet, Past, Lead, and Best. For real estate agents and teams the prompt swaps in: under contract, closed in the last 12 months, sphere, online leads quiet for 30 or more days, past clients two or more years since closing, and expired or withdrawn sellers.

Which email should I send first?
Short answer

The one that is most overdue, which is almost always Past or Quiet. Send it to that group only, then measure by who you mailed: pull the list of recipients and check what they did in the seven days after.

What if I cannot list my customer states?
Short answer

That is the real finding. If you cannot say what state each customer is in, the gap is in how you track customers, not your email copy, and the Origin Score (twenty-seven questions, about five minutes) will show where your business is narrowest right now.

The System Drop

One thing to put to work, every week.

A short email with one setup, the steps, and the prompt or template to do it. Plus the news that changes how you run the business.

Step 1 of 2

More in AI in your business
When you're ready

When you'd rather we build it with you.

Most owners start here. When you want a right hand to build it with you, start with a walk-through. We walk your business with you and find the priority that will do the most for it.

“I went from an independent contractor to a business owner.”

$7.3M to ~$11M in sales

Beau P.Real Estate Team Leader