Data Story

The Greenlight Funnel

A greenlight board where scripts move through stamped statuses — and the unlinked pile becomes part of the evidence.

filmimdbtmdbdevelopmentstudiospipelinedata-quality
Dataset scope
8382
companies
65492
dev projects
140
selected
Snapshot
not time
This dataset has no timestamps—so we visualize a slate snapshot. Unlinked projects are not errors; they’re part of the evidence.
Loading greenlight funnel
Hypothesis

Companies with a higher share of late-stage development projects show higher released conversion (lower bound) and stronger released medians.

Question: Do companies with different development-stage portfolios produce measurably different released outcomes?

Method: Normalize messy status strings into canonical stages; compute stage shares per company; summarize released-linked outcomes and unlinked volume.

Prediction: Higher late-stage share associates with higher released-linked medians, but unlinked volume varies by company.

Test: Compare companies stratified by late-stage share and inspect the released-linked medians with uncertainty from missing linkage.

Narrative Arc
Act I

A company’s slate appears as stacks by status — a snapshot of what’s on the table.

Act II

The funnel narrows: late-stage stamps crowd the end while early scripts pile high.

Act III

Released-linked survivors reveal outcomes, while the unlinked lane reminds us what data can’t see.

Datasets
  • imdb.company_dev_projects
  • imdb.companies
  • tmdb.movies
  • 17_greenlight_funnel.json
Limitations
  • No timestamps: this is a snapshot, not a true funnel over time.
  • Many dev projects can’t be joined to released outcomes.
  • Status strings are messy; normalization is approximate.
Next

Want another story? Head back to the film data stories index.

Back to indexarrow_forward