Marketing Data Extraction

Build Your Daily SEO Dashboard in Claude Cowork

Share Now

A self-updating SEO dashboard for your site, pulling fresh data from Google Search Console and Google Analytics 4 every time you open it. No coding, copy-pasting reports or waiting on a developer.

By the end of this guide, you will have a live page in Cowork that shows:

Yesterday’s clicks, impressions, CTR, average position, and organic sessions, each with a week-over-week delta
A 28-day trend chart with clicks, impressions, and ranking in one view
Your traffic broken down by channel from GA4
Your top-performing pages from last week
Queries that gained or lost the most clicks week-over-week
High-impression, low-CTR queries that are easy wins for title and meta optimisation

You trigger it by typing one sentence into Claude.

1. What You Will Need (One-Time Setup)

2. Step 1: Connect Your Google Accounts to Smacient

3. Step 2: Add the Smacient Connector to Claude

4. Step 3: Install the SEO Morning Check Skill

5. Step 4: Build Your Dashboard

6. Step 5: Use It Daily

7. What to Look at First

8. Building Dashboards for Multiple Sites

9. Frequently Asked Questions

10. Privacy and Data

Need Help?

What You Will Need

One-Time Setup

A Google Search Console property and a Google Analytics 4 property for the site you want to track. Both are free. If you do not have them, set them up at search.google.com/search-console and analytics.google.com first.
A Smacient Claude Connector account (free signup at smacient.com/mde/dashboard)
Claude Cowork is installed on your computer (download here if you do not have it)

Step 1: Connect Your Google Accounts to Smacient

Approximately 2 minutes

The Smacient Claude Connector gives Claude access to your Search Console and Analytics data. You only need to do this once.

Instructions:

Go to smacient.com/mde/signup/ and sign up or log in.
Connect Google Analytics 4 and Google Search Console from the tools section in the dashboard.
While connecting each tool, an OAuth screen will appear. Allow the requested access for Google Analytics and Search Console accordingly. The Smacient connector only requires read-only access and cannot modify or post to your accounts.
After connecting both tools, you will see Google Analytics 4 and Search Console listed as Connected in the dashboard. This confirms the integration is active. The actual site and property list will be pulled by Claude directly when you trigger the dashboard in Step 4.
From the dashboard, find the Connect to Claude button or the MCP Setup section. Copy the configuration URL provided. You will use this in Step 2.

Copy the configuration URL provided. You will use this in Step 2.

If the connection request fails for any of the above tools means that your Google account may not have access to that Search Console or GA4 property. Add yourself as a user in those tools first, then reconnect.

Step 2: Add the Smacient Connector to Claude

Approximately 1 minute

Open Claude AI or Claude Desktop and go to Settings.
Find the Connectors section.
Click Add Connector, paste the MCP Connector URL you copied from the Smacient dashboard, and confirm.
Once added, you will see Smacient listed under your active connectors. This gives Claude access to your GA4 and Search Console data.

Quick test: Open a new task in Cowork and type: “List my Search Console sites.” Claude should respond with your connected sites. If it cannot find the tool, go back and re-paste the URL or restart Cowork.

Step 3: Install the SEO Morning Check Skill

Approximately 1 minute

The skill is a small set of instructions that tells Claude how to build the dashboard for your site. You install it once, and it works for every site you have connected.

A. Download the Skill

Download seo-morning-check-skill-bundle.zip from the link in your invite email or your team’s shared drive.

B. Extract the Zip

Unzip it to get a folder called seo-morning-check/ containing two files: SKILL.md and assets/template.html.

C. Add the Skill to Cowork

You can add the skill using either of these two methods:

Method 1: Through the Claude Interface (Recommended)

