Forecast the Whole Growth System

Task

Formalize forecasting and executive GTM dashboard.

Summary

Bring pipeline, recurring revenue, churn, expansion, acquisition cost, payback, and channel mix into one view.

Prompt Analysis and Research Execution Brief for S5-11

Executive summary

The attachment is not missing. Three files are available: the controlling assignment in prompt.md, a dashboard presentation, and a supporting dashboard workbook. The assignment is to produce one publication-ready, research-backed Markdown article about formalising forecasting and an executive go-to-market dashboard. It is not an instruction to build the dashboard itself; the dashboard is the business evidence that the article must explain.

The article must remain tightly focused on how a growing subscription business should define, operate, and assess an executive dashboard covering pipeline, annual recurring revenue, churn, net revenue retention, customer acquisition cost, CAC payback, and channel mix. Forecast accuracy is the primary measure, but the stated “target variance” is a company-specific working target, not an industry benchmark.

The most important execution issue is a source conflict. The prompt requires inspection of every supplied resource, but it expressly prohibits the final article from mentioning, citing, paraphrasing, or relying on the publisher of the supplied presentation. The correct treatment is to inspect the presentation and workbook for workflow ideas, quarantine them from the article’s evidence base, and independently verify every publishable point through permitted public sources. The presentation’s useful internal concepts include aligning dashboards with decisions, inventorying data sources, documenting definitions, choosing visuals deliberately, adding commentary and actions, and testing dashboards with users.

The workbook offers a practical sequence—audience and goals, metric selection, data readiness, dashboard design, narrative, and action tracking—but should not be treated as a reliable calculation engine without repair. Local inspection found 1,802 formulas, of which 910 contain broken #REF! references, concentrated in hidden dropdown-support sheets. The visible planning tables remain readable, but automated dropdowns and hidden-sheet logic should not be trusted.

A rigorous execution should take approximately 13–18 person-hours over two to three working days, using one researcher-writer plus short reviews from a revenue operations or finance specialist and an editor. No submission deadline is specified.

Attachment status and prompt synthesis

The missing-attachment contingency in the user’s instruction does not apply. The following resources were inspected.

ResourceStatus and contentsRole in the assignmentTreatment
prompt.mdComplete assignment, task record, research rules, voice, structure, source hierarchy, prohibited source, and final quality checkControlling instructionFollow directly; it governs all other supplied material.
Build Better Dashboards…pptxThirty-four slides covering goal alignment, data sources, metric selection, dashboard design, storytelling, testing, and iteration; no substantive speaker notes were presentBackground process materialInspect, but do not cite, name, paraphrase, or rely on its publisher in the final article because the prompt expressly prohibits that source.
Dashboard Workbook…xlsxEleven sheets covering audience and goals, metric alignment, data readiness, design review, narrative, and action trackingInternal workflow and template referenceUse only as private process context. Do not publish its sample figures as evidence. Repair or bypass broken hidden-sheet formulas.

The prompt’s substantive assignment can be reduced to one operating question:

How should a scaling subscription company turn pipeline, recurring revenue, retention, acquisition economics, and channel results into a credible forecast and an executive decision tool?

The article must explain the work rather than merely listing dashboard tiles. It should show how a leadership team defines the measures, establishes ownership, reconciles channel and company totals, compares forecasts with actuals, interprets variance, and decides whether a channel is producing the right customers at an acceptable cost and operating burden.

A second important distinction concerns output versus editorial evidence:

ItemWhat it means
Assigned outputA complete, publication-ready Markdown article
Business evidence discussed in the articleA working executive dashboard with pipeline, ARR, churn, NRR, CAC, payback, and channel mix
Primary business measureForecast accuracy
Working targetA defined variance tolerance, established by the company
Separate dashboard file required by this assignmentNo
Research plan required as final outputNo; the prompt expressly prohibits returning a plan instead of the article
DeadlineUnspecified

Extracted tasks and prioritised action items

The priorities below distinguish mandatory work from useful enhancement. All are derived from the controlling assignment.

