Customer 360
Entity 360

Building Fan 360 with AI-based entity resolution on Snowflake

How the CFL unified fan identities across 9 teams, multiple channels, and years of fragmented data, resolving 15% of records that would otherwise go permanently unmatched.

"We've seen those positive results, going from over 24 hours to less than 20 minutes. I think about simplicity, cost, and scalability and Zingg checks all three."

Dave Musambi, Senior Director, Business Intelligence
‍Canadian Football League

Customer image
15%
Fan records resolved that would otherwise go unmatched
24h → 20m
Resolution runtime using Zingg on Snowflake
9 teams
Touchpoints unified into a single fan profile
Background

The Canadian Football League manages fan relationships across 9 teams and multiple digital touchpoints, online, in-store, by phone, and at stadiums. Each interaction generated its own record, in its own format, with no shared identifier. The data team had a Snowflake warehouse and one clear goal: understand every fan as one person, across every channel.

Challenge

Fan profiles were fragmented by email variations, name spellings, and years of siloed data across teams. Building deterministic rules to unify them would have required enormous manual effort, and would still miss the fuzzy matches that made up the bulk of duplicates. The solution also had to run natively inside Snowflake: no external clusters, no data movement, no maintenance overhead.

Solution

The CFL adopted Zingg Enterprise on Snowflake, normalising fan data from all 9 teams into a clean layer before training began. From there, the resolution pipeline ran entirely inside Snowflake, with no data movement and no external clusters.

  • ML model trained on just 40–50 labelled match pairs per field to get started
  • Full pipeline runs natively inside Snowflake, with no data leaving the warehouse
  • Runtime dropped from 24+ hours to under 20 minutes after Zingg's Snowflake-native optimisation
"I read your article about the journey of optimizing Zingg from over 24 hours to less than 20 minutes — and we’ve seen those positive results as well. I think about simplicity, cost, and scalability — Zingg checks all three."

Dave Musambi, Senior Director, Business Intelligence
‍Canadian Football League

Results
  • Fans who interact online, in-store, by phone and at stadiums now unified as a single profile, for the first time
  • Targeted campaigns and loyalty programs now possible across all 9 teams with a complete fan view
  • Personalised digital experiences previously out of reach became achievable with unified identity data
  • Data team freed from manual rule-writing and cluster management overhead entirely
Platform
Snowflake
Edition
Community
Customer
Canadian Football League
Full Transcript
Read the complete transcript
15 min read
→
FULL VIDEO
Watch the complete interview
→

See how Zingg runs natively on Snowflake — no cluster management, no data movement, no preprocessing overhead.

See how it works →