Other Services
Many agencies are focussed on streamlining processes, reducing unnecessary admin time and providing a deeper understanding of the business, their clients and which dials move which metric, through data driven efficiencies. Our experience spans all areas of a media agency with ready to go templates awaiting your customisation.
Media finance also suffers from "if it isn't broken don't fix it" syndrome. Particularly in multinational agencies and long-established independents. As margins deplete, agencies are turning towards automation, standardised tools and AI to reduce non-income producing FTE and create data driven efficiencies to improve profitability.
General ledger reconciliations, media reconciliations and tracking, debtor turnover declarations, month end reporting and projection models.
Multi-streamed billing and income projection models, with FTE and client profitability analysis to generate contribution to gross profit.
Recurring reports and dashboards populated by data exports or API's produced in Excel or Power BI.
Utilising data from our templates, consolidated planned data populates client, media group and agency level reports and dashboards. Great for publisher spend tracking.
From activations to nationally toured events including ticketing, marketing, operations, capital expenditure, funding, cashflow and profit & loss, joint venture splits.
Comprehensive fee calculation templates to ensure you don't have to go hat in hand to the client after 6 months. Billings / FTE by channel, seasonal spends, quant and qual performance bonus.
Online Training
Excel remains the leader in the production of dynamic modelling, reporting, dashboards and data outputs. We love Excel but understand you probably don't. Each template is produced with the user in mind, eliminating the need for understanding complex formulas and functions.
To get the most out of our templates, there is an Excel for Media Essentials course included with purchases and available for new members.
If you are interested in doing the course by itself, email me at mediaplans.au@madbusiness.com.au.
Microsoft Excel
Sometimes we are faced with challenges which can't easily be solved internally. Our consulting services may be able to help map out the challenge and provide possible solutions.
If the solution you are looking for requires Excel, it is probable we can help. Any initial appointment to explore possibilities is free of obligation and cost. Let's chat.