PriorityExtracted taskRequired actionEvidence of completion
CriticalResolve source conflictsEstablish a source quarantine so the prohibited presentation cannot enter the article’s citations, examples, wording, or claimsSource log identifying permitted, contextual-only, and prohibited materials
CriticalInspect every supplied resourceReview presentation text and visuals, workbook sheets and formulas, and the complete promptInspection notes; no claim that a file was reviewed solely from its filename
CriticalDefine the article boundaryKeep the article on forecasting and the executive GTM dashboard; mention adjacent channel-readiness tasks only when necessaryThe article does not become a general SaaS metrics, dashboard-design, or channel-strategy guide
HighEstablish a metric dictionaryResearch and clearly define pipeline, ARR, churn, NRR, CAC, CAC payback, channel mix, forecast, actual, variance, and forecast horizonA consistent definition and calculation basis for every dashboard measure
HighExplain forecasting practiceCover forecast horizons, snapshots, actuals, error, bias, confidence or scenario ranges, judgemental overrides, and review cadenceReaders can understand how a forecast is produced and tested, not merely displayed
HighConnect metrics to decisionsExplain what each metric changes about channel investment, hiring, spending, retention work, or operating capacityEvery major metric is tied to a decision, owner, and expected action
HighResearch measurement limitationsExplain why similarly named metrics may not be comparable and why percentage-error measures can fail in low-volume or zero-actual periodsDefinitions, caveats, and alternative accuracy measures are included
HighFind public examplesUse one to three public cases, preferably regulatory filings or official investor material, to demonstrate metric-definition differences or dashboard implicationsEach example teaches one specific operating lesson and remains subordinate to the principle
HighDraft the complete articleFollow the specified editorial arc and plain-language business voiceA coherent 2,500–4,000-word Markdown article
HighCite every material claimUse approximately 8–15 strong, freely accessible sources, including primary sources and open researchInline citations throughout and a final ## Sources section containing only sources actually used
CriticalPerform final compliance reviewCheck focus, citations, word count, source accessibility, claims, acronyms, Mermaid syntax, and all prohibited spelling variantsClean final text with no mention of attachments, prompts, confidential data, or the prohibited source
MediumAdd a useful visualInclude no more than two simple Mermaid diagrams when they materially clarify the forecasting process or measurement modelDiagram renders correctly and has an accompanying text explanation
MediumImprove Canadian relevancePrefer Canadian regulatory, government, and English-language sources when equally authoritativeCanadian securities, privacy, data-management, and visualisation guidance incorporated where relevant

The article’s practical questions are also mandatory tasks. It must explain the problem being solved, why the work matters at this stage, what good work looks like, what evidence should exist, what to measure, where judgement is required, how superficial completion fails, and what must be true before the organisation relies on the dashboard.

Deliverables, constraints, success criteria, and assumptions

The following deliverables are required unless explicitly described as optional.

DeliverableRequired formatRequired length or quantityDeadline
Final articlePublication-ready MarkdownApproximately 2,500–4,000 wordsUnspecified
Article heading# [Plain-language article title]One titleUnspecified
Task identifier**Task ID:** S5-11One line beneath the titleUnspecified
Opening summaryMarkdown blockquote40–70 wordsUnspecified
Main bodyPractical business nonfiction with explanatory headingsEnough to cover the full editorial arc without paddingUnspecified
Public examplesVerified company, institutional, or public casesAt least one; preferably one to threeUnspecified
Research baseStrong, freely accessible sourcesApproximately 8–15Unspecified
Academic evidenceOpen or openly available academic researchAt least one or two when relevant literature existsUnspecified
Primary evidenceFilings, official guidance, official documentation, annual reports, or equivalentRequired for company facts and quantitative claimsUnspecified
VisualsMermaid diagram only when usefulZero to twoUnspecified
Source sectionFinal ## Sources sectionOnly sources actually usedUnspecified
Separate executive GTM dashboardNot required as a file by this article assignmentNot applicableUnspecified
Research plan or outline as final responseProhibitedNot applicableNot applicable

Explicit constraints

The final article must not be an outline, research plan, idea list, partial draft, company profile, promotional piece, biography, service pitch, generic motivational essay, or general explanation of the complete methodology. It must not invent Matt Edwards’s opinions, experiences, customer outcomes, or quotations. It must not present the tracker’s “target variance” as a universal benchmark. It must not expose private business facts or unsupported claims.

