Becky Harper Funnel Case Study | Lead Capture System by KC Media Team
Case Study

The Lead Engine We Built for Becky Harper

PackRank made her findable. This system makes sure no lead — old or new — ever slips away again.

51.85%
Email Open Rate
7.41%
Click-Through Rate
800
Dormant Contacts Cleaned
0%
Bounce + Spam Rate

Meet Becky Harper — Again

If you read our PackRank case study, you already know Becky. #1 Luxury Home Agent in Johnson County, 11 years in the business, 246 career sales. Great agent. Great closer. But here's the thing — PackRank solved her visibility problem. It didn't solve what happened after someone found her.

Agent Becky Harper — Keller Williams Realty Partners
Industry Residential & Luxury Real Estate
Service Area Overland Park, Leawood, Olathe, Shawnee, Lenexa & Greater KC
Project Scope Funnel + CRM Automation + List Activation
Timeline Built in a single sprint
Built by KC Media Team

The Real Problem

Becky had two leaks in her funnel that most agents never see. First — leads finding her website had no clear next step. They'd land, look around, and disappear. Second — her CRM had 800 old contacts collecting dust. Duplicates, missing phone numbers, missing emails, names she couldn't reach if she tried. A list that big sounds like an asset. In reality, it was a liability.

PackRank was bringing the horses to water. We needed to give her a way to actually capture them — and rebuild every contact she'd ever earned into something usable.

Why Every Decision Was Intentional

A lot of agencies would have slapped together a generic ConvertKit landing page, dumped Becky's contact list into a mailer, and called it a day. We don't operate like that. Every choice we made was deliberate — built around how real sellers actually behave, and how Becky actually works.

Address-First Funnel Design

Sellers don't want to give you their name first. They want to know what their home is worth. So we built a 3-page funnel that asks for the address before anything else — dropping friction from page one and committing the lead before we ask for contact info.

Segmented List Activation

Becky's old contact list had 500 names — but they weren't all the same. Past clients deserve different messaging than cold leads. Industry contacts shouldn't get marketing at all. So we cleaned, segmented, and tagged every contact before sending a single email.

Domain Warmup Protocol

Sending 500 emails from a brand-new domain is how you get blacklisted. We warmed up Becky's sending domain by starting with her highest-engagement contacts (past clients), then scaled in batches over 10 days. Result: zero spam flags, zero bounces, full inbox placement.

What We Built — Step by Step

Here's the complete system we put in place. Five interconnected pieces — each one purposeful, each one tied to the others.

Phase 1
3-Page Home Valuation Funnel
We designed and built a luxury-aesthetic 3-page funnel hosted at go.blharper.com/valuation. Page 1 captures the address. Page 2 collects qualifying contact details with smart filtering questions. Page 3 confirms the submission with a personalized timeline of what happens next — setting clear expectations so Becky doesn't get "did you get my form?" follow-ups.
Phase 2
Contact List Cleanup & Segmentation
We audited 800 contacts from Becky's database — and immediately found the mess. Duplicate records. Contacts with no email. Contacts with no phone. Contacts with neither. After deduplicating and filtering out unreachable records, we segmented what remained into four strategic groups: real estate prospects, past clients, industry contacts (excluded from marketing), and unclassified records flagged for Becky to manually review. Every contact got proper tags, ownership assignment, and source attribution — making the CRM actually useful instead of a graveyard.
Phase 3
Reintroduction Drip Campaign
Two custom HTML email templates — one for prospects, one for past clients — designed to re-engage contacts who hadn't heard from Becky in 12+ months. The emails don't push for a sale. They acknowledge the gap, offer monthly market insights, and let recipients self-select whether they want to stay subscribed.
Phase 4
Formspree → CRM Integration via Webhook API
Becky's existing website contact form (Formspree) was capturing leads but dumping them into an email inbox that rarely got actioned. We built a webhook bridge that pipes every submission directly into her CRM — automatically creating contacts, assigning ownership, and pushing the lead into her sales pipeline. Instant SMS notification to Becky's phone. Branded email confirmation to the lead. No lead falls through the cracks.
Phase 5
Monthly Market Brief Newsletter System
We built a reusable HTML newsletter template and a 12-month content calendar covering monthly themes — spring market trends, summer buying season, fall pricing strategy, year-end reviews. Each issue is paired with hyperlocal Johnson County data points Becky provides monthly. Combined with blog content on her main site, this creates a steady drumbeat of expertise that keeps Becky top-of-mind without being pushy.

The System Works When Becky Can't

Here's the part most agents never solve. Becky is a top producer — which means she's at listings, in showings, on the phone, on vacation, or asleep. A lead that lands at 9pm on a Friday can't wait until Monday morning. So we built nurture sequences that don't need her.

