Most Investors Run Blind
They close deals. They lose deals. They have no idea why either one happened.
80% of REI businesses that stall had enough leads. They had a tracking problem, not a lead problem. They could not tell you their cost per contract, their dials-to-appointment ratio, or which caller was actually producing.
KPIs change that. Not vanity metrics like "total leads in the CRM." Real numbers that connect your daily activity to your monthly revenue. The kind where you can look at Tuesday's report and know whether you are on pace for the month.
KPIs do not make you a micromanager. They make you a leader who can diagnose problems in 30 seconds instead of 30 days. The fastest-growing operators in this space all track the same core metrics. The ones who stall all have the same excuse: "I know my numbers in my head."
Track This
Leading indicators: dials, conversations, appointments set, offers made. These predict revenue before it happens.
Not This
Only lagging indicators: revenue, closed deals, profit. By the time these drop, the problem started 90 days ago.
Tracking changes behavior even before you act on the data. When a caller knows their numbers are visible, their dial count goes up 15-20% without you saying a word. Visibility is accountability.
Already scored your business? If not, start with the Company Audit to find your bottleneck first. This page picks up where the audit leaves off.
Start With Revenue, Work Backward
Everyone sets a revenue goal. Almost nobody does the math to figure out what that means on a Tuesday afternoon at 2pm.
The Revenue Reverse-Engineering Calculator takes your monthly target and breaks it into the exact daily activities that produce it. Three inputs. Six outputs. Zero guessing.
If your daily dial number looks scary, you need more callers, not more motivation. One caller can do 150-200 dials per day with a power dialer. Divide your monthly dial target by 150 to see how many callers you need.
The Numbers That Actually Matter
Every stage in your pipeline has a conversion ratio. Know them, and you can predict revenue. Ignore them, and every month is a coin flip.
Dials
Raw outbound call attempts. Not everyone picks up. Not every pickup is a real conversation. This is the widest part of the funnel and the one your callers control most directly.
Correct Numbers (32:1)
It takes roughly 32 dials to reach 1 person at a correct, working number who will actually talk. Phone scoring with Trestle can cut this ratio dramatically by eliminating dead numbers before dialing. Watch your conversation rate here: real two-way conversations should run 15-20% of dials. Below 15% means a list or number quality problem, not an effort problem.
Appointments (5:1)
About 1 in 5 real conversations converts to a scheduled appointment. The quality of your script, your speed to lead, and your caller training all affect this ratio.
Offers Made (1.5:1)
Not every appointment results in an offer. Some properties do not meet your criteria. Some sellers are not motivated enough. A 1.5:1 ratio means you make an offer on roughly 2 out of every 3 appointments.
Contracts Signed (4:1)
Close rate varies by market and experience, but 1 in 4 offers getting accepted is a solid benchmark. If yours is worse, look at your comping accuracy and offer strategy.
The Google Sheet That Runs Your Business
Ten tabs. Each one tracks a different piece of the machine. Make a copy and start using it today.
DataSift REI KPI Sheet
Open in Google Sheets. Make a copy (File > Make a copy) to start tracking. The canonical KPI template and daily KPI Slack bot now ship inside the DataSift Lead Management plugin.
Start Here
Company info and initial setup
Goals & Setup
Revenue targets and deal goals
Expenses
Monthly cost tracking by category
Monthly Data
Aggregate monthly numbers
Dashboard
Visual KPI summary
Review Dashboard
Trend analysis and deep review
Caller Tracker
Daily prospector metrics
Lead Manager
Follow-up and pipeline metrics
Transactions
Deal-by-deal tracking
Direct Mail
Mail campaign performance
Inside the KPI Sheet
Each tab has a specific job. Here is what you are looking at and why it matters.
The canonical KPI template structure. The current authoritative sheet is organized into these tabs: Leads Summary, First to Market, Lead Management, Acquisition, SmrtDialer, Exhausted, Offers Summary, Costs, and Expenses. On top of those sits an Executive Summary funnel that rolls everything up: Leads Generated, then Qualified, then Appointments, then Offers, then Accepted, then Contracts, then Under Contract, then Profit. That single funnel is how you read the health of the whole machine at a glance.
The canonical KPI template and its daily KPI Slack bot now ship inside the DataSift Lead Management plugin. The Slack bot posts the daily summary automatically at 5 PM on weekdays, so the team sees the numbers without anyone pulling a report. The tab walkthrough below still uses the older sheet layout while the new template gets published.
Start Here
The orientation tab. Fill in your company name, operator name, and the date you are starting to track. This tab also includes instructions for navigating the sheet and what each color code means.
Do this first. It takes 2 minutes and sets the context for every other tab.
Goals & Setup
This is where you enter your revenue targets, average deal size, close rate, and other core assumptions. The sheet uses these numbers to reverse-engineer your daily and weekly activity targets across every role.
Get these right, and every downstream tab makes sense. Get them wrong, and you are tracking toward a fantasy.
Expenses
Monthly expense tracking by category: tech stack, marketing spend, team costs, and overhead. Every dollar you spend should be traceable to a specific function in your business.
For a deeper interactive expense analysis with live margin calculations, see the Company Audit tool.
Monthly Data
The aggregate view. Total leads generated, appointments set, contracts signed, and revenue closed, all rolled up by month. This is your monthly report card.
Update this at month end. Compare to your Goals tab targets. The gap between goal and actual tells you exactly where to focus next month.
Dashboard
The visual summary. Charts and graphs that show whether you are on pace this month. This is what you pull up in your weekly team meeting to show where you stand.
Green means on track. Red means behind. The dashboard removes subjectivity from the "how are we doing?" question.
Review Dashboard
Deeper analysis: month-over-month trends, conversion rate tracking, and cost per lead over time. The Dashboard tab shows this month. This tab shows the trajectory.
Use this in your monthly review to spot trends before they become problems. A declining conversion rate caught early is a training issue. Caught late, it is a revenue crisis.
Cold Caller / Prospector Tracker
Daily tracking for every caller on your team. Dials, talk time, conversations, appointments set, leads generated. This is the accountability layer that keeps your pipeline full.
Callers update their own numbers at end of day. Weekly target: 5,500+ dials minimum per caller.
Blue columns (Dials, Leads, DNC) come from the dialer system. Callers cannot inflate these. Yellow columns (Time Spent, Campaign) are self-reported. This separation prevents gaming.
Lead Manager Tracker
Daily and weekly reporting for lead managers. Dials made (150/day floor), conversations (25/day), conversation rate (15-20%), leads Sent to Acquisitions (2-5/day, the money metric), same-day contact on new leads (100%), and leads missing tasks (0).
The lead manager is the bridge between your callers and your closers. Sent to Acquisitions is the number that matters. If dials are high but Sent to AQS is low, the problem is follow-up speed or qualification quality. If the conversation rate drops below 15%, the list or the numbers are the issue.
Transactions
Deal-by-deal tracking: property address, purchase price, rehab estimate, ARV, projected profit, and current status. Every contract from signed to closed lives here.
This is how you track projected vs actual profit and measure your deal analysis accuracy over time.
Direct Mail
Mail campaign tracking: list name, pieces mailed, date sent, total cost, responses received, and cost per response. Track each campaign individually so you know which lists and which messages perform.
Direct mail is your third touch in the sequential marketing cadence ($0.50-$2.00 per piece). If cost per response is climbing, check your list quality before increasing volume.
Every Seat Has a Scorecard
Different roles, different numbers. Click each role to see their daily targets, weekly benchmarks, and the one metric that matters most.
Cold Caller
150-200 dials/day
Lead Manager
150 dials/day
Closer
5-10 offers/day
Cold Caller / Prospector KPIs
- Dials per day150-200
- Conversations per day5-8
- Appointments set per day3-5
- Weekly dial minimum5,500+
- Hours on dialer per day4-6
- Cost per lead generatedTrack weekly
The one metric: Appointments set per dial hour. This measures efficiency, not just effort. A caller doing 200 dials with 1 appointment is less valuable than one doing 120 dials with 4.
Lead Manager KPIs
- Dials made per day (floor)150
- Conversations per day25
- Conversation rate15-20%
- Sent to Acquisitions (AQS)2-5
- Same-day contact on new leads100%
- Leads missing tasks0
- Speed to first contact (new inbound)< 1 minute
The one metric: Sent to Acquisitions (AQS), the money metric. 2-5 a day is the goal. 150 dials is a floor, not a target. If the conversation rate falls below 15%, you have a list or number quality problem, not an effort problem. Speed to first contact still matters: 400% higher conversion when you respond within 1 minute.
Closer / Acquisitions KPIs
- Offers per day5-10
- Hot leads contactedWithin 1 hour
- Contracts signed per weekTrack weekly
- Offer-to-contract rate25%+ target
- Projected profit per dealTrack per deal
- Days to closeTrack average
The one metric: Offer-to-contract ratio. If it is below 20%, your comps are off or your offers are too aggressive. Use the comping workflow to tighten your valuations.
The Tally Counter Method
Your callers cannot track dials in a spreadsheet while they are dialing. They need something that takes zero seconds.
The Tally Counter app is a free Chrome extension that puts physical-style counters on screen. One tap per dial. One tap per conversation. One tap per appointment. Zero friction. Transfer to the KPI Sheet at end of day.
Install Tally Counter
Sign up at tallycount.app and add the Chrome extension. Free to use.
Create Your Counters
Set up counters for: Dials, Correct Numbers, Conversations, and Appointments. Each caller gets their own set.
Transfer at End of Day (Daily, Never Weekly)
Before logging off, enter your Tally Counter numbers into the Cold Caller Tracker tab of the KPI Sheet. Do this every single day, never batch a whole week at once. Reset counters. Repeat tomorrow.
Tally Counter Chrome extension with custom counters for dial tracking.
Do This
Use a zero-friction counter (Tally Counter app, physical clicker, or dialer auto-count). Track at the point of action.
Not This
Ask callers to alt-tab to a spreadsheet after every call. They will stop doing it by day 3 and your data goes dark.
Tally counts are self-reported, so put two guardrails on them. First, transfer the numbers to the sheet daily, never weekly. A week-old count is a guess, and guesses kill the trust the whole system runs on. Second, sanity-check every count against DataSift. Conversations can never exceed dials. Every lead Sent to Acquisitions should trace back to a record that actually moved in the CRM. If the tally and the platform disagree, the platform wins.
Your CRM Already Tracks This
DataSift's built-in dashboards are solid. Real-time pipeline health, team activity, deal progress. Zero setup, zero manual entry. More reports are being added over time. But dashboards show you the what. The Google Sheet forces you to sit with the why.
DataSift dashboard: pipeline overview and team activity.
DataSift dashboard: deal progress and reporting.
Google Sheet KPI Tracker
- Full control over formulas and layout
- Custom conversion ratios and benchmarks
- Manual entry = built-in accountability. You can't type "47 dials" without knowing it should have been 150
- Historical data you own forever
- Works for any team size, any market
Best for: strategic planning, goal-setting, team reviews, and long-term trend analysis.
DataSift Platform Dashboards
- Real-time data with zero manual entry
- Auto-tracks CRM activity (calls, status changes, tasks)
- Team-wide visibility without sharing spreadsheets
- New reports being added regularly
Best for: daily pulse checks, real-time team monitoring, and CRM activity verification.
Use both. DataSift dashboards are your real-time pulse check during the workday. The KPI Sheet is your command center for strategy and goal-setting. But here is the thing most people miss: when a number auto-populates on a dashboard, you glance at it. When you manually type that number into a spreadsheet, you feel it. That constant feel for your numbers is the accountability layer no automation can replicate. The operators who scale fastest are the ones who still hand-enter their KPIs even after they have dashboards that could do it for them.
Build a Live KPI Dashboard
You do not have to build charts by hand. Paste one prompt into Claude Cowork (or your SiftStack workspace), connect Google Drive, and Claude builds a live dashboard artifact that re-reads your KPI sheet every time you open it. The numbers stay current. Setup takes about two minutes.
Before you paste: open a new Cowork chat (or SiftStack), turn on the Google Drive connector, and confirm your KPI sheet (for example the "DataSift REI KPI Sheet") lives in your Drive. Then drop in the prompt below and send it. Not named with "KPI"? Just tell Claude the exact file name.
What it builds
One self-contained dashboard with nine live panels, every number computed from your own sheet:
1. Goal-Attainment Gauge
A radial ring showing closed revenue against your annual goal, an annualized run-rate projection, and a deals-to-goal counter.
2. North-Star Cards
Closed Revenue, Pipeline, Deals Closed, and Marketing ROI, each with an inline sparkline and a target status pill.
3. Path to Goal
Cumulative closed revenue plotted against an even monthly goal-pace line, so you see ahead or behind at a glance.
4. 8-Stage Funnel
Dials through Closed with stage-to-stage drop-off and headline rates: Dial-to-Deal, Lead-to-Contract, Offer-to-Contract.
5. Unit Economics
Cost per lead, qualified, contract, and closed deal, plus revenue per deal, revenue per dial, and net profit.
6. Monthly Trend
An interactive chart with chips to switch the metric and a 3-month moving-average overlay. It remembers your last view.
7. Marketing Efficiency
Spend against closed revenue on a dual axis, plus a monthly ROAS bar chart that flags below-average months.
8. Efficiency Ratios
Your conversion ratios against target, with benchmark bars and color-coded status.
9. Full Monthly Table
Every metric, January through December, with totals and targets in one clean grid.
The prompt
Build me a live artifact dashboard from my KPI spreadsheet in Google Drive. Step 1: Find the sheet. Search my Google Drive for my KPI spreadsheet (look for a file with "KPI" in the title). If you find more than one, show me the matches and ask which to use before continuing. Prefer the native Google Sheet over any .xlsx copy. Step 2: Learn its shape. Read the file's contents and identify these tables so you build the parser around the actual layout, not assumptions: - A Goals & Setup table (Annual Revenue Goal, Average Deal Size, Close Rate, and conversion ratios). - A Monthly Data table with one row per metric and columns Jan-Dec plus Total and Target. Metrics include: Dials Made, Correct Numbers, Leads Generated, Leads Qualified, Offer Appointments, Offers Made, Contracts Signed, Booked Revenue, Closed Deals, Closed Revenue, Marketing Spend. - A Dashboard area with a Scorecard (Metric / Actual / Target / % of Target / Status / Gap), Efficiency Ratios (Ratio / Your Value / Target / Status), and a Financial Summary. Step 3: Probe the connector. Call the Google Drive "read file content" tool once on my sheet and look at the real response shape, then write the artifact's parser to handle whatever that tool returns (string, fileContent, or an MCP content array). The sheet comes back as markdown tables, so parse them into blocks and pick each table by its header signature so the dashboard stays accurate if rows move. Step 4: Build a live artifact (not a one-off chart) that re-reads the sheet from Google Drive every time it opens, using window.cowork.callMcpTool with the read-file tool and my file's ID. All numbers must be computed live from the parsed data, never hard-coded. Include: 1. A goal-attainment gauge (radial ring) showing % of Closed Revenue against the annual goal, with an annualized run-rate projection (average of active months x 12) and a "deals to goal" counter. 2. North-star metric cards (Closed Revenue, Pipeline/Booked, Deals Closed, Marketing ROI), each with an inline SVG sparkline and a target/status pill. 3. A "Path to Goal" chart: cumulative closed revenue against an even monthly goal-pace line. 4. An 8-stage conversion funnel (Dials, Right Party, Leads, Qualified, Appointments, Offers, Contracts, Closed) with stage-to-stage drop-off %, compressed bar widths so every stage is visible, and headline rates: Dial-to-Deal, Lead-to-Contract, Offer-to-Contract, and contract close rate. 5. Unit economics cards: cost per lead, qualified, contract, and closed deal; revenue per deal; revenue per dial; net profit; and marketing spend as % of revenue. 6. An interactive monthly trend chart with chips to switch the displayed metric (Closed Rev, Booked, Leads, Dials, Offers, Contracts, Spend) and a 3-month moving-average overlay. Remember my last selected metric. 7. Marketing efficiency: a spend-vs-closed-revenue dual-axis chart and a monthly ROAS bar chart that flags below-average months. 8. An efficiency-ratios table with actual-vs-target benchmark bars and colored status. 9. A full monthly performance table (every metric, Jan-Dec, with totals and targets). Design: make it world-class and modern, a clean light-mode analytics aesthetic with a sticky header, layered soft shadows, gradient accents on the gauge and sparklines, refined typography with tabular-aligned numbers, hover states on cards, and a subtle reveal animation. Use Chart.js (from the allowed CDN with its integrity tag) for charts and inline SVG for sparklines and the gauge. Keep everything in a single self-contained HTML file, design for light mode, and handle loading and error states gracefully. Link back to the source Google Sheet in the footer. When it is done, save it as a live artifact I can re-open, and tell me how to point it at a different sheet later.
Tips
- Different metrics? The prompt adapts to whatever rows your sheet has. Add or remove metrics by editing the list in Step 2.
- Want a daily summary too? After it builds, ask:
Schedule a short summary of these KPIs to run every weekday morning. - Switching sheets later? Just say:
Point the KPI dashboard at [file name] instead. - SiftStack users: the same prompt runs inside your SiftStack workspace. Confirm the Google Drive connector is enabled there too.
Daily, Weekly, Monthly
KPIs without a review cadence are just numbers in a spreadsheet. This checklist is how you turn data into action.
Daily
Quick pulse check before the team starts dialing
Weekly
Team review: what worked, what stalled, what changes
Monthly
Full audit: cost per contract, margin, goal adjustment
For teams of 3+, set up daily automated check-ins in Basecamp or Slack asking "Did you post your KPIs?" Low-friction accountability. Optional but powerful: connect your KPI Sheet to DataBox ($50+/mo) for real-time dashboard visualization that updates every 5 minutes.
Your KPI Priorities by Blueprint
Not every blueprint tracks the same metrics. Your business type determines which KPIs matter most right now.
Blueprint A: Launchpad
You are the operator doing everything. Your KPI focus is simple: dials and conversations. You are building the data that tells you whether this business model works in your market.
- Primary KPI: Cost per conversation
- Track daily: Your own dials, conversations, appointments
- Track weekly: Cost per lead (marketing spend / leads generated)
- Goal: Establish your baseline conversion rates before hiring
You are the caller, the lead manager, and the closer. Track everything yourself so you know what "good" looks like before handing it off.
Blueprint B: Optimizer
You are time-poor and capital-rich. Your first hires are Data Manager ($500-$700/mo) + Lead Manager ($2,000-$3,000/mo) simultaneously. You compress the Replacement Ladder because you need someone answering the phone 9-5 while clean data flows into the CRM.
- Primary KPI: Speed to lead (response time on inbound)
- Track daily: Lead manager response times, follow-up completion
- Track weekly: Offer-to-contract ratio, caller dial counts
- Goal: System runs without you touching it daily
Your team's KPIs matter more than yours. If the lead manager is not responding within 1 minute, leads are dying before they get warm.
Blueprint C: Specialist
Depth over volume. You work fewer leads at higher margins. Your KPIs reflect quality, not quantity.
- Primary KPI: Cost per niche contract
- Track daily: Research hours, decision-makers found
- Track weekly: Niche conversion rate, offers per research hour
- Goal: Highest margin per deal in your market
Lower volume means each lead is more valuable. Track time investment per lead, not just dials. Deep prospecting hours are your leading indicator.
Blueprint D: Scale-Up
Full team, all channels, KPI-driven. You use the entire KPI Sheet. Every role has a scorecard. Every channel has a cost per lead.
- Primary KPI: Profit margin trend (month over month)
- Track daily: All role KPIs via the Caller and Lead Manager tabs
- Track weekly: Conversion rates at every funnel stage, cost per contract
- Goal: 20%+ net margin at scale with predictable monthly revenue
At your scale, one AI-powered virtual system (Claude + Zapier + DataSift) can replace separate Data Manager and Marketing Manager hires. Consolidate and track the savings.
How Dialed In Are Your KPIs?
Rate yourself 1-5 on each dimension. Be honest. The score tells you where to focus first.
KPI Vocabulary
Click any card to flip and read the definition.
KPI
Click to flip
Key Performance Indicator
A measurable value that shows whether you are on track to achieve a specific business objective. Not all metrics are KPIs. Only the ones that connect to your revenue goal qualify.
Leading Indicator
Click to flip
Leading Indicator
A metric that predicts future results. Dials, conversations, and appointments are leading indicators because they come before revenue. Track these to see the future.
Lagging Indicator
Click to flip
Lagging Indicator
A metric that confirms what already happened. Revenue, closed deals, and profit are lagging indicators. By the time they drop, the problem started weeks or months ago.
Cost Per Contract
Click to flip
Cost Per Contract
Total marketing and operational spend divided by contracts signed. The single most important financial KPI. If this number is growing faster than your deal size, your margin is shrinking.
Cost Per Lead
Click to flip
Cost Per Lead
Total marketing spend on a channel divided by leads generated from that channel. Track per channel (SMS, calling, mail) to know which channels are efficient and which are burning cash.
Conversion Rate
Click to flip
Conversion Rate
The percentage of inputs that become outputs at any funnel stage. Dials to conversations, conversations to appointments, offers to contracts. Each stage has its own conversion rate.
Speed to Lead
Click to flip
Speed to Lead
Time between when a lead enters your system and when a human contacts them. Under 1 minute is the target. Responding within 1 minute produces 400% higher conversion than waiting 5 minutes.
Dial-to-Connect Ratio
Click to flip
Dial-to-Connect Ratio
How many dials it takes to reach one person at a correct, working number. Benchmark is 32:1. Phone scoring with Trestle can improve this to 8-10:1 by eliminating dead numbers.
Pipeline Velocity
Click to flip
Pipeline Velocity
How fast leads move through your pipeline stages. Measured in average days from new lead to contract. Faster velocity means shorter cash conversion cycles and more predictable revenue.
Accountability Cadence
Click to flip
Accountability Cadence
The regular schedule for reviewing KPIs and holding team members to their targets. Daily quick checks, weekly team reviews, monthly deep dives. Without a cadence, tracking becomes optional.
Test Your Understanding
Eight questions on KPI frameworks and tracking methodology.
1. What type of indicator is "daily dials"?
2. In reverse-engineering, what do you start with?
3. How many dials typically produce 1 correct number conversation?
4. What is the recommended daily KPI review time?
5. Which KPI matters most for a lead manager?
6. What does "speed to lead" measure?
7. What should you track BEFORE hiring your first caller?
8. Blueprint B operators should prioritize which KPI?
Keep Building
Tools, templates, and companion guides to get your KPI tracking running.
Next live cohort: Monday, July 13 – July 17
5 days live with Ty. 33 interactive modules. Save your seat in the next cohort. Already enrolled? Use this page as your between-session refresher.
DataSift REI KPI Sheet
The Google Sheet template that powers this guide. Make a copy and start tracking.
Tally Counter App
Free Chrome extension for zero-friction daily dial and conversation tracking.
Company Audit Tool
Interactive 4-pillar assessment with 30/60/90 action plan builder. Start here to find your bottleneck.
Deal Flow Tech Stack SOP
Complete tech stack spreadsheet with tools, costs, and setup order by blueprint.
Phone Scoring & Trestle
Cut your dial-to-connect ratio from 32:1 to 8-10:1 by scoring numbers before dialing.
Lead Management & CRM
The 5-part STABM check (Status, Task, Assignee, Board, Messages), temperature as follow-up cadence, and the 4 Pillars of Motivation.
Team Structure & Roles
Role definitions, hiring order, and sequential marketing setup for your team.
Case Studies
Real operator results across all four blueprints. See KPI tracking in action.