All sources must be publicly inspectable. Search-result pages, anonymous blogs, gated analyst reports, sponsored content, unsourced social posts, and Wikipedia are excluded as evidence. Vendor material may be used for product-specific implementation details, but not for broad performance claims when better independent or primary sources exist.

The article must use ordinary business language. Acronyms such as annual recurring revenue (ARR), net revenue retention (NRR), customer acquisition cost (CAC), annual contract value (ACV), and product-led growth (PLG) must be defined when first introduced. The opening must describe a recognisable operating situation rather than begin with a task identifier, abstract definition, or broad claim.

Inferred assumptions

Inferred assumptionBasisRecommended handling
The primary reader is a founder, executive, finance leader, sales leader, or revenue operations leader in a subscription businessThe methodology concerns moving beyond founder-dependent growth and evaluating multiple channelsWrite for a commercially literate reader, but define technical metrics
The company has progressed beyond initial product-market learningThe task sits in the scaled-channel stageState that the dashboard should not substitute for unresolved product, onboarding, retention, or data problems
“Forecast” primarily concerns bookings, new ARR, expansion, contraction, and churn over a defined horizonThe dashboard combines pipeline and recurring-revenue economicsMake the forecast object and horizon explicit rather than using “forecast” generically
Multiple channels may touch the same accountPartners, marketplaces, PLG, expansion, referrals, outbound, and enterprise can overlapRequire attribution and ownership rules to prevent double counting
ARR, NRR, CAC, and payback are management metrics rather than universally standardised accounting measuresPublic issuers disclose materially different definitionsRequire a metric dictionary and reconciliation to recognised financial data
A target variance must be company-specificPrompt explicitly warns against treating it as an industry benchmarkSet tolerances by forecast horizon, sales cycle, segment, channel maturity, and data quality
The publishing platform supports native citations and MermaidBoth are explicitly required or encouragedValidate syntax before delivery; provide explanatory text in case diagrams do not render
The article can discuss a generic dashboard without publishing private company dataNo company-specific dataset or approved private example is suppliedUse hypothetical structures and public examples only
There are operational dependencies despite “none specified” in the trackerReliable forecasting requires definitions, ownership, snapshots, source data, and historical actualsIdentify these as prerequisites, not tracker dependencies

Success criteria

The article is successful when a reader could use it to answer four practical questions:

  1. What should the dashboard contain and why? The measures form a connected model of demand, recurring revenue, retention, acquisition economics, and channel contribution.
  2. Can the numbers be trusted? Every metric has a definition, source, owner, refresh cadence, time boundary, segment rule, and reconciliation method.
  3. Is the forecast improving? Forecasts are saved as dated snapshots and compared with actual results using an appropriate combination of absolute error, relative error, and bias.
  4. What decision follows? Leadership can decide where to add capacity, reduce spending, investigate churn, change channel rules, or withhold further scaling.

The research should start with definitions and disclosure rules, then move to forecasting evidence, public company examples, and visualisation or data-governance guidance.

