Most "marketing dashboard examples" articles show you screenshots of pretty charts and call it a day. What they leave out is the part that matters: which questions each layout actually answers, which connectors feed it, and how often it needs to refresh to stay useful. A SaaS founder, an ecommerce operator, and an agency lead all need different dashboards because they answer different weekly questions. The chart library is the same; the architecture isn't.

This guide covers five marketing dashboard examples by vertical, with the KPIs each layout displays, the data sources they require, the refresh cadence they need, and the common mistakes that turn each one into noise. For the broader question of which KPIs are worth tracking at all (regardless of vertical), see our marketing dashboard KPIs playbook. This post sits one layer down: given the KPIs are agreed, what does the actual weekly view look like for each business model.

The five verticals covered below: SaaS / subscription, ecommerce and DTC, agency multi-client, B2B lead generation, and content and SEO-driven businesses. For each: the weekly question, the KPIs, the layout, the data sources, the refresh cadence, and the pitfall.

1. SaaS / subscription dashboard

The weekly question: are we converting trial signups into paid subscriptions fast enough to make our paid acquisition pay back, and is our churn under control?

SaaS dashboards live or die by funnel visibility. A signup count alone is misleading because trial-to-paid conversion can land anywhere from a few percent on long opt-in trials to nearly 50% on credit-card-required flows, depending on product and channel (see the OpenView product benchmarks for ranges). The dashboard has to expose the full funnel from acquisition through paid retention.

KPIs to display:

• Trial signups by acquisition channel (Meta, Google Ads, LinkedIn, organic, referral)
• Trial-to-paid conversion rate by channel, with the time horizon explicit (day 14, day 30)
• True CAC by channel: spend divided by paid subscriptions actually acquired, not just signups
• MRR / ARR with month-over-month growth
• Logo churn rate and revenue churn rate (these are different and both matter)
• Dunning recovery rate: of failed payments, what percentage recover within the retry window

Recommended layout:

• Top row: three scorecards. MRR, MoM growth %, blended CAC payback period in months
• Middle row: stacked funnel chart by channel (signups → trials → paid → retained at day 90)
• Bar chart: True CAC by channel, sorted ascending
• Bottom row: churn breakdown (logo vs revenue) and dunning recovery rate trend over the last 90 days
• Filter controls: date range, channel multi-select, plan tier

Data sources: Stripe (subscriptions, charges, invoices), Google Ads, Meta Ads, LinkedIn Ads, GA4. Optional: HubSpot for sales-assisted SaaS, Klaviyo if you run lifecycle email.

Refresh cadence: daily is the right default. Trial cohorts move fast and an executive looking at last Tuesday's MRR on Friday is already behind. Hourly refresh only matters if you have a live launch or an active dunning campaign.

The common pitfall: reporting on signup volume without trial-to-paid conversion, then optimizing creative for the wrong outcome. A Meta Ads creative that drives cheap signups but converts at 8% to paid is worse than a LinkedIn Ads creative that drives expensive signups and converts at 45%. For the full mechanics of the trial conversion funnel and dunning recovery, see our Stripe to Looker Studio guide.

2. E-commerce and DTC dashboard

The weekly question: what is our blended return on ad spend after factoring in repeat purchases and email-driven revenue, and which channels are subsidizing which?

DTC and ecommerce dashboards have to combine paid acquisition with the post-purchase economics that actually determine profitability. A 2.5 ROAS at first purchase looks bad until you discover that channel's customers buy 2 to 3 more times in the first 180 days (typical for high-repeat DTC categories). Without that retention layer, every paid optimization is short-sighted.

KPIs to display:

• ROAS by channel (Meta, Google Ads, TikTok, Pinterest, etc.)
• AOV (average order value) by channel and over time
• Repeat purchase rate within 90 days, segmented by acquisition channel
• Email and SMS attributed revenue, split out separately (these compound differently)
• Subscriber LTV by acquisition channel over 30, 90, 180, and 365 days
• Inventory-aware spend efficiency if you sell physical goods (don't drive demand on products you can't ship)

Recommended layout:

• Top row: three scorecards. Total revenue this period, blended ROAS, email + SMS contribution to total revenue %
• Middle row: ROAS by channel bar chart, AOV trend line over the last 90 days
• Cohort heat map: LTV by acquisition month × acquisition channel
• Bottom row: top 10 products by revenue with units sold, email/SMS attributed revenue trend
• Filter controls: date range, channel, product category

Data sources: Shopify (orders, products, customers), Meta Ads, Google Ads, Klaviyo (campaigns, flows, profile properties for source attribution), GA4, TikTok Ads if relevant. For the email + SMS attribution layer specifically, see our Klaviyo to Google Sheets guide.

Refresh cadence: daily as a minimum. During promotional periods (BFCM, sales, launches) hourly refresh becomes worth the cost because creative fatigue and inventory states change inside a day.

The common pitfall: averaging email-attributed and ad-attributed revenue together creates a number nobody can act on. Email and SMS need their own row in the dashboard because they're triggered by different events and respond to different optimizations. Combining them with paid acquisition revenue produces a blended number that hides which lever moves which outcome.

3. Agency multi-client dashboard

The weekly question: across all my clients, which accounts are healthy, which are at risk of churn, and where do I need to pull a creative or a budget conversation this week?

Agency dashboards have a structural problem that single-brand dashboards don't: the chart that means "great month" for client A might mean "panic" for client B, because they have different goals, different spend levels, and different KPIs that matter. The dashboard has to summarize health across accounts without flattening the differences.

KPIs to display:

