📘 You're Losing Customers

📘 You're Losing Customers

data viz for seo

14 Data Visualization Charts for SEO

  • December 16, 2019

About the author

Ryan Stewart

I have an unhealthy obsession with being considered the world's BEST internet marketer. I'm highly active on social media and love a good debate.

As marketers, it’s a never ending challenge to get stakeholders to take action on our recommendations.

But…I get it. It’s difficult to digest spreadsheets with thousands of rows of data.

keyword gap analysis

In all fairness, this is terrible communication tool.

Enter data visualizations.

Visuals help to quickly communicate our findings and get resources approved for implementation.

This blog post will cover our 14 favorite data visualization tactics for managing SEO data, along with some helpful links to incorporate them into your organization’s practice.


Need help wrangling and visualizing your data? Our sister company (CodingIsForLosers) works with companies like yours to build custom tools using the Google Suite. Want to hear more? Schedule a free consult today.


1. Linkscape relationship analysis

By far one of my favorite SEO visualizations. Use it to spot issues with canonical tags, orphaned pages and internal link deficiencies. Personally, I like to use it during link building audits to display the most powerful pages on a site and how those pages and redistributing equity via internal links. Although there’s a slight learning curve to build the chart, there’s a TON of actionable ways to use this data.

google fusion table for seo

Your Website is Losing Money...

Find out exactly how many customers you SHOULD be getting from organic search.

2. Organic revenue + traffic crosswalks

Executives tend to invest in marketing tactics that drive quantifiable returns for the business. That’s why revenue reporting is so critical – it makes it easier to demonstrate an ROI from SEO. We like to use Google Data Studio to pull in revenue data and format it into simple charts to clearly demonstrate the economic impact of our services.

Page 1 is a dashboard that compares organic search to all traffic sources.

revenue dashboard

Page 2 is a dashboard that breaks down who is buying from organic search.

who is buying from google

Page 3 provides even more detail on who / how they’re buying.

revenue performance from seo

3. Striking distance keywords

Google Search Console provides keyword ranking data, filterable by query. We like to filter out “branded keywords” to understand the commercial intent of the website’s current positions.

gsc branded keywords

We can pull that data in Google Sheets and use a scatter plot to visualize the positions of all the keywords, from 1 – 100. This helps build a top level strategy for how many keywords are in “striking distance” of receiving traffic (keywords in positions 8 – 20 need a nudge to reach higher rankings and traffic). This helps you understand if you have a ranking problem (no keywords in the top 100) vs a visibility problem (no keywords in the top 10). This will change your approach to building an SEO strategy.

da vs keyword ranking

4. Technical SEO implementation matrix

After completing a technical audit there’s a landslide of items that need to get implemented, some higher priority than others. This simple quadrant graph is built manually by our consultants as a means to help clients understand the priority of issues found

Of course, we add them into their project plan, but this chart helps leadership understand where to place their resources in a single image.

  • Data source: Technical SEO audit
  • Chart type: Quadrant graph
  • Tool: Google Slides
  • Cost: Free

technical seo matrix

5. Page to keyword ranking distribution

This chart counts the number of keywords each page on a site is ranking for. We like to look for a pretty even distribution (as the image below shows) which tells us that pages across the site are picking up rankings. If the chart certain page clusters picking up more keyword rankings than others, it could point to some potential issues (need for internal links, issues with indexation on subfolders, lack of external links, etc).

On top of that, it helps inform if we need to create new pages to capture keyword rankings that big pages (like the homepage) are picking up (but shouldn’t be).

keyword distribution

6. Website depth structure (flat vs deep)

Depth refers to how a site’s hierarchy is structured – we refer to website’s as “flat” vs “deep” (as illustrated below).

flat vs deep hierarchy visualization

The 2 images are the same site organized in different ways: flat (left) vs deep (right). Generally speaking, “flat” websites are better for search engines and users:

  1. Pages are easier to discover when they’re not buried under multiple sub folders
  2. Search engines place more relevancy on pages located closers to the top level navigation
  3. Deep websites can be more challenging to use and find desired content (for crawlers and visitors)
  4. Flatter websites are easier to create more distinct and topically relevant silos for content to live under

We use software to help us visualize the architecture of a website. This helps inform us (at a glance) if the website is built properly instead of having to dig through millions of lines in a spreadsheet.

website hierarchy

7. Indexation roadblocks by depth

Working on SEO fixes with developers can be challenging – enter OnCrawl. This series of reports is critical for us when trying to communicate SEO roadblocks with the current site’s build. These 4 charts clearly demonstrate where issues are by directory (i.e. JavaScript on product pages, images concentrated at level 5, etc). This helps developers contextualize SEO issues with clear visuals.

  • Data source: Oncrawl
  • Viz tool: Oncrawl
  • Cost: $49/month

indexation roadblocks

8. Organic keyword growth over time

This is the visual I check the most – it’s a quick and dirty chart that shows my keyword progressions over time, filterable by position. Not only do I check this twice a week, but it’s a cornerstone of monthly SEO reporting.


ahrefs keyword growth

9. Keyword visibility over your campaign

We don’t use rank tracking software – we find it expensive and unreliable. Instead, we built our own using Google Search Console, Sheets and Data Studio. Each month we pull a snapshot of keyword rankings from GSC into a Google Sheets file. Then, using a stacked bar chart we’re able to show how their keyword rankings have shifted over time, ideally pushing their % into the top 3 positions.

10. 301 redirects based on page equity

