Metric Definition Alignment Worksheet: One Number, One Owner
A structured worksheet and facilitation guide for locking in the agreed definition, formula, data source, owner, and edge-case rules for every sales metric your team tracks. Kills the "sales says £4.2M, finance says £3.1M" argument at the root.
How to use it
Book the 60-minute alignment session with sales, finance, and RevOps in the same room. Work through the facilitation guide first, then fill in one row per metric using the worksheet table. Publish the completed worksheet as the single reference document and review it at every significant system or process change.
What's inside
- Master worksheet table with columns for metric name, plain-English definition, calculation formula, authoritative data source, single named owner, refresh cadence, and exclusions/edge cases
- Worked example rows for the six most-disputed metrics: pipeline, ARR, win rate, quota attainment, CAC, and churn
- A 60-minute facilitation guide with a timed agenda and specific prompts for each stage
- A pre-session homework template to send participants before the meeting
- A list of the five most common definition disputes and the questions that resolve them
- A sign-off block to make the agreed definitions official
- Guidance on where to publish and how to maintain the document over time
- A "when this breaks down" section naming the failure modes and fixes
Why this exists
Sales says pipeline is £4.2M. Finance says £3.1M. RevOps pulls a third number and nobody can explain the gap. The argument repeats every month because the root cause is never fixed. The root cause is not bad CRM hygiene or the wrong tool. It is that nobody ever wrote down, in plain English, what the metric actually means, who owns it, and how it is calculated from which data source.
This worksheet fixes that. One session, one document, no more competing numbers.
The Master Worksheet
Copy this table. Add a row for every metric your team tracks. Complete every column. Leave nothing blank: if a cell is genuinely unknown, write "TBC by [name] by [date]" so it becomes a visible action item.
| # | Metric Name | Plain-English Definition (no jargon) | Exact Calculation Formula | Authoritative Data Source | Single Named Owner | Refresh Cadence | Exclusions and Edge-Case Rules |
|---|---|---|---|---|---|---|---|
| 1 | |||||||
| 2 | |||||||
| 3 |
Column guidance:
Plain-English Definition. One or two sentences. A new starter should read it and know exactly what counts and what does not. If you need more than two sentences, the definition is not clear yet.
Exact Calculation Formula. Write it out in full. "Closed Won value divided by total opportunities entered in the period" is a formula. "Revenue" is not.
Authoritative Data Source. Name the specific system and, if relevant, the specific report or view. "Salesforce, Opportunities object, standard pipeline report filtered to Stage 2+, excluding Partner channel" is a source. "CRM" is not.
Single Named Owner. One person. Not a team. Not a title. A name. This person is accountable for the number being correct and for fielding disputes. If two people think they own it, you have not finished the conversation.
Refresh Cadence. How often the number is pulled and published. Daily, weekly, monthly, at period close. Be specific.
Exclusions and Edge-Case Rules. This column prevents 80% of future disputes. Write down every "but what about" that comes up in the session. Renewal opportunities, partner-sourced deals, deals above a certain ACV, currencies, partially closed splits: if it caused an argument once, it lives here.
Worked Examples: The Six Most-Disputed Metrics
| # | Metric Name | Plain-English Definition | Exact Calculation Formula | Authoritative Data Source | Single Named Owner | Refresh Cadence | Exclusions and Edge-Case Rules |
|---|---|---|---|---|---|---|---|
| 1 | Pipeline | Total value of all open opportunities the sales team expects to close in a defined future period | Sum of Amount field on all open Opportunities with Close Date in the period, at Stage 2 (Discovery Complete) or above | Salesforce, Pipeline Dashboard v2, "Open Pipeline by Quarter" view | Head of RevOps (Sarah Chen) | Every Monday 08:00, auto-refresh | Excludes: Stage 1 (Unqualified), Renewal opportunities (tracked separately), any opp on hold flagged "Legal Review Pause", Partner-sourced opps (separate Partner Pipeline report) |
| 2 | ARR | The annualised recurring revenue value of all active contracted customers at a point in time | Sum of ARR field on all active Accounts in billing system, normalised to 12 months regardless of contract length | ChartMogul, "ARR Snapshot" report, pulled at last day of each month | Finance Director (Tom Okafor) | Monthly at period close | Excludes: one-off professional services fees, pilots not yet converted to paid contract, any contract in legal dispute until resolution |
| 3 | Win Rate | Percentage of sales opportunities that result in a Closed Won outcome, out of all opportunities that reached a defined qualification stage | Closed Won opportunities divided by (Closed Won + Closed Lost) opportunities, in the same period, at Stage 3 (Proposal Sent) or above | Salesforce, "Win Rate by Rep" report, standard Closed Won and Closed Lost fields | Sales Operations Manager (Priya Rao) | Monthly, published within 3 working days of period close | Excludes: opportunities closed as "No Decision", "Duplicate", or "Disqualified" before Stage 3; excludes Partner-sourced deals from main rate (tracked in separate Partner Win Rate metric) |
| 4 | Quota Attainment | Percentage of a rep's or team's assigned quota achieved through Closed Won revenue in the period | Closed Won ARR in period divided by assigned quota for the period, expressed as a percentage | Salesforce (Closed Won) cross-referenced with quota table in Google Sheets "FY25 Quota Assignments" (Finance-owned) | Head of Sales (Marcus Webb) | Monthly and quarterly, published within 5 working days of period close | Excludes: expansion ARR unless rep carries an expansion quota; excludes deals where revenue is recognised in a future period by finance but booked in Salesforce this period (use finance recognition date for attainment) |
| 5 | CAC (Customer Acquisition Cost) | The average total cost of acquiring one new paying customer, including all sales and marketing spend | Total Sales + Marketing spend in period divided by number of new logos Closed Won in the same period | Finance ERP (Xero) for spend; Salesforce for new logos | Finance Director (Tom Okafor) | Quarterly | Excludes: account management and CSM headcount costs (tracked in CRC metric); excludes spend on renewal or expansion campaigns; if a customer churns and re-signs within 12 months, counts as expansion not new logo |
| 6 | Gross Revenue Churn | Percentage of contracted recurring revenue lost in a period due to cancellations and downgrades, not offset by expansion | (MRR lost to cancellation + MRR lost to downgrade) in period divided by MRR at start of period, expressed as a percentage | ChartMogul, "Churn Report", "Contraction MRR" and "Churned MRR" categories | Finance Director (Tom Okafor) | Monthly at period close | Excludes: revenue lost due to FX movement on non-GBP contracts (tracked separately); a pause request of under 60 days is not counted as churn; counts as churn only when cancellation is confirmed in writing, not at notice date |
The Five Most Common Definition Disputes (and the questions that close them)
1. Pipeline stage entry. "Does it count from Stage 1 or Stage 2?" Ask: at what stage do we have enough information to believe this is a real opportunity? That is your entry point. Write it down.
2. Which close date to use. "The rep moved the close date, so do we use the original or the current one?" Agree on one rule: most teams use the current close date as recorded in the CRM at the point the report is pulled. Write that down.
3. New logo vs. expansion. "Is a new division of an existing account a new logo?" Define parent account hierarchy in the CRM. If the account exists in the system, it is expansion. If it is a net new account record, it is new logo. Write down the CRM rule.
4. When a deal counts as won. "Verbal yes, signed contract, or invoice raised?" Finance and sales frequently differ here. Agree one trigger event. Most teams use countersigned order form. Write it down.
5. Partner-sourced vs. partner-influenced. "Does a deal the partner introduced count in our win rate?" Decide once. Attribute it clearly in the CRM at the opportunity level. Write the rule in the exclusions column.
60-Minute Facilitation Guide
Before the session: pre-work to send 48 hours in advance
Send attendees (sales lead, finance lead, RevOps lead) this prompt:
For each metric we will discuss, write down in one sentence what you currently believe it means and how you currently calculate it. Do not check with each other first. Bring your answers to the session.
This surfaces the disagreements before the meeting starts and saves 20 minutes of discovery time in the room.
Attendees required: Sales lead, Finance lead, RevOps or Sales Ops lead. One facilitator (usually RevOps). No more than six people total.
Timed agenda
| Time | Activity |
|---|---|
| 0-5 min | Facilitator states the purpose: one agreed definition per metric, recorded in writing, signed off today. Not a discussion about who is right. A decision about what we will use going forward. |
| 5-15 min | Compare pre-work answers for Metric 1. Identify exactly where definitions differ. |
| 15-25 min | Agree the definition, formula, source, owner, cadence, and exclusions for Metric 1. Scribe records directly into the worksheet. |
| 25-50 min | Repeat for Metrics 2-6 at roughly 5 minutes each. Flag anything unresolved as a named TBC with an owner and a deadline, not a reopened debate. |
| 50-60 min | Read back every row. Each attendee confirms or raises a specific objection. Resolve or log as TBC. All three leads sign the sign-off block. |
Facilitator rules
- If debate runs past 3 minutes on a single cell, call it: "We have two options on the table. Which one do we use going forward? Vote now." Pick one. Move on.
- "That is a good point" is not a decision. Only a completed row in the table is a decision.
- Anything that cannot be resolved in the session gets a named owner and a date, not a follow-up meeting with no agenda.
Sign-Off Block
| Role | Name | Signature | Date |
|---|---|---|---|
| Sales Lead | |||
| Finance Lead | |||
| RevOps / Sales Ops Lead |
Once signed, this document is the reference. Any future number that differs from these definitions is either a data quality issue or evidence that the definition has changed. In either case, update the worksheet.
Where to publish and how to maintain it
Publish the completed worksheet in one place every team member can find. A pinned page in Notion, Confluence, or your shared drive works. Link to it from your CRM homepage if possible.
Review it when:
- A new CRM or BI tool is introduced
- The business model changes (new product line, new channel, new geography)
- A new finance, sales, or RevOps leader joins
- Any metric generates a dispute that takes more than one email to resolve
That last trigger is the most important. One email to resolve a dispute is normal. Two emails means the definition has a gap. Fix the worksheet, not just the number.
When this breaks down: named failure modes
"We agreed but the CRM doesn't match the definition." The definition is right. The CRM configuration is wrong. Fix the CRM. Do not rewrite the definition to match a broken report.
"The owner left and nobody updated the worksheet." Ownership must transfer at offboarding. Add a step to your offboarding checklist: reassign metric ownership before the person's last day.
"Finance changed how they recognise revenue and didn't tell RevOps." The sign-off block exists for this reason. Any change to a definition requires a new sign-off. Make that a written rule in your team norms.
"Sales is using a different view in Salesforce and getting a different number." There is only one authoritative report per metric. Name it in the source column down to the specific saved view. Delete or rename the other views if you can.
"We filled this in once and never looked at it again." Schedule a 20-minute annual review of the worksheet as a recurring calendar event. Set it now.