Marketing Performance Intelligence: Executive Dashboard

Uploaded Data: n8n_marketing_diagnostic_test.csvReporting period: 2026-10 vs 2026-09
Data quality checks passed with no warnings.

Executive performance summary Calculated from source data

Reported investment increased while pipeline declined.

  • Overall performance: Reported spend increased 21.4% to $85,000, while pipeline decreased 4.9% to $1,439,000 and opportunities decreased 6.4% to 191.
  • Paid Social: pipeline -20.6% ($238,000 to $189,000) while spend moved +21.4%.
  • Paid Search qualified-to-opportunity ratio went from 35.00% to 28.00% (-7.00 pp, -20.0%); period-based, not a cohort rate.
  • Organic Search: pipeline +13.0% with no direct media spend reported; spend-based efficiency metrics are not applicable.

Changes are calculated from period-based source data and do not establish causation.

Executive KPI summary

All channels combined, 2026-10 vs 2026-09

Total spend
$85,000
▲ +21.4%
Previous: $70,000
Spend direction is neither good nor bad without efficiency context
Total pipeline
$1,439,000
▼ -4.9%
Previous: $1,513,000
Total opportunities
191
▼ -6.4%
Previous: 204
Cost per qualified lead
$138.89
▲ +13.5%
Previous: $122.38
Lower is better
Lead-to-opportunity
10.32%
▼ -13.5% (-1.61 pp)
Previous: 11.93%
Period-based ratio, not a cohort rate

Executive decisions and next actions

Calculated observations, hypotheses, and recommended actions

What we know

Calculated from source data
  • Total spend moved +21.4% ($70,000 to $85,000) while total pipeline moved -4.9% ($1,513,000 to $1,439,000).
  • Cost per qualified lead moved +13.5% and lead-to-opportunity conversion moved -13.5% (-1.61 pp).
  • Paid Search qualified-to-opportunity ratio fell from 35.00% to 28.00% (period-based).
  • 6 rule-based anomalies were flagged (5 high, 1 medium, 0 low).

Calculated from the uploaded CSV file; these describe what changed, not why.

What we need to validate

Hypotheses, not confirmed causes
  • Paid Search pipeline decline may be concentrated in sales-stage progression after qualification rather than top-of-funnel acquisition. Hypothesis
    Evidence: Paid Search leads rose 12.9% and qualified leads rose 7.1%, while opportunities fell 14.3%. The observed deterioration is in qualified-to-opportunity, which fell from 35.0% to 28.0% (-7.0 pp, -20.0%).
    Validate by: Run a cohort analysis by lead creation date for September and October Paid Search qualified leads, measuring aging-adjusted qualified-to-opportunity rates, follow-up speed, rejection reasons, and stage-definition consistency.
  • Paid Social decline may reflect combined pressure at acquisition and qualification stages rather than one isolated bottleneck. Hypothesis
    Evidence: Paid Social clicks rose 7.1%, but leads fell 3.6%, qualified leads fell 13.4%, opportunities fell 20.6%, and pipeline fell 20.6%. Stage declines were click-to-lead 2.7% to 2.4% (-0.3 pp, -10.0%), lead-to-qualified 20.0% to 18.0% (-2.0 pp, -10.2%), and qualified-to-opportunity 30.4% to 27.8% (-2.5 pp, -8.3%).
    Validate by: Audit Paid Social lead source records, form completion quality, qualification outcomes, and sales disposition by lead creation week; then compare aging-adjusted progression to determine whether the drop starts at lead capture, qualification, or later follow-up.
  • Organic Search growth may be real, but the lower qualified-to-opportunity rate could reflect conversion lag or weaker downstream progression among newer qualified leads. Hypothesis
    Evidence: Organic Search clicks rose 8.3%, leads rose 15.6%, qualified leads rose 19.4%, opportunities rose 11.1%, and pipeline rose 13.0%, while qualified-to-opportunity fell from 40.0% to 37.2% (-2.8 pp, -7.0%).
    Validate by: Review Organic Search qualified leads by creation date and content entry path, then measure time-to-opportunity, sales acceptance, and lead aging to see whether the lower period ratio persists after cohorts mature.

