Banner

Follow Along

RSS Feed Join Us on Twitter On Facebook

Get Engaged

Banner

Featured Article

Using Your Site Statistics: Getting a Bird’s Eye ViewUsing  Your Site Statistics: Getting a Bird’s Eye ViewHow well do you understand your website design? Ask yourself....Are the design, usability, and informational factors top...
Read More >>

Latest Comments

Latest Articles

How to Improve Conversions  Through A/B TestingHow to Improve Conversions...
What is A/B testing? A/B testing is a method of testing that allows one...
Read More >>
Dialing in Your Call to ActionDialing in Your Call to...
Throughout the course of any marketing campaign, it is necessary to count conversions as...
Read More >>
Evaluating Digital Marketing ROIEvaluating Digital Marketing ROI
Imagine investing $15,000 on a print-based ad campaign. Your company would want proof the...
Read More >>

Our Sponsors

Banner
Banner
Banner

Latest Search Videos

Join Us

Banner
Banner
Using Pareto Analysis for SEO and Keyword Targeting
Written by Anthony Verre
Tuesday, 14 August 2012 12:58

We’ve all been in that place where finding the best keywords to optimize a site is like sitting in a bingo hall waiting for the number to be pulled. We examine exhaustive data from analytics and keyword tools; we sort this way, we sort that way, we examine the intent and implication of each keyword.

optimize with pareto analysis

Or we’re at the other end of the spectrum: you’re a year or two into the campaign, have created steady growth. Then things begin to stagnate; the site’s growth slows down and you’re at loss how to jump start the motor.

Fortunately, there’s a solution you can apply to either of these situations. Pareto Analysis. And, for those not into formality, the 80/20 Rule. Managers and the industrial complex in general have been using Pareto Analysis for decades.

What is Pareto Analysis?

Pareto Analysis is a decision-making technique (problem solving technique) that employs statistics to derive the most effective actions one can take (the 20%) that will deliver the maximum impact (the 80%). In Pareto’s world, it’s identifying 20% of the causes that will solve 80% of the problems.

If you’re a history buff and want the whole story, here’s the Vilfredo Pareto biography.

The idea with Pareto is to take an insurmountable amount data that locks up the decision-making process and begin to manage it in order to find “the vital few and the trivial many”. In this fashion, you can begin making decisions on root causes that deliver a big impact.

How Can Pareto Help in SEO?

Let’s go back to the two situations up above. For the first situation, a behemoth of a keyword list with tons of attributes (i.e. monthly volume, yearly visit totals, CPCs, bounce rates, keyword revenue, etc), Pareto can help by helping ease the fear of choosing incorrectly.

By applying this principle to your keyword list, you can sculpt away the riff-raff to find the 20% of keywords that will deliver the most impact for your client.

In the second example where stagnation has become the order of the day, Pareto can help you segment all those long-tail keywords that begin to start looking like a horse apiece, into an actionable group.

From that actionable group you can generate a second wave of growth and keep the re-up growing strong.

But, it’s not enough to give you the idea; next we’re going to build our own Pareto Analysis in excel.

Building Pareto Analysis for SEO in Excel

*Brushes the chalk dust off the corduroy jacket, and taps the chalkboard*

Step 1: Setting up the Pareto Analysis

For the first step, we’ll need to have all our data ready in excel. (P.S. this is all made-up data, so there are victims to this teaching session). See the example below:

pareto analysis 1

Once you have your data fields of your choice, sort the data field of your choice from largest to smallest. Next it’s time to start calculating percentages.

I find that it’s easier to do this over to the side of your original data so you can do multiple comparisons. However, for simplicity’s sake, we’ll limit it to just Local Monthly so you can see how Pareto functions.

To the right of Local Monthly, create a new column called “Local Monthly %”. And to the right of that column add a new column called “80% Cut Off”.

Here’s what it should look like when you’re done:

pareto analysis 2

Step 2: Graphing The Pareto Results

Fantastic. Now we have a bunch of percentages that only seemed to complicate the matter. But have no fear, we’re about 5 minutes away (depending on your excel skills) from getting some clarity.

