On this page9 sections
Published October 27, 2026.
A dashboard is a set of agreements rendered as charts. When the agreements are missing, the meeting becomes a debate about whose number is right. The fix is not a better BI tool. It is a definitions page that settles the handful of choices every growth dashboard depends on, before the first chart is built.
Decide what counts as a lead
A lead is not every form fill. Decide whether a newsletter signup, a content download, a webinar registration, and a demo request all count, or whether only sales-accepted contacts count. Write the event names and the source systems.
Separate contacts from leads from opportunities. A contact can exist for years without becoming a lead. A lead can exist without an opportunity. A dashboard that uses the words interchangeably will overstate pipeline and understate cost per lead.
Settle MQL ownership and timing
Who marks a contact as marketing qualified: marketing, sales, or a scoring model? What happens when sales disagrees? Record the rule and the timestamp. MQL date should be the date the qualification happened, not the date the contact was created.
If the team uses a scoring threshold, version the model. A score change mid-quarter makes the MQL count incomparable with the prior period. Mark the change on the chart or restate the history with the new model, and say which you did.
Choose the attribution window
Last-click, first-click, linear, and position-based models answer different questions. Pick one primary model for the dashboard and state the window: 30 days, 90 days, or the sales cycle length. Do not mix a 30-day click window with a 90-day revenue window without labeling it.
For B2B with a long cycle, a first-touch or position-based view often explains demand creation, while a last-touch view explains conversion. Show both if the team needs them, but do not average them into a single "marketing ROI" number.
Define the denominator for every rate
Cost per lead needs a lead count and a spend. Cost per opportunity needs an opportunity count and the same spend. Cost per acquisition needs closed-won revenue and the acquisition cost. Each rate needs a stated denominator and a stated time window.
A conversion rate from visitor to lead is not the same as visitor to opportunity. Label the funnel step in the metric name. If the dashboard says "conversion rate" without a step, it will be interpreted differently by every reader.
Normalize currency, time zone, and fiscal calendar
A global dashboard needs a reporting currency and a rate source. Decide whether to use the daily rate or the month-end rate, and apply it consistently. Record the rate date.
Use one time zone for daily reporting and state it. A campaign that runs in three regions can produce three different "days" if the platform and the CRM use different zones. Align the fiscal calendar with finance before the first month-end, not after.
Handle deleted and merged records
When two contacts merge, which record keeps the source? When a lead is deleted, does the spend remain in the denominator? Write the rule and apply it in the transformation layer, not in a spreadsheet after the export.
Keep a change log for the dashboard's source queries. A silent filter change can make a channel look better or worse without anyone noticing.
Document the source of truth
For each metric, name the system of record, the table or report, the refresh cadence, and the owner. A dashboard that pulls spend from the ad platform and leads from the CRM is only as good as the join key. Document the key and the known mismatches.
If two systems disagree, show the discrepancy rather than hiding it. A small "platform vs CRM" variance note builds more trust than a perfectly smooth chart that no one can reconcile.
Review the definitions quarterly
Bring marketing, sales, and finance to a 30-minute review. Check whether the business changed in a way that makes a definition stale: a new product line, a new region, a new sales motion. Update the definitions page and the dashboard version together.
Keep the old definitions for historical comparison. A definition change is a new series, not a correction of the old one.
Implementation checklist
- Define lead, contact, MQL, and opportunity separately.
- Record who qualifies and when the timestamp is set.
- Pick one primary attribution model and a stated window.
- Name the denominator and time window for every rate.
- Normalize currency, time zone, and fiscal calendar.
- Write rules for merged and deleted records.
- Document the system of record and the join key.
- Review definitions quarterly with sales and finance.
