How to Create a SaaS Dashboard in Looker

Building a powerful SaaS dashboard in Looker can transform how you see your business, turning raw data into clear, actionable insights on everything from monthly recurring revenue to customer churn. This guide will walk you through the essential steps to plan, build, and refine a SaaS dashboard in Looker that your entire team can rely on.

Graphed

AI Data Analyst for Growth Teams

Get the insights your sales and marketing teams need to grow your business faster.

• Unify your data in one place in 15 minutes
• Conversational analytics, live dashboards, charts & reports
• Connect our MCP to Claude or ChatGPT

Get Started for Free

First Things First: What Should Go on a SaaS Dashboard?

Before you even open Looker, the most important step is deciding what you want to measure. A dashboard cluttered with dozens of metrics is just as useless as no dashboard at all. The goal is clarity, not complexity. Your dashboard should tell a story about your business's health and point you toward your next best move.

While every business is different, most successful SaaS dashboards track a focused set of key performance indicators (KPIs). Here are the essentials to consider:

• Monthly Recurring Revenue (MRR): The lifeblood of any subscription business. It's the predictable revenue you can expect every month. Tracking its trend shows your growth trajectory.
• Annual Recurring Revenue (ARR): This is your MRR multiplied by 12, giving a broader view of your yearly revenue scale.
• MRR Growth Rate: Tracks the month-over-month percentage increase in your MRR. This is a critical indicator of your growth velocity.
• Customer Lifetime Value (LTV): The total revenue you can expect from a single customer account throughout their time with you. A rising LTV is a sign of a healthy, valuable customer base.
• Customer Acquisition Cost (CAC): The total cost of sales and marketing to acquire a new customer. A core goal is to keep your LTV significantly higher than your CAC.
• Churn Rate: The percentage of customers or MRR lost during a specific period. You should track both Logo Churn (number of customers) and Revenue Churn (amount of MRR).
• Lead Velocity Rate (LVR): This metric measures the growth in qualified leads month-over-month and can be a great leading indicator of future sales.
• Average Revenue Per Account (ARPA): This gives you a clear sense of the relative value of your average customer account, allowing you to identify trends in new contract deal size over time.

Start by picking the 5 to 7 metrics that align most closely with your current business goals. Are you focused on rapid user acquisition? Prioritize CAC and new sign-ups. Working on retention? Churn and LTV should be front and center.

Setting Up Your Data in Looker: The Foundation

Looker is a powerful tool, but it works best when it has a well-structured foundation. This foundation is built on Looker's modeling layer, called LookML. Don't let the name intimidate you, it's a way to define your business logic once so that everyone in the company reports on the same, accurate numbers.

Graphed

AI Data Analyst for Growth Teams

Get the insights your sales and marketing teams need to grow your business faster.

• Unify your data in one place in 15 minutes
• Conversational analytics, live dashboards, charts & reports
• Connect our MCP to Claude or ChatGPT

Get Started for Free

Connecting Your Data Source

Your first step inside Looker is connecting it to your business database. This is typically a cloud data warehouse like Google BigQuery, Snowflake, Amazon Redshift, or a PostgreSQL database where your application data (users, subscriptions, events, etc.) lives. This is done in the Admin > Database > Connections section of Looker.

A Simple Introduction to LookML

LookML (Looker Modeling Language) is how you describe your data to Looker. Instead of writing complex SQL queries every time you want to build a chart, you define your data fields and their relationships in a LookML file. This creates a powerful, reusable model for analytics.

Think of it in two main parts:

• Views: A view file typically corresponds to a single table in your database, like a users table or a subscriptions table. Here you define Dimensions and Measures.
• Dimensions: These are the "group by" fields you use for filtering and segmenting. Think user ID, subscription plan type, sign-up date, or country.
• Measures: These are the quantifiable metrics you want to analyze, like the count of users, the sum of MRR, or the average subscription length.

Creating an "Explore" for SaaS Metrics

An "Explore" is where you join different views together so you can analyze data across multiple tables. For a SaaS dashboard, you'll likely want to create an Explore that joins your users, subscriptions, and maybe a payments or events table.

This joining process allows you to answer questions that span different datasets, like "What is the average lifetime value of customers who signed up in the last six months?" or "Which marketing channel brings in users with the highest MRR?"

Once your basic Views and Explores are set up in LookML, the fun part of building the actual dashboard can begin.

Graphed

AI Data Analyst for Growth Teams

Get the insights your sales and marketing teams need to grow your business faster.

• Unify your data in one place in 15 minutes
• Conversational analytics, live dashboards, charts & reports
• Connect our MCP to Claude or ChatGPT

Get Started for Free

Step-by-Step Guide to Building Your SaaS Looker Dashboard

