A global content catalog on one shared calendar
A national public broadcaster manages a content catalog of more than 50,000 titles in Airtable, connecting territory-level editorial scheduling, AI-driven contract metadata extraction, and creative marketing brief intake. Marketing, Paid Media, PR, and Creative teams replaced siloed trackers and manual data entry with one unified content calendar.
The problem
Territory schedules and campaign trackers were siloed across Marketing, PR, and Creative, each running its own base with no shared view of what was in flight. Complex licensing spreadsheets with hundreds of columns caused performance problems as the catalog grew, and contract data still had to be extracted by hand from 100-page PDFs.
Leadership had no dynamic visibility into campaign progress beyond overwhelming grid views, and creative briefs and asset workflows were disconnected from each other. Status chasing was manual, assets were copied to shared drives by hand, and capacity across creative teams was invisible until something was already late.
What they built
Marketing, Paid Media, PR, and Creative teams built a shared Airtable base that runs territory-level editorial scheduling alongside AI-driven contract data extraction and tracking, creative brief intake and triage, and marketing campaign and paid media tracking. Asset delivery and archiving live in the same connected system as the schedules that depend on them.
PR talent and cast sourcing, design scheduling, and ad slate design approvals route through studio manager approval queues, while resource utilization monitoring and job-level deliverable tracking keep capacity visible. The base connects to Dropbox and Google Drive for asset storage, Slack and Microsoft Teams for notifications, and Tableau for reporting.
The outcome
Marketing, PR, and Creative now share centralized global visibility instead of working from separate trackers, and AI document extraction cut the time spent reading contracts line by line. Creative capacity planning and approvals became streamlined, and financial forecasting improved with the same scenario modeling used elsewhere in the rights workflow.
A centralized asset repository replaced manual copying to shared drives, and dynamic dashboards gave management the cross-team visibility that grid views could not provide. Clear approval queues and dynamic capacity balancing mean creative work moves through the pipeline with far less manual status chasing.
Inside the solution
Campaign Management
Marketing & Communications
- Territory-level editorial scheduling
- AI-driven contract data extraction and tracking
- Creative brief intake and triage
- Marketing campaign and paid media tracking
- Asset delivery and archiving
- Financial amortization modeling and cash tracking
- PR talent and cast sourcing
- Design scheduling
- License period tracking by territory
- Rights availability filtering
- Ad slate design approvals
- Resource utilization monitoring
- Job-level deliverable tracking
- Studio manager approval queues
- Automated notifications
- Complex licensing spreadsheets causing performance issues at scale
- Manual data extraction from lengthy contract PDFs
- Siloed territory schedules and bases across teams
- Lack of leadership visibility into campaign progress
- Centralized global visibility
- Streamlined creative capacity planning and approvals
- Centralized asset repository
- Improved cross-team communication
- Marketing
- Paid Media
- PR
- Creative
- Dropbox
- Slack
- Tableau
- Google Drive
- Microsoft Teams
- Microsoft Power Automate
Campaign Management
Run a global content catalog from one shared calendar: every title, territory schedule, licence, campaign, creative brief and job deliverable is a linked record with an owner, a stage and a rights position, so scheduling, paid media and creative capacity all read from the same source. Airtable AI extracts licence periods and restrictions from long contract PDFs and drafts triage and approval notes, while automations route new briefs into the studio manager queue, push verified licence dates onto the schedules they govern, and file delivered assets into the central repository without anyone chasing status.
From siloed trackers to one connected campaign calendar
Copy the templates
Connect briefs to assets
Wire cross-team reporting
FAQ
Frequently asked questions
Every title, territory schedule, and campaign is a linked record with an owner and status, so the calendar scales by adding records rather than adding new spreadsheets. The structure stays the same whether the catalog holds hundreds or tens of thousands of titles.
A centralized asset repository connected to Dropbox and Google Drive, where assets are delivered and archived against the campaign record they belong to instead of being copied by hand between folders.
AI-driven contract metadata extraction feeds license period and territory data directly into the same base that drives scheduling, so campaign timing always reflects current rights availability.
Ad slate design approvals route through studio manager approval queues in the same base, with resource utilization monitoring so capacity bottlenecks are visible before they cause delays.
Yes, for contract data extraction feeding the license and territory fields. The structured campaign and asset data this workflow produces is also the foundation for further AI-assisted reporting.