1
List every metric your team currently tracks
Before opening the template, compile a complete inventory of the KPIs used across all active channels — paid, organic, email, social, and CRM. Include both leading indicators (CTR, MQL volume) and lagging indicators (CAC, LTV, revenue).
💡 Limit the final document to 12–18 metrics. More than 20 creates reporting overhead without improving decision-making.
2
Write a precise formula for each metric
Enter the arithmetic formula for every KPI, define each variable in plain language, and specify what is excluded. Use the format: Metric = Numerator / Denominator, where Numerator excludes [X] and Denominator includes [Y].
💡 If two people on your team calculate the same metric and get different numbers, the formula is underspecified. Test it before finalizing.
3
Identify and record the authoritative data source
For each metric, name the specific platform, account ID, and report or view from which the number will be pulled. Where multiple sources exist, designate one as authoritative and note how discrepancies are handled.
💡 Add a column for 'last verified date' next to each data source — platforms change their tracking methodology regularly, and outdated source references cause silent errors.
4
Set benchmark targets and minimum thresholds
Enter the agreed target value and the minimum acceptable threshold for each metric. Base targets on at least three months of historical data, and note the source of any industry benchmark you use as a reference.
💡 Set thresholds 15–20% below target rather than at target — this gives you an early-warning signal before performance becomes a serious problem.
5
Define the attribution model and lookback window
Choose and name the attribution model that governs conversion credit for each channel. Record the lookback window in days and explain how multi-channel overlap is handled.
💡 Document the model in plain language in a footnote — 'last-click, 30-day window' — so non-technical stakeholders understand what the numbers represent.
6
Set the reporting cadence and assign responsibilities
Enter the reporting frequency for each metric, the person or team responsible for producing the report, the delivery format, and the deadline relative to the close of each period.
💡 Assign a single owner per metric, not a team. Shared ownership produces delayed or inconsistent reports.
7
Have all responsible parties review and sign
Share the completed document with every stakeholder who will produce or receive metric reports. Incorporate their feedback, then collect signatures from the authorized representative of each party before reporting begins.
💡 Execute the metrics document before signing the underlying marketing services agreement — once the campaign starts, renegotiating definitions becomes contentious.
8
Schedule a quarterly review date
Record a specific calendar date for the first quarterly review in the amendment clause. Set a recurring reminder 30 days before that date to assess whether targets, formulas, or data sources need updating.
💡 Any change in attribution platform, CRM, or ad account mid-engagement should trigger an immediate document amendment, not just a verbal agreement.