Guide
The templates for this are in the Lead Site Crew Kit ($39). Setup files, not results.
Most tracking templates assume you already have traffic, rankings and a tenant. A new rank and rent site has none of those for months. If you only watch "rank" and "rent", the sheet stays empty and you can't tell whether to keep going, change something, or drop the market.
Log what you can actually see each week, and decide once a month. Here's a simple sheet you can copy.
Tab 1: Weekly log (one row per site per week)
| Week of | Site | Pages in sitemap | Pages indexed (GSC) | Impressions (7 days) | Clicks (7 days) | Calls ≥90s | Form leads | What shipped | Note |
|---|---|---|---|---|---|---|---|---|---|
| 2026-10-05 | example-septic.com (illustrative) | 32 | 0 | 0 | 0 | 0 | 0 | Launch, sitemap submitted | |
| 2026-10-12 | example-septic.com (illustrative) | 54 | 3 | 12 | 0 | 0 | 0 | 22 area pages added | First impressions |
Where each number comes from:
- Pages in sitemap: count the <loc> lines in your live sitemap. It confirms that what you think is deployed actually is.
- Pages indexed: Search Console → Indexing → Pages → "Indexed".
- Impressions / clicks: Search Console → Performance, last 7 days.
- Calls ≥90s and form leads: from your call tracking and form inbox. Use one fixed definition of a "real" call and never change it mid-way, or the trend means nothing.
- What shipped: one line. Without it, a jump in impressions can't be tied to anything.
Tab 2: Monthly scoreboard (formulas over the log)
Assuming the log has Week of in A, Site in B, impressions in E and calls in G, and the scoreboard has the site name in B2:
Impressions this month (C2): =SUMIFS(Log!E:E,Log!B:B,B2,Log!A:A,">="&EOMONTH(TODAY(),-1)+1)
Impressions last month (D2): =SUMIFS(Log!E:E,Log!B:B,B2,Log!A:A,">="&EOMONTH(TODAY(),-2)+1,Log!A:A,"<="&EOMONTH(TODAY(),-1))
Change vs last month (E2): =IFERROR(C2/D2-1,"n/a")
Calls this month: =SUMIFS(Log!G:G,Log!B:B,B2,Log!A:A,">="&EOMONTH(TODAY(),-1)+1)
Convention: each weekly row counts toward the month its "Week of" date falls in, even if the week runs into the next month. Keep it consistent and the trend still holds.
| Month | Site | Indexed (end) | Impressions | Clicks | Real calls | Forms | Fixes shipped | Decision |
|---|---|---|---|---|---|---|---|---|
| Oct 2026 | example-septic.com (illustrative) | 3 | 12 | 0 | 0 | 0 | 2 | Keep: indexing started |
Tab 3: Decision rules (write them down before you need them)
Pick your own thresholds, but set them in advance so a bad week doesn't make the decision for you. Example:
| Signal after… | If this is true | Then |
|---|---|---|
| 4 weeks | Indexed pages = 0 | Check robots.txt, sitemap and canonicals before writing more content |
| 3 months | Impressions growing, clicks 0 | Rewrite titles and meta descriptions on the pages getting impressions |
| 3 months | Impressions flat near 0 | Check the pages are actually indexed (Search Console → Pages), then re-check the market teardown: is the competition stronger than you scored it? |
| Any time | ≥ [your number, e.g. 3] real calls in a month | Start a renter shortlist, with the call log as your only proof |
Some sites never rank, and the sheet is how you find that out cheaply.
The 15-minute weekly review
- Fill in one row per site (5 minutes).
- Compare it with last week. If something moved, find the matching "What shipped" entry.
- Choose one fix for next week and write it down.
- On the first of the month, fill in the scoreboard and the Decision column.
When this is enough
For one or two sites, this sheet and Search Console are all you need. Paid rank trackers make more sense once you have several sites and keywords worth watching daily.