Source categoryRecommended sourcesRationale and intended use
Canadian financial-measure disclosureCanadian Securities Administrators’ National Instrument 52-112 and companion policyARR, NRR, CAC, and payback may be supplementary or non-standard measures. Canadian guidance is useful for requiring clear labels, consistent definitions, comparable information, and transparent calculation methods.
U.S. KPI disclosure guidanceU.S. Securities and Exchange Commission guidance on key performance indicators and non-GAAP financial measuresProvides a primary-source model for explaining why a metric is useful, how it is calculated, what assumptions it includes, and whether its definition has changed.
Revenue-recognition standardsIFRS Foundation material on IFRS 15 and IFRS 18Helps distinguish recognised revenue from operational measures such as ARR and highlights the growing importance of transparent management-defined performance measures. IFRS 18 is effective for annual periods beginning on or after January 1, 2027.
Public SaaS filingsLatest filings from companies such as Snowflake and AmplitudeThese filings provide maintained definitions of ARR or NRR and warn that similarly named metrics may be calculated differently. Comparing definitions is more useful than copying a single company’s benchmark.
Forecast-accuracy researchHyndman and Koehler’s work on forecast-accuracy measures; Forecasting: Principles and PracticeEstablishes the limits of common percentage measures, explains MAE, RMSE, MASE, and rolling-origin evaluation, and supports choosing measures appropriate to the data and decision.
Judgemental forecasting researchFildes, Goodwin, and related open research on forecast adjustmentsSupports rules for management overrides: document the reason, preserve the original forecast, and test whether overrides improve accuracy rather than assuming executive judgement always adds value.
Canadian visualisation guidanceStatistics Canada’s data-visualisation guidance and Canada.ca chart patternsProvides Canadian, English-language guidance on audience, message, chart choice, labels, sources, accessibility, simplicity, and accompanying tabular data.
Canadian data governanceGovernment of Canada guidance on FAIR data, stewardship, and metadata standardsSupports source inventories, consistent field definitions, controlled access, data quality, interoperability, and lifecycle accountability.
Official system documentationDocumentation from the company’s actual CRM, billing, finance, data warehouse, marketplace, and BI toolsUse only for implementation facts such as snapshot features, API behaviour, field lineage, permissions, and refresh limits; do not use vendor marketing claims as general evidence
Independent public reportingReputable reporting on a documented forecast failure or metric controversyUse selectively when it adds context or challenges a company’s official account; verify the underlying facts through filings or official records

The best public examples will likely demonstrate one of three lessons: the same metric can have different definitions, an operational metric is not recognised revenue, or consumption and channel models require different forecasting logic. A single well-documented example for each selected lesson is preferable to a list of company names.

Research and execution plan

The work should proceed from source control to metric definitions, forecasting evidence, application, drafting, and compliance review.

flowchart LR
    A[Confirm scope and source rules] --> B[Inspect supplied resources]
    B --> C[Build permitted source register]
    C --> D[Define dashboard metrics and decisions]
    D --> E[Research forecasting methods and accuracy]
    E --> F[Select public examples]
    F --> G[Draft complete article]
    G --> H[Check evidence, citations, and calculations]
    H --> I[Run editorial and prohibited-source review]
    I --> J[Deliver publication-ready Markdown]

Text description: the process separates attachment inspection from the permitted evidence base, defines the measurement model before drafting, and ends with both technical and editorial quality control.

Work stageMain activitiesEstimated effortResource needsOutput
Scope and source controlParse the prompt; establish the instruction hierarchy; create prohibited-source quarantine; confirm article-versus-dashboard boundary1.0–1.5 hoursResearcher-writerScope memo and source rules
Attachment inspectionReview all slides, visual structure, workbook sheets, formulas, sample data, and hidden-sheet issues1.0–1.5 hoursResearcher-writer; spreadsheet and presentation toolsResource inspection notes
Metric-definition researchResearch pipeline, ARR, churn, NRR, CAC, payback, channel mix, revenue, and attribution definitions2.0–3.0 hoursResearcher-writer; official filings and regulatory sourcesMetric dictionary and definition comparison
Forecasting researchResearch horizons, snapshots, error measures, bias, overrides, ranges, forecast reconciliation, and backtesting2.0–3.0 hoursResearcher-writer; open academic literatureForecasting evidence matrix
Example selectionIdentify one to three public cases; verify through current filings and, where useful, independent reporting1.0–1.5 hoursResearcher-writerExample briefs with verified facts
Article draftingWrite the complete article, including opening situation, principle, application, evidence, failure modes, and conclusion3.0–4.0 hoursResearcher-writerFull Markdown draft
Specialist reviewReview accounting/metric distinctions, channel attribution, and forecast operations0.75–1.25 hoursFinance or revenue operations reviewerCorrections and practical validation
Citation and editorial QAVerify every material claim, source accessibility, citation placement, dates, acronyms, voice, and Mermaid syntax1.5–2.0 hoursResearcher-writer and editorPublication-ready final article
Prohibited-source scanCase-insensitive scan for all banned spelling variants; check for unattributed derivative wording0.25–0.5 hoursText-search tool and researcherCompliance confirmation

Estimated total: approximately 13–18 person-hours. The work can reasonably be completed over two to three working days, although the actual delivery date remains unspecified.

