Run link building across every client, from one workspace

Here is the version we hear most often. An agency lands its fifth retainer. The link building sheet that worked fine for two clients now has eleven tabs, three colors of conditional formatting nobody remembers the rule for, and a balance column that broke when someone inserted a row. The account manager who set it up has left. Reporting week arrives and two people spend a full day checking whether last quarter's placements are still live, because the honest answer is that nobody knows.

An agency's real moat is its supplier database. A per-client spreadsheet structure guarantees you never build one.

The links themselves are fine. Mostly. Some of them got removed during a site redesign, one turned into a nofollow when the publisher changed their outbound policy, and two partners quietly stopped returning links in February. None of that shows up in a sheet, because a sheet records what you typed, not what is true on the web right now. That gap is where agency margin goes.

The second problem is subtler and more expensive. When suppliers live in per-client tabs, the agency loses the one asset it has been building the whole time: a qualified partner database. Every new client starts from a cold list. Two account managers email the same editor a week apart. A partner who never reciprocates for Client A gets pitched again for Client C, because the note explaining why they were dropped lived in a tab nobody opens anymore.

So the fix is not a better spreadsheet, and it is not more discipline from the team. It is separating two things that a sheet forces together: the client deliverable, which has to be isolated per retainer, and the supplier intelligence, which is worth far more when it is shared across every retainer you run.

Most agency link reports are bad in the same specific way: they report activity instead of inventory. Twelve links built this month, here are the URLs, thanks for your business. That answers the wrong question. The client wants to know what their total link asset looks like now, whether it grew, what happened to the placements they paid for last year, and why the number moved.

A report worth sending shows four things. Total live links at the start and end of the period, so growth is visible. Links added, with the anchor, target URL, and referring domain for each. Links lost, which is the section everyone is tempted to omit and the one that builds the most trust, because the client will eventually find out anyway. And recovery activity, showing which of those losses you chased and what came back.

That last section changes the tone of the whole relationship. An agency that reports six lost placements and four recoveries looks like it is paying attention. An agency that reports only wins looks fine until the client runs their own audit and finds nine dead links nobody mentioned. We have seen that conversation end retainers.

Return link balance belongs in the client report too, at least for any client whose strategy involves exchanges, and the mechanics of computing it are worth reading before you present one. It is the cleanest way to explain why you paused outreach to a partner the client keeps asking about, and it turns an awkward judgment call into a number on a page.