4
Funnel Tracks
Sellers, buyers, past clients, and website inquiries each get their own dedicated sequence — because they're not the same audience and shouldn't get the same emails.
10
Touchpoints Per Track
A 10-step sequence of staggered emails and texts spanning 3 weeks. Confirmation, education, social proof, market context, and gentle re-engagement — paced to feel personal, never spammy.
3
Weeks of Coverage
Every lead gets 21 days of automated touchpoints — so even if Becky never picks up the phone, the prospect stays warm, stays informed, and keeps Becky top-of-mind.

What Happens The Moment A Lead Submits

0 minBranded confirmation email hits their inbox
2 minBecky gets SMS + email alert with full lead context
1 hourWelcome text sent from Becky's number (if SMS opted-in)
Day 2Follow-up email with neighborhood-specific market data
Day 5Social proof email — recent sales and reviews
Day 9Educational content matched to their funnel track
Day 14Soft re-engagement — "still thinking about it?"
Day 21Final touchpoint + auto-enrollment into monthly newsletter

Becky doesn't get back to me until Tuesday. By then, the prospect has already heard from her twice through the system, knows what to expect, and shows up to the call warm instead of cold.

One Connected System — Three Lead Sources

When all five pieces are connected, Becky's marketing stops being a collection of disconnected tools and becomes a single engine. Here's what happens when a new lead enters the system from any direction.

1

Lead Enters

Via the valuation funnel, the contact form, or the monthly newsletter CTA — every entry point feeds the same CRM.

2

Auto-Routed

Lead is tagged by source, assigned to Becky as owner, added to her sales pipeline, and sent a branded confirmation email — all in under 30 seconds.

3

Becky Notified

SMS and email alerts hit Becky's phone instantly with full lead context — so she can pick up the phone within the hour.

What Activation Actually Looks Like

Here are the real results from the first wave of the reintroduction drip — sent to past clients who hadn't heard from Becky in over a year.

Metric Result Industry Benchmark Status
Delivery Rate 100% ~95% Exceeding
Open Rate 51.85% 20–25% 2x Benchmark
Click-Through Rate 7.41% 2–3% 2.5x Benchmark
Bounce Rate 0% <2% Perfect
Unsubscribe Rate 0% <5% Perfect
Spam Complaints 0 0 Clean
51.85%
Open Rate on a Cold List That Hadn't Heard From Becky in Over a Year

The System Worked Within Hours

Within the first day of going live, two warm leads surfaced — one from the reactivated past-client list, one from the new website integration. This is what intentional system design produces.

Reactivated Past Client

Engaged with the reintro email

A past client who hadn't been in contact with Becky for over a year opened the reintroduction email, clicked through to the valuation page, and engaged with the funnel — within minutes of receiving it. Becky now has a direct line to follow up with someone who was completely off the radar 48 hours earlier.

New Website Lead

Captured via Formspree → CRM

A buyer pre-qualified through a major Kansas City lender submitted Becky's contact form asking about a specific listing. The webhook integration routed the lead into Becky's CRM within seconds, notifying her directly. Without the integration, this lead would have lived in a Formspree email inbox — easy to miss, easy to lose.

The Tech Stack Powering It

We use enterprise-grade tools — but configure them in ways most agencies don't. Here's the stack that runs Becky's lead engine.

Custom HTML/CSS Funnel GoHighLevel CRM Workflow Automation Formspree Webhooks Inbound Webhook API Custom Email Templates SMS Notifications Pipeline Management Domain Authentication (SPF/DKIM) List Segmentation Content Calendar System Blog Integration

What These Numbers Mean — and Don't Mean

We could puff this case study up. We won't. Here's what's real, what's measured, and what we can't claim yet.

Leading Indicators vs Final Outcomes

Real estate transactions close on 30–90 day cycles — sometimes longer. The numbers in this case study are leading indicators: open rates, click rates, lead capture rates, and engagement signals. These are the metrics that predict revenue, but they're not the same as closed deals. As of this writing, the system has been live for a short period. We can already point to qualified leads who have entered the pipeline. We can't yet claim closed transactions tied to it — and we won't until the data supports it.

Why we're sharing it anyway: Because the system design, the engagement metrics, and the foundational work are the things prospective clients should evaluate. Anyone can show you a screenshot of one closed deal. What matters is whether the system can consistently produce closed deals over time — and that's what these leading indicators tell us.

This Isn't a Template You Buy

Most "real estate funnel" products are off-the-shelf. You buy them, you configure them, and they look exactly like every other agent's funnel in your market. Becky's system was designed for her — her brand, her market, her past clients, her sales process. That's what makes it work.

100%
Custom Built
0
Templated Sections
5
Connected Systems

Stop Losing Leads You Already Earned

If you've got a dormant contact list, a website form that goes nowhere, or a funnel that doesn't convert — we can fix that. We don't sell templates. We build systems. And we only take on clients we can actually move the needle for.

START A CONVERSATION