Case study · October 2026 to November 2026

The owner sees calls, leads, sales and the books on one page, and knows when a number is old

The owner of an insurance brokerage runs a busy office. Calls all day, leads from ads and the website, new policies, producers paid on commission, and books kept by a bookkeeper. This fall the owner asked me for one current view of all of it, to see on any given day whether the business and the team were on track.

1 page Calls, leads, speed to lead, sales from ads, ad spend and the books Owner-only, two people can open it · each source read on a schedule and dated on the page · live Oct to Nov 2026

Commercial insurance brokerage

Insurance · Owner reporting October 2026 to November 2026

The problem

The owner of an insurance brokerage runs a busy office. Calls all day, leads from ads and the website, new policies, producers paid on commission, and books kept by a bookkeeper. This fall the owner asked me for one current view of all of it, to see on any given day whether the business and the team were on track. The answers existed. They were just spread across five places. The phone system, the ad accounts, a monthly lead report, the bookkeeper's spreadsheets and QuickBooks. Most of it reached the owner as reports, a weekly call report and a monthly lead report.

What I found

The office already kept the records. The bookkeeper's sales log and the producers' commission statements held the year's sales, one row each. The phone system logged every call. The ad accounts and the lead report held the leads and which of them bought. Nobody had to type in anything new. Putting it all on one page came with two risks. The first was a page that goes stale without anyone noticing. A lost permission or a renamed spreadsheet could leave last week's figures sitting there looking like today's. The second was two copies of one number. If the page and the monthly report each did their own math, sooner or later they'd disagree, and the owner wouldn't know which one to believe.

What we did

I built one page for the owner. Two people can open it, the owner and me. It puts these side by side. - Calls. How many came in, who answered, and a flag on any phone that's refusing calls. - Leads and speed to lead. Each lead from the ads and the website, and how soon somebody called it back. - Sales from ads. New policies matched back to the ads and pages that produced them. - Ad spend, set against what those sales brought in. - The books. The year's sales, what each producer's book brings the house, and cash, each shown with the day it was read. Each source gets read on its own schedule, and the page says how fresh it is. The books section opens with "Figures as of" and the day. If the last read failed, it says so in amber, with the reason and the day the figures are from. After ten days without a new read, it greys out. A read that fails or never runs also alerts my team. The books get read each morning through a read-only connection that can read the bookkeeper's files and nothing else. Before trusting it, we checked that it produced exactly what the hand-checked read had produced. Then we broke it on purpose four ways. A wrong password, two columns swapped, a renamed folder and the wrong folder. Each time it stopped and raised the alarm instead of posting a wrong number. The page and the reports share their facts. The marketing panel gets filled from the same reviewed facts as the monthly lead report, and the update gets refused if the two disagree. The phone panel sorts calls by the same rules as the owner's weekly call report. On the two past weeks we compared, the counts matched exactly.

The numbers

The owner opens one page and sees each part of the business with the day it was read. One example shows why the phone panel is there. The weekly call report showed that one person's phones had stopped ringing, while every setting read on. The cause was the desk phone answering "busy" the second a call reached it, which also killed the ring on that person's apps. Broken equipment. Nobody was dodging calls. It had gone on for seven weeks. The phone panel checks each phone daily now. Run over the stored call logs, it would've flagged that phone about a day and a half after it started refusing calls.

What I can't show yet

The page gives the owner a faster, dated view. I haven't measured whether it changes the owner's decisions or results. Not every panel shows its own age yet either. The books section does, while the lead panels alert my team instead of telling the owner on the page.

Result table

The receipts.

Metric Value Source
Calls by day, by person and team, plus phones refusing calls Daily, from the phone system's call log Phone panel, live 2026-11-10
Leads and how soon each got a call back Daily, from the ad accounts' lead forms and the website form Speed-to-lead panel, live 2026-10-19
New sales matched to the ads that produced them With each monthly lead report, from its reviewed facts Marketing panel, live 2026-10-27
Sales, what each book brings the house, cash Each morning from the bookkeeper's workbooks. Cash from a dated read of the books Owner section, live 2026-11-06. Morning read from 2026-11-10
A desk phone refusing calls Would have been flagged after about 38 hours instead of seven weeks Stored call logs, check run after the fact

Try one question. Are we on pace this month, and are the ads paying for themselves? If answering that takes more than one login or one email, ask me what a single page would read from the systems you already use. [Talk to me at No Brainer Media](https://nobrainersmma.com/contact/).

Want this kind of result?

Book a discovery call. We'll walk your numbers.

No pitch deck. Just your CRM, your ad accounts, and a straight read on what the next 90 days could look like.