Marketing Dashboard Design Guide: Build Dashboards People Actually Use

Marketing dashboard design is where most analytics work goes to die. The team spends weeks building elaborate dashboards. The dashboards get bookmarked. Then nobody opens them. Six months later somebody asks "do we even use this?" and the project quietly disappears.

The problem is rarely the data. It's the dashboard design — too many metrics, no clear question being answered, no actionable next step, no consistent rhythm of use.

This guide covers marketing dashboard design from first principles. KPI selection, layout patterns, tool choices (Looker Studio, Power BI, Tableau), and the design rules that make dashboards genuinely useful rather than decorative.

The work is mostly clarity of thought. Done right, a well-designed dashboard becomes the single source of truth for a marketing team's weekly decisions.

Why most marketing dashboards fail

Most dashboards we audit share the same problems.

Too many metrics

A dashboard with 47 charts forces the viewer to find the signal in the noise. Most people give up.

No clear audience

A dashboard built for "everyone" serves no one. Different stakeholders need different views.

No actionable framing

Metrics shown without context don't tell the viewer what to do. A 12 percent CTR is good or bad depending on the campaign type.

Data without comparison

A number alone is meaningless. "247 leads this month" — compared to what? Last month? Target? Industry benchmark?

No regular cadence of review

Dashboards consulted irregularly become outdated mentally. Weekly review beats sporadic checking.

We covered the broader KPI framework in our marketing KPIs selection guide. Dashboards are the surface that brings KPIs to decisions.

The four dashboard archetypes

Most marketing dashboards fit one of four archetypes. Pick the right one before designing.

1. Executive overview

Audience: leadership, stakeholders. Frequency: monthly.

Purpose: show whether marketing is delivering against business goals.

Content: 5 to 8 top-level metrics, period comparisons, traffic light status indicators.

2. Channel deep dive

Audience: channel manager or marketing operations. Frequency: weekly.

Purpose: monitor and optimise a specific channel's performance.

Content: channel-specific KPIs, campaign-level breakdowns, recent changes, alerts on anomalies.

3. Campaign performance

Audience: campaign owner. Frequency: daily during active campaigns.

Purpose: track campaign progress against targets in real-time.

Content: campaign-level metrics, day-over-day trends, projection toward goal.

4. Diagnostic

Audience: analyst or anyone investigating an issue. Frequency: as-needed.

Purpose: drill into specific patterns or anomalies.

Content: filterable views, raw data access, correlation analysis.

Most teams need all four. Mixing them into one dashboard is the most common design failure.

Section 1 — Picking KPIs for your dashboard

The single most important design decision. Wrong KPIs make the dashboard useless regardless of design.

Start with the decision the dashboard supports

Before listing KPIs, define: "What decision does this dashboard help us make?"

Examples:

• "Are we on track to hit our quarterly lead target?"
• "Is our Google Ads spend producing acceptable CPL?"
• "Which content topics drive the most qualified leads?"
• "Where is our funnel leaking conversion rate?"

If the dashboard doesn't directly support a recurring decision, it's a vanity dashboard.

The 5-metric rule

A useful dashboard answers a primary question with 5 or fewer top-level metrics.

For an executive overview:

• Total revenue this month
• Marketing-attributed revenue
• Cost of marketing
• Marketing-attributed revenue divided by marketing cost (ROAS or ratio)
• One leading indicator (pipeline, leads, etc.)

For a Google Ads channel dashboard:

• Spend (vs budget)
• Conversions (vs target)
• Cost per conversion
• Conversion rate
• Impression share lost to budget

Pick the 5 that matter. Demote everything else to secondary or remove entirely.

Lagging vs leading indicators

Lagging indicators measure outcomes after they happen (revenue, conversions). Leading indicators predict future outcomes (clicks, qualified leads, engagement).

A good dashboard has both. Lagging shows results. Leading enables intervention before results are locked in.

Section 2 — Layout principles

The visual structure of a dashboard determines whether viewers can extract insights quickly.

Most important metric top-left

Most viewers' eyes go to the top-left first. Place the single most important metric there.

For an executive overview: total revenue. For a Google Ads dashboard: cost per conversion. For a content dashboard: organic traffic to revenue conversion.

F-pattern reading

Viewers scan in an F-pattern: across the top, then partway down and across, then down the left side.

Place metrics in F-pattern order of importance. The "below the fold" sections get less attention.

Period comparisons everywhere

Every metric should have a comparison:

• vs previous period (last 30 days vs prior 30 days)
• vs target (current vs goal)
• vs prior year (year-over-year)

A number alone is meaningless. A number with comparison is informative.

Visual hierarchy

Big numbers for top-level metrics. Smaller charts for supporting context. Detailed tables for diagnostic data.

Don't make every chart the same size. Visual hierarchy signals importance.

Color with intent

Reserve color for emphasis:

• Red for negative deviations from target
• Green for positive deviations
• Brand color for primary KPIs
• Neutral grey for context

