background preloader

SEO Excel

Facebook Twitter

Visualize Your Backlinks with Google Fusion Tables. Data can be boring.

Visualize Your Backlinks with Google Fusion Tables

I’m sorry, but it’s true. Don’t get me wrong, I love a good spreadsheet as much as I love a good novel, but whenever I can get away with it, I’d much rather just see the movie. Visualization and presentation have never been more important then they are today. The amount of data that we collect, process, and analyze is overwhelming. Have you ever peeked into the backlink profile for a domain that has over a million links? In typical Google fashion, Google quietly rolled out a brand new “Experimental” version of their Fusion Table application a few weeks ago.

This is what 15,000 links looks like Who said that competitor backlink research couldn’t be fun? You can view the completed Network Graph and Fusion Table here. Want to SEE who is linking to you? 1. For this experiment, I gathered the backlink profiles for four companies in the SEO industry, SEER Interactive, Distilled, SEOMoz, and Zamolution (who rank #1 for “Philadelphia SEO Company”). 2. 3. 4. BOOM. Keyword Research - Using Categories to Make Your Process More Actionable. The author's posts are entirely his or her own (excluding the unlikely event of hypnosis) and may not always reflect the views of Moz.

Keyword Research - Using Categories to Make Your Process More Actionable

One of the earliest and arguably most important parts of the SEO process is keyword research. Keyword research helps you answer that all important question, "In what quantities do people use search engines to find the products and services on my website? ". Your research process will ultimately govern the method you use to structure your website, inspire your content strategy and kick start your link building campaigns. Excel and Google Docs: Tools for the Ultimate SEO Dashboard. I love SEO tools.

Excel and Google Docs: Tools for the Ultimate SEO Dashboard

Competitive Analysis in Under 60 Seconds Using Google Docs. Faced with a new client, and having established a list of keywords they need to target, you want to evaluate the competition to find out what sites are dominating the SERPs for these keywords.

Competitive Analysis in Under 60 Seconds Using Google Docs

However... being an SEO you're a busy guy (or gal), and you need it done right now. I've built a Google Docs tool to automagically do exactly that and this post will walk you through it. The basis for this tool comes from a report in this linkbuilding post on YOUmoz which contained a neat little 'SERP Saturation' report. I don't know how Stephen made his snazzy looking report (he's now shared a few details in this comment), but in response to a few people asking about his I thought I'd put together a tool. Here is Stephen's report: Cool, eh? 1. So, what's the report all about? You can just duplicate the Google Docs spreadsheet I provide below, and change almost any of this to add, modify or take away as per your needs. 2. You must configure it the first time you use it: 3. 2) Open the 'Report' sheet.

Excel functions for fetching Google Analytics data. How to Build an Advanced Keyword Analysis Report in Excel - YouMoz. Analyzing keyword performance, discovering new keyword opportunities, and determining which keywords to focus efforts on can be painstaking when you have thousands of keywords to review.

How to Build an Advanced Keyword Analysis Report in Excel - YouMoz

With keyword metrics coming from all over the place (Analytics, Adwords, Webmaster Tools, etc.), it’s challenging to analyze all the data in one place regularly without having to do a decent amount of manual data manipulation. Playing Around with ImportXML in Google Spreadsheets. Put me in front of a Mac and it’s almost as if I never learned to use a computer.

Playing Around with ImportXML in Google Spreadsheets

Put me in front of Google Spreadsheets and all of the time I’ve spent working with Excel feels a little like time wasted, and not in a good way. I’m just not very used to a spreadsheet that isn’t Excel. Unafraid of a challenge, I recently decided to give Google’s (exceptional) importXML, importFEED and importHTML functions a try – the ability to fetch information from the web to retrieve the data you need. Mostly to make an interesting blog post, but partly out of envy that Excel doesn’t have this function. Tips and Tricks – Excel and SEO: Word Search Formula. The following Excel formula is useful for keyword research, perhaps one of the most important steps in search engine optimization.

Tips and Tricks – Excel and SEO: Word Search Formula

You should always conduct keyword research prior to writing content for your website. By identifying relevant keywords with high traffic and low competition, you stand a greater chance of attracting visitors interested in your content. The word search formula enables us to sort a spreadsheet depending on whether words exist in an adjacent cell. Think of it as a full text search on a column. But instead of just seeing which cells match, we can also interact with the results. Using Excel for SEO – the Grand Collection of Tips. You probably know that I am a big Excel fanatic (though not an expert).

Using Excel for SEO – the Grand Collection of Tips

To me, Excel has always been the ultimate SEO, guest blogging and productivity tool. I’ve been collecting Excel tutorials for years and this post lists the most useful (yet, the least geeky) of them: no matter which SEO task you have come across, chances are you’ll find one of the following tutorials handy: 1. Microsoft Excel for SEOs. P.ost. How To Build Agile SEO Tools Using Google Spreadsheets.