Ultimate Data Visualization Guide for Analysis of SEO Campaigns

 

In an ideal world of analytics there will be no tables and mountain of text, just charts and graphs through which you can visualize patterns and trends in data and take decisions which are beneficial both for your company and clients. This post is an attempt to get one step closer to achieve this ultimate dream.

It is a no brainer that data visualization can easily highlight the most complex problem to you and can easily explain technical issues to a non-technical audience (like your clients) in an effective manner.

So I think there is no need to reinforce its importance and advantages and we can all jump together straight into the wonderful world of Data visualization. Following are the fields of SEO where we need to visualize data the most:

1. Competitive Analysis
2. Back Links Analysis
3. Crawling, Indexing & Site Architecture

 

Competitive Analysis

Visualizing the social media strength of your top SEO competitors

It is always good to know the role social media is playing in the rankings of your competitors. If you have no social media presence and all your competitors do then you’re are losing out on this front.  Here is how I have visualized the social media strength of the top 10 sites on Google.com for the keyword ‘car insurance’:

From this chart I have got a pretty good idea that social media signals are playing some role in the rankings and I have to be active too on social media esp. facebook and twitter to get social shares/mentions. The chart above is a 2-D custom column chart which you can easily create in MS Excel. Here is what I did to create this chart:

Step-1: Scrape the top 10 organic search results from Google.com using SERPs Redux bookmarklet.

Step-2: Use the Excel Plugin by Niels Bosma to quickly fetch Facebook likes, Google Plus and Twitter counts for each URL.

Step-3: Select the table and create a column chart in your Excel workbook: Insert menu > Column > 2-D clustered Column (in Excel 2007).

 

Visualizing the Ranking potential of top 10 SEO competitors for your primary keyword

 

From these two charts you can get a pretty good idea of the competition in the ‘car insurance’ space. Here is what I did to create this chart:

Step-1: Log in to the seomoz keyword difficulty tool , enter the keyword ‘car insurance’, select your search engine & country and then click on the ‘run report’ button.

Step-2: Once you get the report, click on the ‘Export to XLS’ link to download the report into excel.

Step-3: Select ‘URL’, ‘Page Authority’ and ‘Domain Authority’ columns to create the first 2-D clustered Column chart as shown above.

Step-4: Select ‘URL’, ‘Page Linking Root Domains’ and ‘Root Domain Linking Root Domains’ columns to create the second 2-D clustered Column chart.

Click here to download these charts.

 

Visualizing the back link profile of your top SEO Competitor(s)

back-links-analysis-chart

I consider this visualization as the Mother of all SEO data visualization techniques. The kind of insight that you get through this chart is unparalleled. Through this chart you can easily and quickly see the X-ray report of the back link profile of any website. Even the top notch SEO softwares in the market don’t provide such type of analytical insight yet. And this visualization just doesn’t stop here.

You would be very much interested in knowing exactly which blogs, directories, .edu sites, .gov sites etc are driving the ranks of your competitors along with the PA, DA and all other metrics provided by tools like open site explorer. Something like this:

Back Links Analysis Tool

 How I created this chart and what I did to get such valuable insight? The answer is bit difficult. I specially developed my own tool using MS Access to get such type of data visualization. The chart above on ‘visualizing the back link profile of your top SEO competitor’ is actually a MS Access Chart and not a typical Excel chart.  To learn more about how you can create this tool, check out my post How to create your own back link analysis tool.

 

Visualizing the ranking potential of your SEO competitors at Granular Level

Visualizing the ranking potential of your SEO competitors at Granular Level

 If you take a close look at these charts you will find that there are two websites which stand out in almost every chart. These websites have pretty unnatural back link profiles. Most probably they are badly SEOed and may not withstand future algorithm updates. So you get a pretty good idea of the competitive space now. To get these awesome charts I used the SEOmoz SERP Analysis Tool . To use this tool follow the steps below:

Step-1: Run the SEOmoz keyword difficulty report

Step-2: Click on the ‘full report’ button

