6 hours a week back on Yellow Slate's SEO reporting

The problem

Yellow Slate tracks where 300 keywords rank on Google, and reports on it every week. Building that report by hand took most of a working day. It was the largest recurring task in the team's week, and what it produced was a spreadsheet, not a decision.

Before

Someone opened an incognito window, searched a keyword, scrolled until they found the blog post, and wrote down where it sat. Then they closed the window and did it again. About 300 times.

After that came the site numbers. Traffic, users, session duration, then 12 cities one at a time, changing the date range for each and copying the figure across.

5 to 7 hours on the rankings. Another 30 to 45 minutes on the numbers.

And it still stopped at page 1 or 2, because nobody checks page 7 by hand 300 times.

Every week. 300 keywords. One incognito window at a time.

Before

1. Open an incognito window
2. Search the keyword, scroll, find the post
3. Write the position down
4. Repeat, 300 times
5. Copy the site numbers across by hand
6. Copy 12 cities, one date range at a time

Most of a working day

Now

1. Read the email

About 5 minutes

Now

Tuesday morning, 9am. The report fills itself in.

Same spreadsheet, same layout, same rows. Nobody had to learn anything new, and nothing downstream of the report had to change.

An email arrives when it finishes, saying how many keywords were checked and how many need a second look. A typical week is 2.

Rankings now go 10 pages deep instead of 2, and every keyword is measured the same way every week. This week's number and last week's number finally mean the same thing.

What changed

About 6 hours a week, returned. The weekly review is now roughly 5 minutes of reading an email.

Valued at a $10 an hour cost of staff time, that is roughly $3,000 a year, or about 35 working days handed back.

Coverage went from page 1 or 2 to the full top 100 results, across all 300 keywords.

And one quieter change. A keyword that genuinely dropped out of the top 100, and a keyword whose check failed, now look different on the sheet. They used to look identical, which meant a bad week and a broken check were indistinguishable.