Skip to main content

Strengthening community connection with data


A group of three people sit closely on a green sofa in a cozy living room, watching television. The central figure holds a remote control, suggesting they are selecting a program or movie. The scene conveys a warm, relaxed atmosphere with soft lighting and casual clothing. The background is simple, emphasizing the family bond and leisure time.

At a glance

We helped PMGSC build a MarTech implementation roadmap and create data visualization dashboards with Tableau to track viewer behavior and analyze show performance, helping to secure long-term funding and better inform program scheduling that reflects its diverse community.

Impact

By streamlining data intake and analysis with automation, the PMGSC team now has more time and resources to create and curate programming based on informed and interest-targeted viewer behavior.

Key Technologies / Platforms

  • Tableau

Industry

Media & communications

Key Services

Strategy icon
Strategy
Element Icon
Data


Data, data, data

Just over a decade ago, television programming and advertising meant little more than scheduling a spot for airtime and hoping your audience was tuning in. Today, however, viewers are “tuning in“ through their desktops, mobile devices, and connected TVs, shifting the television broadcast landscape. New, data-driven streaming services are popping up regularly. Content programmers and advertisers can now reach specific audiences where they are and offer content that’s tailored to them.

PMGSC is a not-for-profit broadcasting organization that operates two content channels—PBS SoCal and KCET—as well as Link TV, a noncommercial satellite channel. As legacy providers of publicly funded content that aims to inspire, inform, and entertain, the company is in a position to improve its complex marketing and data ecosystem. Through a holistic roadmap, PMGSC plans to unify disparate data sources, fully understand viewer behavior, and craft one-on-one user journeys to become a leader in defining the future of public television.

The best path forward? Informed data.


Only through knowing where we are can we truly know where we are going.

Dan Ferguson

Senior Vice President of Marketing and Communications, PMGSC


Streamlining processes and strategy

Since 2020, PMGSC leaders have been examining their business holistically across all platforms, redefining their goals under the direction of Dan Ferguson, the company’s senior vice president of marketing and communications. With a proven record of successfully leading marketing programs for well-known companies such as DirecTV, STARZ, and AT&T, Ferguson is helping PMGSC find its way in the data-informed streaming landscape.  

The company’s previous methods for gathering insights were both cumbersome and time-consuming. Broadcast and digital data were pulled from at least eight different sources, and staff were inundated by the manual effort of exporting, organizing, and visualizing data. Answers to basic questions like, “How many people did we reach this month?” took weeks to decipher due to the multiday process of exporting, converting, cleaning, and beautifying data. Workload issues ensued, and PMGSC was too bogged down to make clear, informed programming decisions. 

As a not-for-profit that relies on member subscriptions, grants, and foundations for funding, the company needs these insights to show how they affect the communities they serve. Without easy access to unified and clean data, PMGSC was struggling to connect its marketing efforts to its broader mission. PMGSC needed a new data strategy to forge a clear path forward for its business.


Charting a course together

Having enjoyed working with Slalom in the past, Ferguson reached out to our team to help support the following goals:

  • Accelerate automation 

  • Improve efficiency  

  • Increase user engagement 

  • Improve strategic decision-making 

The initial discovery phase consisted of interviews and workshops to assess the current state of marketing efforts, gather requirements for an ideal future state, and identify key KPIs and underutilized data across various sources. We then entered a build phase in which we mapped source data tables to the key KPIs needed for reporting. Through an iterative process, Slalom and PMGSC worked together to design a set of wireframes across broadcast and digital data, providing viewership and rating insights for PMGSC’s various channels.

An adult male holds a young child on his shoulders in front of a blue garage door. The child is sitting comfortably, with hands gripping the adult's head for support. The setting appears to be residential, with both individuals dressed casually. The overall mood is playful and warm, with natural daylight illuminating the scene.
A professional video camera is set up in the foreground, focused on a person seated in a library or study environment. The background features shelves filled with books, while studio lighting equipment is visible to the side. The scene suggests an interview or documentary recording, with a blurred subject and clear focus on the camera equipment. No visible text or numeric values are present.

By piecing together data from various sources, we were able to provide a holistic view of PMGSC’s viewership and show performance across platforms that pinpointed opportunities to increase engagement.

Calvin Tanudisastro

Principal, Slalom


We also partnered with PMGSC to help develop a semantic layer in its existing data warehouse and create a set of interactive Tableau dashboards, enabling the entire organization to make data-driven decisions. These dashboards consider data such as viewership across linear and digital, website engagement, and marketing performance.

In a convoluted landscape of abundant data with no easily accessible way to view it, Slalom helped PMGSC identify a single source of truth. 


PMGSC’s work with Slalom serves as a model for the 300+ other PBS member stations.

Stacy Shaffer

Senior Director of Marketing Operations and Business Intelligence, PMGSC


A digital dashboard displays broadcast overview metrics for Public Media Group of Southern California. The main section highlights monthly broadcast reach for PBS SoCal and KCET, with figures such as 1.34M, 1.02M, and 0.28M clearly visible. The dashboard features line and bar graphs comparing reach and ratings over time, with a focus on visual data representation. The color palette includes blue, orange, and purple tones, and the interface is clean and data-driven.
A digital dashboard summarizes YouTube performance metrics for PBS SoCal, KCET, SoCal Connected, and Link. The main visuals include bar graphs and charts displaying top monthly streams, average watch time per video, total monthly watch time in hours, and new monthly subscribers. Numeric values such as 11,585, 308,046, 134,454, 74,639, 897.7, 126.6, 3,789.293, and 1,153 are clearly visible. The setting is a professional analytics report with a clean, data-driven style.

Empowered insights, informed storytelling

On-air, online, and in the community, PMGSC plays a vital role in the educational and cultural enrichment of Southern and Central California. The organization has won hundreds of major awards for news and public affairs programming, national documentary productions, and educational family programs.  

By streamlining data intake and analysis with automation, the PMGSC team now has more time and resources to create and curate programming based on informed and interest-targeted viewer behavior.  

Through understanding what the data is telling them, the team can elevate the way it’s used. And a more efficient workflow means that any leftover time can now be used for innovation. 

“PMGSC’s work with Slalom serves as a model for the 300+ other PBS member stations as we navigate the future of public television and sustain our cultural importance,“ says Stacy Shaffer, senior director of marketing operations and business intelligence at PMGSC.

What’s up next

With detailed, audience-specific insights and a path forward in place, PMGSC and Slalom continue to partner together to implement a next-generation marketing and data ecosystem. The next phase of the journey is a company-wide, Slalom-supported roll out. Moving forward will open the door to new possibilities across the company and—most importantly—the local communities it serves.






Lassen Sie uns gemeinsam eine Lösung finden.