SEO performance digest

Q: What should a weekly SEO report cover?

Clicks and impressions vs. last week, top moving pages and keywords, near-miss pages ranking 11–20 with high impressions, and any technical issues like dropped indexing or Core Web Vitals regressions.

Q: How do you automate an SEO report?

Connect Search Console and GA4 to Basedash and schedule an AI automation each Monday. Optional: layer in Ahrefs or another rank tracker to capture competitive movement.

An automated weekly SEO performance digest. AI summarizes ranking, clicks, impressions, and top movers from Search Console and Ahrefs.

Use this template How automations work

Runs weekly Scheduled Delivered to Slack, Email

SEO performance digest

Active

Trigger

Runs weekly

Instructions

Generate a weekly SEO performance digest.

Delivery

Slack · Email

Example output

A realistic sample of what this automation delivers — your version draws on your data.

SEO performance digest Runs weekly · Sent to Slack, Email

Sample output

Search Console clicks, last 8 weeks

Top line. 184K organic clicks (+8% WoW), 4.2M impressions (+12%). Average position 18.4 (was 19.1).

Big movers

/vs/omni-vs-sigma — up to position 4 (was 9), +42% clicks. Featured snippet for “omni vs sigma”.
/blog/best-ai-native-bi-tools-compared-2026 — page 1 for 6 new keywords.

“Almost there” pages (rank 11–20, high impressions)

Page	Position	Impressions	Suggested fix
/tools/sql-formatter	14	8,200	Update H1 + add an example block
/features/automations	17	6,400	Refresh the comparison table
/blog/dashboard-sprawl-audit	18	5,100	Add a downloadable checklist

Regressions. /blog/best-bi-tools-2025 dropped 8 positions — competitor refreshed with 2026 numbers. Refresh planned for next week.

The prompt

Copy, paste, customize.

Drop this into a Basedash automation. AI fills in the numbers from every source you've connected.

Instructions

Generate a weekly SEO performance digest.

Cover:

**Top line.** Clicks, impressions, and average position vs. last week and vs. 90 days ago.

**Top moving pages.** Five biggest click gainers and five biggest losers.

**Top moving keywords.** New keywords entering the top 10. Keywords that dropped out.

**Content opportunities.** Pages ranking 11–20 with high impressions — easiest "almost there" wins.

**Technical issues.** Significant changes in indexed pages, average CWV scores, or 4xx/5xx counts.

Close with three named, specific recommendations for next week.

Data sources

Powered by these sources.

Basedash automations read across every connected source in a single run. These are the ones this template tends to use most.

Frequently asked questions

What should a weekly SEO report cover?

How do you automate an SEO report?

Keep going

Related templates

See all

Marketing · Runs weekly

Weekly marketing report

Pulls traffic, signups, ad spend, attribution, and campaign data into a single weekly marketing recap.

Marketing · Runs weekly

Content performance recap

Top blog, video, and landing page performance, ranked by signups, with refresh candidates flagged.

Marketing · Runs daily

Daily ad spend report

Yesterday's spend, clicks, signups, CPC, and CPA across every ad channel in one short morning post.

Get started in under 30 minutes

We can help you migrate your data and dashboards from any other tool.

Start free Book a demo