gantt
    title Indicative execution timeline
    dateFormat  YYYY-MM-DD
    axisFormat  %b %d
    section Foundation
    Scope and source control       :a1, 2026-08-03, 1d
    Resource inspection            :a2, after a1, 1d
    section Research
    Metric and filing research     :b1, after a2, 1d
    Forecasting research           :b2, after a2, 1d
    Public example verification    :b3, after b1, 1d
    section Production
    Complete article draft         :c1, after b2, 1d
    Specialist and editorial review:c2, after c1, 1d
    Final compliance check         :c3, after c2, 1d

Text description: the indicative timeline sequences the work across three concentrated research and production days. Dates show order rather than a promised deadline.

The minimum resource configuration is one experienced researcher-writer with access to public filings, academic literature, spreadsheet inspection, and Markdown validation. A finance or revenue operations reviewer should spend approximately 45–75 minutes checking metric definitions, channel attribution, and forecasting routines. An editor should perform a final plain-language and compliance review.

Risk analysis and templates

RiskProbabilityImpactMitigation
Prohibited-source material enters the articleHighCriticalQuarantine the presentation and derived notes; use it only to generate research questions; independently source every publishable point; run a final case-insensitive text scan
The assignment is misread as requiring a dashboard buildMediumHighState in the working brief that the final deliverable is the article; treat the dashboard as the evidence and operating artefact the article explains
Metrics use inconsistent definitionsHighHighCreate a metric dictionary before drafting; specify numerator, denominator, population, timing, exclusions, currency, owner, and source
ARR is treated as revenue or as a guaranteed forecastMediumHighExplain the accounting-versus-operating distinction and use public filings that explicitly warn ARR is not recognised revenue or a revenue forecast.
NRR or churn is distorted by cohort changesHighHighFreeze the starting cohort; define whether acquisitions, reactivations, free plans, currency changes, services, and usage revenue are included
CAC and payback are understatedHighHighDefine fully loaded acquisition cost; specify whether partner commissions, marketplace fees, implementation support, sales engineering, and allocated labour are included
Channel results are double countedHighHighEstablish account ownership, sourced-versus-influenced rules, hierarchy, lookback windows, and conflict resolution before reporting channel mix
Forecast accuracy is measured with one misleading percentageHighHighReport error and bias separately; use absolute and scaled measures; define treatment of zeros and low-volume channels; compare like horizons
Executive judgement overwrites forecasts without accountabilityMediumHighSave both system and adjusted forecasts, require a written reason for material overrides, and measure forecast value added
“Target variance” is presented as a benchmarkMediumHighLabel it a working tolerance; derive it from historical error, planning needs, horizon, sales cycle, and channel maturity
Article scope expands into general GTM strategyHighMediumApply a scope test to every section: it must materially improve forecasting, dashboard credibility, or the supported channel decision
Current company facts become staleMediumMediumUse the latest filing available on the execution date; state fiscal periods and measurement dates
Private or sample data is published as factLowHighTreat workbook values as placeholders; use public examples or clearly labelled hypothetical figures only
Workbook automation produces incorrect outputsHighMediumDo not rely on hidden dropdown formulas; use visible sheets as conceptual templates and rebuild calculations independently
Mermaid or citations fail to renderLowMediumValidate syntax; keep diagrams simple; include a short text explanation; perform a final preview

Article opening template

# [Plain-language article title]

**Task ID:** S5-11

> [A 40–70 word summary explaining what the article teaches, the decision it supports, and why a credible forecast and dashboard matter before the company scales more sales channels.]

Metric-definition template

FieldExample specification
Metric nameNet revenue retention
Business questionIs the existing customer base growing or shrinking before new-customer revenue?
Formal definitionEnding recurring revenue from the starting customer cohort divided by starting recurring revenue from that cohort
Included changesRenewal, expansion, contraction, and churn
Excluded changesNew customers acquired after the starting date
Cohort ruleCustomers with qualifying recurring revenue at the beginning of the measurement period
Time basisTrailing twelve months, measured monthly
Currency ruleConstant currency or reported currency, explicitly identified
Source systemsBilling, contracts, product usage, CRM
Data ownerFinance or revenue operations
Refresh cadenceMonthly close, with weekly operational estimate if needed
SegmentationChannel, customer size, product, geography, acquisition cohort
ReconciliationExplain how the operating metric connects to recognised revenue and contract data
Known limitationsUsage volatility, contract timing, acquisitions, reactivations, credits
Decision triggeredInvestigate contraction or churn by channel; reassess acquisition spending and expansion capacity

