Posted by randfish
You've got content on your site that doesn't intentionally target any keyword. But how do you identify those opportunities and, most importantly, capitalize on them?
Howdy, Moz fans, and welcome to another edition of Whiteboard Friday. This week we're going to chat about building a killer content-to-keyword map. Now this is something that pretty much every SEO does when they do an audit of a site, whether that's in-house or as a contractor or an agency consultant.
So what I've done here is build out a big one, but actually this is not as fully featured as you might imagine some content-to-keyword maps can be. I've seen them with double the number of columns of these, and I'm sure plenty of you who are watching are saying, "Oh man, Rand, I have even more in my map."
Usually this is done in Excel or it's done in Google Spreadsheets. Either one can work fine. Unfortunately, there's no great software to do this right now. You could use a tool like Moz or a tool, if you're on the enterprise side, like Searchmetrics or Conductor to get a lot of this data. You may pull the data from tons of different places, a Screaming Frog here or a Stat over there, whatever it is, OnPage.org.
But what you're trying to build here is essentially all my keywords mapped to all my URLs. Sometimes you might . . . in fact, if you're doing a comprehensive job, you should find places where you don't have a URL for some keywords because some keywords haven't been targeted yet, but you still want to rank for them. You should probably have some URLs for which you have no keyword. Essentially you haven't intentionally targeted a keyword with that page yet, and this might actually help you prioritize and try and do some of that.
Then you have things like: How much search volume does this get? You're going to try and estimate or use a tool to give you a grade around the title, the content, maybe the URL itself, load speed, and engagement. Engagement could be browse rate or time on site or pages per visit or some combination of all of those things.
You might be looking at internal and external links to the page. Internal links to say, "How well linked to is it internally? Do I have opportunity there?" External links to say, "Am I ranking or not ranking because I don't have external links pointing here?"
I might look at something like a page authority to try and roll those up, Google Desktop and Google Mobile rankings, and the organic visits that that page has received from search engines.
Now, there are a lot more columns that you might consider adding. You could add things like:
You might have more keyword-driven metrics if you're trying to prioritize a big keyword research function, like the things in Keyword Explorer:
Proceed to the route
So now you've got this big content-to-keyword map. "Rand, why am I building this?" Well, look, this map lets you do a bunch of incredibly important, critical things, like:
If you have great ideas or you've done great things inside your content-to-keyword maps, I would love to see them. Please, leave them in the comments. Feel free to link to things. Show off your maps if you feel like uploading them. I would love to see the see columns and the ways that you use this map. Hopefully, in the future, maybe I can convince the Moz Pro software guys to build this for you. ;-)
All right, everyone, take care. We'll see you again next week for another edition of Whiteboard Friday.
Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!
via The Moz Blog http://tracking.feedpress.it/link/9375/4127357