Marketing – Annual Analysis

2016 Marketing Analysis Sheet1 copy

Problem: ProHealth never calculated return on marketing investments.

Solution: Using the numbers from the marketing budget analysis and calculating returns, as the numbers would come in, I began tracking the return on all marketing investments. Upon starting the project, I calculated the previous year’s (2015) ROI. After that, I set a goal with the CEO to achieve a trackable 60% return on investment. I updated the progress monthly and was able to add marketing campaigns when ROI would decrease.

Results: I created the above spreadsheet to display the exact numbers we were working with in the marketing department. This process generated a precise approach to tracking the annual ROI. After tracking and calculating with this new process, I was able to validate 115% of every dollar of 2016’s marketing budget, crushing my goal of 60%.

*At the bottom of the document, I tracked social media progress.

Leave a comment