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.
We've helped hundreds of websites get more leads from Google search, click below to get the free playbook.
Using the model…
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 template for yourself (Google Sheets file).
Sorry, the locker you asked for is either removed or never existed.Enjoy!
Dude, this is money.
Thanks for going to the effort for sharing some of the recipes to your secret sauce.
Wow nice share Ryan. Thanks for this great little tool 🙂
Great resource for PPC ROI stats. We use Adwords and figuring out your ROI is so key. We only market for local business owners so we do it differently but this resource is awesome.
Thanks for sharing on Google+…that is how I found it. I look forward to learning more from you.
Sincerely,
Garret
Hi Ryan
Happy new year and a great big thank you for sharing your ROI template. Not only is the template a fantastic tool but the video and explanation is just as valuable
Wonderful resource Ryan, but I’m a newbie. What does “Website lead rate” mean?
Thanks and stay awesome. Been on a bit of a binge of your videos.
Oops please delete my comment, I understand now.
Thank you Ryan for sharing your ppc results with us. Nice video with clear explanations!
Hey Ryan, great tool. I’m trying it out now to get a grasp of the profitability of a future Adwords campaign.
I’m wondering though why you’re using revenue per sale instead of net income per sale for the e-commerce part. Now it doesn’t factor in the costs of goods sold. Which can make a campaign seem profitable which in reality isn’t.
Or am I missing something here?
Hi Ryan, We can’t find the link to the template.
Please help us out!
Great work Ryan!
I haven’t seen such a great resource elsewhere.
However, the tool is not available for download?
Please clarify
Where is the button to download?
Hi Ryan, love this content! But I couldnt see any video available though. May I know where can I view it?
I managed to found the video on your youtube! Can you advise where to download the template? Couldn’t see it anywhere here though. Thanks in advance
Nice Work!!
But I didn`t find any link to download the templete
Can you help by sharing the link to download it
Thanks in advance
Great stuff. I know this is super old but do you still have that tempalte? 😀
where can I download this excel sheet?
Hey, Ryne Wonderful Explanation but I have one doubt. I think if you know regarding the new search console update if we place any keyword in search then Google just show the Range of Keyword, not exact search volume. In this scenario what can we do to find exact search result other than running google ads?
Great work! I didn`t find alink to download the template. Can you send it?
Regards
Martin
I have an unhealthy obsession with being considered the world's BEST internet marketer. I'm highly active on social media and love a good debate.
Find out moreWe've helped hundreds of websites get more leads from Google search, click below to get the free playbook.
We’ve helped hundreds of companies get more “ready to buy” visitors to their websites - we can do the same for you.
5 years ago