Connect GA4 & Semrush to Build an Automated Client Health Report (2025 No‑Code Guide)

By Sima Team | June 8, 2025

---

TL;DR – In 20 minutes you can stitch GA4 engagement metrics and Semrush keyword/visibility data into a live Looker Studio dashboard that refreshes daily—zero code. Perfect for agencies that need a single "traffic + rankings + revenue" snapshot for every client account. ✨

---

Why This Matters for Agencies

• One link to rule them all. Clients love seeing organic traffic and keyword wins side‑by‑side—no more juggling PDFs.
• Billability boost. Automating weekly health emails saves ~2 h/account/week according to Sima's time‑tracking across 11 European agencies (Mar–May 2025).
• Retention insurance. Early‑warning blend of GA4 conversions dip + Semrush visibility drop flags issues before contract churn.

---

Prerequisites

Tool	Free Plan OK?	What You Need
GA4	✅	Edit access or BigQuery export enabled
Semrush	✅ (Pro)	API key (1 k calls/day on Pro)
Google Looker Studio	✅	Gmail / Workspace account
Supermetrics / Semrush Connector	Free trial	For direct Semrush → Looker pipe (optional)
Zapier (optional)	Free tier	For Slack/Email alerts

Heads‑up 2025: Semrush shipped an official Looker Studio connector in April 2025—no more relying on Supermetrics. (semrush.com)

---

Architecture Overview

flowchart LR
  GA4[Google Analytics 4] -->|Daily API / BigQuery| LS((Looker Studio))
  SEM[Semrush API] -->|Looker Connector| LS
  LS --> REP[Client Health Report]
  REP -->|Weekly PDF| CLIENT[Client Email]
  LS -->|Anomaly threshold| ZAP((Zapier → Slack))

---

Step 1 – Add the GA4 Data Source (5 min)

1. Open Looker Studio → Create → Data Source → Google Analytics.
2. Select the GA4 property.
3. Choose the events table → Click Connect.
4. Rename to GA4 – Client X for clarity.

Pro Tip: To include conversion value you'll need GA4's Data API purchase_revenue metric or the BigQuery export.

---

Step 2 – Plug in Semrush (7 min)

Option A – Official Semrush Connector (zero cost on any paid plan)

1. In Looker Studio, click Add Data → Partner Connectors → Semrush.

2. Authorise with your Semrush account.

3. Pick Domain Overview → Organic Search dataset.

4. Fields to import:

   • Visibility %
   • Estimated Traffic
   • Top‐3 Keywords
   • Backlinks Total

Option B – Supermetrics (if you need historic positions >24 months)

Supermetrics still offers deeper historical depth back to 2015 but costs €49/mo.

---

Step 3 – Build the Dashboard (8 min)

Section	Visual	Data Source	How‑To
Traffic Trend	Time‑series line chart	GA4 → sessions	Set date range to last 12 months
Conversion Funnel	Funnel viz	GA4 events (add_to_cart → purchase)	Use breakdown: device_category
SEO Visibility	Scorecard + sparkline	Semrush Visibility %	Compare last 30 days vs previous
Keyword Wins	Table	Semrush Top‐3 Keywords	Filter by Position_change > 0
Revenue vs SEO	Dual‑axis blended chart	GA4 purchase_revenue + Semrush Estimated Traffic	Left axis €; right axis visits

Drag‑and‑drop, style with brand colours, and you're done.

---

Step 4 – Automate Weekly PDF & Alerts

1. Schedule Report → PDF → Weekly Mondays 08:00 to client emails.

2. Zapier:

   • Trigger: Looker Studio Data Blend threshold (supports webhooks since Feb 2025).
   • Condition: Visibility %↓ > 10 OR sessions↓ > 15 WoW.
   • Action: Post in #client‑health Slack + tag AM.

---

What's New in 2025

• Semrush Looker Connector – Free on all plans; pulls 24 core SEO metrics. (semrush.com)
• GA4 Realtime V2 API – 1‑minute latency now available; ideal for on‑page anomaly alerts. (developers.google.com)
• Looker Studio Smart Alerts – April 2025 release adds native anomaly detection no‑code triggers.

---

FAQs

Do I need BigQuery for this?

No—Looker Studio pulls GA4 API directly. BigQuery is only required if you want event‑level joins or >14 months historical.

Will Semrush API calls burn through my quota?

The Looker connector uses caching; a single domain dashboard ≈ 50 calls/day—well within Pro plan.

Can I add GSC queries too?

Yes. Add GSC data source → blend by date with Semrush Visibility % for richer SERP insight.

---

Final Wrap‑Up

With GA4 and Semrush feeding a single dashboard, you'll:

• Slash prep time – From spreadsheet hell to live link.
• Delight clients – Unified KPI view, automated Monday PDF.
• Catch drops early – Slack pings when traffic or rankings tank.

Next Step: Duplicate the Looker template, attach Sima's time‑tracker to quantify hours saved per account, and bake the delta into your next QBR pitch.

Happy reporting!