Step 4. Turn decisions into analytics opportunities

Step 5 of 9

Step 4. Turn decisions into analytics opportunities

You now have a list of questions from each stage of the customer journey. The next step is to turn those questions into defined analytics use cases — something specific enough to build, prioritise, and assign.

Two things make a question into a proper use case.

A stakeholder. Every use case needs a named owner in the business who will act on the output. A question without a stakeholder is a question that will produce analytics nobody uses. Go back through your list and attach a name or a role to every question before moving forward.

A pattern. An analytics pattern is the type of solution the question calls for. Knowing the pattern tells you what kind of work is involved, what skills you need, and which questions can be grouped and built together.

The six patterns are:

  • Descriptive / Monitoring — What is happening? (Dashboards, KPI tracking)
  • Diagnostic / Root Cause — Why is it happening? (Segmentation, cohort analysis)
  • Predictive / Forecasting — What will happen? (Models, scoring, forecasting)
  • Prescriptive / Optimisation — What should we do? (Optimisation, recommendations)
  • Detection / Alerting — What needs attention now? (Anomaly detection, alerts)
  • Measurement / Attribution — Did it work? (A/B testing, causal inference)

For a full explanation of each pattern, see Analytics patterns.

Example — B2B SaaS

StageStakeholderQuestionPatternExample algorithm
MarketingCMOWhich campaigns are driving signups, and what is the cost per trial?DescriptiveCampaign performance dashboard; cost-per-trial by channel
MarketingCMOWhich campaigns are most likely to bring in accounts that convert and stay? Where should we shift budget?Predictive + PrescriptiveLogistic regression on trial-to-paid conversion by source; budget allocation model
SalesHead of SalesWhat is our win rate by deal size and segment? Where are we losing?Descriptive + DiagnosticWin rate dashboard; cohort analysis by deal size and segment
SalesHead of SalesWhich prospects are most likely to close, and which should the team prioritise this week?PredictiveLead scoring model (gradient boosting on CRM activity and firmographic features)
SignupHead of ProductWhere are people dropping off in the signup flow?DiagnosticFunnel drop-off analysis by step and traffic source
SignupHead of GrowthWhich visitors are most likely to complete signup if we intervene?PredictivePropensity model on visitor behaviour signals
OnboardingHead of Customer SuccessWhat proportion of new accounts complete onboarding, and how long does it take?DescriptiveOnboarding completion rate and time-to-completion dashboard
OnboardingHead of Customer SuccessWhich new accounts are struggling and need intervention before they disengage?Detection / AlertingEarly warning model on onboarding activity; threshold triggers on login and setup completion
ActivationHead of ProductWhat is our time to first value, and how does it vary by segment?Descriptive + DiagnosticTime-to-activation metrics; segment comparison
ActivationHead of Customer SuccessWhich users are at risk of never activating, and what nudge is most likely to help?Predictive + PrescriptiveClassification model on first-week behaviour; recommendation model for intervention type
Ongoing usageHead of ProductWhich features are being used and which are being ignored?DescriptiveFeature usage dashboard; engagement analysis by user and segment
Ongoing usageCPO, Head of Customer SuccessWhich product investments would most improve retention? Which disengaged users are about to churn?Diagnostic + PredictiveFeature importance analysis on retention cohorts; churn prediction model
ExpansionHead of SalesWhich accounts have grown usage without upgrading their plan?DescriptiveUsage-vs-plan gap analysis
ExpansionHead of SalesWhich accounts are ready to expand, and what is the right offer and timing?Predictive + PrescriptiveExpansion propensity model on usage signals; offer recommendation engine
RenewalCFO, Head of Customer SuccessWhat is our renewal rate by segment and cohort?DescriptiveRenewal rate cohort dashboard
RenewalHead of Customer SuccessWhich accounts are at risk of not renewing, and what should we do about each one?Predictive + PrescriptiveChurn prediction model; next-best-action recommendation
ChurnCEO, Head of Customer SuccessWhy are customers leaving, and does the reason vary by segment?DiagnosticExit reason analysis; churn driver segmentation
ChurnHead of Customer SuccessWhich active accounts are most likely to churn in the next 90 days?PredictiveTime-to-churn model; survival analysis; binary classification
Win-backHead of SalesWhat is our win-back rate, and which types of former customers return?Descriptive + DiagnosticWin-back rate analysis; segment comparison of returning vs non-returning accounts
Win-backHead of SalesWhich churned accounts are worth pursuing, and what offer has the best chance of working?Predictive + PrescriptiveWin-back propensity model; offer optimisation

