Innovation & AI · Deterministic analytics prototype

Pipeline IQ

Where is marketing spend actually producing qualified pipeline?

A browser-based diagnostic that helps growth leaders compare paid media spend with CRM pipeline, while keeping data quality and attribution assumptions visible.

Self-directed prototypeDeterministic calculations
Interface

Visible inputs.
Traceable outputs.

Actual prototype screens show the landing page and the analysis flow. Open the screenshots at full size for more detail.

Pipeline IQ landing screen asking where marketing spend produces qualified pipeline
Prototype interface · opening screen · open full image ↗
Pipeline IQ analysis interface with channel and pipeline diagnostics
Prototype interface · analysis view · open full image ↗
Why it was built

Answer the CFO's
pipeline question.

Marketing spend is reported in ad platforms while pipeline lives in the CRM. The two are rarely reconciled cleanly, so channel budgets can be defended using lead counts that say little about commercial quality.

Pipeline IQ is designed to help a CMO or RevOps lead see which sources are associated with qualified conversations, where spend is out of balance and how much pipeline remains unattributed.

Who it is for

Marketing, revenue
& finance leaders.

Built for CMOs, Heads of Growth, RevOps, CFOs and board members at growth-stage B2B organisations who need a more defensible view of channel efficiency.

The tool diagnoses the supplied exports. It does not prove that a channel caused a sale or that the CRM captures every influence.
Methodology

Deterministic calculations.
Explicit assumptions.

01 · Load the exports

The user supplies a CRM pipeline CSV and a paid media spend CSV. Processing is designed to happen in the browser.

02 · Confirm the data shape

The user identifies whether the CRM file is lead-level or deal-level. The interface detects likely columns, then asks the user to confirm the mappings.

03 · Define qualification

The user selects the CRM stage that represents a qualified commercial conversation, since stage names differ between businesses.

04 · Calculate and surface gaps

Rules calculate cost per qualified conversation, pipeline velocity by source, the qualification gap, spend share versus qualified share, and the dark funnel.

Data hygiene matters: empty, unknown and unmatched source values are grouped into an unattributed measure instead of silently disappearing from the analysis.
What the prototype is and is not

A diagnostic for better
budget conversations.

Deterministic

Calculations follow defined rules and user-confirmed mappings; no LLM is used to produce the metrics.

Transparent

Qualification definitions and unattributed records remain visible so the user can judge data reliability.

Not causal attribution

Correlations between sources and pipeline are not proof of incremental channel impact.

Prototype status

Screens show a working concept, not a client deployment or a measured business outcome.