As an avid spreadsheet nerd! I find myself often trawling the web for various templates that can make the often lengthy arithmetic of PPC campaign forecasting a more stream-line affair. As a Google PPC and Conversion Management Agency, we are regularly meeting business owners who have little to no idea about what their website is generating in terms of value or ROI.
To assist our clients, I set out to build a spreadsheet that would make it easier for an every day business owner to be able to map out and forecast a realistic model of how Pay Per Click Marketing could effect their business. The spreadsheet magically considers industry average CPC's (cost per click), campaign conversion rate performance, and overhead expenses and variables. This spreadsheet has now become a fundamental part of our client on boarding process and I would love to offer it to the wider community.
Recieve our Marketing Profitability Forecast Model by filling out the form on the next page
How To Use
Select your industry type (this will set up the industry average Cost Per Click!)Step 1:
Enter all remaining questions, anything in blue font should be your data. For Conversion rates, you can find some useful information on average conversion rates for various industries here.