Template
On-Page SEO Template
Plan page-level fixes side by side: current and new titles, meta descriptions, headings, internal links and image alt text.
TemplateSpreadsheetBeginner
Description
Seeing the current and proposed versions next to each other makes on-page work easy to review and approve. Character guidance is built into the column names.
Use case
Use it when optimizing existing pages, launching new ones, or proposing changes for client approval.
Instructions
- Add one row per page and confirm its single target keyword.
- Copy the current title and meta description exactly as they appear in the page source.
- Write new versions that lead with the keyword and fit the length guides.
- Check there is exactly one H1 and that it matches the page topic.
- List internal links to add and any images missing alt text.
Preview
Column headers with example rows. Replace the examples with your client’s data.
Example rows use a fictional client. Replace them with real data from your tools.
| Row | Page URL | Target keyword | Current title | New title (50-60 characters) | Current meta description | New meta description (up to about 155 characters) | H1 | Internal links to add | Image alt fixes | Status |
|---|---|---|---|---|---|---|---|---|---|---|
| 2 | /teeth-whitening/ | teeth whitening denver | Services | Teeth Whitening in Denver | BrightSmile Dental | Professional teeth whitening in Denver. Brighter results in one visit with a free consultation. Book online today. | Teeth Whitening in Denver | From /cosmetic-dentistry/ and /pricing/ | 3 before/after photos need alt text | Proposed |
Download
A CSV file that opens in Google Sheets, Excel or Numbers. Keep the header row, delete the example rows and add your own.
Download template (CSV)SOPs that use this template
- SOP SOP: On-Page Optimization The step-by-step routine for optimizing a single page, from title tag to internal links.
Practice with it
- Assignment Write meta titles and descriptions for a dental clinic Rewrite the title tags and meta descriptions for three service pages so they match search intent…
- Assignment Fix the heading structure on a service page A cleaning company’s service page uses headings for styling. Restructure them so they make sense to…
My notes
Keep private notes next to anything you read or practice.
Log in to take notes