I have an unhealthy obsession with being considered the world's BEST internet marketer. This blog is one of the channels I use to demonstrate that. I'm highly active on social media and love a good debate (bring it internet trolls). Click the icons below and fire away.
Thanksgiving is my favorite holiday so I'm really feeling the love today.
I'm going to give you the exact data modeling template I use to determine the return on investment (ROI) of paid search (PPC) campaigns.
All you need to do is enter a few cells of information and the entire thing populates for you.
It's an incredibly powerful tool to pitch clients or determine the profitability of keywords for your own internal campaigns.
It's a 4 tab Excel file that calculates itself with a little input on your end.
I've explained how to use it via video (below) and screenshot guide (below).
We need to put in some quick information points to get a better picture of the ROI.
We need to differentiate the difference between traffic for eCommerce and lead generations sites. This models classifies each as the following:
All of the work is done - the Spreadsheet auto calculates everything else!
Let me run you through it so you have an understand of what you're looking at.
I added this tab to clean up the presentation of the ROI, as most clients don't give a shit about all that stuff, they just want to see the results.
ROI is calculated as: (Costs - Revenue) / (Costs)
It seems like a lot of work, but honestly, I'm handing you the keys to a Maserti here. I did all th eheavy leg work for you, all you have to do is change a few cells and you've got an accurate model to predict the ROI of a paid search campaign.
Click the button above to grab the tempalte for yourself (Google Sheets file).