Forecast-accuracy scorecard template

MeasureCalculationWhy include it
Forecast errorActual minus forecastShows direction and size for one period
Absolute errorAbsolute value of actual minus forecastPrevents positive and negative errors from cancelling
BiasSum of forecast minus actual over a defined periodIdentifies persistent optimism or conservatism
Weighted absolute percentage errorSum of absolute errors divided by sum of actualsGives an interpretable portfolio-level percentage when totals are positive
Mean absolute scaled errorAbsolute error scaled against a naïve benchmarkSupports comparison across differently sized series and avoids several weaknesses of percentage error
Forecast value addedAccuracy after a process step compared with accuracy before itTests whether management overrides or added process complexity improve the result

No single accuracy measure is sufficient in every setting. Percentage errors become unstable or undefined when actual values are zero or close to zero, while scaled measures and rolling-origin tests are more appropriate for comparing methods across series and horizons.

Evidence matrix template

Claim or lessonEvidence requiredPreferred sourceCounterpoint or limitationIntended article section
ARR is not the same as recognised revenueAccounting standard plus public filing definitionIFRS Foundation and latest issuer filingARR definitions differ by companyMetric definition
NRR requires a fixed cohortMaintained public-company definitionRegulatory filingConsumption businesses may show more volatilityMeasurement
Judgemental overrides can reduce accuracyOpen academic researchOriginal paper or institutional repositoryMaterial overrides based on new information may add valueFailure modes
Forecast error should be assessed by horizonForecasting text or researchOpen academic sourceExecutive planning may require several parallel horizonsApplication
Channel mix needs attribution rulesOfficial platform documentation plus operating analysisCRM or marketplace documentation“Sourced” and “influenced” may serve different decisionsDashboard design

Bibliography

Supplied resources

  • Deep Research Article Assignment — S5-11. Controlling assignment and editorial instructions.
  • Build Better Dashboards Across Marketing, Sales, and Customer Success. Presentation inspected as supplied context only; prohibited from use as evidence in the final article.
  • Dashboard Workbook for Marketing, Sales, and Customer Success. Spreadsheet inspected locally for workflow, sample tables, formulas, and data-readiness fields.

Primary and official sources

  • Canadian Securities Administrators. National Instrument 52-112: Non-GAAP and Other Financial Measures Disclosure and companion policy.
  • U.S. Securities and Exchange Commission. Commission Guidance on Management’s Discussion and Analysis of Financial Condition and Results of Operations.
  • U.S. Securities and Exchange Commission. Non-GAAP Financial Measures: Compliance and Disclosure Interpretations.
  • IFRS Foundation. IFRS 15 Revenue from Contracts with Customers supporting and post-implementation material.
  • IFRS Foundation. IFRS 18 Presentation and Disclosure in Financial Statements.
  • Snowflake Inc. Fiscal 2026 Form 10-K and fiscal 2027 first-quarter filing.
  • Amplitude, Inc. 2025 Form 10-K.
  • Statistics Canada. Data Visualization: Best Practices.
  • Government of Canada. Guidance on Assessing Readiness to Manage Data According to the FAIR Principles.
  • Government of Canada. Be Good Data Stewards.

Open and academic research

  • Hyndman, Rob J., and Anne B. Koehler. “Another Look at Measures of Forecast Accuracy.” International Journal of Forecasting.
  • Hyndman, Rob J., and George Athanasopoulos. Forecasting: Principles and Practice, sections on forecast accuracy and time-series cross-validation.
  • Fildes, Robert, Paul Goodwin, and Shari De Baets. “Forecast Value Added in Demand Planning.” International Journal of Forecasting.
  • Fildes, Robert, and Paul Goodwin. “Against Your Better Judgment? How Organizations Can Improve Their Use of Management Judgment in Forecasting.” Interfaces.