Automated SEO reports: how to set one up step by step
Short answer Use Google's free Data Studio (called Looker Studio until April 2026). Connect Search Console and Google Analytics, build one page with five or six tiles, set the dates to last month compared with the same month last year, then schedule a monthly PDF email. Business Profile calls need a GA4 link or a monthly download.
Want help applying this to your business? Talk it through on a free 30-minute call.
Book a callHow to set up an automated SEO report: five steps
The free tool is Data Studio. Google renamed it from Looker Studio in April 2026 (Google Cloud Blog). You build it once; after that it runs by itself.
| Step | What you do | Where |
|---|---|---|
| 1 | Connect Search Console | Create → Data source → Search Console |
| 2 | Connect Google Analytics 4 | Create → Data source → Google Analytics |
| 3 | Set the dates: last month vs the same month last year | File → Report settings |
| 4 | Add the tiles below, one per question | Add a chart → Scorecard or Table |
| 5 | Schedule a monthly email | Share → Schedule delivery |
You need at least view access in Search Console and "Read & Analyze" access in GA4, signed in with the same Google account (Data Studio docs: Search Console, Google Analytics). In a hurry? Data Studio's template gallery has a Search Console category with ready-made reports you can copy and trim (same page).
Never set these up yet? Start with Search Console and GA4 key events.
What goes in the report, tile by tile
Each tile answers one question. Build them top to bottom: the higher the tile, the closer it is to money. Why these numbers and not others is explained in is my SEO working; this page is about building them.
| Tile | Question it answers | Source | How to build it |
|---|---|---|---|
| 1. Leads from search | Did Google send customers? | GA4 | Scorecard, metric Key events, filter Session default channel group = Organic Search |
| 2. Non-branded clicks | Do new people find us? | Search Console, Site Impression table | Scorecard, metric Clicks, filter Query doesn't contain your business name |
| 3. Clicks and impressions over time | Is search traffic growing? | Search Console, Site Impression | Time series by month; set this chart's own date range to the last 16 months |
| 4. Top pages | Which pages bring visitors? | Search Console, URL Impression table | Table: page, Clicks, Impressions, top 10 |
| 5. Business Profile actions | Does the Maps listing get used? | Google Sheet (or GA4, if linked) | Calls, direction requests, website clicks |
| 6. Average position | Early hint only | Search Console, Site Impression | Small scorecard, at the bottom |
Notes that change how you build them:
- Tile 1 counts only what you marked. "Organic Search" is one of GA4's default channel groups, and key events count from the day you mark them: marking one "doesn't change historic data" (Google Analytics Data API). Mark form sends, booking confirmations and phone taps before you trust this tile.
- Tiles 2 and 3 use different totals. Search Console hides rare queries for privacy. Those "anonymized queries" are "included in chart totals, unless a query filter is applied" (Search Console Help). So tile 2 will be smaller than total clicks minus branded clicks. That's normal; compare it only with itself over time.
- Tiles 3 and 4 need two data sources. One Search Console data source holds either Site Impression or URL Impression, not both. Google: "create two data sources and add both to a single report" (Data Studio docs).
- Tile 5 has no direct connector. Google's list of its own Data Studio connectors includes Search Console and Google Analytics, but no Business Profile (Data Studio docs). Two ways around it, below.
- Tile 6 goes last for a reason:
"In general, it's recommended to focus more on trends in impressions and clicks than on position alone." (Search Console Help)
Leave out backlink counts, "SEO scores" and site-health checklists. The first two need a paid tool; site problems belong in Search Console's own reports. An owner can't act on any of them each month.
How to add Business Profile calls and directions
- Link it to GA4. In GA4 Admin, under Product links, click Google Business Profile links. You need Editor or Administrator in GA4 and Owner or Manager on the profile. The link shares "interactions, website clicks, calls, directions, messages, bookings, and menu clicks" with GA4 (Business Profile Help). Google doesn't say these numbers reach Data Studio's GA4 connector; if the fields don't show up, use the download.
- Or download it monthly. In the Business Profile Manager, tick the profile, click Actions → Insights, pick the timeframe and download (Business Profile Help). Paste the three numbers into a Google Sheet, and add the Sheet to the report as a data source.
Either way, know what you're counting. Google says the data "includes views, searches, and actions from both organic search results and Google Ads" (same page). If you run ads, some of those calls were paid for.
Set the dates so every email shows the right month
In File → Report settings, set the default date range to Custom and pick the rolling preset for last month. Then, on each scorecard, table and time series, set the comparison date range to the previous year (Data Studio docs). Rolling ranges move with today's date, so each email shows the month just ended, without edits.
Skip the default. The Analytics connector "provide[s] the last 28 days by default" (same page), which never lines up with a calendar month.
Compare with the same month last year, not last month. A roofer's February is always slower than October. Search Console keeps 16 months, enough for one year-over-year view (Google Search Central).
Schedule the email
Open the report, click Share, then Schedule delivery. Add recipients, pick the pages, set the start date and time, set Repeat to monthly, and click Schedule (Data Studio docs). Each email carries the report as a PDF, with a link to the live version.
Pick a day a few days into the month, such as the 3rd. Search Console's newest data "can be preliminary" and "might change in the next few hours" (Search Console Help), and Google's connectors refresh every 12 hours (Data Studio docs).
Limits on the free version, from the same scheduling page:
| Limit | Free Data Studio |
|---|---|
| Schedules per report | 1 |
| Most often | Once a day |
| Recipients per schedule | 50, including you |
| Emails a day / month | 200 / 800 (500 / 3,000 with Google Workspace) |
| Custom subject, "Send now" | Pro only |
| Time zone | Your computer's, can't be changed in Data Studio |
Only the report's owner, an editor, or someone given scheduling permission can create the schedule.
Who should own the report
The business should. Data sources run on credentials: with owner's credentials, other people can view the report without their own access to the data (Data Studio docs). If an agency builds everything under its own Google account, the report runs on the agency's access. Build it under the business account and give the agency edit access. More on keeping your accounts in leaving your marketing agency.
Do you need a paid reporting tool?
For one business, usually not. Paid tools earn their fee when you need rank tracking, backlink data or many locations in one place, or you're an agency branding reports for clients.
| Tool | Price (USD, Nov 2026) |
|---|---|
| Data Studio | Free |
| AgencyAnalytics | $20 per client per month, billed annually (AgencyAnalytics) |
| DashThis | $44 a month, paid yearly, for 3 dashboards (DashThis) |
A side benefit of the free route: the monthly PDFs pile up in your inbox. That's a record older than Search Console's 16 months, which Google says you can only extend by pulling data out "and store it in your systems" (Google Search Central).
Example
Illustrative cases with invented round numbers.
A plumber's first automated report (US dollars)
On the 3rd, the PDF arrives: 9 leads from organic search, 140 non-branded clicks (up from 90 a year ago), 60 profile calls. Ten minutes of reading. The owner pays an SEO freelancer $800 a month and now sees the same numbers the freelancer sees.
A dental clinic in Calgary (Canadian dollars)
The office manager built the report under the clinic's Google account, then gave the agency edit access. When the clinic switched agencies a year later, the report and its 12 monthly PDFs stayed. The new agency, paid C$1,500 a month, started from a known baseline.
An accountant whose tile 1 shows zero
Search Console shows 200 clicks, yet tile 1 reads 0. The booking form was never marked as a key event in GA4. After marking it, leads start counting from that day; earlier months stay at zero.
FAQ
Can Google Analytics email me a report on a schedule?
Data Studio is the way to do it for free: connect GA4 as a data source and schedule the report from the Share menu (Data Studio docs).
Is Looker Studio the same as Data Studio?
Yes. Google renamed Looker Studio back to Data Studio in April 2026 (Google Cloud Blog).
How often should an automated SEO report arrive?
Monthly fits most small businesses, and it matches the last-month date range above. The free version can send at most once a day (Data Studio docs).
Why don't my report's numbers match Search Console exactly?
Usually filters. A query filter drops anonymized queries from totals (Search Console Help), and Site Impression and URL Impression count differently.
Different for you?
- You want to know which numbers matter before building anything: is my SEO working?
- An agency sends the report and you want to judge it: the report to ask for.
- Tile 1 stays empty because calls and forms aren't tracked: GA4 key events.
- You'd rather have the SEO done and reported for you: SEO & GEO Agent.