Rainbow dashboards with every chart in different colors create visual noise.

Section 3 — Tool selection

The dashboard tool matters less than the dashboard design. Pick based on practical constraints.

Free / built-in tools

Looker Studio (formerly Data Studio):

• Free, integrates natively with GA4, Google Ads, Search Console
• Good for marketing dashboards under 10 sources
• Limited custom visualisation options
• Adequate for SME analytics teams

Google Sheets with charts:

• Surprisingly capable for simple dashboards
• Easy to share and collaborate
• Limited automation, manual data refresh

Mid-tier ($20 to $200/user/month)

Power BI:

• Excellent integration with Microsoft stack
• Strong DAX for complex calculations
• Better visualisations than Looker Studio
• Free desktop version, paid for sharing

Tableau:

• Industry standard for advanced visualisation
• Steep learning curve
• Expensive at scale

Modern alternatives

Metabase (open source or hosted):

• SQL-friendly, simple BI
• Free open-source version, paid cloud

Mode Analytics:

• Analyst-friendly, SQL + Python notebooks
• Good for teams with analytics talent

Whatagraph, AgencyAnalytics, Klipfolio:

• Agency-focused, pre-built marketing connectors
• Less flexible than general BI tools

For most SMEs

Looker Studio covers 80 percent of marketing dashboard needs at zero cost. Upgrade to Power BI or Metabase when you need:

• More than 10 data sources combined
• Complex calculated metrics that Looker Studio cannot express
• Better performance on large datasets
• More polished visualisations

Section 4 — Data sources and connections

Dashboards live or die based on data source reliability.

Native connectors first

Use built-in connectors when available:

• GA4 → Looker Studio (native)
• Google Ads → Looker Studio (native)
• Search Console → Looker Studio (native)
• Meta Ads → Looker Studio (third-party)
• LinkedIn Ads → Looker Studio (third-party)

Native is faster, more reliable, and less maintenance than third-party.

Connector hubs

When native isn't enough, use a hub like Supermetrics, Funnel, or Improvado:

• Aggregate 50+ marketing sources
• Push to your BI tool of choice
• Handle schema mapping and refreshes

For a typical SME, a hub costs €50 to €200/month and saves 5 to 10 hours of weekly data engineering.

BigQuery as a warehouse

For more complex setups, route all sources through BigQuery:

• GA4 export (free)
• Google Ads transfer
• Meta export via connector
• Custom data via APIs

Then connect Looker Studio or Power BI to BigQuery. Clean, scalable, fast.

We covered the broader caching and infrastructure context in our caching strategies for web performance guide. The same principles apply to dashboard data infrastructure.

Refresh frequency

Set refresh based on actual decision cadence:

• Daily for real-time campaign monitoring
• Hourly during active launches
• Weekly for executive overview
• Monthly for board-level reporting

Faster refresh = higher infrastructure load. Match it to need.

Section 5 — Filters and interactivity

A dashboard with filters is more useful than a static one — when filters are well-designed.

Essential filters for marketing dashboards

• Date range (always)
• Channel (Google Ads, Meta, Organic, etc.)
• Campaign (drill into specific campaigns)
• Device (desktop, mobile, tablet)
• Geography (country, region, city)

Filter design rules

• Place filters at the top of the dashboard, visually distinct
• Use sensible defaults (last 30 days, all channels)
• Allow saving filter states for return visits
• Cascade filters where appropriate (selecting Google Ads as channel reveals only Google Ads campaigns)

Drill-down patterns

Allow clicking on a chart to filter the rest of the dashboard. Click on "Google Ads" in the channel chart → entire dashboard filters to Google Ads.

This pattern turns one dashboard into many without requiring separate pages.

Section 6 — Annotations and context

Numbers alone don't tell stories. Annotations add the missing context.

Mark significant events

Major launches, algorithm changes, budget shifts, agency changes. Annotate them on the timeline so future viewers see the cause of pattern shifts.

In Looker Studio: annotations are limited. Use text boxes positioned by date for the same effect.

Add target lines to charts

"Target: 200 leads/month" as a horizontal line on the leads chart immediately tells you whether you're tracking above or below.

Use traffic-light status indicators

For executive overviews, traffic lights cut through detail:

• Green: above target
• Yellow: near target, monitoring
• Red: below target, attention needed

A row of traffic lights at the top of an executive dashboard makes the "are we on track?" question take 3 seconds to answer.

Document KPI definitions

A small "i" icon next to each KPI showing what it measures and how it's calculated. Critical for dashboards used by multiple stakeholders with different background knowledge.

Section 7 — Mobile and responsive dashboards

Most dashboards are viewed on mobile by executives between meetings.

Design mobile-first for executive dashboards

If your executive dashboard is unreadable on phone, it won't be used between meetings. Design mobile-first.

Looker Studio mobile mode

Looker Studio supports mobile-specific layouts. Use it for executive dashboards.

Limit charts per mobile view

3 to 5 charts per mobile screen maximum. Above that, scrolling fatigue kills usage.

