Skip to content

Cyber Sale: Save big on Moz Pro! Sign up by Dec. 6, 2024

Search engines 5511dd3

One More Great Way to Use Fusion Tables for SEO

Sven Witteveen

This YouMoz entry was submitted by one of our community members. The author’s views are entirely their own (excluding an unlikely case of hypnosis) and may not reflect the views of Moz.

Table of Contents

Sven Witteveen

One More Great Way to Use Fusion Tables for SEO

This YouMoz entry was submitted by one of our community members. The author’s views are entirely their own (excluding an unlikely case of hypnosis) and may not reflect the views of Moz.

Recently Mark Cianfrani wrote on SEERInteractive.com about how Google’s Fusion Tables can be used for visualising backlinks and social media data. Google’s new interactive graphs supported by Fusion Tables simply blew me away, and I immediately wondered in what other ways this could be used.

Fusion Tables?

Google added a new feature to its Google Docs called Fusion Tables. Essentially, these are databases hosted online just like other types of Google documents. The only difference is that with Fusion Tables you can do things you simply could not do before: create Network Graphs!

Since I thought the concept of the Network Graph fits the characteristics of links perfectly, I decided to see if I could create something nice for visualising the internal link structure of a website. Although I’ve just started out experimenting with this, I’d like to show you what I came up with.

Network Graph of Expand Online

The above graph shows the internal linking structure of www.expandonline.nl. The blue dots are pages where links are placed; the orange ones are the pages that the links are to. Each dot has a roll-over function that highlights the pages it links to (in case of a blue one) or is being linked from (in case of orange).

Roll-over function of Network Graph

As you may have noticed the graph looks quite nice and organised. Let’s just say, I didn’t do that. What is not visible in the screenshot is that the pages are also grouped by category. This is obviously due to the fact that they receive links from the same top pages, but all in all it looks great!

You can check out the Network Graph I made.

How did I do it?

It’s relatively simple to generate such an image using only XENU Linksleuth, Fusion Tables, and Excel (or whatever spreadsheet software you use). Here’s a short how to:

  1. Crawl a website with Xenu and export the GraphFiz file.
  1. Import the file to Excel using the Text Import Wizard. Select ‘Delimited’ and use Space as separator. You should now have the following spreadsheet:

Export of XENU

  1. You need to slightly tweak the Excel file to make it nice and clean. This makes sure you will not get errors while importing the data to a Fusion Table in Google Docs. First of all delete column A and column C as there is no relevant information there. Then Delete row 1 and add headers to the remaining empty row at the top. After this you might want to filter out some junk from the table such as:
  • Images
  • Stylesheets
  • Duplicates
  • Etc.

If your standard pages end in .html, it’s quite easy to grab only the .html pages only and delete the rest. Otherwise, it’s slightly more work.

Finally, I recommend adding some text to make sure the values in Column A do not show up in Column B and vice versa. Having links in both columns seems to prevent the nice color separation of link source and target and generates a messier graph in general. I add ‘S:‘ to the source and ‘T:‘ to the target. When you’re done, it should look something like this:

Edited XENU Export

  1. Save your file locally as .xlsx and go to Google Docs. Here you can create a new Fusion Table from a local file:

Google Docs Fusion Table Interface

  1. When your table is created you can select: ‘Experiment’ => Network Graph and BOOM! There it is!

Extras:

You can add extra columns to your spreadsheet before uploading it to Google. For example: hierarchy of the page, category, or anything you like. These can be used for filters like: Link Target < 2 levels deep. Have fun!

You can set the Number of Nodes Shown, which you can use to make the graph more like a ‘model’ or more like reality. One more great way to use Fusion Tables for SEO.

Back to Top

With Moz Pro, you have the tools you need to get SEO right — all in one place.

Read Next

How to Create an SEO Forecast [Free Template Included] — Whiteboard Friday

How to Create an SEO Forecast [Free Template Included] — Whiteboard Friday

Nov 22, 2024
Directional Reporting in GA4 — Whiteboard Friday

Directional Reporting in GA4 — Whiteboard Friday

Aug 02, 2024
The Value of SEO Beyond Traffic and Leads — Whiteboard Friday

The Value of SEO Beyond Traffic and Leads — Whiteboard Friday

Jun 28, 2024

Comments

Please keep your comments TAGFEE by following the community etiquette

Comments are closed. Got a burning question? Head to our Q&A section to start a new conversation.