Visualize Your Backlinks with Google Fusion Tables. Data can be boring.
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. 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.
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.
I’m sort of a pack-rat when it comes to Google Docs tools and Excel add-ins. I went absolutely nuts when Tom Critchlow posted his Google Docs SEO tutorial on distilled. Since then, I’ve rolled a few tools of my own and collected pretty much anything to do with SEO and spreadsheets since then. 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.
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. 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.
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. In addition, dependent on your site’s business model, tying revenue metrics to keyword data is a whole other battle. This post will walk you through a solution to these keyword analysis issues and provide some tips on how you can slice and dice your data in wonderful ways. 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.
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.
It’s frustrating trying to get XML data into Microsoft Excel – unless you’ve got the time and patience to build some basic Macros or VBscript for your requirements. 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.
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).
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: Microsoft Excel for SEOs. P.ost. How To Build Agile SEO Tools Using Google Spreadsheets.