Advvy has been at the forefront of turning Excel media plans into consolidated gold for over 10 years. They have the only Excel AddIn which connects media plans to an online platform and provides agencies and their clients a dynamic view of their total planned data.
An array of Power BI dashboards, flow charts and expenditure reports across campaigns, master clients, divisions, media groups, offices, products and more, keeps a user intimately informed in real time.
Together, we have created bespoke media plan templates for global and local agencies and their clients, and along the way discovered a real synergy.
Advvy's roadmap holds some game changing innovations which will bring media plans, actual data and automation much closer together.
We are proud to be a preferred partner of Advvy.
If you already use Advvy and wanting a stable way to create media plans and sync them to the platform, then you have come to the right place. Advvy media plans require the conversion of data to exactly conform to their structure and data taxonomy to consolidate correctly.
Each media plan is synced to a database which produces an amazing set of dashboards, flow charts and reports. Our Advvy media plan templates are part of a 3-way data calibration with the Advvy Platform and the agency's booking system, generally Media Ocean's SMD. Everyone uses the same data sets.
Power Query is used to consolidate planned data, then convert it into weekly costs and delivery metrics. Data is then mapped to the Advvy tables used to sync in with the platform database. No macros needed.
Mediums, Markets, Network, Media Owners, Audiences, Media Types and Sub-Types, Languages, Phases, Fee Types and Currencies are all downloaded from Advvy and utilised within the template. Dynamic.
Client Rate Data is downloaded from Advvy and can facilitate client fee structures, adserving rates and buffers and much more, negating the need for individual client templates and avoiding costly errors.
Get a new template in 10 days.
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.
Enter data once, breakdown totals and delivery metrics by media type, market, network, publisher, buy type, demographic, week and month.
Built specifically for Advvy, this template boasts:
Interactive Consolidated Media Plan PIVOT report
Summary Dashboard
Data Quality Dashboard
Links to Reference Data
CPT Register and Conversion table for TV Planners
Advvy data integration
Custom branding, calibrated data taxonomy
Low maintenance reliability.
Whether you want to upgrade your current template, utilise one of our ready to go templates or build something from scratch, simply select a time from below and we will demonstrate what we have. In the same MS Teams meeting we can explore other solutions. Feel free to email your template in advance to Danny Wood at mediaplans.au@madbusiness.com.au.