Decisions requiring additional evidence

  • #1 Organic Search high-intent conversion-path replication test: The current dataset does not include page-level traffic or lead-level source paths. Launch requires page-level analytics and lead-level source-to-page mapping. Complete a power calculation before launch using baseline visitor-to-qualified-lead rate for eligible pages, minimum detectable relative change, expected organic traffic to test pages, allocation method, and desired confidence and power.
  • #2 Paid Search post-MQL progression diagnostic with routed-sales holdout: Lead-level cohort data is required because current inputs are only period aggregates. Complete a power calculation before launch using baseline aging-adjusted qualified-to-opportunity rate, minimum detectable relative improvement, traffic volume of Paid Search qualified leads, allocation ratio, and desired confidence and power.
  • #3 Paid Social landing-page and form-path conversion test with incrementality holdout: Current data is aggregated by period, so launch requires variant-level and lead-level tracking plus cost data. Complete a power calculation before launch using baseline lead-to-qualified rate, minimum detectable relative change, Paid Social traffic and lead volume, split ratio, and desired confidence and power. If an incrementality holdout is included, power inputs must also cover expected holdout size and outcome variance.

Budget changes should wait for this evidence; attributed pipeline and CPL alone do not establish marginal returns.

Next actions

Priority investigations and recommendations (AI-generated):

  1. Pause further Paid Search spend increases until an aging-adjusted cohort review confirms whether the qualified-to-opportunity drop is lag or true sales-stage deterioration.
    Why: Paid Search spend rose 21.4% while pipeline fell 12.9%, and the confirmed bottleneck is qualified-to-opportunity falling from 35.0% to 28.0% (-7.0 pp, -20.0%). Attribution limits and conversion lag make immediate budget conclusions unreliable. · Owner: Demand Gen and Sales Ops
  2. Run a controlled Paid Social landing-page and qualification audit by lead creation week to isolate whether losses begin at click-to-lead or lead-to-qualified.
    Why: Paid Social showed broad deterioration: click-to-lead fell 2.7% to 2.4% (-0.3 pp), lead-to-qualified fell 20.0% to 18.0% (-2.0 pp), and pipeline fell 20.6% while spend rose 21.4%. Because decline spans multiple stages, CPL alone is insufficient for budget decisions. · Owner: Demand Gen and Marketing Ops
  3. Audit Organic Search qualified leads for time-to-opportunity and sales disposition before adding resources, despite growth in leads, opportunities, and pipeline.
    Why: Organic Search improved in volume and pipeline, but qualified-to-opportunity fell from 40.0% to 37.2% (-2.8 pp, -7.0%). Organic is a non-paid acquisition channel, so reported spend is not interchangeable with paid media budget. · Owner: SEO Lead and Sales Ops

Experiments in priority order:

  1. #1 Organic Search high-intent conversion-path replication test (score 16.00, illustrative)
  2. #2 Paid Search post-MQL progression diagnostic with routed-sales holdout (score 15.00, illustrative)
  3. #3 Paid Social landing-page and form-path conversion test with incrementality holdout (score 9.00, illustrative)

Channel performance

Paid Search, Paid Social and Organic Search compared with the previous period

