Open-data publication quality funnel

// Reconcile every excluded record and avoid silently losing quarantined data.
// Synthetic worked example: all entities, schedules and measurements are illustrative.
// Every string below is EXAMPLE text from a fictional model: replace it.
// Replace assumptions and inputs before applying this model to actual work.

initiative improvement {
  title: "Illustrative Open-data publication quality funnel"
  owner: "Process owner"
  horizon: "One illustrative reporting period"
}

cohort stage_0 {
  n: 12000 source "Synthetic teaching fixture"
}

funnel_step step_0 {
  title: "Example: Records imported"
  n: = stage_0.n
}

cohort stage_1 {
  n: 11500
  from: stage_0
  excluded: { schema_mismatch: 500 }
}

funnel_step step_1 {
  title: "Schema compliant"
  n: = stage_1.n
  from: step_0
}

cohort stage_2 {
  n: 11020
  from: stage_1
  excluded: { duplicate_rows: 480 }
}

funnel_step step_2 {
  title: "Duplicates removed"
  n: = stage_2.n
  from: step_1
}

cohort stage_3 {
  n: 10600
  from: stage_2
  excluded: { rights_unresolved: 420 }
}

funnel_step step_3 {
  title: "Rights confirmed"
  n: = stage_3.n
  from: step_2
}

cohort stage_4 {
  n: 10350
  from: stage_3
  excluded: { metadata_incomplete: 250 }
}

funnel_step step_4 {
  title: "Published with metadata"
  n: = stage_4.n
  from: step_3
}

kpi completion {
  title: "End-to-end completion share"
  baseline: = stage_4.n / stage_0.n * 100
  target: 80
  unit: "%"
}

kpi early_loss {
  title: "Initial gate attrition share"
  baseline: = (stage_0.n - stage_1.n) / stage_0.n * 100
  target: 5
  unit: "%"
}

view conversion: funnel(step_0)
view accounting: consort(stage_0)
view improvement_grid: okr_grid(improvement)