metric_mdt_rfp_intake

beta

metric table

Incoming RFP intake volume by month, channel, study type, and pipeline status.

Definition

rfp_count is the number of incoming RFPs in a bucket, keyed on received_month with entity / region / study_type / channel / intake_status dimensions. Measures the pre-proposal intake funnel — not proposals or wins (only intake_status='quoted' RFPs became proposals).

Watch out for

highReading rfp_count as proposals or wins
rfp_count is incoming-request volume. Only RFPs with intake_status='quoted' became proposals; use mdt_pipeline / mdt_win_rate for proposal-grain analysis.
mediumIgnoring status when sizing the live queue
The live/open queue is intake_status in (received, qualifying, on_hold); quoted/declined are closed intake outcomes.

Questions this answers

“How many RFPs came in by channel this year?”
“What's the intake pipeline by status and study type?”

7 of 7

Column

Type

Description

Tests · PII

received_month

Date

First day of received month. Grain + sort key.

1 test

entity

LowCardinality(String)

Target Smithers legal entity. Dimension + sort key.

1 test

region

LowCardinality(String)

Client region. Dimension + sort key.

1 test

study_type

LowCardinality(String)

Study type requested. Dimension + sort key.

1 test

channel

LowCardinality(String)

Intake channel. Dimension + sort key.

1 test

intake_status

LowCardinality(String)

Intake-pipeline stage. Dimension + sort key.

1 test

rfp_count

UInt64

Count of incoming RFPs in the bucket.

1 test