Build a creator contracts reporting dashboard without vanity metrics

What to take away

If you run sponsorship campaigns from a Manchester agency, the familiar failure is a screenshot folder and a spreadsheet that cannot say what was delivered.
A creator contracts reporting dashboard holds four thingscontracted deliverables, publication dates, disclosure evidence and the metrics the brand actually bought.
Every row should trace back to a clause in the signed sponsorship agreement, not to a platform total.
For UK disclosure, apply the ASA’s CAP Code rule 2.1, which requires marketing communications to be obviously identifiable as such. The CMA enforces consumer-protection law under the Digital Markets, Competition and Consumers Act 2024.
Report rates and totals across the campaign, not the single best post.

Which columns belong in the dashboard?

Start from the contract, not the platform. Each creator row should carry the deliverable, the relevant contract clause, the agreed fee, the publication window and the disclosure wording the creator accepted.

Use Google Sheets as the working dashboard. Build one row per contracted deliverable, so each result can be checked against its clause.

Create columns for the clause reference, deliverable, fee, publication window, agreed disclosure wording, bought metric, target, actual result and campaign status.
After publication, add the live post URL, actual publication date, disclosure evidence link and date checked.
Enter the target and window from the signed contract. At each refresh, total results for posts inside that window and compare them with the campaign target.

Dashboard columns to include

Deliverable
Agreed fee
Publication window
Disclosure wording
Bought metric (e.g. completed views)
Evidencelive post URL and date checked

Add columns for reach, impressions, clicks and saves where reported, but keep a separate column for the metric the brand bought, such as completed video views. Record the source and export date for each result; use platform reporting such as YouTube Studio, Meta Business Suite or TikTok Studio where relevant, and keep estimates clearly separate from platform figures.

Keep the live post URL, the date and time you checked it, and a link to the evidence file in separate fields. Record the reporting period and metric definition too; decide before launch how clicks will be attributed and apply that method consistently. The guide to measurement and reporting choices can inform those decisions.

How do you keep disclosure evidence usable?

Set the required disclosure in the contract and dashboard before publication. A clear default is “Ad” prominently at the start of the caption; a platform’s paid partnership label can be used as additional disclosure, not as a substitute for a clear caption label. On the day the post goes live, capture the post, full caption and label, then compare the displayed wording with the agreed wording word-for-word and save the evidence against the relevant row.

The ASA administers the CAP Code, whose rule 2.1 requires marketing communications to be obviously identifiable as such. The CMA enforces the unfair commercial practices regime under the Digital Markets, Competition and Consumers Act 2024. Keep the live-post evidence and your word-for-word label check so you can show what was published if a complaint arrives later.

If a creator edits a caption after publication, log the change and the time. A dashboard holding only final screenshots cannot show what a viewer saw on day one.

What does a worked example look like?

A drinks brand in Leeds signs five creators for a summer push. The fees are £800, £1,200, £1,500, £600 and £900, so contracted spend is £5,000.

The agreement sets a combined target of 250,000 views and 2,000 link clicks. Four creators deliver 218,000 views and 1,740 clicks inside the window. The fifth posts late, outside the agreement’s publication-window clause, so their 30,000 views land in the following month; record the clause and any signed variation in that row.

The brand reports 87% of the view target for the campaign window, not 99% once the late post is counted. That distinction matters when finance reconciles the £5,000. Set the click-attribution method before launch, name the source used and apply it consistently; the guide to attribution methods covers the choices.

Should you measure platform reach or brand outcomes?

Reach is cheap to collect and easy to inflate. Brand outcomes cost more to gather but survive scrutiny.

ISBA and Ebiquity published evidence on Total TV effectiveness about how measurement choices change the answer you get. The same principle applies to creator spend: choose the metric before the campaign, not after the numbers arrive.

Where a creator licenses existing footage for reuse, check the ownership terms. The Intellectual Property Office publishes guidance on IP and licensing that affects what you can repost and measure.

Who owns the dashboard and how often do you refresh it?

Name one owner. In most agencies that is the account lead, with finance reading a monthly export.

Refresh weekly during a live campaign and monthly afterwards. Each refresh should add evidence, not just numbers.

Version the file, so that when the sponsorship agreement is varied the dashboard shows which version the reported figures relate to.

This is general guidance only. Individual contracts and disclosure decisions need a qualified adviser.

Common questions

How many metrics should a dashboard track?

Aim for six to ten. One bought metric, two supporting reach figures, disclosure status, fee and publication date cover most campaigns.

Do I need consent to store creator screenshots?

You need a lawful basis for holding personal data about creators, and you should tell them what you keep and why. Check your privacy notice before adding fields.

Can I report estimated reach instead of platform figures?

You can, but label it as an estimate and name the tool that produced it. Mixing estimates with platform numbers in one column misleads the reader.

What happens if a creator deletes a post?

Keep the original evidence and the deletion date. Report the deletion rather than quietly removing the row, because the contracted deliverable was not maintained.