- May 2, 2010
- 9,939
- 16,038
In column F (Average position), put the average position in serprobot or another tracker; not sure how easy that is, but in serprobot, it's just a number that is an average number of keywords calculated with rankings of those keywords and is displayed on your site's dashboard.
In the % improvement, because 60 is better than 100, you have to use the sum:
Code:
=((F4-M4)/F4)*100That code would be for the 10-day check and would go in column N (% improvement)
Just fill it in each time you make a change, the date, the site, the variable you are testing, adding an article, removing all tags, changing jpgs to webp, pbn links, whatever change it is.
Take the average day's positions as a record, and make assumptions about what you think will happen.
After each day (it doesn't have to be the time scale I used), you can use whatever, 3, 7, 14 days, and fill in the ranking from your tracker.
It's important that you give time for changes to occur and monitor them before layering on any more changes; however, if you have something similar, you'll notice that rankings mostly always go up generally when new content is published. It's great to see by how much, though, with a history tracker. It's important to be regular with the updates, too. And don't just skip writing an update because you are lazy. You need this data to help you, so it should be classified as crucial in your work.
If you are looking for a job in SEO, having evidence like this and showing your portfolio of work will get you at least in the door.