02 May '13, 2pm

Spreadsheets for SEO: Filtering Google Webmaster Tools Data by Domain

Spreadsheets for SEO: Filtering Google Webmaster Tools Data by Domain

Hey all, I tend to be the guy everyone comes to for Excel help at Bronco, so I thought I’d start doing posts on solving some of the most common issues I find popup being an SEO. This may well have been talked about before by other bloggers, but it may be new to a lot of you, please let me know whether you want to see more posts like this or not. Ok, so my first post on spreadsheets for SEO, I’m doing a quick tutorial on how to manipulate your latest links list from Google Webmaster Tools. Download it as a CSV and you should get something that looks like this when you open up Microsoft Excel: Let’s face it, it’s a pretty nasty big list of URL’s, with no domain de-duplication, in a nutshell it’s not easy for your average user to manipulate. So one of the first things you might want to do is reorganise it so you can see how many unique domains are linking and maybe a breakdow...

Full article: http://www.davidnaylor.co.uk/spreadsheets-for-seo-filteri...

Tweets

Video Recap of Weekly Search Buzz :: May 3, 2013

seroundtable.com 03 May '13, 2pm

This week I reported on a scary possible Google Rich Snippet hacking issue, I hope it is just a display bug. Bing Webmaste...

May 2013 Google Webmaster Report

seroundtable.com 06 May '13, 1pm

thread has the typical chatter around traffic shifts from Google, ranking fluctuations and discussions around seasonal imp...

3 Free SEO Tools for Auditing and Troubleshooti...

searchenginejournal.com 02 May '13, 1pm

It’s not uncommon in today’s SEO landscape to wake up and find a sudden drop of organic search traffic and/or keyword rank...

How Not to Visualize Your Data

How Not to Visualize Your Data

seomoz.org 02 May '13, 11am

Lately, I’ve been seeing data visualizations everywhere, including the products in my own kitchen. This week, I had sighti...

.ME domain names

domain.me 04 May '13, 8am

Want your own piece of Internet real estate? Need an online home for that brilliant blog or budding business idea? Look no...

See if you can spot the differences & then find...

godaddy.com 02 May '13, 8pm

Buy a domain name and the world is your oyster. Domains are more than just addresses for your websites , they're also your...

13 domain name extensions discounted this month. What? Yes.

13 domain name extensions discounted this month...

name.com 03 May '13, 12pm

Your online promo code for COM/NET registration and renewal is DOMAINDEMAYO which roughly translates to "I don't know much...

Google Webmaster Tools Reporting Stalled

Google Webmaster Tools Reporting Stalled

seroundtable.com 08 May '13, 12pm

Many many webmasters are complaining in the Google Webmaster Help forums that the reporting in Google Webmaster Tools spec...

How Google Now Will Impact SEO & What You Can Do to Get a Head Start

How Google Now Will Impact SEO & What You Can D...

searchenginewatch.com 07 May '13, 1pm

Google has released many products and services over the last few years to improve the way people search and find informati...

Cupping for Beginners - Tools of the Trade

Cupping for Beginners - Tools of the Trade

coffeegeek.com 01 May '13, 4pm

Your next decision is what coffee should you be evaluating. First, starting with three or four coffees is best, though you...

How to create a site structure Google will love...

wordtracker.com 04 May '13, 5pm

For the first year of Google's life, it was actually called BackRub. The system got its name from the term backlinks - the...

Local SEO - "Why is it important?"

searchengineguide.com 03 May '13, 6pm

Tweet What's Local SEO? When the term "local business" is thrown around, it doesn't mean the mom and pop shops in small to...

Don't click that dumb SocialMeter thing, it WIL...

networksolutions.com 02 May '13, 8pm

WHOIS TERMS & CONDITIONS: Access to .ME WHOIS information is provided to assist persons in determining the contents of a d...

webmaster tools #seo #seomoz

seomoz.org 12 May '13, 4pm

For webmaster tools, you authenticate each site separately. These are different country level top level domains, and will ...

SEO

seobythesea.com 01 May '13, 9pm

Somehow, in a Bill and Ted’s Excellent Adventure crossed with Michael Pollan’s Food Rules moment, I found myself typing ou...