As I mentioned at the beginning, I started using this system to help keep myself organized and heading in the right direction. If I don't have some sort of systematic steps to follow, I will get distracted and my sites and my readers will suffer.

It's a shortcoming I have but at least I am aware of it and can try to do something about it. Maybe you have similar issues or are just so busy that you lose track of where you are in each project.

Using this spreadsheet...

  • Allows you to keep track of your targeted keywords
  • Gives you easy access to your page links
  • Helps you spread your internal linking around to all your pages
  • Let's you track the progress of your site building
  • Let's you easily assign and track outsourced writing efforts

If the template we went over is not exactly what you need for your business, you have the flexibility to add or remove anything you need to make it fit. That's the great thing about IM. There are so many different ways to accomplish the same tasks. What works for me may not be perfect for you, but you can adapt the idea and make it your own.

If you have any questions or suggestions as to something I forgot in this training module, please feel free to contact me on WA. Thank you for reading and best of luck on your IM efforts!
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