SEO Reporting format create it in excel: 1st sheet: Index page: Monthly Report - 31, January- 2007 Table of Content Summary of Report View Details (hyper link with targeted excel sheet page) Ranking Report View Details (hyper link with targeted excel sheet page) Back Link Creation View Details (hyper link with targeted excel sheet page) Competition Analysis View Details (hyper link with targeted excel sheet page) Site Study View Details (hyper link with targeted excel sheet page) Directory Submission View Details (hyper link with targeted excel sheet page) Article Submission View Details (hyper link with targeted excel sheet page) 2nd sheet Report Summary Monthly Report - 31, January- 2007 Activates Status Site Study Done Squidoo Creation & Posting Done Blog Creation & Posting Done Back Link Report Done Content Creation Done Directory Submission Done Article Submission Done Competition Analysis Done Traffic Analysis Done Ranking Report Done Back to Index (hyper link with Index excel sheet) 3rdsheet Report Summary Monthly Report - 31, January- 2007 S.no. Link Page URL Link Page Rank 1. http://abcdotcom 5 2. http://www.efgdotcom 2 Back to Index (hyper link with Index excel sheet) 4th sheet Report Summary Monthly Report - 31, January- 2007 S.no. Finalized List of Keywords Google.com Yahoo.com Msn.com 1. Abcd 1 12 1 2. Efg 3 5 13 Back to Index (hyper link with Index excel sheet) 5th Sheet Report Summary Monthly Report - 31, January- 2007 Competition Analysis-October -2007 Checks www.xdotcom www.x1dotcom www.x2dotcom ww.x3dotcom Google Index 1020 474 877 1330 Yahoo Index 1393 665 1294 1364 MSN Index 7526 3292 6469 31249 Google Link (Search Query) 43 343 246 222 Yahoo Link (Search Query) 1012 3382 2203 2577 IP Address 66.18.102.199 66.179.248.24 12.186.34.40 Error Page Rank 5 6 6 Error Last Cached Homepage (G.) 5-Dem-07 4-Jan-08 5-Jan-08 3-Jan-08 Last Cached Homepage (Yahoo) Yes Yes Yes Yes Last Cached Homepage (MSN) 10/1/08 10/11/07 10/12/07 11/1/08 Robots.txt Yes Yes Yes No Dmoz Listing 0 2 1 0 Yahoo Directory Listing 0 5 4 0 Internal/External Link from H.p 24/2 44/6 32/13 13/107 H1 Tag abcl xyz N/A N/A Title Tag AB |.. |.. abc - ccc abce, abc xyz| yxz Back to Index (hyper link with Index excel sheet) 6th Sheet Report Summary Monthly Report - 31, January- 2007 Site Study- December-2007 Checks Explanation in Brief Google Index 324 Yahoo Index 568 MSN Index 340 Google Internal Link (Webmaster Tool) 1575 Google External Link (Webmaster Tool) 518 Yahoo Link 1951 Penalty Check no Page Rank 3 Last Indexed (Homepage) 2-Jan-08 Average Crawl Rate (Webmaster Tool) 42 Server Header Check 200 OK 404 Page Check (Webmaster Tool) 0 Canonical Issue Yes Invisible Text No Copyscape Check (Homepage & All Article Page Created for Past Month) NO Domain Expiry Date 31-Jul-08 W3C Validator Failed validation, 3 Errors Back to Index (hyper link with Index excel sheet) 6th Sheet Report Summary Monthly Report - 31, January- 2007 Content Used For Submission Title: ABCD Description this website is ………… URL http://www.abcdotcom/abc/xyz/index.php S.no. Directory Resource URL 1. Back to Index (hyper link with Index excel sheet) Monthly Report - 15, October- 2007 \ Content Used For Submission Description: The…………… URL http://www.abcdotcom/oal-courses.php S.no. Article Resource URL 1 abcdotcom 2 efgdotcom Back to Index (hyper link with Index excel sheet) Like that you have to add more resources This is my first approach to create a report format for our seo client Any suggestion most welcome.
Nice format of report but I want to include some important parts into it. Here one more column thats is Title or Anchor text of the back links would be add. One more tab about Gain/Loss would be added. Here you will show the difference of the keyword position before SEO and after SEO