• Skip to main content
  • Skip to primary sidebar
Foxxr Digital Marketing - Capitola CA
Top Rated in Google
BBB A Plus Accredited
(727) 379-2207
Menu
  • ABOUT
      • Social Media Marketing Social
      • Reviews Reviews
      • Room Rentals Customer Success Stories
  • SERVICES
    • Local SEO Packages Local SEO
    • Web Design Web Design
    • Paid Search Paid Search Marketing
    • Content Marketing Content Marketing
    • Link Building Link Building
    • Email Marketing Email Marketing
    • Social Media Marketing Social Media Marketing
    • SEO and Internet Marketing SEO
    • Video Marketing Video Marketing
    • Website Maintenance Website Maintenance
    • Local SEO Packages Foxxr Marketing Analytics
  • PRICING
    • Local SEO Packages Local SEO Packages
    • Web Design Website Design Packages
    • Social Media Marketing Yext Powerlistings
    • Web hosting Web Hosting
    • Reviews Reputation Management
    • Website Maintenance Website Maintenance
  • RESOURCES
    • Website Maintenance Free Website Audit
    • SEO and Internet Marketing Free Local SEO Audit
    • Social Media Marketing Free PowerListing Scan
    • Content Marketing Marketing eGuides
    • Video Marketing Video Gallery
  • BLOG
  • CONTACT
  • HELP
  • LOGIN

How to Organize Keywords

January 28, 2013 by Brian Childers

organize-keywords Organizing keywords and keyword distribution to specific pages and posts on your website is an important step in the content creation process. It helps us align the content to relevant to the keywords that you’re targeting.

The Yoast SEO plugin for WordPress does a great job of providing a snapshot of your page summary view,  but for many of your target keywords, you won’t yet have a page and you’ll need to create one. By using a spreadsheet you can easily see where in your site’s architecture you’ll want to put it, and define key information about it before you start writing.

I have found that keeping track of your keywords in Excel or a Google spreadsheet in a structured way helps you with your content development strategy. It also helps you document which pages are targeting which keywords to refer back to in the future.

Google Spreadsheet or Excel works well

I use Google spreadsheet to outline my keyword research and keyword strategies for content generation.  Once the initial keyword research is complete, I’ll export these keywords into the spreadsheet (after sorting by volume highest to lowest and competition lowest to highest). This is a method for local search Foxxr has found to be successful, but national search involves a more detailed method using more long tail keywords.

On this spreadsheeet,   I created a column for the list of keywords we’ll be targeting, the URL of the page, the title tag, the meta description, the meta keywords (some directories still use meta keywords, so I decided to include these). I also added the character count function so that I can see how close we are to our general targets. The targets are 70 characters for a title and 165 characters for a description per the Yoast SEO plugin. These are  guidelines that will avoid search engines truncating this information on the search engine results page.

Match keywords to your pages and posts

The first step in organizing keywords is to populate the spreadsheet with your existing web pages. The search engines want to see unique information for each and every page, creating a list of keywords here is a good way to quickly spot any duplications. Then take a look at the keywords from your keyword list and find the most appropriate pages of your site for each of the keywords.

You should make sure to distribute one keyword per page and try not to force anything. Search engines prefer unique and relevant content. So if you have a keyword that doesn’t match any page of your site, you’ll want to create a new page. When you add a new page to your spreadsheet, the good news is that you’ve got a blank canvas. You can define the SEO-friendly URL, title, description, and header right here in the spreadsheet.

The meat is in the body

Writing content when you know the how to organize keywords and create a list of keywords you’re optimizing it for upfront allows you to really dial-in on all of the best practices of content writing for keywords that you are covering. Remember, the meat of each page is the body copy (about 300 words), and you’ll probably need to go back through your existing pages to make sure that they’re really optimized for the keyword you’ve defined as a target.

The Yoast SEO plugin has a great on-page analysis tool. Another great tool that you have to pay a monthly subscription for is Scribe by Copy Blogger.

The suggestions from these tools can really help guide the changes you’ll be making to your pages.

