Home  › Search › SEO

4 Steps to Identifying Your True Organic Competitors

  |  July 27, 2011   |  Comments

A sure-fire way to map out the competitive landscape for your industry.

Whether you are a large international organization or a small village shop, if you are engaging in an SEO campaign, it is critical to understand your industry's true organic landscape in order to:

  • Identify who you're up against
  • Set expectations on the likelihood of obtaining top rankings for desired keywords
  • Understand the tactics and strategies that are working for top ranking sites so that you can learn from them and execute at a higher level

The first question that should be coming to mind is: "Who are my true competitors?" Many large enterprises and their executives are often surprised to find that who they typically think of as a direct competitor may not always be the same set of competitors performing well in organic search for high volume keywords. This month I'm going to delve into the world of Excel Pivot tables and rely on hard numbers and data to identify a sure-fire way of mapping out the competitive landscape for your industry in four easy steps.

Step 1 – Conduct Keyword Research

A solid SEO campaign revolves around conducting keyword research to determine how your customers are searching and targeting the high volume, as well as low-hanging fruit phrases. In this example, we're using 15 keywords around the domain name registration and web hosting industry – I hope that's neutral enough for an example! However, the more in-depth your keyword list is, the more meaningful your end result data will be.

Step 2 – Collect Ranking Data

Most rank tracking software has the ability to provide reports that display which URLs are ranking in each position for a set of keywords. I ran my report on the 15 keywords in Google to a depth of 20 positions. Once exported, you'll want to have a format that shows line by line the URL that's ranking in the top 20 positions for each keyword. It should look similar to the screenshot below:

rankingdata

Once you have your data, add a column that isolates the top-level domain name of the ranking URLs as shown below:

top-level-domains

Step 3 – Create the Pivot Table

To create the pivot table in Excel, simply select the entire set of data and go to Insert>Pivot Table and place it in its own worksheet. Once created:

  • Add the Domain to "Row Labels" and "Values"
  • Add Position to "Values" and update the value field settings to show the Average instead of Count

Your pivot table should appear similar to the screenshot below:

pivottable

Once your pivot table has been created, select all of its data, copy/paste it into a new worksheet, and sort the data by count of domain (largest to smallest):

countofdomain

Step 4 – Analyze the Data

Reviewing the data above, you can see that NetworkSolutions.com, Register.com, and GoDaddy.com are ranking most frequently for my set of 15 keywords and have a strong average position for those rankings. The data doesn't stop there though! Get creative with your pivot tables by adding in additional metrics such as other search engines, categorize your keywords to see who the top competitors are for unique sets/topics of keywords, or even decrease the depth of rankings to only look at who is ranking in the top three positions for an understanding of who is controlling the top spots where you want to be.

Once you have your list of competitors, it's time to start analyzing their content and SEO strategies for insights into why they are ranking, what they have that you don't, and then determine how you can do it better in order to break into the top positions. More on this next time.

Finally, are you conducting competitive analyses within your organization? If so, what other ways are you identifying your true online competitors?

Crispin Sheridan

Tags:

ClickZ Live San Francisco This Year's Premier Digital Marketing Event is #CZLSF
ClickZ Live San Francisco (Aug 11-14) brings together the industry's leading practitioners and marketing strategists to deliver 4 days of educational sessions and training workshops. From Data-Driven Marketing to Social, Mobile, Display, Search and Email, this year's comprehensive agenda will help you maximize your marketing efforts and ROI. Register today!

ABOUT THE AUTHOR

Crispin Sheridan

Crispin Sheridan is the Senior Director, Global Search at SAP. As part of the digital team, he established and leads the search and testing practices at SAP. Crispin is responsible for paid, natural, and mobile search and all online testing. Search and testing at SAP are fully centralized and globally funded and run under a hybrid in-house and agency model.

Crispin has proven that search learnings and keyword insights work hand in hand with social media marketing and together can effectively drive B2B lead generation. Furthermore, the development of the SAP.com Test Lab has contributed significant success to SAP's digital marketing efforts.

A frequent guest speaker at conferences, including SES New York, San Francisco, Toronto, London, Delhi, Shanghai, and Hong Kong, Crispin was appointed to the SES Advisory Board in December 2009. He has also been a guest speaker at the e-Metrics Summit and ad:Tech, and is a member of Google's B2B Technology Council. You can follow him on Twitter at @crispinsheridan and read his monthly SEO column on ClickZ.

COMMENTSCommenting policy

comments powered by Disqus

Get the ClickZ Search newsletter delivered to you. Subscribe today!

COMMENTS

UPCOMING EVENTS

Featured White Papers

BigDoor: The Marketers Guide to Customer Loyalty

The Marketer's Guide to Customer Loyalty
Customer loyalty is imperative to success, but fostering and maintaining loyalty takes a lot of work. This guide is here to help marketers build, execute, and maintain a successful loyalty initiative.

Marin Software: The Multiplier Effect of Integrating Search & Social Advertising

The Multiplier Effect of Integrating Search & Social Advertising
Latest research reveals 68% higher revenue per conversion for marketers who integrate their search & social advertising. In addition to the research results, this whitepaper also outlines 5 strategies and 15 tactics you can use to better integrate your search and social campaigns.

WEBINARS

    Information currently unavailable

Jobs

    • Internet Marketing Campaign Manager
      Internet Marketing Campaign Manager (Straight North, LLC) - Fort MillWe are looking for a talented Internet Marketing Campaign Manager to join the...
    • Online Marketing Coordinator
      Online Marketing Coordinator (NewMarket Health) - BaltimoreWant to learn marketing from the best minds in the business? NewMarket Health, a subsidiary...
    • Call Center Manager
      Call Center Manager (Common Sense Publishing) - Delray BeachWanted: Dynamic Call Center Manager with a Proven Track Record of Improving Response...