Keyword reports in Slack, or: stop screenshotting the same table every Monday

Keyword reports in Slack, or: stop screenshotting the same table every Monday

The Monday SEO ritual at most agencies, in five steps:

1. Open Search Console.
2. Export top queries.
3. Paste into a Google Sheet.
4. Screenshot.
5. Drop into #seo with the phrase "morning team, here's the latest."

By Wednesday nobody can remember what was in the screenshot, and by Friday everyone is preparing the next one. The data is doing its job. The ritual is not.

What makes a keyword report actually useful

A useful keyword report is not the top 20 queries. It's the top 20 movers.

Knowing your #1 keyword is still your #1 is not news. It is, in fact, almost the definition of not-news. The news is that "data integration tools" went from position 23 to 11 last week. That is something a human can do something about — confirm the page that's ranking, decide whether to push more internal links at it, look at the SERP and see who else moved.

Three views that earn their place in a channel:

Top movers. Bar chart of biggest position deltas, week over week, above some impression floor (so you're not optimising for queries with three searches a month).

New entrants. Queries that ranked this week and didn't last week. Almost always a sign that a page is finding a new audience, often a hint that there's an emerging topic worth doubling down on.

Decliners. Queries that lost position. Position decay is non-linear once it starts — catching it early is worth real money.

A flat "top 20 by clicks" bar chart is fine for the dashboard. None of the three above are flat top-20 bars. They are why the report matters.

A two-post-a-week pattern that holds up

• Monday 9am, #seo — top 20 queries by clicks last week. The "what's working" pulse.
• Thursday 9am, #seo — top 20 movers by position delta. The "what to do this week" pulse.

Two posts. Roughly five seconds of human reading each. The week of work falls out of them.

If you want a monthly view on top: clicks and impressions over the last 90 days, first of the month. Trends only. No actions implied. Helpful to keep the macro picture alive.

Tying queries back to pages

Queries don't fix themselves; pages do. The follow-up to any keyword post is always "which page is this?", and Search Console knows.

A nice pattern: pair the keyword post with a top pages by impression delta post, same channel. Looking at them side by side, the work usually leaps out — "this page has gained 12,000 impressions in a week and the title still reads like a 2019 listicle, let's update it."

The trap

Don't post 50 keywords every day. That is the Slack-as-dashboard antipattern, and it lasts about two weeks before everyone mutes the channel. We wrote about it at length in the agency reporting cadence playbook.

Less, but on time, in the right channel. That's the rule.

Setting it up

1. Add Google Search Console as a source in Chartcastr.
2. Pick the queries report. Filter to whatever impression floor matches your scale.
3. Pick #seo and the schedule.
4. Optionally turn on AI commentary so each post arrives with a one-liner on what moved.

Related reading

• Connect Google Search Console to Slack — the broader Search Console connector overview.
• Google CTR benchmarks in Slack — the next chart to pair with this one.
• Agency Slack SEO internal reporting — full agency stack.
• Bar charts from Sheets to Slack — if you're rendering the report from a Sheet rather than Search Console direct.