ChannelSpendPipelineCPLCost / qualified leadLead-to-opp conversion
Paid Search
$51,000
was $42,000
▲ +21.4%
$640,000
was $735,000
▼ -12.9%
$64.56
was $60.00
▲ +7.6%
$170.00
was $150.00
▲ +13.3%
10.63%
was 14.00%
▼ -24.1% / -3.37 pp
Paid Social
$34,000
was $28,000
▲ +21.4%
$189,000
was $238,000
▼ -20.6%
$62.96
was $50.00
▲ +25.9%
$350.52
was $250.00
▲ +40.2%
5.00%
was 6.07%
▼ -17.6% / -1.07 pp
Organic Search
$0
was $0
— 0.0%
$610,000
was $540,000
▲ +13.0%
n/a
was n/a
— n/a
n/a
was n/a
— n/a
15.38%
was 16.00%
▼ -3.9% / -0.62 pp
All Channels
$85,000
was $70,000
▲ +21.4%
$1,439,000
was $1,513,000
▼ -4.9%
$45.95
was $40.94
▲ +12.2%
$138.89
was $122.38
▲ +13.5%
10.32%
was 11.93%
▼ -13.5% / -1.61 pp

Improved Deteriorated Context-dependent (spend) Direction is judged per metric: lower is better for CPL and cost per qualified lead; higher is better for pipeline and conversion. Spend changes are shown neutrally.

Funnel bottlenecks

Stage conversion by channel, previous vs current period

Non-cohort metrics. Funnel ratios are period-based (current-period outcomes divided by current-period volumes), not true cohort conversion rates. Bars share one scale across stages and channels.
Most significant bottleneck: Paid Search qualified-to-opportunity 35.00% to 28.00% (-7.00 pp, -20.0% relative).

Paid Search

Concentrated bottleneck

One stage fell more than 15% while other stages held, improved, or declined only slightly (under 7.5%).

Click-to-lead▲ +0.34 pp / +6.8%
Prev
5.00%
Curr
5.34%
Lead-to-qualified▼ -2.03 pp / -5.1%
Prev
40.00%
Curr
37.97%
Qualified-to-opportunity▼ -7.00 pp / -20.0%
Prev
35.00%
Curr
28.00%
Over 15% threshold

Paid Social

Distributed decline

3 stages declined, none by more than 15%. The declines compound.

Click-to-lead▼ -0.27 pp / -10.0%
Prev
2.67%
Curr
2.40%
Lead-to-qualified▼ -2.04 pp / -10.2%
Prev
20.00%
Curr
17.96%
Qualified-to-opportunity▼ -2.52 pp / -8.3%
Prev
30.36%
Curr
27.84%

Organic Search

Isolated minor decline

One stage declined, by less than 15%.

Click-to-lead▲ +0.17 pp / +6.7%
Prev
2.50%
Curr
2.67%
Lead-to-qualified▲ +1.35 pp / +3.4%
Prev
40.00%
Curr
41.35%
Qualified-to-opportunity▼ -2.79 pp / -7.0%
Prev
40.00%
Curr
37.21%

Anomaly summary

Rule-based alerts grouped by channel and ordered by severity

6 unique anomalies: 5 HIGH 1 MEDIUM 0 LOW Each alert appears once; funnel-stage findings are merged into the related alert.

Paid Search

3 alerts
HIGHSpend up, pipeline down

Spend +21.4% while pipeline -12.9%.

HIGHLead-to-opportunity decline above 15%

Lead-to-opp rate -24.1% (14% to 10.63%). Funnel stage contributing to this: Qualified-to-opportunity 35% to 28% (-7 pp, -20% relative).

MEDIUMQualified leads up, opportunities down

Qualified leads +7.1% while opportunities -14.3%. Funnel stage contributing to this: Qualified-to-opportunity 35% to 28% (-7 pp, -20% relative).

Paid Social

3 alerts
HIGHSpend up, pipeline down

Spend +21.4% while pipeline -20.6%.

HIGHCPL increase above 20%

CPL +25.9% ($50 to $62.96).

HIGHLead-to-opportunity decline above 15%

Lead-to-opp rate -17.6% (6.07% to 5%). No unflagged individual funnel stage declined more than 15%; observed smaller stage declines: (Click-to-lead -10%, Lead-to-qualified -10.2%, Qualified-to-opportunity -8.3%).

