Using This SEO Template
This SEO Template will let you organize your website"s on-page SEO (search engine optimization). It will help you formulate a plan, make it easier to coordinate pages and keywords, and allow you to track both changes and results all in one place. To make this template easy to use, this cover sheet will break down how to use each section within the template, highlighting the nuances of the layout and while providing tips for to help you maximize your productivity using this template.
Column A: Content Type
The content type denotes the type of page you are working on. Is it your home page or an internal page? Is it a landing page or a blog post? A product page or a thank-you page? It"s important to note which page you are editing to keep track of how the edits relate to the overall mission of that page.
Column B: Current URL
The current URL is something that can be entered manually or exported from a site crawler report. HubSpot"s Page Performance tool (under Reports) allows you to export all indexed pages on your site. From that exported document, you can simply copy and paste the URLs. If you are not using HubSpot you can try using a free tool like Xenu"s link crawler (http://xenus-link-sleuth.en.softonic.com).
NOTE: You will inevitably have to do some sort of file clean up on this file import. In addition to the pages you want to review, most tools will export pages from your webiste that you may not want to optimize. Organize your template/spreadsheet by order of importance and focus on optimizing 5-10 pages a week based on the URL. This will allow you to pace yourself and use your time wisely on the road to optimization.
Column C: Current Page Title
The current page title is as simple as it sounds -- the current title of the page you have selected to optimize. Page titles can be exported with either tool mentioned above (in the "current URL" section).
Share This Template
Column E: Current Page Description
The current page description is a simple the description of your page. It is also commonly referred to as the page"s meta description. Page descriptions can be exported with either tool mentioned above (in the "current URL" section).
Column G: What"s the purpose of the page?
Define the overall goal of this page. This is something you will want to manually define (perhaps for each page or for a group of pages). Is it to provide product information, define a solution, serve as FAQ, promote an event? What"s the end goal? Has the content on this page delivered that purpose?
Column H: Who is the target audience?
On-page SEO starts with this key concept. Your target audience, or buyer persona, is the market for whom you are writing your content. If you don"t know who you are writing for, or who you are trying to attract through your SEO tactics, your content will be aimless. Clearly define which persona type each page targets.
Column J: Edit Date
Make a manual note of the date each time you edit a particular page. In the end you cannot edit all pages at once, so it is important to note when changes occurred -- especially if you have to report progress back to someone else, such as a boss or a client.
Column K: New Page Title
This is where the planning for your new SEO strategy begins. Manually note/plan new page titles for a particular page. The goal here is to lay out the purpose of the page without being redundant. Best practice for page titles is "Keyword | Keyword Variation." See an example on the optimization template.
Column L: Page Title Length
The length columns will make sure that you adhere to certain character limits. The recommended length for page titles is 70 characters. This temlate automatically calculates page length for you.
TIP: A quick and easy way to kick off your optimization project is to update all page titles longer than 70 characters.
Column L: New Page Description
Enter your new page description. Descriptions should be one short, declarative sentence that incorporates your keyword -- which you laid it out in your page title -- in some form. The page content should not just repeat verbatim the content you have it on the page itself.
Column N: Page Description Length
The length columns will make sure that you adhere to certain character limits. This will automatically be calculated for you. The recommended length for page titles is 150 characters.
Column O: Target Keyword
Think of