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.
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/).