If you have used the ROI Calculator Spreadsheet tool that Shawn came out with before, you know that it takes several steps to get to the point where you can start entering in cost data and seeing that ROI. If your need for ROI data is only occasional, then this works great. In addition, if you click on the appropriate link below, you can download the latest version of this spreadsheet, which eliminates step 4 from Shawn's procedure.

Microsoft Excel 2007 Version
Microsoft Excel 97-2003 Version

If, however, you find yourself running through these steps again and again on a frequent basis with no shortcut in sight, there is hope!

Introducing...the ROI Calculation Macro.

Continue reading "Google Analytics ROI Calculation Macro" »

If you've done research on excluding internal traffic from your Google Analytics reports, then you've probably heard words like "user defined variable", "dynamic or static IP address", and "orphaned web page." While you may want to become familiar with these terms someday, the truth is that not everyone is a webmaster.

What's my point? Well, I'm not sure if anyone's come up with this before, and quite frankly I wouldn't be surprised as this method is very easy, but here's a quick and easy way to exclude any kind of internal traffic from your reports, regardless of IP-whats-its. All you have to know is how to write an email.

Here's how:

Continue reading "Excluding Internal Traffic the Easy Way" »

What do replacement grandmas, weed, new brains and vacations to Hell have in common? If you just said "They're all being advertised with Google Adwords" then you are correct!

I'm sure we've all seen some strange stuff out there in PPC land. There have been so many wacky things in Adwords that I decided it's time to have a little contest before these weird little ads disappear. So, I Introduce to you ROI Revolution's First Annual Funny Adwords Contest.

Update 12/12/2007: Round 1 Winners:

1st Place: #6- eBay (40 Points)
2nd Place: #1- Kayak.com (20 Points)
3rd Place: #7- NextTag.com (14 Points)
Honorable Mention: # 5- Target (13 Points)

See Funny Adwords Contest: Round 2 Ads.

Find The Secret To Solid, Sustainable Improvements To Your Website
Learn the insider secrets to making more money from your website than ever before – Guaranteed! Get started right away with the Google Analytics Training Course..

Continue reading "Funny Adwords Contest: Round 1 Winners" »