B2B Marketing Blog - TopRank®

B2B Marketing views, news and interviews.

Contact Us

MENUMENU
  • Services
    • Influencer
      • Start Your B2B Influencer Pilot
    • Content
    • Search
  • Insights
    • Blog
    • News
    • Resources
  • Our Work
    • B2B Technology
    • IT Service Management
    • Project Management Software
    • Social Networks
    • Supply Chain
  • About Us
    • Meet the Team
    • Careers
  • Connect

Core Content SEO Tools: Keyword Glossary & Editorial Plan

Lee Odden
Lee Odden
Blogging Strategy, Content Marketing, Online Marketing, SEO, SEO Tools

Content SEO ToolsIt’s funny when you work in an industry for a long time that the basic things you create to make life a little easier 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 managing category and page level optimization, keyword mapping and competitor keyword mapping.

Another tool was an Editorial Plan that documents articles/blog posts, media, promotion and planned re-purposing. There are basic building blocks for becoming more efficient with search engine optimization tasks, but I’ve received a lot of requests for them.  I thought they might be useful to our readers to use for inspiration to create 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
Basic Keyword Glossary

After conducting research using 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 target 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
Basic Content Plan for a Blog

It’s no mystery that we like blogs as an online marketing, Social, SEO and content marketing tool. Planning content through an editorial calendar (as a magazine other publication would) is essential for producing content that is of interest to the target audience, that represent target keywords, and keeps authors on track and flush with ideas 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 plan 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 least part of the reason. 🙂

However, will be making the actual spreadsheets available at BlogWorld New York.  Be sure you check out my sessions if you’re attending those events.

What kinds of templates have you created for managing SEO and content marketing tasks?

About Lee Odden

@LeeOdden is the CEO of TopRank Marketing and editor of TopRank's B2B Marketing Blog. Cited for his expertise by The Economist, Forbes and the Wall Street Journal, he's the author of the book Optimize and presents internationally on B2B marketing topics including content, search, social media and influencer marketing. When not at conferences, consulting, or working with his talented team, he's likely running, traveling or cooking up something new.

Comments

  1. Anonymous says

    May 18, 2011 at 7:15 am

    Wow! Love the keyword glossary, thank you, Lee. The other nice thing about the editorial plan is that you can share what is upcoming (on your blog or in your email newsletter). We will be doing that soon at Spin Sucks.
    I hope we have the chance to meet at Blogworld.
    Lisa

    • leeodden says

      May 18, 2011 at 11:13 am

      Thanks Lisa, great tip on the editorial plan. Previews work well in TV, radio and other media, why not blogs? Definitely looking forward to Blogworld – see you there. 🙂

  2. Shonali Burke says

    May 18, 2011 at 8:32 am

     Ooh, this is great, Lee, thank you! I hope we can connect at BWE too, it would be great to see you again.

    • leeodden says

      May 18, 2011 at 10:52 am

      Glad you like Shonali. We have many more templates and tools in store 🙂 I’ll definitely see you next week.

  3. Anonymous says

    May 18, 2011 at 7:10 pm

    I like the way you set up and organized your spreadsheets. I find that  my clients have a hard time keeping track of their SEO efforts unless they set up a chart they can read and follow. It’s a great idea!

  4. Ian Harte says

    May 19, 2011 at 4:32 am

     Spreadsheet = number 1 tool in any SEO campaign! 

  5. Tamara Gruber says

    May 19, 2011 at 10:01 am

     Cool, glad to see the small-time hack spreadsheets I’ve created when writing web content aren’t too far off from the professionals.

  6. Emma Coakes says

    May 22, 2011 at 1:47 pm

    I’m doing a lot of this but this gives me ideas to raise the game a couple of levels. Thanks for sharing. Do you find that trends and stories come along that force you to change your plan? Four weeks forward planning seems like a long time.

    • leeodden says

      May 23, 2011 at 9:48 am

      Yes, we allow for wildcards. Overall, we like to have a content plan for 6 months out at a general level and add specifics as we go – but always allowing for things that might “pop up”.

LET’S GET SOCIAL

RSS Feed Twitter Facebook LinkedIn Marketing with Intent: The Future of SEO & B2B Search Traffic 2022 B2B Influencer Marketing Research Report Elevate B2B Marketing Podcast

Learn about:

B2B Ignite USA 2023

SUBSCRIBE        

TOPRANK BLOGGING TEAM

TopRank Marketing Blogging Team

 

Optimize

RECOMMENDED RESOURCES

SEO Blogs

MARKETING BLOG RECOGNITION

CMI

Copyright © 2023 · TopRank Marketing

Return to top of page