This is the second part of my series of post on SEO documentation followed Pre SEO Site Analysis Report Template.
The result of a successful SEO campaign is often measured by conversions that generate through organic search results by keyword rankings and we inform the same through SEO ranking reports sent on a weekly/monthly/bi-monthly basis.
I have prepared a simple SEO keyword ranking report template using Excel which can be used to maintain the keyword ranking report from the month 1 onwards.
Click the below link to download
On reviewing the report you can find the details of ranking report for the major three search engines namely Google, Yahoo and Live. In the ranking section you will notice that I have split the details in to three separate columns for each month as Page, Position and Rank.
- Page: The search engine result page where your domain is ranking for the keyword.
- Position: The position at which the keyword is ranking within that page.
- Rank: The actual rank position for the keyword. I have used the below formula,
Rank = [(Page – 1) * n] + Position
where, n = maximum number of results per page
Ex: Page = 3, n=10, Position=5
Rank = 25
Note: The maximum search result per page is 10.
An important point that you need to add to the report is a disclaimer which explains the variation in the keyword rank position.