It's a plain Google Sheet, nothing remotely fancy, and every client gets a copy of it before the first retainer payment even clears properly. A Brentwood estate agent once said it was more genuinely useful than anything her previous agency had sent in two full years of monthly reports combined, which says more about the industry's reporting standards than it does about our spreadsheet, honestly.
Tab One: What You're Actually Paying For, Month by Month
Not a generic service list — a proper month-by-month plan showing what we expect to be doing specifically in month one versus month six versus month eleven. Content production ramps up differently from technical work, and link building ramps differently again on its own schedule. Seeing it laid out like this stops the "what am I even paying for this month" question before it even starts, because the answer's already sitting right there in a cell they can check whenever they like. It's not a static plan either — if an early finding changes the roadmap, we update the tab and flag the change, rather than quietly deviating from it without comment.
Tab Two: Baseline Numbers, Captured Before Anything Changes
Traffic, rankings on priority terms, Google Business Profile views, call volume where relevant — all frozen as of day one, before any work begins. We've learned the hard way that skipping this step causes real arguments later down the line. Without a properly documented baseline, a client six months in genuinely can't remember what things looked like before everything improved, and the improvement feels far less real than it actually is. One Brentwood client was convinced nothing had changed until we pulled up her own baseline tab and showed her organic traffic had gone from 340 to 1,150 monthly sessions in that time. Our approach to SEO reporting for Essex clients is built around that same principle — document the starting point properly, or nobody can trust the finish line.
Tab Three: The Keyword List, With Honest Difficulty Ratings
Every target keyword, tagged clearly as easy, moderate, or hard based on real competitive analysis, never on wishful thinking dressed up as strategy. We've seen other agencies hand clients a list of fifty keywords with no indication whatsoever that forty of them are essentially unwinnable within the budget actually being paid. Ours is deliberately shorter, usually fifteen to twenty-five terms total, each one realistically achievable within the contract period agreed. Shorter, honest lists genuinely beat long, flattering ones every single time.
A Brentwood florist initially pushed back on this, wanting a longer list that "looked more ambitious" for her own records. We kept it at eighteen terms and explained why: chasing fifty would have meant spreading a limited monthly budget so thin that none of them moved meaningfully, which helps nobody and just produces a flat line across the board by month six.
Tab Four: A Running Log of Every Technical Fix
Dated, specific, admittedly boring to read, but genuinely useful nonetheless. "Fixed canonical tag conflict on 14 product pages, March 12th" isn't exciting copy for a glossy report cover, but it's exactly the kind of granular detail that matters when a client's accountant eventually asks what the money's actually been buying all this time. We'd rather hand over a slightly dull spreadsheet entry than a vague sentence about "ongoing technical optimisation" that means nothing concrete.
Some months this log runs to thirty entries. Some months it runs to four. Both are honest reflections of the actual work that happened, which is exactly the point — a log that always shows the same volume of activity every single month, suspiciously evenly spread, is usually a sign it's being padded rather than genuinely recorded.
Tab Five: Review Dates, Set Well in Advance
Quarterly review meetings, scheduled on day one rather than arranged reactively whenever someone eventually remembers to book one. This small thing matters more than it might sound at first — agencies that only talk to clients when something's gone badly wrong train those clients to associate contact itself with bad news. Scheduled reviews, good month or bad month, keep the relationship honest on both sides of the table. It also means nobody's chasing a diary slot during a genuinely busy period, which happens more often than it should when meetings get arranged reactively.
We've sat in enough of these quarterly reviews now to notice a pattern. The clients who read the spreadsheet between meetings, not just during them, tend to stay longer and trust the process more. The ones who never open it tend to be the ones who panic at month four. We can't force anyone to look at their own numbers, but we try to make it hard to avoid doing so by accident.
Why We Built It This Way in the First Place
Frankly, because early on we didn't have anything like this at all, and client relationships suffered for exactly the reasons listed above — fuzzy expectations, no baseline, vague keyword promises, purely reactive communication. The spreadsheet isn't glamorous marketing material by any stretch. It's a direct response to our own past mistakes, made visible to every client so they're not simply trusting us blind. More on how this fits into our broader reporting approach sits on the page detailing our SEO process for Essex clients.
What Clients Actually Say About It, Honestly
Most say surprisingly little about it in the moment — it's a spreadsheet after all, not a fireworks display designed to impress. The real appreciation usually surfaces around month five or six, when someone references a number from tab two in a meeting with their own team and realises they actually have genuine evidence sitting there, not just a vague feeling about whether things are improving. By that point it's stopped feeling like paperwork and started feeling like proof they can actually point to, which is more valuable to most business owners than any amount of upfront reassurance from us could ever be. We'll take a quiet spreadsheet over a confident sales pitch every single time, and most clients, once they've lived with both, tend to agree with us on that. It's unlikely to ever win us a design award, but that was never really the point of building it in the first place. The point was always trust, and plain, checkable numbers earn more of that over a year than any polished dashboard interface ever has in our experience working with Essex clients across very different sectors, from boatyards to kitchen fitters to local solicitors, none of whom had much patience for jargon dressed up as genuine insight when a plain, ordinary sentence would have done exactly the same job just as well, and probably a bit faster too, without anyone needing to reach for a dictionary halfway through reading it quietly at their own kitchen table.
The Bottom Line
A spreadsheet sounds like a fairly small thing to build an entire invoice process around, but it solves the actual problem that sinks most agency relationships eventually: nobody wrote down what was promised, or what things genuinely looked like beforehand. Every Brentwood client gets one because the alternative — trusting memory and vibes six months later — has never once worked out well for anybody involved. It's boring by design, and that's precisely why it works. Clients occasionally ask if we'd ever drop it for a flashier dashboard tool instead. We've looked at a few. None have beaten a plain spreadsheet for the simple reason that a client can open it on any device, without a login, without an app update, five years from now if they wanted to. The fanciest dashboard tool is still only as honest as the data someone decides to put into it, and a shared spreadsheet makes it genuinely harder to quietly leave something out.
Looking for SEO agency in Essex?
Let's talk about what your business actually needs
Digital Impact Ventures provides SEO, AI visibility and digital marketing support for businesses across Colchester and Essex. Get in touch and we will talk through where your business is now and where it needs to go.