The ROI Revolution Blog

Google Analytics ROI Calculation Macro

November 26, 2007

Glue Gun! 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.

Keep Reading »

Social Bookmarks:

Permalink | Comments ( 6 ) | TrackBacks ( 0 )

Filed under: Analytics
Tagged as: Analytics Technology

Posted by Jeremy Aube, Web Analytics Engineer at 6:00 PM

Excluding Internal Traffic the Easy Way

November 20, 2007

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:

Keep Reading »

Social Bookmarks:

Permalink | Comments ( 19 ) | TrackBacks ( 0 )

Filed under: Analytics
Tagged as: Analytics Basics, Filters, Reports, Tracking

Posted by Shawn Purtell, Senior Web Analytics Engineer at 1:59 PM

Funny Adwords Contest: Round 1 Winners

November 6, 2007

funny Adwords contest 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)