Organic Search

0 alerts

No anomalies detected.

Prioritized growth experiments

Ranked by illustrative priority score

Illustrative estimates. Priority Score = (Impact x Confidence x Feasibility) / Effort. Impact, Confidence, Feasibility: 1 (low) to 5 (high). Effort: 1 (low effort) to 5 (high effort). Scores are AI-proposed inputs combined by a fixed formula; they are not measured business facts, and no baselines or financial returns are assumed.
#1

Organic Search high-intent conversion-path replication test

Organic Search · Owner: SEO Lead and CRO Manager
16.00
Priority score
(illustrative estimate)
Impact 4Confidence 3Feasibility 4Effort 3

(4 x 3 x 4) / 3 = 16 · Priority Score = (Impact x Confidence x Feasibility) / Effort

Linked finding

Organic Search clicks rose 8.3%, leads rose 15.6%, qualified leads rose 19.4%, opportunities rose 11.1%, and pipeline rose 13%, while qualified-to-opportunity fell from 40% to 37.21% (-2.79 pp, -7%).

Hypothesis Hypothesis, not confirmed

Replicating the highest-intent organic entry paths and conversion journeys on additional relevant pages may increase qualified lead generation without worsening downstream quality, though the observed qualified-to-opportunity dip may be lag rather than lower lead quality.

Test design

Treatment: Apply a replicated high-intent conversion-path template to a randomized or phased set of eligible Organic Search landing pages, including clearer CTA hierarchy, tighter message match, and a consistent handoff path based on the best-performing existing page patterns.

Control: Leave a matched set of eligible Organic Search landing pages unchanged during the same period, or use a phased rollout with untreated pages as concurrent controls.

Rationale: Organic Search is the strongest growth area in the available data and is not dependent on paid budget reallocation. Testing on-page replication is an actionable growth experiment using a comparatively healthier channel, while still monitoring downstream quality because period-based qualified-to-opportunity has softened.

Success metrics

Primary: Organic Search visitor-to-qualified-lead conversion rate by tested page cohort

Secondary:

  • Organic Search visitor-to-lead conversion rate
  • Qualified-lead volume from tested pages
  • Aging-adjusted qualified-to-opportunity conversion rate for leads sourced from tested pages
  • CTA click-through rate on tested pages

Guardrails:

  • No material decline in sales acceptance rate of Organic Search qualified leads
  • No material decline in average pipeline per opportunity
  • No material deterioration in bounce or engagement metrics for tested pages

Measurement window: Use a phased or randomized page-level test long enough to accumulate stable page-level traffic, then allow additional cohort aging time before judging downstream opportunity progression from Organic Search leads generated during the test.

Measurement dependencies

  • Landing-page URL or content group
  • Organic session counts by page
  • CTA clicks by page variant
  • Lead creation timestamp
  • Qualification timestamp
  • Opportunity creation timestamp
  • Lead source and entry page
  • Sales acceptance or disposition data
Additional data required before launch: The current dataset does not include page-level traffic or lead-level source paths. Launch requires page-level analytics and lead-level source-to-page mapping. Complete a power calculation before launch using baseline visitor-to-qualified-lead rate for eligible pages, minimum detectable relative change, expected organic traffic to test pages, allocation method, and desired confidence and power.

Decision criteria

Scale: Scale the page template to more Organic Search pages only if the treatment improves the primary metric versus control and guardrails remain stable after enough downstream aging time.

Iterate: Iterate if the treatment improves visitor-to-lead conversion but not visitor-to-qualified-lead conversion, or if effects vary materially by page type or search intent cluster.

Stop: Stop if the treatment fails to improve the primary metric or if improved conversion is accompanied by weaker downstream quality guardrails after cohort maturation.

