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 operators 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)
32 dials to reach 1 person at a correct, working number who will talk. Trestle phone scoring cuts that ratio by killing dead numbers before you dial. Real two-way conversations should run 15-20% of dials. Below 15% means a list or number problem, not effort.
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. Tabs: Leads Summary, First to Market, Lead Management, Acquisition, SmrtDialer, Exhausted, Offers Summary, Costs, and Expenses. An Executive Summary funnel rolls it up: Leads Generated, Qualified, Appointments, Offers, Accepted, Contracts, Under Contract, Profit. One funnel, whole machine at a glance.
The template and its daily KPI Slack bot ship inside the DataSift Lead Management plugin. The bot posts the summary at 5 PM on weekdays. The walkthrough below still shows 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 bridges callers and closers. Sent to Acquisitions is the number that matters. High dials but low Sent to AQS points to follow-up speed or qualification quality. Conversation rate below 15% means a list or number quality problem.
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. Conversation rate below 15% means a list or number problem, not effort. Respond within 1 minute: 400% higher conversion.
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 guard them twice. Transfer numbers to the sheet daily, never weekly: a week-old count is a guess. And sanity-check against DataSift: conversations can never exceed dials. When tally and platform disagree, the platform wins.
Your CRM Already Tracks This
DataSift's dashboards are solid: real-time pipeline health, zero manual entry. But dashboards show the what. The sheet makes you 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. Dashboards are the real-time pulse check, the sheet is the command center. Here is what most people miss: an auto-populated number gets a glance. A number you type by hand, you feel. That feel is the accountability layer no automation can replicate.
Build a Live KPI Dashboard
Paste one prompt into Claude Cowork (or SiftStack), connect Google Drive, and Claude builds a live dashboard that re-reads your KPI sheet. Two-minute setup.
Before you paste: open a new Cowork chat (or SiftStack) and turn on the Google Drive connector. Confirm your KPI sheet (for example the "DataSift REI KPI Sheet") lives in your Drive. Then send the prompt below.
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.
KPI Engine Claude Skill
Add it to your SiftStack and skip the manual pull. Claude logs into DataSift, reads your activity log, and grades every caller. Dials, correct numbers, leads, funnel pacing, Excel workbooks, and a daily Slack digest. Download the skill →
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 Phase
Each phase of the Deal Flow Ladder tracks different metrics. Your phase determines which KPIs matter most right now.
Phase 1: The Operator (open the phase page)
You are the operator doing everything: one county, one list, sequential marketing live. Your KPI focus is simple: dials and conversations. You are building the data that tells you whether this market works.
- 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.
Phase 2: The Delegator (open the phase page)
You multiply touches and move data and admin off your plate. If capital lets you compress and a Lead Manager answers the phone 9-5, their response time becomes your number one metric.
- Primary KPI: Speed to lead (response time on inbound)
- Track daily: Follow-up completion, response times on new leads
- Track weekly: Offer-to-contract ratio, dial counts
- Goal: System runs without you touching it daily
Your team's KPIs matter more than yours. If new leads are not getting a response within 1 minute, they are dying before they get warm.
Phase 3: The Manager (open the phase page)
You scale the team on overflow. Every role has a scorecard. Every channel has a cost per lead. The full KPI Sheet earns its keep here.
- Primary KPI: Cost per contract
- Track daily: All role KPIs via the Caller and Lead Manager tabs
- Track weekly: Conversion rates at every funnel stage
- Goal: Every seat hits its scorecard before you fill the next one
Overflow triggers each next hire. The scorecards tell you when a seat is full and when it is time for the next rung.
Phase 4: The Owner (open the phase page)
You own the machine and deep-prospect every unreached door. Depth over volume: fewer leads, higher margins. Your KPIs reflect quality and the health of the whole system.
- Primary KPI: Profit margin trend (month over month)
- Track daily: Research hours, decision-makers found
- Track weekly: Niche conversion rate, offers per research hour, cost per contract
- Goal: 20%+ net margin with predictable monthly revenue, then clone the machine into the next market
Deep prospecting hours are your leading indicator. At this 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.
Keep Building
Tools, templates, and companion guides to get your KPI tracking running.
5-Day Deal Flow Challenge
Next live cohort: Monday, August 24 to August 28
5 days live with Ty. 34 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.
KPI Engine Claude Skill
Claude pulls and grades your calling KPIs straight from DataSift, with Excel and Slack digest output.
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.
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 at every phase of the ladder. See KPI tracking in action.