Building a creator media kit dashboard that shows source dates and missing data

What to take away

This is a dashboard specification, not a built or tested dashboard.
A scope strip, four evidence panels and a source register carry most of what a media kit report needs.
Every figure carries a source, a reconciliation date and a named owner.
Missing, zero and undefined are three different states.
A reviewer reproduces one panel from the retained extract before release.

Start with the decision, not the display

Write the intended decision above the layout. For example, the owner may need to know whether an approved kit version reached its scheduled recipients. Keep that administrative question apart from whether the kit won new business.

OSR dashboard guidance covers user need and maintenance, but its remit is official statistics. Read it as a house design principle, not a rule a private portfolio must follow.

If the owner only needs a distribution reconciliation, a dated table may be enough. Do not add an interactive display because a supplier sells one.

Give the report a visible scope strip

Place the kit identifier, version, observation period, timezone and extraction timestamp together. Name the cohort and the rule used to establish England coverage. Keep recipients with unknown location in their own category rather than assuming they sit outside England.

Scope strip fields

Kit identifier and version
Observation period and timezone
Extraction timestamp
Cohort and England coverage rule
Unknown-location recipients kept separate
Data source and responsible owner
Last reconciled date per source

Keep a source register beside the panels

Attach a source and a named owner to every measure. A release register, an event export, an enquiry log and an agreement register are four separate sources, each with its own reconciliation date. Put those dates on the page so freshness cannot hide older inputs.

Measure	Source	Counting unit	Last reconciled	Owner
Approved releases	Release register	One kit version sent	31 Aug 2026	Portfolio owner
Observed interactions	Event export	One defined interaction	31 Aug 2026	Portfolio owner
Commissioning enquiries	Enquiry log	One classified message	29 Aug 2026	Portfolio owner
Documented agreements	Agreement register	One signed agreement	28 Aug 2026	Portfolio owner

Illustrative layout. Dates and labels are placeholders, not measured results.

Microsoft Excel or Google Sheets holds this register and keeps each definition next to its number. If a panel's claim is still undecided, read reporting on a creator media kit without inventing impact first.

Arrange four evidence panels

Use an output panel for recorded releases, an engagement panel for defined interactions, an enquiry panel for classified commissioning messages and an outcome panel for documented agreements. Each panel carries its own event rule and counting unit.

For any proportion, show the numerator, the eligible denominator, the follow-up window and the exclusions. Place unmatched enquiries outside cohort response calculations.

Missing, zero or undefined

Is the source missing?

Yes

show unavailable state

was the source and period fully checked?

Example panel with sample values

One output panel might read as follows. The values are placeholders that show the layout, not results.

Field / Illustrative value

Panel: Approved releases
Source and owner: Release register, portfolio owner
Counting unit: One kit version sent
Records in period: 12
Unknown-location recipients: 3
Last reconciled: 31 August 2026
State: Available

Before adding a comparison line, check how a benchmark's population and metric are tested, because a figure from a different population will not carry across.

Make interpretation travel with the data

Annotate a revised event definition, an interrupted collection or an incomplete follow-up. Keep the earlier extract when a figure changes, with the reason. Treat a new measurement system as a possible break until compatibility is checked.

ONS guidance on uncertainty in charts advises showing uncertainty where it changes interpretation. Do not invent an interval around incomplete administrative records; describe the coverage problem instead.

Missing data shows as unavailable. Zero is a measured value and needs a completed check of the source and period. An undefined rate needs an explicit denominator.

Check a proposed release

Ask a reviewer to rebuild one panel from the retained extract.
Change a cohort filter and confirm the numerator and denominator move together.
Inspect empty states, unknown locations and records outside the date range.
Record the checker, the report version, the findings and any unresolved issue.

Recipient-level detail needs a lawful basis before it appears. Read how much personal information a creator media kit needs to disclose and take qualified privacy advice. The ICO guide to the GDPR is the starting point for that review.

Maintain the reporting view

Assign an owner for source changes, broken definitions and correction requests. Agree a refresh schedule with that owner. The view supports a decision only within its documented coverage.

Common questions

What does a finished dashboard actually look like?

A scope strip, four evidence panels, a source register with reconciliation dates and an exportable table that keeps the active filters and notes. The example above shows one panel filled in.

How often should the figures be refreshed?

Agree the interval with the owner and record it in the scope strip. Refresh each source on its own schedule, because event exports and agreements rarely update together.

Can I build this in a spreadsheet?

Yes. Microsoft Excel or Google Sheets can hold the register, the panels and the export, provided every column keeps its definition, unit and reconciliation date.