Media buying

Structuring the tracking of media campaigns, from media planning to billing

Havas Mediadom

Media consulting and buying agency

Airtable

Media buying

Structuring the tracking of media campaigns, from media planning to billing

Havas Mediadom

Media consulting and buying agency

Airtable

Context, Objectives & Solution

Mediadom manages media campaigns involving numerous media types, territories, plan lines, budgets, deliverables, supplier documents, and client invoices. Operational tracking must cover the entire cycle: brief, media plan, client validation, production, broadcasting, reporting, invoicing, and closure.

Tracking is difficult to maintain between the media plan, production, and invoicing

Campaigns to track with multiple operational steps: scoping, media plan creation, client validation, production, broadcasting, reporting, invoicing, and closure.

Implementation of plan line tracking including support, media, territory, wave, asset, format, dates, gross budget, net budget, discounts, and comments.

Documents and invoices to be centralized to secure the relationship between quotes, supplier invoices, customer invoices, down payments, disbursements, and fees.

Mission objectives

Centralize campaigns, media plans, creatives, plan line items, deliverables, and documents in Airtable.

Provide a clear vision of the status of each campaign, each plan line, and each deliverable.

Facilitate budget tracking and invoicing, from gross budget to net budget and client invoices.

What we have concretely put in place

Structuring the management of media campaigns

Creation of a campaign pipeline with statuses: to be framed, media plan to be created, media plan in progress, client validation, production, broadcasting, review, billing, and closure.

Implementation of plan line tracking including support, media, territory, wave, asset, format, dates, gross budget, net budget, discounts, and comments.

Creation of operational views to track ongoing campaigns, reports to be generated, campaigns to be invoiced, and the broadcast timeline.

Link deliverables, documents, and billing

Structuring the tracking of deliverables with statuses, assets, formats, messages, deadlines for creation, production, generated files, and time spent.

Centralization of quotes, rate cards, supplier invoices, and client invoices linked to campaigns.

Implementation of budget management with gross budget, budget before RCM/TM, RCM, net budget, breakdown by media, and breakdown by territory.

Impact & Result

Mediadom now has a central system to manage its media campaigns from end to end: briefs, media plans, plan lines, media channels, assets, deliverables, documents, budgets, broadcasting, reporting, and billing. The team gains visibility into campaigns to monitor, reports to produce, lines to broadcast, and invoices to prepare.