Open Claude AI and go to Settings.
Find the Customise or Skills section (https://claude.ai/customize/skills)
Click Add Skill and upload the SEO-morning-check/ folder, or point it to the extracted folder on your computer.

Method 2: Through the File System

Move the entire seo-morning-check/ folder into your Cowork skills directory.

On Windows:

C:\Users\<your-username>\AppData\Local\Temp\claude-hostloop-plugins\<plugin-id>\skills\

On macOS:

~/Library/Application Support/Claude/plugins/<plugin-id>/skills/

The <plugin-id> is a unique hash for your install. To find it: open Cowork, go to Settings, find any installed plugin, click “Show in folder” or “Open location”, and navigate up to the skills/ folder.

D. Restart Cowork

Quit and reopen Cowork to load the skill. If your version has a “Reload Skills” option under Settings, you can use that instead.

Step 4: Build Your Dashboard

Approximately 30 seconds

Open Cowork, start a new chat, and type something like: “Build me an SEO morning check for example.com.”

Replace example.com with the domain you connected in Step 1.

Claude will:

Find your Search Console site URL and GA4 property automatically. If you have multiple matching properties, it will ask you which one to use.
Generate the dashboard HTML.
Register it as a live artifact, which opens in your Cowork sidebar.

The first load takes 25 to 35 seconds because it pulls data from six different reports. After that, your dashboard will appear.

Other phrases you can use to trigger the dashboard:

“Create a daily SEO dashboard for mysite.com”
“I want a daily organic check for mysite.com”
“Make me an SEO live view for mysite.com”

Step 5: Use It Daily

Each morning:

Open Cowork.
Click your dashboard in the artifacts sidebar, or use the keyboard shortcut to switch to the artifacts tab.
Hit the Reload button in the artifact header to pull fresh data.
Skim the KPIs and trend chart. The deltas show you what changed since last week.

Your 7d / 28d window preference is saved, so the dashboard always opens in your preferred view.

What to Look at First

The KPI strip at the top. A red CTR delta alongside flat impressions means you are losing clicks at the search results level. This is usually a title or meta description issue, or AI overviews taking clicks.
The trend chart. A sharp drop on a specific date is your starting point. Cross-reference it with any deploys, content changes, or known Google updates.
Top losers. If one query is driving most of the loss, focus there. If the loss is spread across many queries, it is more likely a sitewide issue, such as technical SEO, indexing, or a manual action.
Opportunities. High-impression, low-CTR queries are typically the highest-leverage items to work on that week.

Building Dashboards for Multiple Sites

If you have connected multiple domains in Step 1, you can build one dashboard per domain. Trigger the skill again with a different site name:

“Build me an SEO morning check for awshad.com.”

Each dashboard is a separate artifact with its own URL. They do not conflict with each other.

FAQs

Q: Claude cannot find the gsc_list_sites tool, or says there is no Search Console connector. What do I do?

A: The Smacient connector is not installed or is not running. Go back to Step 2 and re-add the connector.

Q: My site is not in the list when Claude calls gsc_list_sites. Why?

A: You connected with a Google account that does not have access to that GSC property. Add yourself as a user in Search Console using the correct Google account, then reconnect at https://smacient.com/mde/dashboard/

Q: Claude built the dashboard, but everything shows “Loading…” forever. How do I fix this?

A: Wait at least 35 seconds. The first load is slow because the dashboard pulls data from six API calls. If it is still blank after a minute, right-click the artifact, select Inspect, and open the Console tab. Look for [seo] log lines and send a screenshot to [email protected].

Q: The chart shows data, but the numbers look wrong or outdated. Is something broken?

A: No, this is expected. Google Search Console has a 2-day reporting lag. The dashboard intentionally shows data ending 3 days ago to avoid partial or blank days.

Q: I see GA4 conversions attributed to “Unassigned” in the prior period. What does that mean?

A: This is a tracking configuration issue in GA4, not a dashboard problem. The dashboard flags it because it is worth fixing. Your conversion event is missing source attribution. Check your GA4 tag setup or speak with whoever configured your tracking.

Q: I want to add a feature or change a section. Can I do that?

A: Yes. Open Cowork and ask Claude directly. For example: “Add a device split (mobile vs desktop) to my SEO dashboard.” It can edit the artifact in place.

Privacy and Data

Smacient only reads your GSC and GA4 data. It cannot post, modify, or delete anything.
Your data is fetched on demand each time you open the dashboard. Smacient does not store your reports.
The dashboard runs locally inside Cowork on your computer. The HTML does not leave your device.
You can disconnect Smacient at any time from the dashboard or from Cowork settings.