Guide 04

How to Build a Simple Weekly Rank Report

A 15-minute routine and a one-page template that turns Search Console numbers into a report you'll actually read.

A rank report doesn't need a dashboard. For a small site, one short page each week does the job: which keywords moved, by how much, and what you did that might explain it. Here's a routine that takes about fifteen minutes and a template you can copy.

Choose your keyword list once

Start with a short, stable list. Changing the list every week makes the report impossible to compare.

Good candidates:

  • Searches that describe what you sell or offer, in your customers' words ("emergency plumber Tulsa", not "residential plumbing solutions").
  • The main topic of each page you've put real work into.
  • Two or three searches that include your brand name, as a health check.
  • One or two "stretch" keywords you'd like to rank for but don't yet.

Open Search Console's Performance report, set the range to the last 3 months and look at the Queries tab sorted by impressions. Searches that already bring impressions are the best place to start, since Google already connects your site with them.

Aim for 10 to 25 keywords. Write down which page you want to rank for each one.

Fix the settings

Decide these once and keep them:

Setting Suggested choice
Day of the week Monday (covers the full previous week)
Date range Last 7 days, compared with the previous 7 days
Country The country most of your customers are in
Device All, unless more than about 70% of your visitors use one type
Search type Web
Source Search Console average position, not manual searches

Stick to one source. A manual check from your own laptop and a Search Console average measure different things, and mixing them creates fake movement.

The 15-minute routine

  1. Open Search Console, then Performance and Search results. Apply your date range, country and device.
  2. Note the week's totals: clicks, impressions and average position for the whole site. These go at the top of the report.
  3. For each keyword, add a Query filter (exact match or "contains", whichever you chose at the start) and note the average position. With the comparison on, you'll see the previous week's value too.
  4. Enter the numbers in your log. The Tweeted Ranks rank log stores them per keyword and draws the trend. A spreadsheet works just as well.
  5. Write one line about what changed on the site that week. New page, rewritten title, a few new links, a slow day for the server. If nothing changed, write "no changes."
  6. Mark anything that moved more than three positions, in either direction, for a closer look.

A template you can copy

Here is the whole report. Keep it this short.

Week of Monday's date

Site totals: clicks, impressions, average position (with last week's figures in brackets)

Biggest gains: up to three keywords, old position → new position

Biggest drops: up to three keywords, old position → new position

Changes made this week: one or two lines

Next week: one thing you'll do, such as "add FAQ section to the pricing page"

That's all. If you share the report with a partner, a client or your followers, this structure is easy to read on a phone. The rank log's "share my progress" box turns the same numbers into a short post for X if you like working in public.

How to read the changes

Weekly positions wobble. Before you react, ask three questions.

Is the move bigger than the usual wobble? Look at the last five or six weeks for that keyword. If it normally swings between 7 and 9, a reading of 9 is nothing. A jump from 8 to 15 is something.

Did impressions change too? A better position with half the impressions may mean you dropped out of the searches where you ranked low, so the average improved without anything getting better. A worse position with more impressions may mean you started appearing for new, harder searches.

Did the page change? Compare with your notes. If you rewrote the page two weeks ago and it has climbed steadily since, that's a useful lesson. If it fell right after you changed the title, consider changing it back.

Give any change at least two or three weeks before you judge it. Google often takes time to recrawl a page and settle on a new position.

When to act

Most weeks you won't need to act on the report. That's fine, and it's the point: the report tells you when nothing is wrong, so you can spend your time making the site better.

Act when:

  • a keyword drops more than five positions and stays down for two weeks running,
  • several keywords fall at the same time (see our guide on what to do when rankings drop),
  • a keyword you've worked on has been stuck on page two for months, which usually means the page needs to answer the search better than the pages above it,
  • a new query shows up with lots of impressions and no page written for it.

Keep a long memory

Search Console holds 16 months of data. Your own log can hold years. Once a month, export your log as a CSV and keep the file somewhere safe. A year from now, when a keyword falls, you'll be able to see whether it fell the same way last year at the same time, which happens more often than you'd think with seasonal searches.

For the basics of finding these numbers, see how to check your Google rankings for free with Search Console.

Questions

How many keywords should a small site track?
Between 10 and 25 is plenty for most small sites. Choose searches that match pages you want found and that a customer would actually type. You can always look at the full query list in Search Console for discoveries.
Is weekly too often?
For most small sites, weekly is a good rhythm. Daily numbers are too noisy to act on, and monthly checks make it hard to connect a change in position to something you did.
Should the report include traffic?
Yes, briefly. Clicks for the tracked queries tell you whether a better position is turning into visits. A top line with total clicks and impressions for the week is enough.

Read next