A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Landing Page | Recommendation | [Your Company] Notes | Google Doc Draft | Targeted Keywords | [Your Company] Status | [Client] Status | [Client] Notes | Impressions | Clicks | CTR | Average Position | Sessions | Pages / Session | Pageviews | % Organic Visits | Avg. Time on Site | % Exit Rate | [Goal #1] | [Goal #2] | Transactions | Revenue | # Ranking Keywords | Top Keyword | Search Volume | Google Rank | Page Value | Date Published | Last Mod Date | Author | Word Count | # Internal Links | # Inbound Links | Title Tag | # Len | Meta Description | # Len | H1 Tag | Canonical Tag | |
2 | This column will include a list of all of page URLs on the website, which can be exported from Screaming Frog. | This will provide your next step recommendations. | This will include reasoning behind your next step recommendations. | This contains URLs to the Google Docs where SEO recs can be made. | This lists the targeted keywords for each page that we'll want to track. | This will provide you or your company's status. | This is where your client will update their status. | This is where your client can add their notes. | This will help to highlight online visibility using the last 12 full months of data from Google Search Console. | This will help to highlight website visits and engagement using the last 12 full months of data from Google Analytics. | This is where you'll document organic conversions and revenue using the last 12 full months of data from Google Analytics. | This can help with viewing at a high level the search intent, relevancy and visibility using data from Ahrefs. | This can help highlight content freshness using data from Screaming Frog. | This can help highlight internal and external promotion and visibility using GSC. | In some cases, having this information can be helpful to know how pages are currently optimized, if optimized, and if there are any interesting discoveries or potential hindrances. This information can be pulled using Screaming Frog. | |||||||||||||||||||||||||
3 | /blog/url-1 | No Change | This is a recently optimized article. We will continue to monitor the page and provide updates. | https://docs.google.com/document/d/example-google-doc-url-1/edit | [target keyword 1], [target keyword 2], etc. | Complete | Complete | Optimized in April. | 5,300,000 | 400,000 | 7.55% | 9.7 | 380,000 | 1.17 | 444,600 | 85.47% | 0:10:00 | 86.00% | 85 | 30 | 150 | $35,000.00 | 1,300 | [top keyword] | 53,000 | 6 | $15.00 | 8/1/2020 | 9/1/2020 | [Author name] | 800 | 10 | 0 | [Title tag #1] | 79 | [Meta description #1] | 158 | [H1 tag #1] | /blog/url-1 | |
4 | /blog/url-2 | Monitor | This is a recently published article that was also optimized. We will monitor and provide updates. | https://docs.google.com/document/d/example-google-doc-url-2/edit | [target keyword 1], [target keyword 2], etc. | Complete | Complete | Already optimized in April. | 2,000,000 | 200,000 | 10.00% | 8.5 | 200,000 | 1.14 | 228,000 | 87.72% | 0:10:00 | 88.00% | 1 | 11 | 0 | $0.00 | 1,400 | [top keyword] | 450 | 1 | $3.00 | 10/15/2020 | 10/15/2020 | [Author name] | 2,250 | 20 | 75 | [Title tag #2] | 74 | [Meta description #2] | 229 | [H1 tag #2] | /blog/url-2 | |
5 | /blog/url-3 | Update | Please confirm that the content is still accurate and add to the optimization queue. | https://docs.google.com/document/d/example-google-doc-url-3/edit | [target keyword 1], [target keyword 2], etc. | In Queue | In Queue | Scheduled for content review in September, then will add to SEO queue. | 3,500,000 | 140,000 | 4.00% | 7.3 | 160,000 | 1.22 | 195,200 | 81.97% | 0:08:00 | 82.00% | 48 | 23 | 0 | $25,000.00 | 1,000 | [top keyword] | 12,000 | 1 | $0.15 | 12/15/2016 | 9/1/2019 | [Author name] | 500 | 5 | 0 | [Title tag #3] | 62 | [Meta description #3] | 146 | [H1 tag #3] | /blog/url-3 | |
6 | /blog/url-4 | Update | Please confirm that the content is still accurate and add to the optimization queue. | https://docs.google.com/document/d/example-google-doc-url-4/edit | [target keyword 1], [target keyword 2], etc. | In Progress | In Progress | Content updated. Pending SEO recs and upload. | 3,500,000 | 140,000 | 4.00% | 17 | 150,000 | 1.16 | 174,000 | 86.21% | 0:09:00 | 85.00% | 53 | 10 | 0 | $0.00 | 1,600 | [top keyword] | 5,500 | 3 | $2.50 | 12/15/2016 | 9/1/2019 | [Author name] | 750 | 5 | 0 | [Title tag #4] | 71 | [Meta description #4] | 163 | [H1 tag #4] | /blog/url-4 | |
7 | /blog/url-5 | No Change | We have no recommendations for this page at this time. | https://docs.google.com/document/d/example-google-doc-url-5/edit | [target keyword 1], [target keyword 2], etc. | Complete | Complete | 2,500,000 | 110,000 | 4.40% | 20 | 116,000 | 1.15 | 133,400 | 86.96% | 0:11:00 | 88.00% | 43 | 9 | 0 | $0.00 | 1,100 | [top keyword] | 8,600 | 3 | $8.25 | 12/1/2016 | 11/15/2019 | [Author name] | 650 | 7 | 65 | [Title tag #5] | 70 | [Meta description #5] | 150 | [H1 tag #5] | /blog/url-5 | ||
8 | /blog/url-6 | Merge | This is duplicative of [URL] and has poor performance metrics. We suggest merging. | https://docs.google.com/document/d/example-google-doc-url-6/edit | [target keyword 1], [target keyword 2], etc. | Complete | Complete | Content merged in June. | 2,500,000 | 7,700 | 0.31% | 95 | 7,700 | 1.14 | 8,778 | 87.72% | 0:04:00 | 89.00% | 0 | 0 | 0 | $0.00 | 5 | [top keyword] | 5,600 | N/A | $0.00 | 3/15/2019 | 12/1/2019 | [Author name] | 1,300 | 5 | 35 | [Title tag #6] | 85 | [Meta description #6] | 204 | [H1 tag #6] | /blog/url-6 | |
9 | /blog/url-7 | Update | Please confirm that the content is still accurate and add to the optimization queue. | https://docs.google.com/document/d/example-google-doc-url-7/edit | [target keyword 1], [target keyword 2], etc. | In Queue | In Queue | Scheduled for content review in October. | 2,500,000 | 96,000 | 3.84% | 14 | 104,000 | 1.16 | 120,640 | 86.21% | 0:11:00 | 87.00% | 110 | 10 | 2 | $250.00 | 1,100 | [top keyword] | 6,000 | N/A | $0.00 | 12/15/2016 | 9/1/2018 | [Author name] | 850 | 5 | 0 | [Title tag #7] | 73 | [Meta description #7] | 163 | [H1 tag #7] | /blog/url-7 | |
10 | /blog/url-8 | Merge | This is duplicative of [URL] and has poor performance metrics. We suggest merging. | https://docs.google.com/document/d/example-google-doc-url-8/edit | [target keyword 1], [target keyword 2], etc. | In Progress | In Progress | Content currently in review. | 2,500,000 | 8,000 | 0.32% | 80 | 7,500 | 1.82 | 13,650 | 54.95% | 0:08:00 | 88.00% | 0 | 0 | 0 | $0.00 | 10 | [top keyword] | 1,200 | 2 | $0.00 | 9/15/2016 | 9/15/2019 | [Author name] | 1,000 | 15 | 0 | [Title tag #8] | 67 | [Meta description #8] | 155 | [H1 tag #8] | /blog/url-8 | |
11 | /blog/url-9 | Update | Please confirm that the content is still accurate and add to the optimization queue. | https://docs.google.com/document/d/example-google-doc-url-9/edit | [target keyword 1], [target keyword 2], etc. | In Queue | In Queue | Scheduled for content review in October, then will add to SEO queue. | 1,500,000 | 79,000 | 5.27% | 9.3 | 85,000 | 1.20 | 102,000 | 83.33% | 0:08:00 | 84.00% | 17 | 9 | 1 | $175.00 | 600 | [top keyword] | 1,900 | 4 | $3,500.00 | 12/1/2016 | 9/1/2018 | [Author name] | 500 | 5 | 0 | [Title tag #9] | 72 | [Meta description #9] | 146 | [H1 tag #9] | /blog/url-9 | |
12 | /blog/url-10 | Remove | This has a cross-canonical and has performed poorly. | N/A | N/A | Complete | Complete | Removed and redirect put in place in March. | 50 | 0 | 0.00% | 0 | 0 | 0.00 | 0 | #DIV/0! | 0 | N/A | 0 | 0 | 0 | $0.00 | 0 | [top keyword] | 8,100 | N/A | $0.00 | N/A | N/A | [Author name] | 300 | 0 | 0 | [Title tag #10] | 69 | [Meta description #10] | 203 | [H1 tag #10] | [cross-canonical-url] |