Step-3: Once you get access to the full report, click on ‘Export to XLS’ link (it usually takes several hours to a day to get the report and you also loose 1 credit.  So be careful what you wish for. Download the report into excel.

Step-4: Select different columns to create different column charts as mentioned above.

I have done all the hard work for you. Click here to download all of these charts now.

Please Note: You can also use SEOmoz API to fetch the data if you are really technical. I avoid the usage of APIs in blog posts to keep them simple.

 

Visualizing back links overlap between websites

venny

Through this Venn diagram you can visualize back links overlap between websites. You can also get a complete list of overlapped linking domains. These are those domains which are linking out to two or more of your competitors. Getting links from such domains is relatively easy. So it can help you with your link building campaign.

From the diagram above you can see that the website 1 has got links from 12 domains. Out of this 12 domains: 5 domains link out only to website A, 3 domains link out to both website 1 and website 3 and remaining 4 domains link out to website 1, website 2 and website 3. This is what this Venn diagram is all about. All the numbers on the diagram are clickable (in actual tool) and you can see the list of overlapped linking domains in the text area below the diagram.

I have used mock data here for simplicity. You can replace website 1,2 and 3 by your competitors websites and use real data in the text fields. You can download the linking domains of up to 4 websites using open site explorer (click on the linking domains tab and then download the list) and then copy paste the linking domains list into the text boxes of the corresponding websites as shown above to create the Venn Diagram.

The tool that I have used to create this Venn diagram is known as Venny and the credit for discovering the great usage of this awesome tool goes to Kelvin Newman of SiteVisibility.co.uk. He has put a nice video on his website that tells in detail about how to use this tool efficiently.

 

Visualizing the overall ranking potential of your website and that of our competitor

seomoz-radar-chart

Here I am visualizing the ranking potential of BBC and CNN websites. As you can clealry see BBC has, stronger ranking potential than CNN. This is something which you can easily explain to any non-teachnical person without the need to explain DA, PA and other OSE metrics.  I developed this Radar Chart through a SEOmoz lab tool known as Visualizing linkscape data. You can’t get such type of visual insight from anywhere else.

 

Visualizing the Link growth/ Velocity of your website and that of your competitor

This chart visualizes the link growth of the BBC and CNN websites. As we can see from the chart, CNN has speed up its link building efforts and is on its way to beat BBC. Come on BBC! Don’t let us down. You can get similar insight for any website(s). I created this chart through Majestic SEO BackLink History Tool.

 

 

Back Links Analysis

Visualizing the Geographic Profile of a site’s back links

geo-profile-backlinks

You would be interested in knowing the geo locations of your back links. The chart above shows the back links profile of an English website hosted in US. Since it is an English website, so it is pretty natural to have majority of links from English speaking countries. But let us suppose your website is in Hindi (my native language).

If such website is acquiring majority of its links from English speaking countries like US and UK then I will be really surprised and would like to investigate. Often such links turns out to be spammy. This type of visualization is more useful to those marketers who are into international SEO and who deal with multiple language websites.

 

To get this chart I used the Advanced Report of the Majestic SEO Tool. Follow the steps below to get this chart:

Step-1: Log-in to your Majestic SEO account and click on ‘reports and tools’ link at the top right hand side.

Step-2:
Enter the URL of the domain whose back links you want to analyze in the ‘Analyse a New Website’ text box. From the drop down menu select ‘URL Level advanced report for….’ and then click on ‘create a report’ button. In this way you can create an advanced report.

Please Note: You can create advanced report for a domain for free if you can verify the domain ownership in your Majestic SEO account. If you can’t verify the domain ownership then you need to subscribe to their paid service.

Step-3: Click on ‘Summary Reports’ drop down menu at the top and then click on ‘countries’. You will see a report like this:

majestic-seo

 Step-4: Click on the ‘Export Report CSV’ link at the bottom left hand side and download this report into Excel. Select the ‘country’ and ‘backlinks’ columns and create a 2D Clustered column chart.  You can also create a pie chart if you like.

 

Visualizing the Anchor text distribution analysis of a website

link-building-bus

This word cloud is the visual representation of the anchor text distribution of back links of a leading insurance website. Their link building bus seems to be going towards the gray area of SEO: over optimized anchor text.

You can see how the keyword ‘insurance’ is on its way to dominate their brand name followed by the keywords ‘online’ and ‘car’. They should focus on getting more links with brand name as the anchor text before their back link profile starts looking unnatural to the point that we no longer need this word cloud.

Consider this bus as a warning system for over optimized anchor text. To get this bus, follow the steps below:

Step-1: Scan your website using ‘open site explorer’

Step-2: Click on the ‘anchor text’ tab and then click on ‘download CSV’ link to download the list of anchor text into excel.

Step-3: Copy the column which contains all of your anchor text in your excel document and then paste them into Tagxedo to create a word cloud. Tagxedo provides lot of layouts, colors, themes, shapes etc. I selected bus as the shape.

 

Visualizing the Quality of Back Links of a website

link-profiling
This chart shows the distribution of back links to a website in the ‘signs’ industry and is a great way to visualize the quality of links a website has acquired. Dr. Pete of usereffect.com gets the credit for discovering this awesome way of linking profiling. To create this chart, follow the steps below:

Step-1: Scan the website through Open Site Explorer (OSE)

Step-2: Select “Show [Followed + 301]”, select “from [External Pages Only]”, Select “to [All Pages on the Root Domain]”

Step-3: Export results to CSV/Excel

Step-4: Download the worksheet created by Dr. Pete here.

Step-5: Export Open Site Explorer results from Excel and paste it into the first worksheet (“OSE Data”). The second sheet (“Domains”) will automatically strip out the sub domains. The third sheet (“Max PA”) is a pivot table that calculates the maximum Page Authority for each sub domain and then collapses that into the 10 buckets.

Please Note: You may need to refresh the Pivot Table (Go to ‘Data’ Menu and Click ‘Refresh All’ in Excel 2007)

 

 Crawling, Indexing & Site Architecture

Visualizing the informational architecture of a small website

visual-sitemaps

This map visualizes the site architecture of one of my website eventeducation.com. Visualizing the structure and information architecture of a web site can help a lot in understanding the crawlability, indexing and usability issues of the site. I developed this map through a tool known as Power Mapper.

This tool has a web browser type interface. So if you can use a web browser than you easily use this tool too. Just enter the URL of the website you want to map and then click on Map > Map Entire Site. Boom! You can map the entire site and that too using 7 different styles of map.

The style that I have used for my map is known as ‘Electrum’. You can also restructure the site structure produced by this tool through a simple drag and drop. In this way you can create new prototype of your website structure. The only downside of this tool is that it doesn’t work well for very big websites.

 

Visualizing the informational architecture of very big & complex websites

The only way I could find to analyze and visualize the information architecture of very big websites is to break down the data into edges and vertices and then look at individual sections of a website instead of the whole website.

If you try to visualize the information architecture of a very big and complex website in a single view, then all you will see is a big black hole. You can’t see the number plates of each and every house and buildings in London in one view no matter how powerful your telescope is, can you?

Big websites are just like mega cities, large and complex. Each web page of the site represents a house and the name (title tag, main heading) of each web page represents the number plates. So you need to learn to navigate while you visualize. I use the graphic visualization tool called NodeXL which has been specially designed to study large and complex social networks.

There are tons of graphic visualization tools out there like Graphviz , Cytoscape etc. But NodeXL is my personal favorite, mainly because it is an Excel template, it is easy to use unlike Graphviz and other visualization tools and above all it’s Free. You can get the data from Xenu Link Sleuth , screaming frog SEO spider or Open Site Explorer. Xenu link sleuth and screaming frog are good tools to visualize site architecture. OSE can also be used for this purpose but I mainly use it to visualize internal and external link flow of a website.

nodeXL

 I made this chart through NodeXL. It visualizes the link flow from the home page to other pages on the website. By hiding vertices and edges you can visualize any section of a website no matter how big or complex it is. Explaining how I developed this chart is beyond the scope of this post. You can read the NodeXL Tutorial till I come up with another post just on this. Anyways I have opened up a world of possibilities for you to experiment with. It is not very hard. Trust me.

 

Visualizing the wireframe of a website

visualizing-wireframes

This is the wireframe of a landing page of amazon.co.uk. I created this wireframe in a second and in just one click through Wirify bookmarklet. This bookmarklet can help you lot in usability testing and in understanding the wireframes of your competitors. It can also help you with your PPC landing page design.

 

Visualizing crawl diagnostic issues

visualizing crawl diagnostic issues
All these charts (& many more) are available in SEOmoz web app under the ‘crawl diagnostics’ menu. You don’t need to make them. Just select the one you would like to see from a drop down menu.

The cool thing about these charts is that not only you can visualize the various crawling issues but can actually see the progress made on on-page SEO efforts over time. For example you can see from the charts that duplicate page titles and page contents are on a rise. This may be due to some CMS issue and you need to look into it. Such type of insight is not available in any other tool and this is why they are special.

 Related Posts

 

Subscribe to my blog
Join my free newsletter and learn to avoid the analytics mistakes everyone seems to be making over and over again.

 



Subscribe to my YouTube Channel > > >

 

About the Author:

Please feel free to endorse/forward my LinkedIn Profile to your clients, colleagues, friends and others you feel would benefit from PPC, Web Analytics or Conversion Optimization.

For any question/comment Contact me