In partnership with
Your company's whole history is already in the cloud. You just can't get to it.
Five years of jobs, invoices, and lead sources sit inside your field software, where you can look at them one screen at a time. You can't ask them a single question.
This week is about what you get once that history is yours and in order. The payoff shows up twice: the day you sell, and the next time you set an ad budget.
In this issue:
Owning your data only pays once it's organized
A one-afternoon test of what your records can answer
What a buyer asks that a folder of PDFs can't answer
Your meetings, inside Claude and ChatGPT
Last week's customer call has the details your proposal needs. Right now they're buried in notes nobody can find.
Wispr Flow Notetaker captures your meetings with names, numbers, and product terms spelled right, then brings them into Claude or ChatGPT through a built-in connector. Ask Claude to draft the proposal from your last three calls with a prospect, or pull together what the deal team said about pricing this quarter.
Need something from a call in March? Ask one question across every meeting you've had and get the answer with citations. Get Wispr Flow Notetaker, free to try on Mac and Windows.
— & —
IN THE KNOW
The short version: Getting your data out of the vendor's software is the easy part, and on its own it's worth very little. The value shows up when it's organized into one history you can ask questions of, because a buyer and your ad budget both need exactly that.
Your data already lives in the cloud, just out of your reach
Housecall Pro runs in the cloud. So do ServiceTitan and QuickBooks Online.
You already trust the cloud with your whole company. You just don't hold the keys to any of it.
So step one is short, and it needs no new software. Once a month, export the records into a OneDrive or Google Drive folder in the company's name. Housecall Pro exports customers and jobs, Jobber exports clients, invoices, and quotes, and ServiceTitan exports its reports to Excel.
That's ownership, and it's worth doing. On its own, it answers nothing.
A folder of monthly files is still just a pile. Monthly exports overlap, so a job that closes in March and gets edited in April shows up in both files with two totals. The same customer gets entered twice.
And the pile is split. Your jobs live in your field software, your payments live in QuickBooks, and your ad spend lives somewhere else.
Organized records answer the questions you haven't asked yet
Organizing it means each job, customer, and invoice shows up once, in its latest version. It means a job in your field software lines up with its payment in QuickBooks. And it means the whole thing lands in one place built to answer questions.
Getting it there is real data work. At my day job we run on big platforms, but the organized records underneath belong to us.
Once your records are in order, you stop pulling reports and start asking. Type "which customers spent the most with us over the last three years" and AI answers straight from your own records.
Ask how many customers came back for a second job. Ask which month your average ticket peaked, or which crew's jobs get called back. There's no report to build and no spreadsheet to stitch together.
A PDF of last month's revenue answers one question forever. Organized records answer the questions you haven't thought of yet.
A buyer and your ad budget ask the same kind of question
Picture a buyer three years from now. They ask what share of revenue came from repeat customers. They ask which services carry the margin, and how much of the business hangs on one big account.
Hand them a folder of PDFs and you're digging for weeks. Answer on the spot, straight from your records, and you look like a business that runs on facts. That's worth something at the closing table.
The same records settle your ad budget long before you sell. Ask which lead source produced jobs that actually got paid, and what each one cost you.
Your ad platform counts a form fill as a win. Your organized records count the deposit.
Owning your data is the start, and organized data is what you sell.
— & —
MAKE IT MODERN
Run this lead source test in one afternoon. It shows you what two organized files can answer.
Export last year's jobs from your field software, with lead source and job total. If the export won't include lead source, that's your first finding.
Export last year's payments from QuickBooks as a spreadsheet.
Put both in one Google Sheet, one tab each. Delete phone numbers and emails first.
Paste both tabs into ChatGPT or Claude with this prompt:
Tab 1 is every job from last year, with lead source and job total.
Tab 2 is every payment from last year.
Match payments to jobs by customer name and invoice number.
For each lead source, show: number of jobs, total billed, total paid,
and jobs with no matching payment.
List anything you couldn't match. Don't guess.Read the unmatched list first. That list is the mess your systems leave you, and it's what organizing fixes. If two files answer this in an afternoon, picture five years organized in one place.
— & —
FROM THE STOICS
Nothing, Lucilius, is ours, except time.
- Seneca
He knew how easily the things we hold slip away. Your history only counts as yours once you can put it to work.
— & —
BEFORE YOU GO
If you want help putting years of your records in order, reply "diagnostic" and I'll send the details.
P.S. Google keeps about 16 months of your search data and 18 months of your profile data. That history expires on its own, and next week I'll show you how to keep it.
