Investing in Cloud Analytics

Initially, Shield considered using a customer data platform (CDP), but given he’d already invested in BigQuery as the company’s cloud data warehouse, creating a separate data silo didn’t make sense. Plus, the high engineering effort required to set up a customer data platform to launch campaigns meant the time-to-value was too slow. Shield needed a way to leverage his data in BigQuery to power high-performing marketing and sales campaigns as quickly as possible.

“Regarding CDPs, we want to control our own destiny, we want a platform that will scale with us. A CDP can be a useful tool but is not a substitution for an owned First-Party Modern Data Stack on Google Cloud. I think people are making a mistake putting all their eggs in that basket. How do you ever migrate in the future if you want to move away from a 3rd-party vendor? It’s like starting over to extract yourself. By owning the architecture, you avoid vendor lock-in. That’s what we love about the architecture we’ve built with Flywheel,” Shield said.

BigQuery and Flywheel Software Deliver Growth Faster

Flywheel Software offered an innovative, new architecture capable of enriching BigQuery data sets with ticketing data, merchandise sales data, fan engagement and other important business data sources. By connecting sales and marketing teams directly to Red Sox customer data in BigQuery, Flywheel enabled the Red Sox team to leverage its B2B and B2C data immediately , without being limited by slow ETL pipelines and inflexible data models.

For the first time, the Red Sox marketing team could create audience segments with Flywheel’s no-code builder, and launch campaigns within hours instead of weeks. Freed from constant SQL queries and audience list pulls, the data team could focus on building more sophisticated predictive models.

“We went from spending all of our time answering data requests to a self-service model with scalable data democratization via Flywheel, which allows our team to be more proactive vs reactive,” said Jon Hay, Vice President Data, Intelligence & Analytics, Boston Red Sox.

How Flywheel Software and BigQuery Work Together

• Customer 360: Flywheel helped the Red Sox combine all of their data sources into a single view of their customers in BigQuery, then connected them to every marketing and sales channel via Flywheel’s platform.
• Predictive Models: The Sales team deployed a fan avidity score predictive model trained on BigQuery data to more efficiently target outreach.
• BigQuery Access and Data Sharing: Red Sox data can be seamlessly combined with Major League Baseball data using BigQuery’s data-sharing capabilities.
• Extensible Data Visualization: Since Flywheel writes all audience data back to BigQuery, the Red Sox analytics team can perform its own performance analysis.

“As Fenway Sports Group continues to evolve, we see our data prowess and the extensible architecture we’ve built with Flywheel Software as an asset that new FSG Media & Entertainment properties can tap into to support their growth and evolution,” Shield said.

Flywheel Audience Segmentation

With Flywheel, analytics and activation live in one place, making audience design a five-minute exercise. This means the marketing team has more at-bats to find winning combinations of target audience, channel, and message.

Uplift Measurement, the New Moneyball

With each audience launch, the Red Sox marketing team automatically applies ongoing A/B experiments by segmenting audience members into treatment and control groups in-app.

This experimental design unlocks visualizations for marketers to quickly understand the impact on ticket sales, ticket scans, total spend, number of games watched via streaming services, email opens, Salesforce opportunities closed, app logins, or any other metric in BigQuery.

1. Ingest data sources via an Import Service running in Google Kubernetes Engine (GKE) and Cloud Storage, though you can use self-serve ETL tools like Matillion;
2. Transform data with data build tool (dbt) via Cloud Composer to produce transparent and reliable data pipeline models.
3. Activate data with Flywheel, deployed on Google Cloud and using GKE, Pub/Sub and other services to deliver audiences and personalization fields to Salesforce, Facebook, Zeta, and Iterable. (Flywheel Software supports any destination with extensive API integrations.)

“Flywheel enabled and then dramatically accelerated the Red Sox transition to a data-driven organization,” said Hay.

Winning Segments

So what kind of marketing segments were successful for the Red Sox that your team could apply? Here is a quick summary of a few key examples:

Take Advantage of Timely Buyer Patterns

Encouraging the away team’s fans to attend a game at their home stadium may seem counterproductive, but it turns out to be a great revenue opportunity. For example, target the Oakland A’s fans that live in the Boston area (via Google Ads or email) to purchase tickets when the Red Sox play the Oakland A’s.

Deeper Segmentation and Hyper-Personalization

Build an audience with deeper segmentation based on data points in your BigQuery tables to achieve higher conversion rates. One of the highest-leverage customer segments is single-game ticket buyers with a high propensity to buy season tickets. The Red Sox have an AI model that scores fans on this propensity. When a high-scoring fan purchases a ticket to a homestand game, a sales rep is immediately notified via Salesforce to call the fan and set up a VIP tour before the game, giving the rep an opportunity to upsell season ticket packages.

Deliver High Quality Leads for your Sales Team

Leverage data in BigQuery to set your sales team up for success with campaigns targeting the right buyers at the right time. One example is sending existing purchasers of suites that don’t yet have a concessions package and have visited the website recently to the CRM as warm leads for the sales team.

“Our sales team refers to the Audience Builder as the Flywheel Lead machine”—Jon Hay, Vice President Data, Intelligence & Analytics, Boston Red Sox

Transform Your “Front Office” like the Boston Red Sox in 3 Easy Steps

Today, eight other Major League Baseball teams leverage Flywheel Software to drive marketing and sales wins, along with teams across the NBA, NHL, and NASCAR. Whether your company is in retail, financial services, travel, software, or something else entirely, you can join the expanding group of companies driving sustainable growth through real-time analytics by connecting BigQuery from Google Cloud to Flywheel Software. Here’s how:

If you have Customer Data in BigQuery…

1. Book aFlywheel Software + BigQuery democustomized to your use cases.
2. Link your BigQuery tables andmarketing and sales destinationsto the Flywheel Software platform.
3. Launch your first Flywheel Software audience in less than one week.

If you are getting started with BigQuery…

1. Get aData Strategy Session with a Flywheel Solutions Architectat no cost.
2. Use our Quick Start Program to get started with BigQuery in 4 to 8 weeks.
3. Launch your first Flywheel Software audience in less than one week thereafter.