Organizing your list of keywords on a spreadsheet will help you in a number of different ways.

  • It gives you one place to organize and document the content of your site that will support the keywords that you’re targeting.
  • It serves as an excellent resource for your copywriters, and will help streamline workflows.
  • As a Google spreadsheet, it acts as a collaboration tool that can be updated in real time across all team members.
  • It  keeps your content strategy on track.

At Foxxr, we track organize our client’s keywords on a collaborative Google Web Development Workbook.

how to organize keywords

Related Posts

  • winning-seo-customers Winning New Customers
  • The Local Search Ranking Factors for DummiesThe Local Search Ranking Factors for Dummies
  • writing-for-the-web Writing for the Web and 79% of Readers
  • Website-DesignWebsite Design or Functionality. Which Comes First?
  • Google Search Result Updates May Be Costing You Traffic and Revenue - CAGoogle Search Result Updates May Be Costing You Traffic and Revenue! Here’s What to Do
  • 9 Undeniable Benefits to Call Tracking9 Undeniable Benefits to Call Tracking

Filed Under: Featured on Home, OffPage SEO, SEO Tagged With: Google, List Of Keywords, Spreadsheet

About Brian Childers

Brian Childers is the Founder & CEO of Foxxr, a digital marketing agency based in St. Petersburg, Florida. Childers leads a team of digital marketing experts with specialties in; Web Design, Local & National SEO, Paid Search Management, Link Building, Content Marketing, and Social Media to help clients attract an insane amount leads and revenue.
Follow Brian on Twitter

Reader Interactions

Primary Sidebar

Social Media eGuide
Social Media eGuide
reCAPTCHA
Sending

Recent Posts

  • The Long and Arduous Epic Story of the Hero Image
  • How Much Does SEO Cost? 2019
  • How To Own Google’s Position Zero- ‘Featured Snippet’
  • Best Practices To Get Into The Knowledge Graph
  • The Fastest, Easiest Way to Create Email Marketing Campaigns

Tools and Resources

  • Free Local SEO Audit
  • Free Website Audit
  • Free Business Listings Scan
  • Referral Rewards
  • Marketing eGuides
  • Success Stories
  • Live Beach Cam
free-website-analysis3

Hot Resources

  • Free Local SEO Audit
  • Free Website Audit
  • Free Business Listings Scan
  • Referral Rewards
  • Marketing eGuides
  • Success Stories
  • Live Beach Cam

Popular Programs

  • Local SEO Services
  • Web Design
  • SEO Services
  • Email Marketing
  • Paid Search Marketing
  • Reputation Management
  • Content Marketing

Pricing

  • Local SEO Packages
  • Website Design Packages
  • Website Maintenance
  • Web Hosting
  • Yext Power Listings
  • Reputation Management
801 74th St. N.
Saint Petersburg, FL 33710
[email protected]
(727) 379-2207
(831) 531-7771
Hours:
Mo - Fr: 6:00 am - 6:00 pm

Tweet Tweet

Latest Tweets by @Foxxrinc
Google Partner
Paypal Verified Foxxr St. Petersburg
Top Rated in Google
Yext Partner
better-business-bureau-accredited-opt

Hot Resources

  • Free Local SEO Audit
  • Free Website Audit
  • Free Business Listings Scan
  • Referral Rewards
  • Marketing eGuides
  • Success Stories
  • Live Beach Cam

Popular Programs

  • Local SEO Services
  • Web Design
  • SEO Services
  • Email Marketing
  • Paid Search Marketing
  • Reputation Management
  • Content Marketing

Pricing

  • Local SEO Packages
  • Website Design Packages
  • Website Maintenance
  • Web Hosting
  • Yext Power Listings
  • Reputation Management

Connect with Us

801 74th St. N.
Saint Petersburg, FL 33710
[email protected]
(727) 379-2207
(831) 531-7771
Hours:
Mo - Fr: 6:00 am - 6:00 pm

© Copyright 2008 – 2019  Foxxr, Inc. · Privacy Policy · Site Map