Automated SEO reports: a weekly Search Console and GA4 report, and how to send it to Slack
Automated SEO reports: a weekly Search Console and GA4 report, and how to send
it to Slack A weekly SEO report needs five things: clicks, impressions,
average position, your top queries and pages, and the same numbers for the
week before. You can pull them by hand from Search Console's Performance
report and GA4, schedule a free emailed PDF with Looker Studio, or have an
agent post the numbers in Slack every Monday. This article covers all three.
What to put in a weekly SEO report Keep it to what changes a decision: Clicks,
impressions, average CTR and average position for the week, next to the
previous week. Top queries by clicks, with their average position. Top pages
by clicks. Organic sessions from GA4, to see what the clicks turned into. One
line of interpretation: what moved and what you will do about it. Always write
the exact date range next to every figure. "Clicks: 1,240" is useless;
"Clicks, 28 Sep to 4 Oct: 1,240 (previous week, 21 to 27 Sep: 1,090)" is a
report. Pull it from Search Console Open Search Console, pick your property,
and choose Performance in the left menu (the Search results report). Click the
date filter at the top. Pick a range, such as the last 7 days. The report
keeps 16 months of data. To compare, open the date filter, click Compare, and
choose last week against the previous period. You can have only one comparison
at a time. Read the totals at the top of the chart: total clicks, total
impressions, average CTR and average position. Switch between the Queries and
Pages tabs to see the top rows. To keep the data, use the export button and
choose Google Sheets, Excel or CSV. The export is limited to 1,000 rows.
Average position is the topmost position your site held, averaged across the
queries it appeared for. It is not a ranking for one keyword, and it moves
with screen sizes, layouts and search types. Do not read it as rank tracking.
Pull organic traffic from GA4 In Google Analytics, choose Reports in the left
menu. Go to Acquisition, then Traffic acquisition. The table starts with
Session default channel group. Find the Organic Search row and read its
Sessions, Engaged sessions and Engagement rate. Change the date range, or
apply a comparison, from the date control at the top of the report. Send it by
email for free with Looker Studio Looker Studio can email a report on a
schedule. It has connectors for both Search Console and Google Analytics 4.
Build a report with the numbers above, then: Open the report and click Share,
then Schedule delivery. Add recipients, choose the pages to include, and set
the start date and time. Use Repeat to set the frequency, for example every
week. Click Schedule. Recipients get a preview of the first page, a link to
the report, and a PDF. On the free version you get one schedule per report, a
highest frequency of once a day, and up to 50 recipients per schedule. The
schedule follows your operating system's time zone, and it cannot be changed
inside Looker Studio. The catch: it is a PDF in an inbox, and it does not
compare weeks unless you build that comparison into the report yourself. Do it
with Kipwise Agent If your team lives in Slack, Kipwise Agent can post the
numbers where people already read. It is an AI agent in Slack that reads
Search Console and GA4 with your own Google access. Connect Google first (
Connect your tools to Kipwise Agent ), then say: "@Kipwise Agent every Monday
at 9:00, post last week's top 10 Search Console queries for example.com with
clicks and average position, compared with the week before. State the date
range next to every figure." You can add: "Also include organic search
sessions from GA4 for the same weeks." What happens: On Monday at 9:00 in your
Slack time zone it posts "Scheduled for @you" and answers in that thread. It
fetches each week from Search Console separately, so each figure carries its
own dates. Both Search Console and Analytics access are read-only. It cannot
change your site or your settings. It only reports what it fetched. If a query
does not come back, it does not fill the gap with a guess. Honest limits: It
reports average position from Search Console, the same number you see in the
Performance report. It is not rank tracking for a keyword from a given
location. A request returns a limited number of rows (up to 100), so ask for
the top 10 or 20, not everything. The report is as complete as Search
Console's data is. It does not add a data source Search Console does not have.
A repeating request can
Last updated: a month ago