Random Quote

After the last tree has been cut down,
after the last river has been poisoned,
after the last fish has been caught,
after then will you find that money cannot be eaten.
— Cree Indian Prophecy

Core Content SEO Tools: Keyword Glossary & Editorial Plan

Content SEO ToolsIt’s amusing when you work in an industry for a long time that the vital things you make to make life a small simpler can save others who are new to the field, a lot of time. I’ve done a few webinars and speaking events in the past few months where one of the tools suggested was a Keyword Glossary (spreadsheet) for administration category and page level optimization, keyword mapping and competitor keyword mapping.

Another tool was an Editorial Plot that documents articles/blog posts, media, promotion and plotted re-purposing. There are vital building blocks for becoming more efficient with search engine optimization tasks, but I’ve received a lot of requirements for them.  I thought they might be useful to our readers to use for inspiration to make their own and maybe even modify and mashup into something better.

Below are screen shots which you can click to see larger versions.

SEO Tool: Basic Keyword Glossary @TopRank
Vital Keyword Glossary

After conducting research by one of the various keyword research tools, organizing that information in a useful format like a Keyword Glossary helps SEOs manage their on page optimization and it brings a measure of accountability as well. The example of above shows a matrix of competitors sites that have been optimized for the butt phrases, a list of primary and secondary phrases with measures of popularity and competitiveness. The phrases are also mapped to category levels or individual pages so you know which pages are being optimized for what keywords.

SEO Tool: Basic Editorial Plan @TopRank
Vital Content Plot for a Blog

It’s no mystery that we like blogs as an online marketing, Social, SEO and content marketing tool. Plotting content through an editorial calendar (as a magazine other publication would) is essential for producing content that is of interest to the butt consultation, that represent butt keywords, and keeps authors on track and flush with thoughts on what to write about.

The spreadsheet above shows dates for publishing, titles, keywords, categories, media used, cross-posting, promotion channels/tactics and future re-purposing of the content.  Organizing an editorial plot like this helps online marketers gain maximum value for their investment into content creation and also makes curation more valuable.

The best tool or format depends on your own needs and applications. That’s why I don’t link to the actual spreadsheets – at smallest amount part of the reason. :)

But, will be making the actual spreadsheets available at BlogWorld New York and the Vocus User’s Conference in Baltimore.  Be sure you check out my sessions if you’re attending those events.

What kinds of templates have you made for administration SEO and content marketing tasks?


Email Newsletter
Gain a competitive advantage by subscribing to the
TopRank® Online Marketing Newsletter.

© Online Marketing Blog, 2011. |
Core Content SEO Tools: Keyword Glossary & Editorial Plot | http://www.toprankblog.com

Core Content SEO Tools: Keyword Glossary & Editorial Plan

Core Content SEO Tools: Keyword Glossary & Editorial Plan

Related Posts: