How to Create a Revenue Dashboard in Looker with AI

Building a revenue dashboard shouldn't feel like a side job. Getting a clear, real-time picture of your company's financial health is fundamental, but stitching it together from different platforms can be a manual, time-consuming slog. This article will walk you through how to create a powerful and insightful revenue dashboard in Looker (now part of Google Cloud), using its built-in intelligent features to streamline the process and uncover trends.

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 Things First: Planning Your Revenue Dashboard

Jumping straight into building a dashboard without a plan is like starting a road trip without a map. Before you touch any data, take a moment to define what you actually need to see. A focused dashboard is an effective dashboard.

Identify Your Key Revenue Metrics

What numbers matter most to your business? Your revenue dashboard should answer your most critical financial questions at a glance. Think about the story you want your data to tell. Here are some essential metrics to consider:

• Overall Revenue: The big-picture number, often tracked over time (daily, weekly, monthly).
• Revenue by Source/Channel: Which marketing or sales channels are driving the most income (e.g., Organic Search, Paid Social, Email Marketing, Direct Sales)?
• Monthly Recurring Revenue (MRR) / Annual Recurring Revenue (ARR): Absolutely critical for any subscription-based business.
• Average Revenue Per User (ARPU): Helps you understand the value of an average customer.
• Product or Service Revenue: Which of your offerings are the top performers?
• Revenue by Region: Are there geographic areas that are outperforming others?
• Conversion Rate: What percentage of visitors or leads are turning into paying customers?

Sketch It Out

You don't need fancy design software. Grab a pen and paper or open a simple digital whiteboard. Sketch out a rough layout of your dashboard. Where do you want your most important, top-level numbers to live? Most dashboards have key performance indicators (KPIs) in large, single-number formats across the top, followed by more detailed charts and tables below. This simple exercise helps clarify your vision before you get lost in configuration menus.

Creating Your Revenue Dashboard in Looker: A Step-by-Step Guide

With a clear plan in place, you’re ready to start building. Looker is powerful because it connects directly to your database, providing a single source of truth that powers all your reports. The setup involves a few distinct stages, from modeling your data to building the actual visualizations.

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 1: Connect Your Data and Define Metrics in LookML

Unlike some tools that have you wrestle with raw data for every chart, Looker uses a modeling layer called LookML. Think of LookML as your company’s custom data dictionary. It's a central hub where your data team defines all your business logic and metrics once.

For example, your LookML model is where you would write the definition for "Total Revenue" as SUM(order_price). Once defined, anyone at the company who uses "Total Revenue" in a report is using that exact same calculation. This eliminates the classic problem where the sales team's revenue number doesn't match the finance team's because they're calculating it differently.

While learning LookML is a developer-focused task, understanding its role is important. It's the "brain" that makes your dashboard reliable and consistent. A well-built LookML model is what makes self-service analytics and even Looker's AI features possible for the rest of the team.

Step 2: Start Building Visualizations with "Explores"

Once your LookML model is set up, building charts and graphs becomes much easier. In Looker, you start creating visualizations inside of an "Explore." An Explore is a user-friendly, point-and-click interface that lets you, well, explore your data.

1. Navigate to the Explore section in Looker and choose the relevant data model (e.g., "Sales Data").
2. On the left side, you'll see a list of Dimensions (the attributes you group by, like "Date," "Marketing Channel," or "Country") and Measures (the values you calculate, like "Total Revenue" or "Number of Orders").
3. Simply click the fields you want to include in your analysis. To see revenue over time, you might select "Order Date" as a dimension and "Total Revenue" as a measure.
4. Click the Run button. Looker queries your database directly and returns the results.

Step 3: Choose the Right Chart Type

By default, Looker will show your results in a table. The magic happens when you visualize it. Use the "Visualization" tab to select the best chart type for your data:

• Line Chart: Perfect for tracking a metric over time, like your MRR growth over the last 12 months.
• Bar/Column Chart: Great for comparing values across categories, like Revenue by Marketing Channel.
• Pie Chart: Use sparingly, but it can be effective for showing the composition of a whole, such as the percentage of revenue from different product categories.
• Single Value: Ideal for displaying a single, important KPI at the top of your dashboard, like total revenue for the current quarter.

Once you've created a visualization you like, give it a title (e.g., "Monthly Revenue Trend") and save it as a "Look."

Step 4: Assemble Your Dashboard

Now it's time to bring all your individual Looks together into a cohesive dashboard.

1. Click New > Dashboard from the main navigation.
2. Give your dashboard a name, like "Q3 Revenue Dashboard."
3. Click Add Tile and choose to add one of the Looks you just saved. You can also build new tiles directly from this view.
4. Repeat this process for all your planned charts and KPIs. Drag and drop the tiles to arrange them according to your initial sketch. Resize them as needed to create a clean, organized layout.

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 5: Add Interactive Filters

A static dashboard is useful, but an interactive one is empowering. Filters allow you and your team to slice and dice the data without needing to create new reports. A common filter for a revenue dashboard is the date range.

When creating a filter, you can link it to the relevant date field on each of your dashboard tiles. Now, an end-user can select "Last 90 Days" or a custom date range from a single dropdown, and every chart on the dashboard will update automatically. You can do the same for region, campaign name, or any other important dimension.

Using Looker's "AI" and Smart Features

Connecting data and building charts is the foundation, but modern BI tools have intelligent features that take your analysis to the next level. Looker integrates parts of Google's AI model, Gemini, to help you get answers more naturally and proactively.

Chat with Your Data for Quick Answers

Sometimes you need an answer to a one-off question and don't want to build a whole new chart. Within an Explore, Looker integrates natural language querying. You can simply type a question in plain English, such as: "What was our total revenue from the United Kingdom last month?"

Looker will interpret your request, select the right dimensions and measures, and generate the data for you. From there, you can turn that result into a dashboard tile with a single click. This feature empowers less technical team members to get answers on their own, without having to navigate menus or ask a data analyst for help.

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

Spot Future Trends with Forecasting

For line charts and other time-series visualizations, Looker can add a built-in forecast. With a few clicks in the visualization settings, you can ask Looker to project future performance based on your historical data.

This is incredibly useful for a revenue dashboard. It can help you estimate whether you're on track to meet your quarterly goals or spot a potential downturn before it happens. While it's not a crystal ball, it provides a data-driven projection that can inform your strategy.

Get Proactive with Alerts

Instead of checking your dashboard every hour, you can have insights come to you. Looker allows you to set up alerts on your tiles. For instance, you can create an alert on your "Daily Sales Revenue" tile that sends you a Slack message or an email if the value drops below a certain threshold for two consecutive days.

This turns your dashboard from a reactive reporting tool into a proactive monitoring system, ensuring you never miss a significant change in performance.

Final Thoughts

Building a revenue dashboard in Looker organizes your most critical financial data into a single source of truth, enabling better, faster decision-making for your entire team. By blending traditional dashboard creation with smart features like natural language queries and proactive alerts, you move from just looking at what happened to understanding what's happening now and what might happen next.

Of course, the power of Looker comes with a steep learning curve, often requiring a dedicated data team to set up and manage the underlying LookML models. That sort of setup can be time-consuming and expensive. That's why we built Graphed. We wanted to provide the same real-time, consolidated view of your sales and marketing data, but without the technical overhead. After connecting your sources like Shopify, Google Analytics, Salesforce, and ad platforms in just a few clicks, you can ask questions in plain English like, "show me a dashboard of my revenue by ad channel for the last 90 days." We build the dashboard for you instantly, allowing you to get answers in seconds, not weeks.