Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

Analytics › Advanced

Writing Metric Definitions for a Software Training Provider

You resolve three conflicting sets of figures at an invented software training provider by tracing each number to its source and writing governed definitions for leads, enrolments and revenue. The exercise practises fixing formula, grain, filters, time rule and owner, splitting a word into two named metrics where two meanings are both needed, and planning how definitions are versioned and enforced.
ExerciseAdvanced levelModule 3: Metric governance and data flow5 minUpdated

Why this matters

When three dashboards show three numbers for one word, the argument is about the definition, not the business. The guide to metrics layers and definitions lists the sources of drift and the fields a definition must settle; the guide to data flow and integrations shows where in the stack each number is born; a definition is only enforceable once you know which system can produce it.

The provider and its conflicting numbers

Syntaxfern Software Training is an invented provider of online and classroom software courses for businesses. Individuals buy online courses through a checkout; companies book classroom seats through a sales adviser, often for courses starting weeks later.

Illustrative example — not a real result

Syntaxfern Software Training: one month, three dashboards

MetricMarketing dashboardSales dashboardFinance report
Leads640480n/a
Enrolments210260245
Revenue£98,000£131,000£112,000
  • Marketing: Looker Studio on the analytics connector. Leads are lead key events, including brochure downloads and repeat submissions. Enrolments are online checkout orders. Revenue is online purchase revenue including VAT, on the event date.
  • Sales: CRM reports. Leads are new person records, deduplicated by email, excluding existing customers. Enrolments are seats on won deals, by close date. Revenue is won deal value excluding VAT, by close date.
  • Finance: the ledger. Enrolments are seats on courses delivered in the month with paid invoices, after cancellations. Revenue is recognised on the course delivery date, net of VAT and refunds.

Data flow: web forms feed the analytics property and the CRM; the online checkout writes to the booking system, which fires the analytics purchase tag; sales-led bookings go from the CRM to the booking system by hand; the booking system raises invoices into the ledger. The marketing dashboard blends three connectors and is slow to open.

Tracing the gaps:

  • Leads: 640 − 110 brochure downloads − 30 repeat submissions − 20 existing customers = 480.
  • Enrolments: 260 seats closed − 25 for next month's courses − 5 cancelled + 15 sold last month for this month = 245. The 210 are online orders, some with several seats, and exclude sales-led bookings.
  • Revenue: marketing's £98,000 includes VAT and covers online only; sales' £131,000 includes deals for future courses.

Anatomy of a governed definition

A governed definition has a stable key, one plain sentence, a formula built from other defined metrics, a grain and its roll-up rule, the filters always baked in, the date and zone a row is counted on, a source of truth, an owner, a version and a known-differences note. When one word legitimately carries two meanings, such as revenue booked and revenue recognised, it becomes two metrics with two names, never one metric with a toggle. The source of truth is the system closest to the event, chosen from the data flow rather than from the loudest team.

Task

  1. Decide which disputed words need one definition and which need splitting into two named metrics.
  2. Write each definition with key, meaning, formula, grain, filters, time rule, source, owner and known differences.
  3. Say what happens to the marketing dashboard's current lead and enrolment figures.
  4. Plan versioning and enforcement, including how the dashboards read the definitions.
  5. Answer a vendor who says a customer data platform would fix the problem.

Worked answer

Every team counts correctly by its own rules; the fix is naming and ownership.

KeyMeaningGrain and time ruleSource of truthOwnerKnown differences
form_submissionsEvery web form completion, any typeSubmission, by event dateAnalytics propertyHead of marketingHigher than leads: includes downloads, repeats and customers
leadsNew prospective customers from any enquiry routePerson, by CRM creation dateCRMHead of marketing, agreed with salesLower than form submissions; deduplicated by email
seats_bookedLearner seats on confirmed bookings, net of cancellationsSeat, by booking dateBooking systemSales directorRuns ahead of finance for courses starting later
seats_deliveredSeats on courses delivered and invoicedSeat, by delivery dateBooking system and ledgerFinance directorLags bookings by the gap to the course date
revenue_bookedValue of confirmed bookings, excluding VATBooking, by booking dateBooking systemSales directorIncludes future courses; not recognised revenue
revenue_recognisedRevenue on delivered courses, net of VAT and refundsSeat, by delivery dateLedgerFinance directorThe only figure for financial reporting

The marketing dashboard. Its lead figure is renamed form submissions and stays as a channel signal. Its online orders become an online slice of seats booked, read from the booking system rather than from analytics (GA4), so classroom seats are no longer invisible to marketing.

Versioning and enforcement. Record every definition in a KPI dictionary with version and date, and mark each company KPI as certified once its owner signs it off. Build one modelled table per metric from the named source and point every dashboard at those tables rather than at raw connectors. That also fixes the slow dashboard, as the Looker Studio performance guide explains for blends. A change needs the owner's approval, a new version, restated history and a dashboard note. Each month, check that seats delivered reconcile to the ledger and that leads reconcile to CRM records.

The vendor. A customer data platform (CDP) resolves identity and activates segments; it does not decide what revenue means, and added now it would produce a fourth number.

Common mistakes

  • Choosing a winner instead of naming meanings. Finance's revenue and sales' revenue are both needed.
  • Defining on raw columns. Seats booked should feed both cost per seat and revenue booked.
  • Letting dashboards compute their own versions. One path from source to chart, or the drift returns.
  • Buying a tool to settle a definition. Agreement comes first; enforcement follows.

Next, bring this together with warehouse data and causal tests in the measurement strategy capstone, or revisit dashboard design at the intermediate analytics level.

Pages this lesson applies

Terms used on this page

Also related

Related