Scoring assumptions
  • Impact: Organic Search is already growing and could provide scalable learning without relying on paid budget changes.
  • Confidence: Directional evidence is positive, but page-level drivers are not visible in the current aggregate data.
  • Effort: Page-template replication and instrumentation are moderate compared with channel-wide operational changes.
  • Feasibility: A phased page test is practical once page-level analytics and source-path mapping are available.
#2

Paid Search post-MQL progression diagnostic with routed-sales holdout

Paid Search · Owner: Demand Gen Manager and Sales Ops
15.00
Priority score
(illustrative estimate)
Impact 5Confidence 4Feasibility 3Effort 4

(5 x 4 x 3) / 4 = 15 · Priority Score = (Impact x Confidence x Feasibility) / Effort

Linked finding

Paid Search qualified-to-opportunity fell from 35% to 28% (-7 pp, -20% relative), while qualified leads rose 7.1% and opportunities fell 14.3%.

Hypothesis Hypothesis, not confirmed

The Paid Search decline may be driven by lower progression after qualification for some routed segments, or by conversion lag and lead aging rather than a true underlying quality drop.

Test design

Treatment: For a randomized subset of new Paid Search qualified leads, apply an accelerated post-qualification handoff package such as stricter routing SLAs, immediate rep alerts, and standardized first-touch follow-up sequence.

Control: Maintain current post-qualification routing and follow-up process for the remaining randomized subset of new Paid Search qualified leads.

Rationale: The confirmed anomaly is downstream, not top-of-funnel: leads and qualified leads rose while opportunities fell. A randomized operational treatment helps test whether progression can be improved without assuming channel-attributed decline equals incremental business loss. Because source data is period-aggregate only, lead-level timestamps and routing data are required before launch.

Success metrics

Primary: Aging-adjusted qualified-lead-to-opportunity conversion rate for Paid Search leads by lead creation cohort

Secondary:

  • Median time from qualification to first sales touch
  • Median time from qualification to opportunity creation
  • Opportunity creation rate within fixed cohort age bands
  • Disposition or rejection reason mix for Paid Search qualified leads

Guardrails:

  • Sales acceptance rate of Paid Search qualified leads
  • Average pipeline per opportunity for Paid Search
  • No material decline in contact rate or meeting-booked rate versus control

Measurement window: Run until pre-launch power calculation requirements are met, then observe each lead cohort long enough for qualification-to-opportunity lag to mature; include an additional readout after the majority of in-test cohorts have reached the agreed aging threshold.

Measurement dependencies

  • Lead creation date
  • Qualification timestamp
  • Opportunity creation timestamp
  • Lead source and sub-source
  • Campaign or ad group identifier
  • Sales owner or routing path
  • First-touch follow-up timestamp
  • Disposition or rejection reason
Additional data required before launch: Lead-level cohort data is required because current inputs are only period aggregates. Complete a power calculation before launch using baseline aging-adjusted qualified-to-opportunity rate, minimum detectable relative improvement, traffic volume of Paid Search qualified leads, allocation ratio, and desired confidence and power.

Decision criteria

Scale: Scale the accelerated handoff process for Paid Search only if the treatment improves the primary metric versus control after cohorts mature and guardrails remain stable or better.

Iterate: Iterate if directional improvement appears in the primary metric but results differ by segment, or if guardrails show mixed tradeoffs that suggest the need to refine routing or follow-up steps.

Stop: Stop if the treatment does not improve the aging-adjusted primary metric after the planned observation window, or if guardrails worsen materially versus control.

Scoring assumptions
  • Impact: Paid Search is the largest paid pipeline contributor and shows the clearest confirmed downstream deterioration.
  • Confidence: The bottleneck is well supported by the period data, but the cause remains a hypothesis until aging-adjusted cohort analysis is available.
  • Effort: Requires sales-process coordination, lead-level instrumentation, and randomized operational execution.
  • Feasibility: Measurement is feasible only after lead-level timestamps, routing, and cohort maturation data are available.
#3

Paid Social landing-page and form-path conversion test with incrementality holdout

