6 min readThe Subtraq team

Your client won’t open the spreadsheet. They’ll open a link.

Every start of month, the same half-day — export, paste, format, write the commentary, send. And on the other end, a file skimmed diagonally. The problem isn’t your layout. It’s the format itself, and what it forces the client to do.

There's a ritual common to every agency and freelancer: the monthly report. A spreadsheet, sometimes a presentation, with screenshots, columns, a chart, and a paragraph of commentary written at the end when you're exhausted.

That document is expensive to produce and delivers little — for a reason that has nothing to do with its content.

Three reasons a spreadsheet fails

It puts the burden on the reader. Download, open in the right app, find the right tab, figure out what column E means. Every step loses someone. A client running a business won't go through that to read three numbers.

It's out of date the second you send it. The file freezes a snapshot on the 1st of the month. On the 12th, when the client has questions, they reopen a document that no longer says anything about the current week — and they write to you asking "where do things stand," which means asking you to do the work again.

It proves nothing. A number typed by hand into a cell has no source. That's not a matter of trust — it's that nobody, including you, can trace back from a cell to the data that produced it. The day a number gets challenged, there's nothing to open.

The only question the client is asking

It comes down to four words: how much did it bring in.

Everything else — impressions, reach, engagement rate, new followers — is working material. It's useful to you. It's not what they're looking for, and a page that starts with those indicators is mostly telling them the answer to their question isn't there.

A dashboard is read in seconds or not at all. It needs to give, in order: the dollars earned, the channel that brought them, the link that converted. That's the principle behind the dashboard and client report page.

The six lines that are enough

What you showWhy it's there
Revenue attributed to a placementthe answer to the question
Unattributed revenuethe document's honesty
Distribution spend, alongsidewithout it, no report is possible
Placement rankingswhere to put the budget next
Change from the previous monththe only comparison that matters
The model and window usedso two months are actually comparable

The last row looks technical and is essential. A report that doesn't state which attribution model it applies or what window it uses isn't comparable to anything, not even to itself the following month. Changing these settings mid-quarter without noting it is the best way to lose a careful client's trust — the article on the three models explains what each one changes in the rankings.

Show the unattributed

It's counter-intuitive, and it's what separates a credible report from a brochure.

On any honest setup, some revenue isn't tied to anything: word of mouth, returning customers, branded search. That's unattributed revenue. The instinct is to redistribute it "proportionally" so everything looks measured.

Don't. You're adding an invented amount to each line, and you lose the only guarantee that holds: attributed plus unattributed equals the total collected, to the dollar. A visible gap gets discussed in a meeting; a smoothed number doesn't — until the day the client adds up the rows on a calculator.

And there's a commercial benefit to showing it. Unattributed revenue that decreases month over month is proof of work: it means more sales are now attributable, which means the tracking setup is coming together.

The commentary is you

A dashboard doesn't replace your analysis — it makes it possible in five minutes instead of half a day. The value you're selling was never the formatting of numbers: it's what you conclude from them.

Three sentences are enough, and they always follow the same structure: what moved, why, what we do next month. The rest of the document is there so the client can verify what you're saying without having to take your word for it. That's exactly the role of a consultable document: to support your word, not replace it.

The format change is the real method change.

A page in your name, accessible via a link. Always current, openable on a phone, no software, no account needed. When the client has questions on the 12th, they go back to the page instead of writing to you. That saves time on both sides, and it's what white labeling enables.

Or read-only access to their own workspace, if they want to dig in. They see their links and what those links generated — never your other clients, never your costs, never your internal notes. That's the principle of client workspaces.

The practical difference is enormous: you stop producing a document and start giving access. The monthly work shrinks to the analysis, which is the part you know how to do and that can't be automated.

The end-of-month trap

One last word on timing, because it produces uncomfortable conversations.

A monthly report stops the clock on the last day of the month. But a sale can be attributed to a click that's several weeks old: early next-month sales will therefore credit placements from the previous month, after the report has been sent. The month-end total keeps moving for a while.

Two ways to live with it, and only one that holds. Either you freeze the report and accept that it always slightly underestimates the end of the period — in which case, say so on the document. Or you give always-on access, and the question disappears on its own because the client sees the same live page you do.

What you shouldn't do is send a file on the 1st and then a correction on the 10th. That's the surest way to give the impression that the numbers are negotiable.

Where to start, concretely

  1. One link per placement, before anything else. Without that discipline, no report can name what sold. Three posts, three links.
  2. Connect the tool that collects payment. Without the sale, you're presenting clicks, and you're back to talking about engagement rates.
  3. Set the model and the window, write them on the document, and don't change them mid-quarter. The attribution window article helps with the choice.
  4. Replace the attachment with a link starting next month. Keep the monthly send: the regular touchpoint has value — the file doesn't.
  5. Set an alert for anything that needs to be visible before month end. A collapsing link doesn't announce itself on the 1st — that's what alerts are for.

Questions that come up

"My client wants a PDF — they insist." Give them both. The link for ongoing access, the export for archiving. What matters is that the archived document is no longer the only version available.

"What if I don't have access to their sales?" Then you can't produce a revenue-denominated report, and you need to say so rather than compensating with reach metrics. Access to sales data is a legitimate ask in a performance contract; sales tracking explains how it works.

"How do I compare multiple channels in the same document?" By placing spend next to revenue, channel by channel, using the same model throughout. The traps are detailed in the multi-channel ROAS article and on the ROAS and ad spend page.

"The client will see that not everything is attributed — won't that look bad?" The opposite. A report where everything is perfectly attributed signals a tool that's making things up, and a client who's worked with another agency before will know it.

"Does this work for a solo freelancer?" That's actually where the gain is clearest: the monthly half-day isn't billable to anyone. The freelancers and marketing agencies pages describe both cases.


The full dashboard, in your name and with no account needed for the client, is described on client report. For the mechanics that fill it, it's attribution marketing.

See the method applied to real numbers

Read next

The rest of the method

7 min

We count the visits. Not the visitors.

Measuring a campaign doesn't require identifying anyone. What a tracked link actually records, and who is responsible for what under GDPR.

The monthly letter

One more article. Once a month.

What we published, what we learned building it, and the numbers we can show. No offers, no automated follow-ups.

One letter a month, written by us, with no tracking pixel inside. Your address is used for that and nothing else: it is never sold or shared. Privacy policy · Unsubscribe