Hopefully the picture above comes through ok, I'll figure something else out if not. But that is a basic template I use to track keywords.You can see the column titles are the metrics I mentioned on the previous page. As I write each article and publish it, I fill in the columns with a 'Y' so I'll know it's done.If you have a more involved system of publishing your articles, you could use submitted date, scheduled publish date, anything you want really. What I am showing is just some basics to get you started. You will need to adapt them to your own style and use what works for you.
Define The Headers
If you notice, the top row is in bold type and contains the metrics we want to track. As you get more and more keywords, this row will eventually scroll off the screen as you move down which can make it hard to remember what goes where.I am using Google Documents to store my spreadsheet and it has a way you can define header rows so that they will always stay on the screen as you scroll.
What you will need to do is:
- Click 'View'
- Select 'Freeze Rows'
- Select the number of rows you want to use as headers, usually 1
This will 'freeze' however many rows you selected and keep them on the screen at all times.Now that we have the basic sheet setup, let's look at the metrics I mentioned and why they would be important.
Reply
Thank you very much for this tutorial. It was very helpful.
Leata
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)
