If you track search engine rankings and send reports to clients every month, a good way to present this information in a monthly report is to create an Excel sheet with historical data of your rankings charting your progress from when their campaign began to the present date.
Keyword Checking Tools like RankTracker is good for giving you an indication of whether your search terms have gone up or down. But if you check your rankings often, have many keywords and track both local and global versions of Bing, Yahoo as well as Google, the final published report will be quite long. Often you (or a client) will have to trawl through pages and pages of data before finding the data they require that month.
Using Conditional Formatting in Excel, creating a simple chart to track whether you have made a positive or negative impression in the SERPs is made really simple. All you need to do is set up your keywords when the