Paid Social · Owner: Paid Social Lead and Marketing Ops
9.00
Priority score
(illustrative estimate)
Impact 4Confidence 3Feasibility 3Effort 4

(4 x 3 x 3) / 4 = 9 · Priority Score = (Impact x Confidence x Feasibility) / Effort

Linked finding

Paid Social deterioration is spread across stages: click-to-lead fell from 2.67% to 2.4% (-10%), lead-to-qualified fell from 20% to 17.96% (-10.2%), and qualified-to-opportunity fell from 30.36% to 27.84% (-8.3%).

Hypothesis Hypothesis, not confirmed

A simpler Paid Social post-click experience and tighter qualification cues may improve lead capture and downstream lead quality, but the observed channel-attributed decline may not equal incremental business impact without a holdout.

Test design

Treatment: Send a randomized treatment share of Paid Social traffic to a simplified landing-page and form path with clearer qualification cues, reduced friction, and stronger message match between ad and page; maintain existing media delivery otherwise.

Control: Keep the current Paid Social landing-page and form experience for the randomized control share. If platform execution allows, maintain a small audience or geo holdout from Paid Social exposure to estimate incremental lead creation alongside attributed conversion changes.

Rationale: Paid Social weakness appears to start before and during qualification rather than at one isolated stage. A randomized post-click test addresses click-to-lead and lead-to-qualified hypotheses directly, while a holdout helps separate channel-attributed conversion changes from incremental business impact.

Success metrics

Primary: Lead-to-qualified-lead conversion rate for Paid Social lead cohorts

Secondary:

  • Click-to-lead rate
  • Cost per lead
  • Qualified-lead volume from Paid Social
  • Aging-adjusted qualified-to-opportunity conversion rate for Paid Social cohorts
  • Incremental lift in lead volume for any audience or geo holdout

Guardrails:

  • No material decline in form completion quality indicators
  • No material decline in sales acceptance rate of Paid Social qualified leads
  • Average pipeline per opportunity remains stable or better

Measurement window: Run until power requirements are met for the primary metric, then hold observation long enough for qualified leads generated in-test to age into opportunity where possible; report early on click-to-lead and later on aging-adjusted downstream progression.

Measurement dependencies

  • Landing-page variant assignment
  • Ad creative and audience identifiers
  • Clicks and sessions by variant
  • Lead creation timestamp
  • Qualification timestamp
  • Opportunity creation timestamp
  • Lead source and campaign metadata
  • Form-field completion and qualification outcomes
  • Cost by variant or campaign
  • Holdout or suppression assignment if used
Additional data required before launch: Current data is aggregated by period, so launch requires variant-level and lead-level tracking plus cost data. Complete a power calculation before launch using baseline lead-to-qualified rate, minimum detectable relative change, Paid Social traffic and lead volume, split ratio, and desired confidence and power. If an incrementality holdout is included, power inputs must also cover expected holdout size and outcome variance.

Decision criteria

Scale: Scale the treatment only if it improves the primary metric versus control after cohorts mature enough for qualification assessment, and guardrails remain stable; if a holdout is included, prefer scaling when attributed gains are directionally consistent with incremental lift.

Iterate: Iterate if click-to-lead improves but lead quality guardrails soften, or if results vary meaningfully by audience, creative, or form path.

Stop: Stop if the treatment does not improve the primary metric, or if higher lead capture is offset by weaker quality guardrails or no support from the incrementality read where measured.

Scoring assumptions
  • Impact: Paid Social shows broad deterioration and meaningful spend, so fixing the earliest failing stages could be commercially important.
  • Confidence: The decline is confirmed, but the exact failing mechanism is less isolated than in Paid Search.
  • Effort: Requires landing-page changes, tracking updates, and ideally a holdout for incrementality.
  • Feasibility: Measurement is feasible with variant, lead-level, and cost tracking, none of which are present in the current period aggregates.