Every channel — owned, social, audio, and earned — consolidated by program
Demo — sample data
Earned mentions (Meltwater)
Broadcast & print citations of program work, mapped to the program via tagged boolean searches
All channels roll up to the same program — owned in blue, earned in orange
Follower counts from the scoping inventory
| Title | Type | Channel | Engagement | Earned pickups |
|---|
Web content carries its program dimension from the Drupal data layer (GA4 → BigQuery). Each social handle, podcast, and microsite belongs to exactly one program, so a simple mapping table in BigQuery attaches the program to everything Supermetrics lands — no tagging work on the platforms themselves.
Earned media joins the same picture: Meltwater’s boolean searches (citations of program reports and scholars in broadcast and print) are tagged by program and exported into BigQuery alongside the owned channels. That’s how a report launch, its social push, its podcast episode, and its press pickup all appear on one timeline — and why the twice-yearly board notes become a filtered view instead of a manual hunt across ten platforms.
