Ticketing and fan data governance framework deployed across 8 venues

Challenge

The regional division managed 8 venues, each using a separate ticketing system and fan database. This setup created duplicate fan records across systems, leading to incorrect ticket sales attribution, repeated loyalty points, and failed upsell attempts targeting existing customers. The revenue team calculated these problems were costing nearly $1 million annually.

Approach

We created a single fan identity by matching email, phone, and purchase data across eight venue databases to eliminate duplicates. Then, we set up rules to block new duplicates from entering the system. Finally, we built a dashboard to monitor duplicate rates in real time.

Outcome

We cleaned up the fan database by merging duplicates, cutting them from 184,000 to 11,200 within 800,000 records. This fixed misattributed sales and duplicate loyalty points, stopping $940K in annual revenue losses. With accurate fan records, the upsell campaign failure rate fell sharply, from 144 to 24 failures per month, because campaigns reached the right audience.

We rolled up our sleeves and sifted through 800,000 fan records. Turns out, 184,000 were duplicates. So, we cleaned house and cut out all the repeats.

We dove into the data and uncovered 184,000 duplicate fan records out of 800,000 across eight venues. That blew the revenue team’s minds, it was way more than they expected. The duplicates had piled up over six years because each venue was managing its own data, completely siloed. There was no way to connect fan identities across locations.

Spotting problems early saved us a bunch of time and money.

First off, we cleaned up all the duplicate records. Then, we put in place some quick checks to catch duplicates the moment new fan records popped up. That small change slashed monthly duplicates down to under 4,000.

How We Put Together Upsell Campaigns That Really Reached the Right Customers, and Got Results

About 18 of every 100 of our upsell campaigns were bombing because duplicate records kept sending mixed messages to the wrong fans. So, we jumped on fixing that with identity resolution. Once we did, our campaigns hit the right fan profile 97 of every 100 times. Crisis averted.

Results

• $940K Annual revenue leakage resolved
• 184K to 11K Duplicate fan records
• 8 Venues on unified fan identity
• 144 to 24 Failed campaigns per month

In the client's terms

The question

Which number is right, and who gets to decide?

The situation

Eight venues, eight ticketing systems, eight fan databases. The same fan existed several times over, so sales were attributed to the wrong venue, loyalty points were issued twice, and upsell campaigns were sent to people who had already bought. The revenue team put it near $1M a year.

What we found

Nobody owned the fan record, so nobody was accountable for whether two rows were the same person. Deduplicating once would have bought about a quarter before the duplicates returned.

What it produced

Duplicates fell from 184,000 to 11,200 across 800,000 records. Misattributed sales and double-issued loyalty points stopped, closing $940K a year in leakage. Failed upsell campaigns fell from 144 a month to 24.

The roadmap

A single fan identity resolved across all eight databases on email, phone and purchase history. Then the part that matters: rules at the point of entry so new duplicates cannot be created, rather than a clean-up that has to be repeated. A live duplicate-rate dashboard so the next drift is visible while it is small.

The work behind this result

• We cannot trust the numbers, the problem this engagement resolved.
• Semantic Layer Engineering Consulting
• Master Data Management Consulting
• Data Governance Consulting Services
• Reporting Improvement Business Case, for whoever has to approve the spend.
• The 30 day Corporate Drag and Risk Diagnostic, findings yours either way.

Related case studies

• Implemented a data governance framework in 6 regional offices that cut FOIA response time from 34 to 8 days and stopped $1.2M in yearly compliance penalties.
• Automated call report preparation cut compliance labor from three weeks to two days and eliminated $680K in annual costs, resulting in zero MRAs in the next exam cycle.
• Built a reliable ESG data system that cut sustainability report prep time from 18 weeks to 3 weeks.
• Improved data accuracy in 12 city departments to recover $4.1M in federal grants lost to reporting errors.