Sharing format

Most dashboards are shared via link. For executive dashboards, consider:

• Weekly email snapshot (image + key numbers)
• Slack/Teams integration with weekly summaries
• PDF export for board meetings

The dashboard exists where decisions happen, not just in the browser.

Section 8 — Dashboard governance

Without governance, dashboards multiply uncontrolled.

One owner per dashboard

Every dashboard has a named owner responsible for maintenance, accuracy, and removal.

Without an owner, broken dashboards stay broken because no one fixes them.

Quarterly review

Every quarter, review:

• Is each dashboard still being used?
• Are the KPIs still relevant?
• Are the data sources still accurate?
• Should any dashboards be archived?

Most teams discover 30 to 60 percent of their dashboards are unused after honest review.

Naming convention

[Audience] - [Topic] - [Frequency]

Examples:

• Executive - Marketing Overview - Monthly
• CRO Team - Funnel Analysis - Weekly
• Performance - Google Ads - Daily

Predictable names make finding dashboards easier.

Folder structure

Organise dashboards by:

• Audience (executive, operations, analyst)
• Or function (paid, organic, content, sales-funnel)

Pick one and apply consistently.

A 30-day dashboard project plan

If you're building a new marketing dashboard or rebuilding existing ones, follow this sequence.

Days 1 to 3 — Decision audit. Document the recurring decisions the team makes weekly and monthly. Pick the top 3 to 5.

Days 4 to 7 — KPI selection. For each decision, identify the 5 metrics that would change the answer. These become your KPIs.

Days 8 to 12 — Data source setup. Connect Looker Studio (or chosen tool) to your data sources. Verify accuracy by comparing to platform-native reports.

Days 13 to 18 — Build version 1. Top-left primary KPI, F-pattern layout, period comparisons, traffic-light status. Mobile-friendly.

Days 19 to 23 — Test with users. Show the dashboard to 3 to 5 intended users. Ask what's missing, what's confusing, what's unnecessary. Iterate.

Days 24 to 28 — Polish. Annotations, target lines, KPI definitions. Make it production-ready.

Days 29 to 30 — Roll out. Set the recurring review cadence. Train the team on use. Establish the owner.

Most dashboards take 30 days from concept to production-ready. The discipline is in the user testing — most dashboards fail because they were built without input from intended users.

A real example — Marseille cosmetics executive dashboard

We built an executive marketing dashboard for a Marseille cosmetics e-commerce client. Previous setup: 8 separate Looker Studio dashboards, none consistently used, executive complaints about "too many numbers".

After 21 days of redesign — single executive dashboard with 5 KPIs (revenue, ROAS, AOV, new vs returning customer ratio, marketing efficiency ratio), traffic-light status indicators, mobile-friendly layout, weekly automated email snapshot — the executive started consulting the dashboard weekly before her weekly marketing meeting.

The dashboard surfaced a pattern: new customer acquisition cost was rising while returning customer revenue was flat. The team shifted budget toward retention campaigns. Returning customer revenue rose 22 percent over the next 60 days. The full story is in our Marseille cosmetics case study.

Common dashboard mistakes

These are the patterns we see most often.

Too many metrics. 5 KPIs maximum at the top level.

No comparison. Numbers without "vs target" or "vs prior period" are meaningless.

No clear owner. Broken dashboards stay broken.

Built without user input. Dashboards designed in isolation rarely match user needs.

Mobile unfriendly. Executive dashboards must work on phones.

No update cadence. Dashboards not on a review schedule become stale.

Tool over substance. Sophisticated tool with poor design beats simple tool with good design rarely.

Frequently asked questions

How many marketing dashboards should a typical SME have?

3 to 5 in active use. One executive overview, one or two channel-specific (Google Ads, organic), one campaign performance, optionally one diagnostic.

Is Looker Studio enough for SME marketing dashboards?

Yes for most. Power BI or Metabase make sense when you have 10+ data sources, need complex calculations, or want polished visualisations.

How often should I update dashboard data?

Match refresh to decision cadence. Daily for campaign monitoring, weekly for channel optimization, monthly for executive overview.

Should I show negative data on dashboards?

Yes. Hiding bad news from dashboards destroys trust. Show it with context (why it happened, what's being done).

Can I automate dashboard creation?

For some dashboards yes — tools like Whatagraph and AgencyAnalytics offer template-based generation. Custom dashboards still benefit from human design.

Should I include cost data on dashboards?

For internal marketing dashboards, yes — cost is essential for ROAS and efficiency metrics. For shared dashboards with external partners, mask sensitive cost data.

Get a dashboard design audit

We audit existing dashboards and propose redesigns free of charge. Within 48 hours we deliver a critique of current dashboards and a redesign plan focused on the decisions your team makes.

Book a free 30-minute audit. We screen-share, walk through your current dashboards and decision processes, and you leave with a clear plan.

Or explore our Google Ads service for the full system we run on accounts that need integrated paid media and analytics.