More on Using Excel to Plan Your On-Site SEO

SMS Text

This article is inspired by SEJ past post ” Use Excel to Plan Meta Tags, Titles and URLs for SEO” published by Loren Baker. It was really informative and useful, so I decided to do a follow-up with some more tips.

Add Separate Column for Your Primary Keyword: after doing keyword research with Wordtracker or Google Keyword Suggestion Tool you can select your primary (base) keyword for your particular page and put it in this column.

Add Separate Column for Your Secondary Keywords: after you’ve selected your primary keyword for a page, you should select secondary keywords for your page.

Add Column for Google Competition: check the competition of your primary and secondary keywords in Google. So you can get the basic idea of your keywords competition in Google

Why we should add the column of Primary Keywords, Secondary Keywords and Google Competition?

When writing meta tags, if you can see what your primary keyword and what your secondary keywords are, that will be easier for you to create a proper title and description. Besides, you can always evaluate your chances of getting to Google first page by seeing your Google competition for each phrase.

When is it best to use Excel for that?

Use it when introducing (global) changes to your site meta data: add more columns for Old Title, Old Description and Old Keywords.

If you are changing your title tags and descriptions throughout the site, you should add these columns to then evaluate your progress. (Note, these changes should be moderate of course, don’t introduce them in a bulk).

Use it when instructing your client:

Note: using Excel with all the data listed above and in the previous post is a good way to deal with the clients. This way you are likely to be safe from any misunderstandings.

Use it to keep track of your site performance:

Excel is the best way to store your data to get back later on and figure out what was changes when and what else can be done.

Now, if you have any idea what else we can add please feel free share it here in comments.

Subscribe to SEJ!
Get our weekly newsletter from SEJ's Founder Loren Baker about the latest news in the industry!
  • Joe

    Would you mind sharing your blank Excel file as a download link? Thanks!

  • Søgemaskineoptimering

    What about backlinks, pr, links, day, visit etc

  • Dharak Sandeep

    This Excel Sheet will be better and more important if we make new sheet named “”Link Back”. In this sheet we’ll make a list of back links, which been crawled by Google particular page of site. So, we can make record, that which links are permanent and which been deleted by Google in link collection.

  • seo

    it is very good idea. and it is importment.

  • J U Hasan

    In our office, we use Google Docs to keep track our SEO performance. I believe you can do little more – like put keywords in seperate and then track their performance in different columns. That will keep you busy in tweaking your performance for earch keyword.

    Anyway, thanks for bringing this up for everyone. Cheers!

  • Ewan Kennedy

    @ Gunjan,

    Like you, I create first column for primary keyword and secondary column for secondary keywords. I create a third column for the url with which the primary keyword is most closely associated ie targeted. Also, it makes the whole sheet much more manageable if you used filters so that you can view just the data you’re working on at that moment rather than scrolling up and down what are sometimes hundreds of rows of spreadsheet.

    I also, as you do, find it helps client relations because it is an easy way to communicate to them very large numbers of changes and why you have made them (eg using estimated search
    frequencies). It also helps them realise that doing SEO well is quite time consuming so gets the bills paid more quickly!

    @ Dharak

    Yes, I add another sheet to record backlinks so that I can track which ones I’m responsible for adding. It also allows me to follow up on those I’ve requested to see whether they’ve been added, declined or need following up.

  • Games

    Excel is a nice tool to view the statistic changes when you have more parameters to look at. But it is still not very clear about how to use this tool for tracking the site performance change. It will be great if we can see an example.

  • Gunjan Pandya

    @Dharak Sandeep
    @ AkbeForum

    This article is for to plan your On-Site SEO through Excel…

    Later on I will write an Article on to plan Off-Site SEO through Excel and in that article I will mention about Backlinks, PR etc.

  • 实验台

    it is very good idea. and it is importment.

  • 通风柜

    it is very good idea. and it is importment.

  • nike dunk

    good idea, got it.

  • website. designer in mumbai

    Thanks a lot …. this will really be very helpful and the matter of the fact is the whole content fall so smoothly at place …. make it very readable …. appreciate the effort.

  • 实验台

    Thanks a lot …. this will really be very helpful and the matter of the fact is the

  • 通风柜

  • Mike

    i used this same excel on my first client proposal & it worked great.

  • Terry Harmon

    Great post! I think I might alter some of my progress reports to use some of this information.