Measurement
Part of Why food creator partnerships measurement needs a shared method
When to build a food creator partnerships reporting dashboard
Build a food creator partnerships reporting dashboard that ties creator spend to covers and bookings, with a checklist for choosing metrics and refresh cycles.
What to take away
- Build the dashboard when you have at least two creators running in the same period and no single view of spend against covers.
- Agree the metric set before you pick softwarebookings, covers, spend, cost per booking and reach.
- Pull data from booking systems, creator platforms and your own tracking links, not from screenshots.
- Refresh weekly during a campaign and monthly once the pattern settles.
- Set a lawful basis for any personal data before it enters the dashboard.
Signs you need a dashboard
A spreadsheet works while you run one creator a month.
The dashboard exists to answer one question: which creator activity produced covers, and at what cost?
If you cannot answer that within a day, build the dashboard. The measurement and reporting method sets out the wider practice behind it.
Choose the metrics first
Pick five metrics and no more. Test each against five criteria: it answers a decision you can make, it has a named source, it can refresh automatically, it compares across creators, and it does not duplicate another metric. Bookings or covers, creator spend, cost per booking, reach and engagement rate pass those tests for most restaurant campaigns.
Five metrics and their sources
Metric
- Bookings or covers
- Reservation system
- Creator spend
- Invoices
- Cost per booking
- Calculated
- Reach
- Creator platform
- Engagement rate
- Creator platform
Named source
- Bookings or covers
- Creator spend
- Cost per booking
- Reach
- Engagement rate
Which? publishes a monthly consumer insight tracker showing how UK households feel about spending.
Map your data sources
List every system that holds a number you need. Typical sources are the booking platform, the till, the creator's own analytics and your finance records.
Two named tools cover most needs. Looker Studio connects to Google Sheets, so a booking system export lands in a sheet and refreshes on a schedule. Power BI connects to a SQL database or REST API, so reservations flow from booking systems that expose one.
From source systems to dashboard
- Booking platform: covers and bookings
- Till: covers and spend
- Creator analytics: reach and engagement
- Finance records: creator spend
- Check export speed and refresh rate
- Apply ICO data protection rules
Where you handle creator contact details or audience data, follow the ICO guidance on data protection for organisations before that data reaches the dashboard.
Build it in four steps
- Agree the metric definitions with whoever signs off the budget.
- Connect the booking system first, because it holds the outcome.
- Add creator spend and reach second.
- Set the refresh cycle and the person responsible for each tile.
TikTok's agency solutions pages describe the reporting and partner structures available to agencies, which is useful if you work through an intermediary rather than direct.
Checklist before go-live
- Five metrics agreed and defined in writing.
- Every metric has a named source and owner.
- Booking data flows automatically.
- Creator spend reconciles to invoices.
- Tracking links are unique per creator.
- Personal data has a lawful basis and a retention period.
- One person can produce the weekly view in under 30 minutes.
- A fallback exists for weeks when a source fails.
When a source fails, do not overwrite the last good figure. Record the failure date, keep the previous value with a note, and backfill when the export returns.
If the booking system is down, use the till or reservation book for the affected days and mark those numbers as manual. Tell the budget holder which tiles are incomplete before the weekly meeting.
Avoid the common traps
Set a fixed attribution window, such as 14 days from the first click, and apply it to every creator. Cost per booking is creator spend divided by attributed bookings. For a 14-day window from first click, a booking counts if its timestamp falls within 14 days of that click.
If three creators touch the same diner, assign the booking by your stated rule, such as last click or first click.
Worked example, illustrative figures: Creator A spend £1,200, 40 attributed covers, cost per booking £30. Creator B spend £900, 20 attributed covers, cost per booking £45.
Review the definitions quarterly, and check the common measurement mistakes before your next creator round so the same gaps do not reappear.
Common questions
How many creators before a dashboard is worth it?
Two or more running in the same period is the practical threshold. Below that, a single sheet with the same five metrics does the job.
Should the dashboard include follower counts?
Only as context. Follower count does not predict covers, so keep it off the main view and out of the cost calculations.
Who should own the dashboard?
One named person, usually whoever holds the marketing budget. Shared ownership is the fastest route to stale figures.
How often should figures refresh?
Weekly during an active campaign, monthly between campaigns. More frequent updates add noise without changing decisions.