With your data model ready, you're now set to build the visualizations that will populate your dashboard. In Looker, each chart or table on a dashboard is called a "Tile."

Step 1: Start Building from an Explore

Navigate to the "Explore" section and select the data Explore you created for your SaaS metrics. This will take you to the Explore interface, with your defined Dimensions and Measures available in the left-hand panel.

Step 2: Create Your First Tile (Example: MRR Trend)

Let's build a classic line chart showing your monthly recurring revenue over time. It's one of the most important charts for any SaaS business.

1. Select your Dimension: In the left panel, find your subscriptions view. Click on a date dimension, like Subscription Created Date. Looker will automatically let you group this by different timeframes. Choose "Month."
2. Select your Measure: Next, find the measure you defined for recurring revenue, such as Total Monthly Recurring Revenue. Select it.
3. Run the Query: Click the "Run" button. Looker will generate a data table showing MRR for each month.
4. Choose Your Visualization: Below the data table, click on the visualization options. Select the Line Chart icon. Looker will instantly convert your data into a visual chart.
5. Customize: Use the settings (gear icon) in the visualization tab to clean up your chart. You can adjust colors, add axis labels (e.g., "Month" and "MRR ($)"), and give your chart a clear, descriptive title like "MRR Trend Over Time."

Step 3: Save Your Visualization to a Dashboard

Once you're happy with your MRR chart, it's time to add it to your dashboard. In the top-right corner of the Explore page, click the gear icon and select "Save to Dashboard."

A dialog box will appear. You can add it to an existing dashboard or type in a new name, like "SaaS Key Metrics," to create a new one. Click "Save," and your first tile is now live.

Step 4: Add More Tiles for Other KPIs

Repeat the process from Step 2 to build out the other KPIs you planned to track. Here are a few examples:

• Churn Rate: A bar chart with Month as the dimension and your Churn Rate % measure.
• New Customers by Plan: Create a stacked bar chart showing the count of new customers per month (Dimension: Sign-up Month, Measure: User Count), stacked by Subscription Plan (another Dimension).
• CAC vs. LTV: A combination chart with Month on the X-axis and two series on the Y-axis - LTV and CAC - to see if the gap between them is widening.

The key is to rinse and repeat: start in Explore, select fields, run, visualize, customize, and save to your dashboard.

Graphed

AI Data Analyst for Growth Teams

Get the insights your sales and marketing teams need to grow your business faster.

• Unify your data in one place in 15 minutes
• Conversational analytics, live dashboards, charts & reports
• Connect our MCP to Claude or ChatGPT

Get Started for Free

Step 5: Arrange and Filter Your Dashboard

Once you have several tiles, go to the dashboard itself. You can enter "Edit Mode" to drag, drop, and resize tiles to organize them logically. A good practice is to put your most important KPIs (like a big number display of current MRR) at the top.

Finally, add dashboard-level filters. This is one of Looker's most powerful features. You can add a filter for the Date Range, allowing any viewer to adjust the timeframe of the entire dashboard with one click. Other useful filters for a SaaS dashboard include Customer Segment, Plan Type, or Country.

Advanced Tips for a Better Dashboard

A basic dashboard is good, but a great dashboard tells a story and is easy to use. Here are a few tips to take it to the next level.

• Use Table Calculations: For quick metrics like period-over-period growth, you can use "Table Calculations" directly in the Explore interface without needing to update your LookML. It allows you to create custom formulas right on the fly.
• Organize Visually: Group related tiles together. Place all your growth metrics in one row, retention metrics in another, and profitability metrics on a third. Use text tiles to add headings and brief explanations for each section.
• Leverage Color: Use color purposefully. For example, use green for positive trends like MRR growth and red for negative ones like churn. Be consistent in your color choices across the entire dashboard.
• Set up Alerts and Schedules: Make your dashboard proactive. You can schedule it to be sent as a PDF to your executive team every Monday morning. Even better, you can set up Alerts to get a notification if a key metric (like new sign-ups) drops below a certain threshold.

Final Thoughts

Creating a SaaS dashboard in Looker is an incredibly valuable exercise that brings your business data to life. It moves your team from guessing to knowing, allowing everyone to make data-informed decisions based on a single source of truth. By planning your metrics carefully and following these steps, you can build a reporting tool that actively helps you grow your business.

While Looker is a fantastic tool for deeply technical teams, not everyone has the time to learn LookML or the resources for a data engineer to set it all up. We created Graphed to remove that complexity entirely. Instead of writing code, you just connect your SaaS and marketing data sources and ask questions in plain English, like "Show me a dashboard of my MRR, churn rate, and LTV for the last six months." Our AI handles the rest, building a live, interactive dashboard for you in seconds, freeing you up to focus on the insights, not the setup.