The ROI Revolution Blog

Campaign ROI Calculation Spreadsheet

February 7, 2007

Campaignroi_thumb.jpg
Click on the image to see the full report


*NOTE: This article is out of date. Please visit the updated article here.

One of the major problems with using Google Analytics is that it does not yet allow you to input cost data for your non-AdWords sources. While there are several ways to go about doing this manually, we've come up with a quick, simple tool you can use to help speed the process along.

This tool will help you calculate your CPA and ROI for your Campaign, Medium, and Source ROI Reports.

1. Download our MS Excel file located here and open it.

2. Export the report you wish to modify as an MS Excel file and open it (Only for the Campaign ROI, Medium ROI, and Source ROI reports!)

3. Copy the entire exported spreadsheet report by selecting 'Select All' from the 'Edit' menu at the top of the spreadsheet, and then going to Edit -> Copy. Alternatively, you can simply click anywhere in the spreadsheet and press CTRL+A and then CTRL+C.

4. Paste the spreadsheet into the Paste Report Here Tab in the Cost Calculator tool. This is easily done again either by using Edit->Select All and then Edit -> Paste or for the shortcut savvy,
CTRL+A followed by a CTRL+V

PasteReportfull_thumb.jpg
Click on the image to see the full report

5. Go to the ROI Report tab at the bottom in the Cost Calculator tool.

ROIReportmt_thumb.jpg
Click on the image to see the full report

6. Enter in the cost data for the appropriate campaign/source/medium.

7. The CPA and ROI will be automatically calculated for any items that provided revenue during the given time period, as shown below in a completed row for the MSN source.

ROIReportfll_thumb.jpg
Click on the image to see it full-size

8. Save or print the results

9. Rinse and Repeat

We're also working on a similar tool for All CPC Analysis.

Google Analytics for Online Advertisers
Here at ROI Revolution, we consider Google Analytics tracking essential for paid search, so it's included in our PPC Campaign Management service.

Social Bookmarks:

  • Twitter
  • Digg
  • Facebook
  • del.icio.us
  • Furl
  • Reddit
  • Spurl
  • Google
  • StumbleUpon
  • Sphinn
  • co.mments

Permalink | Comments ( 2 ) | TrackBacks ( 0 )

Filed under: Analytics
Tagged as: Improving Conversion, Reports

Posted by Shawn Purtell, Senior Web Analytics Engineer at 6:54 PM

Comments

Christian Wilson said:

Thanks for providing a great spreadsheet but my GA campaign ROI shows visits, campaign costs, but no revenue (and thus no ROI).

I have set e-commerce on in my website profile. I am not sure what to do beyond this.

March 28, 2007 3:25 AM

Shawn Purtell said:

Hi Christian,

Revenue data can come from two places: One is from implementing ecommerce on your website correctly by using the hidden form. The other is from your monetized lead generation goals (but not if you have ecommerce turned on).

For more information on how to install the hidden form, you can visit Google's help file here.

March 29, 2007 11:52 AM

Post Your Comments

© 2002-2012 ROI Revolution, Inc. All rights reserved. ROI Revolution is a registered trademark of ROI Revolution, Inc.