Fan Unification Platform

One warehouse view of a fictional national soccer federation's fans, unified across CRM, ticketing, merch, and email marketing by a measured identity-resolution pipeline. All data is synthetic (seeded generator, no real persons) — which is exactly what makes the unification accuracy measurable against ground truth.

New here? Start the three-minute record-lineage tour to follow one generated source identity through matching, a golden record, SCD history, a warehouse fact, and a BI-ready mart row—with direct links to the code and SQL.

Measured against generator ground truth on every run — including the result that didn't flatter: at the naive threshold the probabilistic pass lost to plain deterministic rules, and the committed sweep that chose the operating point is published in full. Baseline vs probabilistic, head to head →

Revenue across every pillar

Ticketing, merch, memberships, and donations live in four different source systems; only unified identity makes one revenue picture possible.

Ticket → merch crossover

Of fans whose first ticket purchase fell in a month, the share who bought merch within 90 days — the cross-sell question unification exists to answer. Fans without a complete 90-day observation window are excluded, so the tail is censored honestly instead of reading as zero conversion.

Explore

• Start here: one record's lineage — source row to BI-ready result
• Unification quality — measured precision/recall vs ground truth
• Revenue · Engagement · Pipeline ops