Making Google Look Smart – The Sustainable SEO Strategy

Making Google Look Smart – The Sustainable SEO Strategy

*Note from John – This is a guest post by Matt Gratt, who recently struck out on his own to follow his dream of being an entrepreneur. Matt is someone I’ve respected for a while, so it’s a pleasure to have him guest post here! You can find him on his blog, Twitter, or Google+.

While you can’t put glasses on a search engine, you can make it look smart.

This was an eventful couple of months in SEO – BuildMyRank and other blog networks were de-indexed and shut down. Google began sending webmasters warnings of negative links. And expert SEOs have reported that major aspects of anchor text weight have changed.

So what does all of this mean? And more importantly, how can SEOs continue to deliver the traffic, sales, and ROI that clients expect and businesses need in this time of unprecedented change?

We need a sustainable strategy – not a series of escalating tactics. And the  sustainable strategy is very simple…

Make Google look smart.

Make Bing look smart.

Make whatever panopticon of vertical search engines, semantic text crawlers, Siri-like smart agents, and social decision engines the future brings look smart. Read more about Making Google Look Smart – The Sustainable SEO Strategy

Explode your Keyword List for Linkbuilding Magic

Explode your Keyword List for Linkbuilding Magic

You know what’s better than ranking for your head terms? Ranking for your head terms plus the longtail variations of those terms that can also drive great traffic. Once you get outside of the head term fixation, you realize that incredible value exists in the longtail of keywords. In fact, over 80% of queries are considered “longtail”, according to this graph:

What I am going to do today is show you how to blow out your keyword list using tools like UberSuggest and Soovle so that you can identify the terms around your head terms so that you can create content and build links to your site using all of the related terms, still rank for your head terms, AND capture the longtail traffic!

Read more about Explode your Keyword List for Linkbuilding Magic

Competitor Link Prospecting in Microsoft Excel

Competitor Link Prospecting in Microsoft Excel

You all know I’m a big fan of Microsoft Excel, and I love building Excel templates that help you do your work better. You’re in luck, because today I’m releasing to you an Excel template that I love.

I call this one the Competitor Backlink Prospector. Now, SEOmoz has the Labs Competitive Link Finder, but this tool has never quite worked the way I’ve wanted it to. So, I took it upon myself (inspired by my old coworker Ethan Lyon, who is now at SEER) to create this spreadsheet. Read more about Competitor Link Prospecting in Microsoft Excel

The Difference Between Winners and Losers

The Difference Between Winners and Losers

Do you cringe when someone says “I could have done that”? Whether it is a blog post, a new startup, or a piece of modern art, people say it all the time.

I have come to realize that there are two kinds of people – those who do and those who say they could. Those who win are the doers and those who don’t never move into the realm of the unknown and thus keep saying “I could have done that.”

The point is, you didn’t.

What separates the doers from the could-have-dones? There are a few key characteristics, which funny enough are the same characteristics that I often see being written about as characterisitcs of entrepreneurs. Read more about The Difference Between Winners and Losers

Content Marketing Webinar Video

Content Marketing Webinar Video

A couple of weeks ago, I had the pleasure of doing a webinar entitled “A Guide to Content Marketing” alongside Greg from Zemanta. During the hour-long session, we sought to give tips and tricks about content marketing for everyone from a small business operator to professional SEOs listening in as well.

My favorite tip, one that I use frequently, is the value of having a place where you can store ideas as soon as they arrive. Often, ideas that go into your idea-holder will not see the light of day, but some are good enough to be expounded upon further and then written to the point of publishing.

Read more about Content Marketing Webinar Video

Eight Useful Excel Functions for SEO

Eight Useful Excel Functions for SEO

It’s probably not a secret anymore that I love Microsoft Excel for data crunching. Nothing makes me happier than getting a whole mess of data and making sense of it. While I’m definitely not an Excel ninja on the level of Mike Pantoliano, I’ve learned a number of tricks in the past couple of years to help out a lot with my work. Whether it’s keyword research, building a sitemap, or cleaning up URLs and finding duplicates in rows, here are eight of my favorite Excel functions that make my life easier every day.

For all of these, the data is in cell A1, unless otherwise noted.

Stick these in your list of functions!
Read more about Eight Useful Excel Functions for SEO