Hopefully you know what a spreadsheet is, basically it looks like a big grid and is USUALLY used for tracking financial data. Over the years and with a lot of help from big companies, spreadsheets have evolved to be useful for more than just numbers. They are great for keeping things organized as it is very easy to add and remove columns of data and sort data by just about anything. What we are going to use it for is tracking our keywords.What we are going to use a spreadsheet for is to:

  1. Track what keywords we use

  2. What they link to

  3. How many links we have TO them

  4. Whether we have articles written for them

  5. Pictures and Media for the keyword?

  6. What social bookmarking have we done

These are just the basics, once you get going you might find other metrics you want to keep track of. With a spreadsheet, you simply need to add a new column and you can start adding in the new data. As well, if you find new keywords it is very easy to add them to your list!

Let's look at an example...
Like This 34
Previous Page
Next Page


Join the Discussion
Write something…
Recent messages
grit Premium
Excellent article series. I learned a lot. I think I'm going to implement this strategy. Thanks.
Reply
gooph Premium
Great idea! Thanks for the tutorial. I'm sure it will keep me organized.
Reply
tport144 Premium
For a second there I thought you describing one of my campaigns! This is a great idea for keeping things organized and a great tutorial! I plan to start using Excel to get organized immediately! I use Excel daily at my "day job" and it never occured to me to use it for my projects.
Reply
jchilders Premium
Yeah, I typically think of 'numbers' when I hear Excel. But it's pretty useful for organizing any type of data. If you are better at Excel, I'm sure you can come up with some pretty snazzy forms. My template was pretty quick and dirty, but it gets the job done. :)
Reply
Leatnel Premium
Jon, this sounds like the ideal way to keep your keywords organized! I'm just getting started, again (long story), but my niche has soooo many aspects and thus, many keywords. I already have two documents of keywords, and a bunch written in my notebook. What better time to start organizing them, but at the beginning. I have a little bit of Excel experience, and plan on setting up a template right away.
Thank you very much for this tutorial. It was very helpful.

Leata
Reply
jchilders Premium
Yes, this could definitely help focus on different aspects. You could easily sort your keywords and group them together by 'sub-niche', then tie them all together back to you main niche.
Reply
Deezdz Premium
Great tutorial on staying organized Jon! I have different files in different places for all different campaigns...I haven't found a system yet but this seem like a great template to organize everything.
Reply
jchilders Premium
If you want to keep everything in one place, you could use different 'sheets' within a single Excel document. One for each campaign.

If you do use a single file for everything, I would definitely keep updated copies in different places though, just in case one gets 'lost'. (recently had a harddrive die without warning and lost a bunch of stuff)
Reply
Top