Next, what we’ll want to do is create a 2-D column chart highlighting “Keyword”, “Local Monthly”, and “Local Monthly %”.  Don’t use a 3-D column chart (even though you might want to), because Excel won’t let you combine a fancy 3-D chart with a 2-D line graph.

For this exercise, we have to stay in boring 2-D.

When you’re done, you should have something that looks like this:

pareto analysis 3

We have all the data points mapped that we need; we just can’t see them all right now. The next thing we need to do is create a multi-axis chart to graph the Pareto results. Tip: if you highlight the columns and right-arrow, you’ll eventually see the Local Monthly % in line at the bottom, like this:

pareto analysis 4

Right-click this data series and change the chart type to a 2-D line chart. You should see a solid red line at the bottom of the chart now. Highlight this line, right-click again, and format the data series to make it a secondary axis.  Now you should see this:

pareto analysis for seo 1

Step 3: Drawing an 80% Line in the Sand

Now that we’ve graphed the Pareto results, we’ve got to set that 80% line in the sand to capture the 20% that will create the most impact. Draw your line and find those keywords.

pareto analysis for seo 2

Step 4: Clean, Rinse, Repeat

That’s using one single metric, you can do this type of analysis for all the data points and create targeted list of keywords that will bring you the most bang for your buck.
As you can see, Pareto Analysis for SEO can be pretty handy to slim down your keyword choices or to help craft new strategies for client’s that have become stagnant.

Download the Pareto Analysis Workbook for SEO to help get you started on your own keywords.

Anthony Verre -

Anthony Verre is the founder and CEO of Silver Arc Search Marketing. Known at-large as "The Milwaukee SEO" . He has worked in search engine optimization and search marketing for over 5 years. He also writes a blog on search marketing, search engine optimization, and social media marketing news and opinion called The Milwaukee SEO.

You can also hook up via

Read More >>


More articles by this author

How To: Performing a Competitive Link AnalysisHow To: Performing a Competitive Link Analysis
We all know that link building is a cornerstone of...
Read More >>
Be A Better Boardroom SEOBe A Better Boardroom SEO
The boardroom; it’s the last place you’d think SEO happens....
Read More >>
 

Comments  

 
0 #1 Jey Pandian 2012-08-14 14:01
Thanks for this post Tony and the worksheet, I'm going to try it out today.

Best,
Jey
Quote
 
 
0 #2 Anthony Verre 2012-08-14 14:09
Hi Jey,

You're most welcome! Let me know how it works out for you! :-)
Quote
 
 
0 #3 Matt Beswick 2012-08-14 14:56
This appeals on so many levels - excel ninja skills, geekery, and actual SEO usefulness (which is a rarity). Will give it a go later :)

Matt
Quote
 
 
0 #4 David 2012-08-21 23:43
Hey Anthony - This is a great idea, and I downloaded the file and reproduced your result by following your steps, but I don't understand why the formula is the way it is in the local monthly column. Why does the formula in C3 add the previous result from C2 (and so on down the column). Thanks a bunch if you can shed light on that.
Quote
 
 
0 #5 Debbie Cruze 2012-08-28 13:18
SEO is something that many people choose to do. It is something that helps you to make your website better.
Quote
 
 
0 #6 Anthony Verre 2012-08-28 13:26
Hi David,

Sorry for the tardy response. In order to use Pareto Analysis, to find the 20% of highly impactful keywords, you have to use your set as a finite universe. In other words, per the example, you have to use your set as a 100% total. By adding in the value before it, like the C3 example, with the current value, you maintain the integrity of that 100%.

Does that make sense? If you were take each value divided by the sum of the whole, you negate the set's finite value.

Hope that helps! :-)
Quote
 
 
0 #7 سایپا 2014-04-08 09:36
In addition to art that will give you good
Quote
 

Add comment


Security code
Refresh

Getting Around the Site

Home - all the latest on SNC
SEO - our collection of SEO articles
Technical SEO - for the geeks
Latest News - latest news in search
Analytics - measure up and convert
RSS Rack - feeds from around the industry
Search - looking for something specific?
Authors - Author Login
SEO Training - Our sister site
Contact Us - get in touch with SNC

What's New?