How to Keep Your SEO Efforts Organized with a Content Inventory Spreadsheet

How to Keep Your SEO Efforts Organized with a Content Inventory Spreadsheet

Most people who have read my writing know that I have a good deal of knowledge about SEO. I have learned that having an inventory of all your content can be very helpful to a company’s SEO efforts. A content inventory is basically just a spreadsheet where you log all of the content written for your company. It does not matter if this content came in the form of a podcast, infographic, or traditional article; you log the information onto a spreadsheet. There are several different pieces of information that you may want to make note of in your spreadsheet: 

  • Title of the page
  • URL
  • Keywords used
  • Description of the article

An inventory of all of your content is designed to help you stay organized and improve your SEO efforts. Although all of these categories may seem like a lot of work, I can assure you that the benefits far outweigh the few minutes spent updating this sheet. I know that as a writer, I absolutely love knowing where all of our content is at all times. This works especially great when you have an SEO team working to create content and improve SEO. It helps communication and it keeps you, the business owner, in the loop.

How to Set Up a Content Spreadsheet

There are a few things that I would keep in mind when it comes to creating this spreadsheet and then using it to improve your SEO:

  1. Google Docs – I would highly recommend using Google docs to set up your content inventory because it updates in real-time. Everyone can have access to the spreadsheet and it is always readily available when an employee is logged into his/her Gmail account. This makes it easy for one employee to pop over and see what the other employee is doing. This helps ensure that two people are not going to guest post on the same website or write about the same topic for the company website. 
  2. Analyze Keywords – When it comes to helping improve your SEO efforts, it’s important you analyze the keywords that you’ve used. This goes for both the articles on your own website as well as guest posting. In many cases, it actually helps to have separate logs for the two different types of content. You will want to look at the keywords you were targeting and see which content did well, which keywords seemed to get the most attention, and which websites you may not want to post for again. 
  3. Make Changes – Once you have all of your content and the keywords you used laid out in one spreadsheet, you can start deciding if you should delete pages that did not perform. You also want to look at the pages that did perform well and see if you can figure out a pattern or optimize the pages further. 

I have been using a content inventory spreadsheet since I began this career over ten years ago, and I can tell that it directly affects the way that we approach SEO. Our team looks at this spreadsheet monthly to determine the type of content that does well on our site and the keywords that have gotten a lot of attention. Aside from only SEO advantages, a content inventory makes it easy to hold employees accountable for their work. 

Have you ever used a content inventory spreadsheet before? Did you find that it helped make your SEO efforts easier?