Data Centric Media Plan Templates
Consolidating media plans often involves a tedious, manual process that can consume hours or even days of administrative time. Imagine consolidating campaigns for all clients across a media group, office, state, or an entire agency. Nightmare.
The reason? Most media plan templates are custom client reports and not standardised data. Until now.
Our templates follow 3 steps to generate a data cube which drives multiple reports and dashboards, while facilitating integrations with platforms like Advvy. Data cubes are easily consolidated for a master client or agency view.
Utilising standard data sets, smart formatting, filtered data validation and auto-fill, data entry is a breeze and creates a structured planned data set.
Each structured planned data set is consolidated inclusive of weekly flighting, costs & delivery metrics to populate reports and dashboards.
Consolidated data is converted week and month data to permit date ranged reporting. Data is mapped for custom integrations like Advvy.
Creating planned data sets enable cross sectional analysis by media type, market, demographic, publisher, network and much more. This flexibility provides insights across a single campaign, clients, departments and a whole agency.
Tracking client budgets and generating billings and income forecasts is much easier utilising multipurpose data.
Ready to go templates are poised for customisation, saving thousands on development and testing. They already work, we just need to make it work your way.
Starting with an in-depth demonstration of your selected template followed by a mini workshop, together we create a blueprint of your new template.
We work through your active template to capture your "must haves", ensuring the ready to go template is a good base.
Once the Statement of Work is authorised, work commences on calibrating standard data sets, customising reports and dashboards, and implementing branding requirements.
Once design is finalised, there is a testing period of 5 business days. Unlimited support is provided.
Time to get it into circulation. We record a training session, provide an Agency Handbook and there is optional post implementation support.
A success guarantee ensures the template operates to expectation with any faults fixed immediately at no cost. Game on.
The Advanced 12 Month All Channel Plan is a sophisticated tool with a simplified UI. Standard data sets populate easy to use pull down lists ensuring data integrity across multiple plans. Perfect for clients requiring market, media type, weeks and months analysis.
Imagine having complete control over your campaign. A media plan so advanced it looks, feels and functions like an application. Enter data once, breakdown totals and delivery metrics by media type, market, network, publisher, buy type, demographic, week and month.
Built for the AU market, this template boasts:
Interactive Consolidated Media Plan PIVOT report
Inbuilt Budget Reconciliation and spend tracker
Multi selection, date ranged MBA builder and Rolling MBA Register
Automated Adserving costs from a defined ratecard
CPT Register and Conversion table for TV Planners
Data Cube output for integration into platforms & other templates.
Great for single campaigns
Custom branding, calibrated data taxonomy
Whether your digital client only tracks impressions and clicks or has a full funnel conversion to ROAS $, our Digital Only Plan has you covered.
Adserving, verification, attention and other CPM Costs
Automated flighting utilising from and to dates
Budget Plan & Report by 3 custom categories
Multi selection MBA Builder and Register
Comprehensive Publisher Tracking Module
Budgeting Module
Summary & Dashboard
Monthly client fee structure
Change & Optimisation Register
Data cube output for platform integrations
Great for multiple campaigns in one place
Custom branding, calibrated data taxonomy
A single tab media plan with standard data sets, adserving ratecard and MBA Builder. A sleek, no nonsense media plan with all of the essentials and nothing more.
All channel plans on the one tab
Date ranged MBA Builder and MBA Register
Data cube output for consolidation and integrations
Standard data sets and ratecards for automation and integrity
Enter monthly rates & quantities for quick actualisation
Date range automatic status formatting
Monthly Client Fee Structure
Packages include optional training
User and super user training is available on all templates and is recorded for your future reference. It is smart to have onsite support through your super user.
Bespoke online training can be packaged too. We create a training package just for you which is available for new employees and refreshers for existing ones. All hosted here.
Of course there is some Excel training in there, especially around PIVOT reports.
Change management can be difficult, particularly in media. Situations arise where there is user error, missing function or lack of knowledge.
Support is available. We create a MS Teams Channel which is yours alone. We store your agency handbook, training videos and FAQ's here for easy access, you can post questions and raise tickets.
Support ensures continuity of business.
Future development of your media plan template functionality to address changes in your business, new client requirements, data & platform integrations or simply custom reporting can be achieved through email to mediaplans.au@madbusiness.com.au.
Your new media plan template already has the foundations which can easily be built upon.
We can help with any excel template.
60 minutes could change the way you present your media plan, track your campaign and streamline your consolidated reporting. Save admin time, reduce errors and solve spend and delivery issues before campaigns end.
A live demonstration on MS Teams providing you with the opportunity to see one of our templates in action. From data entry to MBA and spend tracking.
Send us a copy of your template after you book your demonstration, and we can prepare for the questions you will have. Send it to mediaplans.au@madbusiness.com.au.