How to Create a Performance Dashboard in Looker

Creating a performance dashboard in Looker Studio transforms your raw data into a clear story about your business. Instead of jumping between platforms and wading through spreadsheets, a well-built dashboard gives you instant answers about what’s working. This guide provides a step-by-step walkthrough for building a helpful, real-time dashboard from scratch.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First, What Kinds of Questions Should a Dashboard Answer?

A performance dashboard isn’t just a random collection of charts, it’s a tool designed to help you make faster, smarter decisions. Its primary job is to monitor your progress toward specific business goals by tracking key performance indicators (KPIs).

Before you ever drag and drop a single chart, your dashboard should be able to answer questions like:

• Are we on track to hit our monthly traffic and sales targets?
• Which marketing channels are driving the most valuable leads?
• How did our latest product launch impact website engagement?
• Where are our website visitors coming from, and which pages are they visiting most?

A good dashboard turns these complex questions into simple, visual answers that you can understand in less than a minute. It eliminates the manual work of pulling reports so you can spend your time acting on the insights, not just finding them.

Before You Build: Planning Your Dashboard

The success of your dashboard happens before you open Looker Studio. A few minutes of planning will save you hours of rebuilding and ensure you create something genuinely useful. Ask yourself three critical questions.

1. What is the dashboard's purpose?

Start with the end in mind. What decisions will this dashboard help you or your team make? Are you trying to monitor daily marketing campaign spending, track quarterly sales goals, or analyze website user behavior? Defining a single, clear purpose helps you stay focused and avoid a cluttered dashboard that tries to do everything and accomplishes nothing.

• Good example: "To monitor the performance of our Q2 content marketing efforts by tracking traffic, engagement, and leads from blog posts."
• Bad example: "To show all our marketing data."

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

2. Who is the audience?

A dashboard for your company’s CEO looks very different from one for your social media manager. The audience determines the level of detail and the specific metrics you’ll display.

• Executives: Need a high-level overview. They care about summary KPIs like total revenue, customer acquisition cost (CAC), and marketing ROI.
• Marketing Managers: Need more detailed performance data to manage campaigns. They’ll want to see channel performance, conversion rates, and cost per lead.
• Specialists (e.g., SEO or PPC): Need granular, real-time data on their specific area. An SEO specialist needs to see keyword rankings, organic traffic trends, and top landing page performance.

Design your dashboard to give your specific audience the answers they need, in a language they understand.

3. Which metrics matter most?

Based on your purpose and audience, select a handful of KPIs that truly measure success. Avoid "vanity metrics" that look nice but don’t reflect business value (like social media impressions without clicks or engagement).

For a web performance dashboard, for example, your essential KPIs might be:

• Users: How many unique individuals are visiting your site.
• Sessions: The total number of visits.
• Conversion Rate: The percentage of visitors who complete a goal (e.g., make a purchase, fill out a form).
• Traffic Source / Medium: Where your visitors are coming from (e.g., Google / organic, Facebook / social).
• Top Landing Pages: The most popular entry pages on your website.

Choose 5-7 core metrics to form the foundation of your dashboard. You can always add more detail later, but starting simple is the best approach.

Step-by-Step: Building Your Performance Dashboard in Looker Studio

With our plan in place, it’s time to start building. For this walkthrough, we’ll create a basic website performance dashboard using a Google Analytics 4 data connection.

Step 1: Create a New Report and Connect Your Data

First, go to Looker Studio and click Blank Report. You’ll immediately be prompted to add a data source.

1. Search for and select the "Google Analytics" connector.
2. Authorize Looker Studio to access your Google account if you haven’t already.
3. Select the GA4 Account and Property you want to pull data from.
4. Click Add to connect it to your report. The data source is now available for you to use in any chart.

Looker Studio makes this incredibly easy for Google products. The process is similar for other sources like Google Ads, BigQuery, and Google Sheets. For non-Google sources like Facebook Ads or Shopify, you often need a third-party connector.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Add a Title and Date Range Control

Good dashboards are organized and user-friendly. Start by giving your dashboard a clear title (e.g., "Website Performance Overview").

Next, and most importantly, add a date range control. This filter is essential as it allows you (and anyone you share the report with) to analyze performance for specific timeframes — like "Last 7 Days" or "This Quarter." You can find it under Add a control > Date range control.

Step 3: Display High-Level KPIs with Scorecards

Scorecards are perfect for showing your main metrics at a glance. Place them right at the top of your report so the most important numbers are seen first.

1. Go to Insert > Scorecard.
2. By default, it may show a metric like "Views." Don’t worry. Click on the scorecard to select it.
3. In the Properties panel on the right, under "Metric" find and select Total users.
4. Copy and paste this scorecard two more times. Change the metric on the new scorecards to Sessions and Conversions.

You now have three clear KPIs at the top, telling you exactly how many people visited, how many total visits occurred, and how many times your primary goals were completed.

Step 4: Visualize Trends with a Time Series Chart

Next, you’ll want to see how one of your KPIs is trending over time. A time series (or line) chart is the best way to do this.

1. Go to Insert > Time series chart.
2. Place it right below your scorecards.
3. In the Properties panel, make sure the "Dimension" is set to Date. For the "Metric," choose Sessions.

Now you can immediately spot trends, seasonality, or the impact of a recent marketing campaign on your site traffic. Did traffic spike after you sent an email newsletter last Tuesday? This chart will show you.

Step 5: Compare Sources with a Bar Chart

It’s important to know where your traffic is coming from. A bar chart is an effective way to compare the performance of different channels.

1. Go to Insert > Bar chart.
2. Set the "Dimension" to Session source / medium to see the origin of your traffic.
3. Set the "Metric" to Total users to see how many people each channel drives.
4. From the Style tab, you can add data labels to see exact numbers on each bar automatically.

You can now easily compare whether organic search, paid ads, or social media is your biggest traffic driver.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 6: Add a Table for Granular Details

Finally, a table is great for showing more detailed information. Let’s create a table to see which landing pages are performing the best.

1. Go to Insert > Table.
2. For the "Dimension," choose Page path and screen class.
3. For the "Metrics," add Views, Sessions, and Conversions. You can add or remove metrics in the panel on the right.

This table gives you actionable insight into your content. You can see which pages attract the most attention and which ones are effective at converting visitors, helping you decide where to focus your marketing efforts.

Further Polish and Design

Take a few moments to organize your charts and make the dashboard clean and professional. Drag the corners to resize visualizations, align objects using the grid guides, and use the Text tool to add headings for each section.

Final Thoughts

By following these steps, you’ve moved beyond simply looking at data and started creating a dynamic tool for analysis. This basic framework helps you plan with purpose, build a functional dashboard in Looker Studio, and generate real insights that can steer your business decisions in the right direction.

Thinking through audience needs and mastering the clicks in a BI tool is a fantastic skill. At the same time, we know that marketers and founders are often overwhelmed and just need to get quick answers to keep their campaigns and business moving. That's why we built Graphed. We wanted to eliminate the manual setup and maintenance so you can skip right to the insights. Just connect your platforms like Google Analytics, Shopify, or Facebook Ads, and then ask questions in plain English like, "show me top-performing landing pages by conversions this month as a table" and get your answer, as a chart, in seconds.