abbhinavs

-- PQL vs MQL Lead Volume and SAM Conversion by Quarter
-- Level: Lead (inquiry-based, not org-deduped)
-- SAM source: fnd_sfdc.meeting (Inbound SDR, Meeting Completed, Manager Approved)
-- Lead type: PQL = campaign_type_v2 = 'Confluent Cloud Sign-Up', MQL = everything else
-- SAM-to-lead mapping: most recent MQL before the SAM date via DLF

WITH leads AS (
  SELECT
    inquiry_id,
    lead_or_contact_id,

abbhinavs

-- PQL vs MQL Lead Volume and SAM Conversion by Quarter
-- Level: Lead (inquiry-based, not org-deduped)
-- Source: dwh_inbound_funnel.denormalized_lead_funnel
-- Lead type: PQL = campaign_type_v2 = 'Confluent Cloud Sign-Up', MQL = everything else
-- SAM definition: new_is_real_meeting = TRUE

WITH leads AS (
  SELECT
    inquiry_id,
    mql_date_time,