Fivetran > Case Studies > Denver Broncos Enhance Fan Experience with Fivetran's Automated ELT Process

Denver Broncos Enhance Fan Experience with Fivetran's Automated ELT Process

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Oil & Gas

Applicable Functions

Maintenance
Sales & Marketing

Use Cases

Leasing Finance Automation
Time Sensitive Networking

About The Customer

The Denver Broncos are one of the most successful pro football teams with eight AFC and three Super Bowl championships to their credit. They also have an impressive 52-year track record of selling out every home game. The team's ticket strategy and analytics are led by Clark Wray, the Senior Director of Ticket Strategy and Analytics. Wray and his team of four are responsible for maintaining the data flow, which is critical for continuing their sellout streak. They operate with a lean team and are constantly adding new data sources to reach the next generation of fans.

The Challenge

The Denver Broncos, a successful pro football team, faced a significant challenge in maintaining their data pipelines. The team's Senior Director of Ticket Strategy and Analytics, Clark Wray, and his lean team were spending excessive time on home-brewed data integrations. Whenever an original data source or API changed, it would disrupt the data connections they had built, often halting the flow of information for hours. If these issues were not addressed promptly, the business risked operating on inaccurate data. Additionally, the team was constantly adding new data sources to communicate and reach the next generation of fans. It was crucial for them to connect and centralize their email data in Dynamics 365, marketing automation data in Eloqua, and fan feedback in Qualtrics.

The Solution

The Denver Broncos turned to Fivetran to automate their Extract, Load, Transform (ELT) process. Fivetran's technology allowed the team to stop worrying about data source connections breaking, saving them time and enabling them to provide more comprehensive and accurate data insights faster to stakeholders. Fivetran also helped the Broncos eliminate many of their data silos, providing a 360-degree view of their fans, which was essential for delivering a frictionless experience. The team could create a unified and personalized cross-platform customer experience, see the entire marketing mix with access to over 50+ marketing connectors, and combine insights from these platforms across inter-department tools to build a holistic view. Fivetran's solution ensured quick and easy data ingestion into the Broncos' Snowflake cloud, providing accurate, reliable real-time data when needed.

Operational Impact

With Fivetran's automated ELT process, the Denver Broncos have been able to shift their focus from maintaining data pipelines to deriving insights from data. This has enabled them to enhance the fan experience significantly. The team now has a 360-degree view of their fans, which is crucial for delivering a frictionless experience. They can create a unified and personalized cross-platform customer experience, see the entire marketing mix, and build a holistic view by combining insights from various platforms. Fivetran's solution has also eliminated a lot of worry for the team, allowing them to focus on what they want most: a winning football team and happy fans.

Quantitative Benefit

The Denver Broncos ticket strategy and analytics team saves 20+ hours a week on data pipeline maintenance by automating the ELT process with Fivetran.
Fivetran's solution provides faster, real-time access to data, leading to a better, more personalized fan experience.
Every pipeline connected with Fivetran saves the Broncos weeks of lost engineering time.