The week a new client signs is usually spent on the things that feel urgent: kickoff decks, trafficking sheets, getting the first line items live. Reporting goes on the list as a task for later, somewhere around day five, framed as “pull the export and fill the template.” That framing is the problem. Client reporting onboarding is not a production job you do once the campaign is live. It is a set of decisions about that account that will hold for as long as the account does.
Whatever you improvise in week one becomes the convention. If you put CTR as the first tile because it was the first column in the export, CTR is now the headline metric for that client, and in month four you will be explaining a CTR dip on a campaign that was bought on reach. If you send the link to one marketing manager because that was the only email in the contract, you will be forwarding reports manually to a procurement team you did not know existed. If the first report goes out on a Wednesday, Wednesday is the day, and six months later someone is working late on a Tuesday to protect a deadline nobody ever chose.
None of that needs fixing later if roughly four decisions get made before report one ships. They take an hour between them, and they are all easier to make while there is no performance data to be defensive about.
Report one tests your client reporting onboarding, not your dashboard
Agencies tend to judge report one by how it looks. The client looks at something else: whether the numbers match what they were promised in the media plan, whether the report answers the question they will be asked internally, and whether they can find it again next month without digging through email.
Those three things are all setup, not design. A beautiful report that shows net spend when the client’s finance team works in gross spend will generate a correction email within a day. A plain report with the right spend definition, the right recipients and a predictable location will not.
So treat report one as a dry run of the account’s reporting process rather than as a deliverable. Build it, send it internally to whoever runs the account, and check it against the signed media plan before the client ever sees it. If the totals do not reconcile with the plan, you want to find that out in week one, when the honest answer is “the plan used a different date range” and not “we have been reporting the wrong number since launch.”
Definitions get agreed before there is data to argue about
Every metric in your report has at least two plausible definitions, and the client has one of them in their head. Conversions can mean platform-attributed or last-click in GA4. Spend can be media cost or media cost plus fees. Reach can be deduplicated across platforms or summed per channel, which are different numbers and only one of them is honest. VTR can be built on 100% completions or on a 75% threshold, depending on the platform you pulled it from.
Pick the definition once, write it in a single shared paragraph, and put it where the client can find it later. Three or four lines is enough:
- Spend is net media investment, excluding agency fees, taken from the platform export.
- Conversions are platform-attributed, 30-day click and 1-day view.
- Reach is reported per platform and not summed across platforms.
- CPM, CPC, CTR and VTR are calculated from totals for the period, never averaged across rows.
That last point matters more than it sounds. A rate averaged over daily rows gives a different answer from the same rate computed on period totals, and the gap grows when daily spend is uneven. If a client ever rebuilds your CTR in a spreadsheet and gets a different number, this is usually why. There is a longer treatment of where to put these definitions so they actually get read in the glossary placement piece, but for onboarding, the point is only that the definitions exist on paper before the campaign has results worth arguing over.
Who gets the link, and what they are allowed to see
Ask for the distribution list in the kickoff call, not after the first report. You want to know three things: who receives it, who else will be forwarded it, and whether anyone on the client side is not allowed to see cost data.
That last one catches people out. On a retail or franchise account, regional managers often get the performance view while media cost stays with head office. On a client with a procurement function, someone will eventually ask how the link is protected and whether it can be revoked, and that question tends to arrive from an IT or security contact rather than your marketing stakeholder. It is a short conversation if you can answer it with specifics: the report lives behind a link with a per-client access key, you can unpublish it at any time, and the data sits in the EU. It is a long conversation if your answer is “it’s a PDF in your inbox.” The questions client IT teams actually ask are covered in this piece on access keys and secure sharing.
Decide at the same time whether this client gets individual report links or a portal where they see their own reports collected in one place. For an account that will produce twelve monthly reports and a handful of campaign wrap-ups, a portal saves you the “can you resend the August one” email about four times a year.
The template this client gets is the template every client gets
Here is the part agencies underestimate. The layout you build in a hurry for a new account does not stay with that account. Someone copies it for the next client, because copying is faster than building, and the typo in the KPI tile label, the chart that plots impressions as a pie, and the section order that buries conversions below creative performance all travel with it.
Build the template once, deliberately, with the section order you would defend in a review meeting: outcome first, then the drivers, then the detail. The reasoning behind that order is in why section order beats design, and the case for treating the layout as a reusable asset rather than a per-client design is in build the layout once, reuse it for every client.
Report template onboarding then becomes a fill job rather than a build job. You pick the group-by and metrics per row, accept or change the suggested fill, and the structural decisions stay where you made them. This is where Screebl’s templates earn their place in a new client reporting setup: the template is reusable, it locks once reports depend on it so an edit in March does not silently rewrite February, and the campaign export goes in as Excel or CSV with rates computed from totals. The mechanics of that first upload are walked through in turning an Excel export into a client dashboard.
Cadence and send day are decisions, not defaults
Reporting cadence setup is two separate choices that often get collapsed into one. The first is frequency: weekly, monthly, or monthly with a lightweight weekly pulse during the first flight. The second is the send day, which is the one that quietly determines your team’s workload.
Avoid the first and last working day of the month for a monthly report. Month-end is when platform data is still settling, when finance is closing, and when every other account in your agency also wants its report. Day three or four of the following month gives the data time to finalise and spreads your own delivery load. For weekly, pick a day that sits after the client’s internal meeting rather than on it, so you are informing a decision instead of racing one.
Write the cadence into the account’s reporting note along with the definitions, and tell the client the date rather than the frequency. “You will have the September report on 3 October” prevents more follow-up emails than “we report monthly.” There is more on choosing between the two rhythms in weekly or monthly.
The short conversation that prevents the first “that’s not what I meant”
Before report one goes out, spend fifteen minutes asking the client one question: what do you have to report upwards, and to whom?
The answer reshapes the report. A marketing manager reporting to a CFO needs cost per acquisition and spend against budget at the top. A brand manager reporting to a commercial director needs reach, frequency and share of voice. A performance lead who reports to nobody but themselves wants the detail you would otherwise cut. You cannot infer this from the media plan, and the client will rarely volunteer it, because from their side it is just their job.
Ask it in the kickoff while you still have an excuse to ask basic questions. In month three, the same question sounds like you were not paying attention.
The onboarding sequence, in order
A usable client reporting checklist for a new account, completed before report one ships:
- Confirm the client’s internal reporting line and the one number they are judged on.
- Write the metric definitions, including how rates are calculated and which platform is the source of truth for each.
- Agree the recipient list, who may see cost data, and whether the client gets a portal or individual links.
- Choose cadence and a specific send date, and put the first three dates in the calendar.
- Fill the template from your standard layout, do not build a new one, and name it for reuse.
- Reconcile report one against the signed media plan internally before sending.
- Send report one with one short note explaining what the client should look at first.
None of this is reporting work. It is account setup that happens to prevent reporting work, and it is cheapest in the week when nobody is yet unhappy about performance. If you would rather the template part of that list were already solved before the next account signs, the plans are the place to start.