301 redirects are a way to deprecate pages into another one. When working with a big, legacy website we may want to remove 301 redirects after they have been properly de/re-indexed in search results. However, you wouldn’t want to remove 301 redirects from pages who have external link equity, as that 301 redirect passes 100% of equity across pages. This chart crosswalks URLs that have a 301 redirect in place with the PA (or UR) of that page. This helps understand the link equity of your redirected pages and make decisions about how to handle them easier.

  • Data source: DeepCrawl, SiteBulb or Oncrawl + Moz PA / Ahrefs UR data
  • Viz tool: Google Sheets
  • Chart type: Scatter Plot
  • Cost: FREE

301 redirects by page

11. Unoptimized titles and meta descriptions

Page titles and meta descriptions are key influencers in helping searchers determine which result to click on. This chart pulls through all the URLs on a site with title and description issues (duplicate, short, long, etc) and crosswalks with Google Search Console CTR data. The result is a visual priority of which pages you should focus on to rewrite page titles and meta descriptions.

The bigger boxes and lightest shades are the most problematic. They’re getting a lot of search impressions but very low CTR. The sizing of the boxes is traffic opportunity (impressions) and the coloring is by CTR (lightest are lowest, darkest are highest CTRs).

keyword tree map

12. Crawl + ranking changes

Log files help spot Google crawl behavior changes. That’s usually an indicator for a technical issue or an algorithm update. Segments allow you to see what page types Google crawls every day, which shows you if one of them have an issue or not.

SEO Visibility is a reflection of your share of voice in organic results. It’s a lagging indicator but a helpful one for the strategic perspective. Since organic ranking positions only say so much in times of SERP features, SEO Visibility can be a helpful performance indicator for organic traffic.

A change in crawl rate is often reflected by a change in SEO Visibility. Looking at both metrics helps me put into context what could be going on and quickly diagnose potential problems.

Mind you, none of the metrics are perfect by themselves but help to raise the right questions. There are more numbers and reports I’m looking at but I found SEO Visibility and Log Files to be underrated und helpful.

  • Data source: Botify, SEMrush
  • Viz tool: Botify, SEMrush
  • Cost: Botify (Request only), SEMrush ($99/month)
  • More info:  This tip came from Kevin Indig, VP of Content and SEO at G2

botify crawl analysis

13. Competitor authority analysis

We build this chart off the back of our keyword research file. While our consultants are discovering keywords, they’re also recording the DA and PA of the sites ranking for our target keywords.

This allows us to build simple visualizations in Google Sheets that show the client the “gaps” in authority compared to the competition.

This helps us to frame the conversation around link building and how much effort we need to spend to acquire them each month.

competitor authority analysis

14. SERP result type analysis

While recording keywords for clients we’re also analyzing the SERPs to understand the types of content ranking. This helps us understand the exact type of content we should create to rank for our set of target keywords.

This also helps frame the conversation with clients about content deficiencies and the need to invest in production at scale.

serp result type analysis

Wrapping it up…

Sending massive spreadsheets or presentation decks don’t work for busy executives or stakeholders. Data visualization helps stakeholders quickly understand your work without having to spend hours digging through your work or sitting on a call.

Moreover, data viz is incredibly handy for search professionals. This post only scratches the surface on what you can do with your data.

If you need some assistance building out custom charts, reports or data pipelines for your company, let’s chat.

Our consultants are standing by to help.

Leave a Comment

Your email address will not be published. Required fields are marked *

Comments ( 104 )

  • eVden eVE NakliYaT Says
    6 months ago

    Nice post. I learn something totally new and challenging on websites I
    stumbleupon on a daily basis. It will always be interesting to
    read through articles from other writers and practice a
    little something from their web sites.

  • EvDEN Eve NAKliYAt Says
    5 months ago

    It’s impressive that you are getting ideas from this post as
    well as from our argument made at this place.

  • EVDeN eVe nAkLiyAt Says
    5 months ago

    Informative article, totally what I needed.

  • Regtech Blockchain Says
    5 months ago

    In ɑ ԝorld where everything iѕ changing into something new, it’s simple tо comprehend finance.

  • EvDEn EvE nakliyAt Says
    3 months ago

    continuously i used to read smaller content that
    as well clear their motive, and that is also happening with this article which I am reading at this place.

  • seo-копирайтинг на английском Says
    3 months ago

    СЕО текст характеризуется обязательным наличием ключевых слов и словосочетаний, а также соблюдением дополнительных требований, устанавливаемых поисковыми системами.

  • копирайтер на английском языке Says
    3 months ago

    SEO копирайтинг является современной тактикой написания и редактирования текстов для сайтов.

  • Nakliyat Says
    1 month ago

    You’ve made some good points there. I checked on the net to find out more about the issue and found most people will go along with your
    views on this web site.

  • situs slot minimal deposit 5000 Says
    3 weeks ago

    Incredible! This blog looks exactly like my old one!
    It’s on a totally different topic but it has pretty much the same layout and design. Wonderful choice of

  • Evden Eve Nakliye Says
    1 week ago

    Now I am going to do my breakfast, when having my breakfast coming yet again to read other news.

  • 지역별 마사지 Says
    6 days ago

    Howdy would you mind sharing which blog platform you’re using?

    I’m looking to start my own blog soon but I’m having a difficult time selecting between BlogEngine/Wordpress/B2evolution and Drupal.
    The reason I ask is because your design seems different then most blogs and I’m looking for something completely unique.
    P.S Sorry for getting off-topic but I had to ask!


    Find out how much organic traffic your website should be getting through our Traffic Projection Analysis.




    Using data from your website, our Traffic Projection analysis can accurately forecast how much traffic (and revenue) your website could be getting from Google.