How to become more efficient: collect all your data in a Masterplan document and use Excel Macros to extract daily, weekly, vs. Budget insights stylishly presented in an easy to update excel sheets.
Fantastic solution for combining all your data in one dashboard regardless the source!
In my previous job the main issue we had was how to save time limiting manual work whilst ensuring the business was receiving the same level of information.
On top of this, data where coming from diverse sources, and we needed to report by day/week/month both comparing stats by period, budget and forecast.
Here our solution: we input daily data in a master sheet documents (traffic, ad spends, mkt/organic sales, call centres, shop,….) and use excel macros to do the job for us.
Here a quick and intuitive example of what can be done.
CREATIVE DIGITAL IDEAS 