• Account health indicator per client (green/yellow/red based on configurable thresholds against each client's own goals)
• Weekly spend vs budget by client, with pacing flag for over/under burn
• Aggregate CPL/CPA by client compared to that client's rolling 90-day baseline
• Top conversion channel per client this week (which platform is doing the work)
• Client-facing dashboard link per account (white-label embed or shared Looker Studio link)
• Account manager workload signal: which clients have launched campaigns in the last 14 days versus which haven't

Recommended layout:

• Top: traffic-light grid of all active clients with health indicator and short status note
• Middle: pacing table with spend vs budget % per client, color-coded
• Bar chart: week-over-week CPL/CPA delta per client, sorted by absolute change
• Drill-down: click a client to expand a per-account mini-dashboard (spend, conversions, top campaign, last creative refresh date)
• Filter controls: client multi-select, channel, account manager owner

Data sources: all paid platforms in use across the client portfolio (Google Ads, Meta Ads, LinkedIn Ads, TikTok Ads, Microsoft Ads, etc.), GA4 per client property, Search Console per client property, plus a client metadata table mapping account IDs to client names, budgets, and KPI thresholds.

Refresh cadence: daily for the health overview, hourly during active campaign launches for the affected clients only. The trap is refreshing every client hourly when most of them are on weekly review cycles.

The common pitfall: a single uniform template across all clients that hides each one's specific goals. A B2B SaaS client and a DTC fashion client should not be compared on the same set of KPIs in the same dashboard. The agency dashboard surfaces health flags; the per-client dashboard surfaces the actual numbers in that client's own framing.

4. B2B lead generation dashboard

The weekly question: where in the funnel from impression to closed deal are we leaking, and is the leakage in marketing, in SDR follow-up, or in sales close?

B2B dashboards have a longer time horizon than DTC. A click today becomes a lead tomorrow, an MQL next week, an SQL the week after, and a closed deal three months later. The dashboard has to show velocity through each stage, not just volume at each stage, or you'll optimize for top-of-funnel and starve the bottom.

KPIs to display:

• Lead volume by acquisition channel and campaign (LinkedIn, Google Ads, organic, referral, content)
• MQL → SQL conversion rate, segmented by lead source
• SQL → opportunity → closed-won rate, segmented by lead source
• Days-to-stage velocity: average time from MQL to SQL, SQL to opportunity, opportunity to close
• CPL by channel compared to that channel's blended CAC after considering close rate
• Pipeline value created this period, with channel attribution

Recommended layout:

• Top row: scorecards. Pipeline created this period, MQL→SQL conversion %, average sales cycle days
• Funnel diagram: stage-by-stage volumes with conversion percentages
• Heat map: channel × stage conversion rate (which channels close, which only top-of-funnel)
• Bar chart: blended CAC by channel (factoring close rate, not just CPL)
• Bottom row: SDR / AE workload by stage, deals stuck in stage longer than 14 days
• Filter controls: date range, channel, deal size segment, account owner

Data sources: HubSpot or Salesforce (lifecycle stages, deal amounts, sources), LinkedIn Ads, Google Ads, GA4 with form-fill conversion events, and a definitions table that maps platform-side ad campaign IDs to CRM source/medium values so the join works cleanly. The HubSpot side specifically requires the lifecycle velocity layer. See our HubSpot to Google Sheets RevOps guide for the data shape and joins. For the LinkedIn side, see our LinkedIn Ads to Google Sheets guide.

Refresh cadence: daily for pipeline and lead volume; weekly is fine for conversion rates and velocity because they don't move quickly. Hourly refresh is rarely worth the cost in B2B because the underlying sales cycle is measured in weeks.

The common pitfall: ignoring lead source quality decay over time. A channel that produced great leads six months ago may have shifted: audience saturation, creative fatigue, or a competing message in market degrades lead quality long before CPL itself moves. Track MQL→close rate per channel on a rolling 90-day window so you can catch quality drift before it shows up as missed pipeline. The lagging metric is closed-won revenue; the leading metric is the 90-day MQL→close trend per source.

5. Content and SEO-driven dashboard

The weekly question: which content pieces are driving qualified traffic that converts, and where are we losing rankings (or never had them) on the keywords that matter?

Content dashboards have to bridge two data layers that are usually kept apart: SEO performance (Search Console: queries, clicks, impressions, position) and behavioral conversion (GA4: sessions, signups, trials). A blog post with great traffic that never converts to product trials is a different problem from a blog post that converts at 8% but only has 200 monthly visitors. Both deserve attention, for different reasons.

KPIs to display:

• Organic clicks and impressions by landing page, week-over-week trend
• Average position for top 50 target queries, with movement flag (gained or lost > 3 positions)
• Conversion rate per blog landing page: sessions to product signups or trials
• Anonymized queries percentage: how much of your traffic Search Console hides (the <10 monthly impressions threshold). High anonymization means your reporting is incomplete and you should weight long-tail performance accordingly
• Content age curve: traffic by post age in months. Identifies the freshness decay rate for your domain
• Crawl budget signals for large sites: impressions on pages with very low average position (3+ pages of SERP back) suggesting indexation without intent match

Recommended layout:

• Top row: scorecards. Total organic clicks last 7 days, average position across top 50 queries, organic conversion rate
• Table: top 25 landing pages sorted by clicks, with conversion rate column, position delta column
• Movement alert: queries that gained or lost >3 positions in the last 28 days
• Anonymization indicator: percentage of impressions Search Console reports as anonymized for the period
• Cohort: post age vs clicks, showing the decay or growth curve for your content
• Filter controls: date range, page type (blog vs landing vs docs), country

Data sources: Search Console (queries, pages, performance), GA4 (sessions and conversions joined to landing page), Ahrefs or Semrush optionally for ranking history beyond Search Console's 16-month limit. For the connector specifics and the anonymized queries problem, see our Search Console to Google Sheets guide and GA4 to Google Sheets guide.

Refresh cadence: weekly is the right default. Organic positions don't move daily and looking at this dashboard daily creates noise. Exceptions: post launches, Google core updates, or major content publishing days where you want a check-in 48 hours later.

The common pitfall: reporting on organic traffic in aggregate without splitting it by intent. Trial-driving blog posts and brand-search hits both show up as "organic" in GA4 but represent completely different customer states. Segment by landing page intent (educational vs branded vs comparison) so you can see which type is moving.

To wire any of these layouts to live data, the connector layer underneath is what makes the dashboard maintainable. Connect the sources you need to Sheets, Looker Studio, BigQuery, or Power BI in minutes and skip the API maintenance.

Quick reference: which dashboard needs which destination

The complexity column tracks how many data sources you have to join and how clean the joins are. SaaS and ecommerce dashboards typically join 3-5 sources cleanly. Agency dashboards multiply that by the number of accounts. B2B is complex because CRM joins to ad platforms rarely have a clean shared key and you usually need a manual mapping table.

FAQ

A note on the numbers in this guide: ranges like trial-to-paid conversion (a few percent up to near 50%), repeat purchase rates, refresh cadence guidance, and warehouse thresholds reflect cross-industry benchmarks. Your account-specific numbers can sit well outside these ranges. Treat them as orientation, not as goals.

What's the difference between a SaaS dashboard and an ecommerce dashboard?
SaaS dashboards center on subscription funnel mechanics: trial-to-paid conversion, MRR, churn, dunning. Ecommerce dashboards center on transaction economics: ROAS, AOV, repeat purchase, LTV. They share the paid acquisition layer (Meta, Google Ads, etc.) but the back-end revenue layer is different. A SaaS dashboard built on ecommerce KPIs will hide your churn problem; an ecommerce dashboard built on SaaS KPIs will undercount your repeat-purchase economics.

How many dashboards should a marketing team maintain?
Three is usually the right number: a weekly executive overview, a per-channel deep-dive used by the team running that channel, and a per-vertical or per-client dashboard for stakeholders. Beyond three, maintenance starts consuming more time than insight. Combine related views in one dashboard with filter controls rather than multiplying separate files.

Should agencies build one universal dashboard or one per client?
Both. One agency-level dashboard for health overview across the portfolio (the layout in section 3 above), and one per-client dashboard tuned to that client's specific KPIs and goals. The agency dashboard is for internal account management; the per-client dashboard is for the client review. They serve different audiences.

What's the right refresh cadence for a marketing dashboard?
Daily is the right default for most paid acquisition data. Weekly is enough for SEO and content. Hourly only makes sense during active campaign launches, BFCM-style promotional windows, or live event coverage. Refreshing more often than the decision cadence creates noise without value.

Do I need a data warehouse to build these dashboards?
No, not for a single brand with under 10 data sources. Sheets or Looker Studio with direct connectors is sufficient. A warehouse becomes necessary when you cross any of these thresholds: more than 10 million rows in your most active table, more than 5 ad accounts joined to CRM, multi-year history beyond what each source retains, or stakeholders needing read-only access without source credentials. For the full warehouse decision framework, see our Marketing Data Warehouse 2026 Guide.

How do I avoid building a dashboard that nobody looks at?
Anchor the dashboard to a specific weekly question that has a decision attached. If looking at the dashboard doesn't change what anyone does this week, the dashboard is decoration. The five questions at the top of each section above are examples: each one connects to a budget shift, a creative kill decision, an SDR follow-up trigger, or a content priority change. Dashboards without decision triggers tend to fall out of use over time.

Conclusion

The five marketing dashboard examples above are templates, not exact prescriptions. The right dashboard for your team depends on which weekly question matters most and which decisions you make in front of the data. SaaS founders looking at trial conversion will build the funnel view first. DTC operators will build the channel ROAS plus retention cohort. Agency leads will build the multi-client health grid. B2B teams will build the pipeline velocity funnel. Content teams will build the page-by-page conversion table.

The connector layer underneath all five is the same: you need clean data from your paid platforms, your analytics, and (in three of the five) your CRM or subscription system, refreshed on a schedule, joined cleanly into the dashboard tool of your choice. That's the work that has to happen before any layout becomes useful, and it's the work that most marketing teams underestimate when they start.

Start a free Dataslayer trial to connect any of the data sources referenced above into Google Sheets, Looker Studio, BigQuery, or Power BI, and start building the layout your weekly question requires.