Data Visualization for analysis of SEO Campaigns – Tutorial

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 and 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 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 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 ten 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 Moz keyword explorer tool, enter the keyword ‘car insurance’, select your search engine and 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.

Download these charts.

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


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. 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


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 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 your competitor


Here I am visualizing the ranking potential of BBC and CNN websites. As you can clearly 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 this type of visual insight from anywhere else.

Visualizing the link growth/velocity of your website and 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


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.

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:


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


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

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 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.

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 and site architecture

Visualizing the informational architecture of a small website


This map visualizes the site architecture of one of my website 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 and 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.


 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


This is the wireframe of a landing page of 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 (and 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



Do you know the difference between Web Analytics and Google Analytics?

99.99% of course creators themselves don’t know the difference between Web analytics, Google Analytics (GA) and Google Tag Manager (GTM).

So they are teaching GA and GTM in the name of teaching Web analytics.

They just copy each other. Monkey see, monkey do.

But Web analytics is not about GA, GTM.

It is about analyzing and interpreting data, setting up goals, strategies and KPIs.

It’s about creating strategic roadmap for your business.

Web Analytics is the core skill. Google Analytics is just a tool used to implement ‘Web Analytics’.

You can also implement ‘Web analytics’ via other tools like ‘adobe analytics’, ‘kissmetrics’ etc.

Using Google Analytics without the good understanding of ‘Web analytics’ is like driving around in a car, in a big city without understanding the traffic rules and road signs.

You are either likely to end up somewhere other than your destination or you get involved in an accident.

You learn data analysis and interpretation from Web analytics and not from Google Analytics.

The direction in which your analysis will move, will determine the direction in which your marketing campaigns and eventually your company will move to get the highest possible return on investment.

You get that direction from ‘Web analytics’ and not from ‘Google Analytics’.

You learn to set up KPIs, strategies and measurement framework for your business from ‘Web analytics’ and not from ‘Google Analytics’.

So if you are taking a course only on 'Google Analytics’, you are learning to use one of the tools of ‘Web analytics’. You are not learning the ‘Web analytics’ itself.

Since any person can learn to use Google Analytics in couple of weeks, you do no get any competitive advantage in the marketplace just by knowing GA.

You need to know lot more than GA in order to work in Web analytics and marketing field.

So what I have done, if you are interested, is I have put together a completely free training that will teach you exactly how I have been able to leverage web/digital analytics to generate floods of news sales and customers and how you can literally copy what I have done to get similar results.

Here what You'll Learn On This FREE Web Class!

1) Why digital analytics is the key to online business success

2) The number 1 reason why most marketers are not able to scale their advertising and maximize sales.

3) Why Google and Facebook ads don’t work for most businesses & how to make them work.

4) Why you won’t get any competitive advantage in the marketplace just by knowing Google Analytics.

5) The number 1 reason why conversion optimization is not working for your business.

6) How to advertise on any marketing platform for FREE with an unlimited budget.

7) How to learn and master digital analytics and conversion optimization in record time.


My best selling books on Digital Analytics and Conversion Optimization

Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.

Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.

Attribution Modelling in Google Analytics and Beyond
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.

Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.

Himanshu Sharma

Digital Marketing Consultant and Founder of

Himanshu helps business owners and marketing professionals in generating more sales and ROI by fixing their website tracking issues, helping them understand their true customers' purchase journey and helping them determine the most effective marketing channels for investment.

He has over 12 years of experience in digital analytics and digital marketing.

He was nominated for the Digital Analytics Association's Awards for Excellence. The Digital Analytics Association is a world-renowned not-for-profit association that helps organisations overcome the challenges of data acquisition and application.

He is the author of four best-selling books on analytics and conversion optimization:

error: Alert: Content is protected !!