Example — Non-bank lender

StageStakeholderQuestionPatternExample algorithm
MarketingCMOWhich campaigns are generating applications that go on to settle? What is the cost per settled loan?DescriptiveCampaign-to-settlement attribution dashboard; cost per settled loan by channel
MarketingCMOWhere should we shift budget to get more of the right applications?PrescriptiveChannel ROI model; budget allocation optimisation
ReferralHead of DistributionWhich brokers are sending the most volume and the best quality applications?Descriptive + DiagnosticBroker performance dashboard; quality scoring by settlement rate and default rate
ReferralHead of DistributionWhich brokers should we invest more in, and which are costing more than they are worth?Diagnostic + PrescriptiveBroker value model; commission cost-benefit analysis
ApplicationCOOWhat is application volume by channel and how is the mix trending?DescriptiveApplication mix dashboard; channel trend analysis
ApplicationCEO, COOAre there sources of applications we are underinvesting in?Diagnostic + PrescriptiveChannel opportunity analysis; segment gap analysis
Pre-approvalCCOWhat proportion proceed to full approval, and where do they fall over?Descriptive + DiagnosticPre-approval conversion funnel; decline reason analysis
Pre-approvalCCOWhich applications are likely to fail at approval so we can flag them early?PredictiveEarly approval failure prediction model; classification on application features
Document collectionCOOHow long is this taking, and where are the delays?Descriptive + DiagnosticTime-in-stage analysis; delay driver analysis by document type and borrower segment
Document collectionCOOWhich applications are going to miss settlement targets unless we intervene?Predictive + DetectionTime-to-completion prediction; escalation trigger model
ApprovalCCOWhat is our approval rate, and how does credit performance compare to what we expected?Descriptive + DiagnosticApproval rate dashboard; predicted vs actual default performance monitoring
ApprovalCCO, COOAre there applications in the queue we should prioritise or escalate?PrescriptiveApplication prioritisation scoring; queue optimisation model
Settlement and fundingCOOWhat proportion of settlements are on time, and where do delays come from?Descriptive + DiagnosticSettlement time dashboard; delay reason analysis
Settlement and fundingCOOWhich loans in the pipeline are at risk of not settling on time?PredictiveSettlement delay prediction model; risk scoring
ServicingCFOHow is the book performing by cohort, product, and channel?DescriptivePortfolio performance dashboard; cohort analysis
ServicingCCO, CFOWhich borrowers are showing early signs of stress before they miss a payment?Detection / AlertingEarly warning model on repayment behaviour; anomaly detection on payment patterns
HardshipCCOWhat proportion of hardship arrangements result in the borrower returning to normal repayments?Descriptive + DiagnosticHardship outcome tracking; cohort comparison by arrangement type
HardshipCCOWhich borrowers are at risk of entering hardship in the next three months?PredictiveHardship propensity model; early intervention scoring using repayment and behavioural features
ArrearsHead of CollectionsWhich contact approaches are most effective at resolving arrears?Measurement / AttributionA/B analysis of contact strategies; intervention effectiveness measurement
ArrearsHead of CollectionsWhich borrowers in arrears are most likely to resolve without escalation, and which need immediate action?Predictive + PrescriptiveArrears resolution prediction model; next-best-action for collections team
Discharge or refinanceCFOHow many customers are leaving at refinance and what is the typical timing?Descriptive + DiagnosticDischarge reason analysis; prepayment speed by cohort and product
Discharge or refinanceCFO, Head of RetentionWhich borrowers are most likely to refinance away in the next six months, and is there an offer that would retain them?Predictive + PrescriptivePrepayment prediction model; retention offer optimisation

In Step 5, you will score each of these use cases for business impact — using the strategic context from Step 3 to separate what matters from what is merely interesting.