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?
In today’s Whiteboard Friday, Rand illustrates the process of creating your own content-to-keyword map to discover where to optimize, what content to build, and how to intelligently target keywords when you’re auditing a site.
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.
What we’re trying to get here is a picture of: Here are all the keywords that we’re trying to target. Here’s all the content that we have, and maybe we have keywords for all of that content. Maybe some of that content doesn’t have a keyword, those kinds of things. We’re trying to map these together so that we know what needs optimization, what new content needs to be built, what keywords need to be targeted to fit with which content, all of these types of things. This is how we identify the priorities and work that an SEO should be doing as they’re attacking a new site, attacking a new campaign.
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:
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. 😉