« Tag, I'm It - 5 Things You Didn't Know About Me | Main | PPC Management Strategy »
How to Calculate Keyword-Based Conversion Numbers in Google Analytics
January 4, 2007
Google Analytics is great for assigning goals to certain events, showing you the referring keyword that triggers those events, and displaying what keywords have the best conversion percentage. But how do you determine the exact number of conversions that took place? If G1 is the download of a file, and G2 is the sale of a book, how do you determine the number of downloads or the total number of books sold, sorted by individual keywords?
You can easily determine a hard number of conversions (over a specified date or date range) in the Goal Verification menu:
But assigning raw conversion numbers to specific keywords is a bit trickier. Not rocket science, but it takes a little work. Here's what I do.
- First, create a Google Analytics keyword report. You have to determine conversions-by-keyword on a source-by-source (i.e., domain-by-domain) basis. So navigate to All Reports -> Marketing Optimization -> Visitor Segment Performance -> Referring Source. Pick a specific source (I chose "google [organic]"), then specify the Keyword report as shown here:
Note: To produce a keyword report, the source must be labeled as [organic] by Google Analytics.
- Once you've created the keyword report, export it into Excel, which should give you something like this. Note that I've added some column head colors, and that I've replaced actual keywords with "Keyword 1," etc., to protect client privacy:
- So now we know that Keyword 1 converted 1.53% of the time, over 652 visits. But how many raw conversions is that? It's a simple calculation, and we'll add it into the first available column to the right. The following shot gives the formula:
This forumla simply takes the number of visits from each keyword and multiplies by the conversion percentage, then divides by 100 to account for the percent. Note: This specific formula works only if the existing columns appear as shown here. You'll need to change the [-1] or [-3] as necessary if you have more or fewer columns in your spreadsheet.
I'm a little surprised that the raw number of conversions isn't already a part of the keyword report. It's valuable data and would be easy to add to the programming. Fortunately, unlike some full referring URL strings, conversion-by-keyword data is available with only a few clicks.
All posts by Erik Dafforn
posted by Erik Dafforn at January 4, 2007 1:02 PM
Intrapromote: [ Case studies | SEO services | Bios ]
Trackback Pings
To TrackBack this entry, use the following URL:
http://seoblog.intrapromote.com/mt-tb.cgi/342
Comments
I took my time to look over all the comments, but I really enjoyed the article. It proved to be Really advantageous to me and I am trustworthy to all the commenters here! It’s again amiable when you can not only be advised, but also entertained! great job with this article.
Posted by: Pok Giacalone at August 25, 2010 6:34 PM
I took my time to look over all the comments, but I really enjoyed the article. It proved to be Really advantageous to me and I am trustworthy to all the commenters here! It’s again amiable when you can not only be advised, but also entertained! great job with this article.
Posted by: Pok Giacalone at August 25, 2010 6:35 PM
What a write!! Very informative also easy to understand. Looking for more such writeups!! Do you have a twitter or a facebook?
I recommended it on stumbleupon. The only thing that it's missing is a bit of new design. However thank you for this information.
Posted by: Carmelo Shanberg at August 31, 2010 9:32 AM