SEM Reporting Dashboards That Executives Actually Read
Most SEM reports executives receive get scanned for 90 seconds and closed. The marketer who produced 40 hours of analysis sees three of those 40 hours yield any decisions. The problem isn’t the executive — it’s the report structure. Most reports default to “everything we did” instead of “what matters and why.” This guide is the playbook for building SEM reporting that executives actually read, act on, and trust.
By the end, you’ll have a dashboard structure that compresses a quarter of search marketing into one page of decisions.
What executives actually want to know
The CFO, CEO, or board member opening your SEM dashboard cares about three things:
1. Are we hitting our number? Revenue, pipeline, leads — the outcome that matters to the business.
2. What changed and why? Big movements deserve narrative explanation.
3. What are we doing about it? Specific next actions tied to specific opportunities or risks.
What they don’t care about:
- Impressions, clicks, CTR (unless they’re the leading indicator of #1)
- Per-campaign granularity
- The 200 things you’ve been working on
- Industry benchmarks vs. yourself
- “Optimization activities completed”
The compression to those three questions is the difference between executive-ready reports and operational logs.
The 5-layer executive dashboard
Layer 1: The headline (above the fold)
A single sentence describing the period.
“Q1 search marketing delivered $1.2M in attributed revenue (88% of $1.36M target), up 22% vs. Q4.”
That’s the report. Everything else is detail to back it up.
Layer 2: The 4-6 KPIs
Cards showing the metrics that matter for your business:
- Revenue (or pipeline) attributed to search — the headline number
- CAC or cost per qualified lead — efficiency
- ROAS or payback period — economics
- Lead/revenue growth vs. prior period — trend
- Pipeline coverage / forecast vs. plan — forward-looking
- Brand search lift — health of upstream demand
Each KPI shows:
- Current value
- Comparison to prior period (% change with arrow)
- Comparison to target (if applicable)
Layer 3: The trend chart
A single line chart showing the headline metric over the last 13 weeks or 6 months.
Why one chart, not five? Executives can absorb one trend. Multiple trends compete for attention.
Layer 4: The narrative
3-5 short bullets answering:
- What’s working that should continue?
- What’s not working that needs attention?
- What’s the most important decision in the next 30 days?
Example:
- “Performance Max for ecommerce delivered 4.8× ROAS this quarter, up from 3.2×. Continuing to scale.”
- “Branded paid CPM increased 35% — competitors bidding more aggressively. Investigating.”
- “Q2 priority: launch dedicated landing pages for top 5 non-branded campaigns. Estimated +15% conversion.”
That’s the entire content. Three to five lines. Each tied to action.
Layer 5: Drill-down (optional, link to it)
For the analyst or marketer who wants more, link to a detailed dashboard. Don’t put it on page one.
This is the entire executive dashboard. Five layers. One screen.
What to leave out
Most marketers over-include. The cuts:
Cut: “Activities completed.” Executives don’t care that you ran 47 A/B tests. They care about the outcome of those tests.
Cut: Industry benchmarks not relevant to your goals. “We’re at 2.5% CTR vs. industry average 1.8%” doesn’t tell the executive whether you’re hitting their number.
Cut: Per-campaign breakdowns. Aggregate. Detail is for operational reports, not executive.
Cut: Vanity metrics. Impressions and CTR matter to you. They don’t move the conversation upstream.
Cut: Excuses. “iOS 14 affected our attribution” is true and uninteresting. Show what you’re doing about it.
Cut: Multi-tab dashboards. Executives won’t navigate. Single screen or it didn’t exist.
Tools to build executive dashboards
Looker Studio (free): best for most cases. Connects to GA4, Google Ads, Search Console natively. Drag-and-drop editor. Free.
Tableau / Power BI: enterprise, more capability, higher learning curve. Worth it for $1M+/year marketing budgets with multiple data sources.
Klipfolio / Whatagraph / Improvado: dedicated marketing dashboard tools. Easier than Looker for non-analysts. Subscription cost.
Custom (Hex, Metabase): for advanced data teams. SQL-based.
For most SMB-to-mid-market accounts, Looker Studio is the right choice. The dashboard you build matters more than the tool.
A Looker Studio template structure
For a typical SEM dashboard, the data sources:
- Google Ads (via native connector)
- Google Analytics 4 (via native connector)
- Search Console (via native connector)
- CRM (HubSpot, Salesforce — via partner connector)
Layout:
Page 1 — Executive view (the dashboard above):
- Title + headline metric
- 6 KPI cards
- One trend chart
- Narrative text section (editable monthly)
Page 2 — Channel breakdown:
- Performance by campaign type (Search, PMax, Shopping, etc.)
- Top campaigns by revenue and CPA
- Period comparison table
Page 3 — Funnel view:
- Impressions → Clicks → Sessions → Conversions → Revenue
- Conversion rate at each step
- Drop-off analysis
Page 4 — Audience/Geo:
- Performance by audience segment
- Geographic breakdown
- Device split
Page 5 — Operational notes:
- Tests in progress
- Recent changes log
- Next-period plan
Page 1 is for executives. Pages 2-5 are for the marketing team itself.
Cadence
Monthly executive report: page 1 plus narrative. 5-10 minutes for executive to read.
Weekly operational report: pages 2-5. For the marketing team’s own optimization.
Quarterly business review: combine + add forward-looking strategic recommendations. 30-60 minutes meeting.
Don’t send the executive dashboard weekly — fatigue makes it irrelevant. Monthly is the sweet spot.
Common reporting mistakes
1. Reporting on activity, not outcomes. “We posted 47 ads” vs. “47 ads contributed to $200K pipeline.”
2. Mixing time horizons. Some metrics weekly, some monthly, some quarterly — confusing. Standardize the time window.
3. Using last-click attribution when budget is upper-funnel. Last-click undervalues upper-funnel work. If you’re investing in awareness, use multi-touch attribution.
4. Reporting on what’s measurable vs. what matters. Some important things are hard to measure (brand lift, brand search increase). Report on them anyway with proxies.
5. Inconsistent definitions. “Conversion” means one thing this month, another next month. Lock definitions and document them.
6. No narrative. Numbers without interpretation force the executive to do the interpretation. They won’t.
7. Long PDFs delivered late. Live dashboards beat static PDFs. Up-to-date data beats polished reports.
8. Reporting on Google Ads vs. GA4 differences without resolving. “GA4 shows X, Google Ads shows Y — we’re investigating” repeated quarterly signals lack of expertise.
A 30-day reporting overhaul
Days 1-7: Audit current reports.
- Talk to executives: what do they actually look at? What decisions do they make from reports?
- List the metrics that drive decisions vs. the metrics you’ve been reporting.
- Identify the gap.
Days 8-15: Design the new dashboard.
- Pick 4-6 KPIs that map to business outcomes.
- Sketch the 5-layer structure on paper.
- Build Page 1 in Looker Studio.
Days 16-22: Add operational pages.
- Build pages 2-5 for marketing team use.
- Connect all data sources.
- Validate metrics match source systems (within tolerance).
Days 23-27: Pilot.
- Send the new monthly executive report.
- Solicit feedback: was it actually useful? What’s missing? What’s extra?
- Iterate.
Days 28-30: Lock and document.
- Finalize template.
- Document metric definitions.
- Set monthly cadence.
By day 30, you have a defensible reporting structure executives actually use.
Frequently asked questions
How long should an executive dashboard take to read? 60-90 seconds for the at-a-glance view. 5-10 minutes if they want detail. If it requires more than 10 minutes, restructure.
Should I include in-platform screenshots? Mostly no. They look impressive but don’t communicate decisions. Use synthesized charts instead.
What if my executive wants more detail? Give them access to pages 2-5. Don’t put the detail on page 1 by default.
How do I report attribution when platforms disagree? Pick one source of truth (usually GA4 with data-driven attribution). Document why. Report from that source consistently.
Should I include competitor data? Sparingly. “Our SoV is X” or “Competitor launched Y campaign” is interesting if it informs action. Avoid as filler.
Executive reporting is an art separate from analysis. The marketer who can produce great analysis but mediocre reports gets less budget than the marketer who produces decent analysis with great reporting. Both skills are learnable, but reporting is the higher-leverage one for organizational influence. Invest in it; the payback is bigger than another month of campaign optimization.