Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Create a CRM Dashboard in Looker with AI

Cody Schneider••9 min read

Creating a truly useful CRM dashboard often feels like a task reserved for data analysts who speak fluent SQL. But combining your sales data with a powerful tool like Looker can give your team a centralized command center to track performance and spot opportunities. This article will walk you through how to build a CRM dashboard in Looker and explain how new AI features can dramatically speed up the process.

GraphedGraphed

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.

Watch Graphed demo video

So, Why Build a CRM Dashboard?

Before jumping into the "how," it's worth a quick reminder of the "why." Your CRM (like Salesforce or HubSpot) is a goldmine of data, but its native reporting tools can be limiting. Moving that data into a BI tool like Looker allows you to create a single source of truth for your entire sales organization, helping you achieve several key goals:

  • Track KPIs in One Place: Get a real-time, consolidated view of sales performance, pipeline health, and team activity without toggling between a dozen different reports.
  • Boost Team Performance: Build leaderboards and track progress against quotas to foster friendly competition and keep reps motivated.
  • Identify Bottlenecks: Visualize your sales funnel to see exactly where deals are stalling, allowing you to address issues before they impact your forecast.
  • Improve Forecasting Accuracy: Combine current pipeline data with historical trends to create more reliable sales forecasts.
  • Make Data-Backed Decisions: Stop relying on gut feelings. A clear dashboard helps you decide where to focus coaching, which lead sources to double down on, and how to adjust your sales strategy.

Step 1: Get Your CRM Data Ready

The saying "garbage in, garbage out" is especially true for data analytics. A powerful dashboard built on messy data is still a messy dashboard. Before you even open Looker, spend a little time on data hygiene inside your CRM. This critical first step will save you major headaches down the road.

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.

Essential Data Prep Tasks:

  • Standardize Your Fields: Ensure everyone on your team is using fields the same way. Are deal stages clearly defined and consistently used? Is the "Lead Source" field a dropdown list instead of a free-text field where typos can run wild? Consistent inputs are essential for clean outputs.
  • Clean Up Stale Data: Archive or delete old, junk leads and contacts. Remove duplicate records that could skew your numbers.
  • Enforce Data Entry Rules: Use your CRM’s built-in validation rules to require key information (like deal value or close date) before a record can be saved. The more complete your data, the more meaningful your analysis will be.

Once your CRM data is in good shape, the next technical step is making it accessible to Looker. Looker doesn't store your data, it queries it directly where it lives. This typically involves connecting your CRM to a cloud data warehouse like Google BigQuery, Snowflake, or Amazon Redshift. This step often requires some technical help to set up data pipelines, but it’s the foundation for high-performance reporting.

Step 2: Understanding Looker and LookML

With your data prepped, it's time to dive into Looker. The secret sauce behind Looker is a modeling language called LookML. Think of LookML as a translation layer that sits between your database and your dashboard visualizations.

It's where you define your business logic in a reusable way. Instead of writing complex SQL queries for every chart, you define metrics and dimensions once in LookML. For example, you define what "Revenue," "Deal Stage," or "Sales Rep" means. Once defined, anyone on your team can use these a la carte components to build their own reports without needing to know SQL.

This centralization is powerful because it ensures everyone is using the same definitions for key metrics. When your sales manager and finance team both pull a "revenue" number, LookML ensures they're pulling the exact same number, calculated in the exact same way.

GraphedGraphed

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.

Watch Graphed demo video

A Simple LookML Example

To give you a better idea, here's what a very basic piece of LookML might look like for a 'Deals' table from your CRM:

view: deals {
  sql_table_name: `your_database.deals` ,,

  dimension: deal_id {
    primary_key: yes
    type: string
    sql: ${TABLE}.id ,,
  }

  dimension_group: created {
    type: time
    timeframes: [date, week, month, quarter]
    sql: ${TABLE}.created_at ,,
  }

  dimension: stage {
    type: string
    sql: ${TABLE}.deal_stage ,,
  }

  dimension: owner {
    type: string
    sql: ${TABLE}.owner_name ,,
  }

  measure: total_deal_amount {
    type: sum
    sql: ${TABLE}.amount ,,
    value_format_name: usd_0
  }

  measure: count {
    type: count
  }
}

Here, we’ve defined dimensions (like "Stage" and "Owner") you can group by and measures (like "Total Deal Amount" and "Count") you can calculate. Building this model is traditionally the most technical part of using Looker.

Step 3: Building Your Dashboard (The Traditional Way)

After your LookML model is set up, you can start building the visual dashboard. This involves creating individual charts, known as "Tiles" in Looker, and arranging them on a canvas.

Here's the manual, step-by-step process:

  1. Create a New Dashboard: Start with a blank canvas from your folder in Looker.
  2. Add Your First Tile: Click to add a tile and choose to create a new "Look" (a saved visualization).
  3. Select an Explore: An "Explore" is your starting point for a query, based on the LookML model you built. You would select your "Deals" Explore.
  4. Pick Dimensions and Measures: On the left-hand panel, you’ll see all the dimensions and measures defined in your LookML. To see deal count by sales rep, you’d select the "Owner" dimension and the "Count" measure.
  5. Customize the Visualization: Looker will probably default to a table. You can easily switch this to a bar chart, pie chart, or another visual that best represents your data.
  6. Save the Tile: Once you're happy with your chart, save it to your dashboard.
  7. Repeat for Every Chart: Now, repeat that process for every single metric. Building a sales funnel? That's one tile. Showing performance against quota? Another tile. Tracking sales cycle length? That’s yet another.

As you can see, while powerful, this process can be time-consuming and requires a lot of clicking, filtering, and customization to get it right.

Step 4: Speeding Things Up with AI

This is where things get interesting. The manual process works, but it can be slow. Modern BI tools, including Looker, are embedding AI and generative capabilities (powered by models like Google’s Gemini) to make the whole process faster and more conversational.

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.

How AI is Changing Dashboard Creation in Looker:

  • Ask Questions in Plain English: Instead of manually selecting dimensions and measures, Looker's conversational features allow you to simply ask for what you want. You could type, "Show me total deal amount by owner for last quarter as a bar chart" and the system will generate the corresponding query and visualization for you. This dramatically lowers the barrier to entry for non-technical users.
  • Auto-Generate Visualizations: With some new tools, the AI can even suggest the best chart type for the data you’ve pulled. After asking a question, it might automatically render a time-series line chart if it detects date-based data.
  • Get Deeper Insights Faster: AI features can help you drill down without all the manual clicks. Once you have a chart, you can ask follow-up questions like "Why did John's number of closed-won deals dip in February?" or "Filter this for deals over $10,000," allowing for a more fluid and intuitive exploration of your data.
  • Draft LookML with AI Assistance: For the data modelers, new generative AI features are helping to write LookML code. A developer can describe the logic they need in plain English, and the AI will generate a LookML snippet as a starting point, cutting down on development time and the steep learning curve.

Must-Have Visualizations for Your Sales CRM Dashboard

Whether you build it manually or with AI assistance, a great dashboard provides a comprehensive view of your sales engine. Here are some essential metrics and charts to include:

Sales Performance Metrics

  • Revenue vs. Goal: A simple gauge chart or scorecard showing how your team is tracking against its revenue quota for the month, quarter, or year.
  • Win Rate (%): The percentage of deals won out of all closed deals (won and lost). Track this by team, rep, or lead source to see what's working best.
  • Average Deal Size: Helps with forecasting and understanding if reps are focusing on high-value opportunities.
  • Sales Leaderboard: A bar chart ranking reps by closed-won revenue or number of deals. This is a great motivator and provides clear performance visibility.

Pipeline Health Metrics

  • Deals by Stage Funnel: A funnel visualization showing how many deals are in each stage of your sales process. This is the fastest way to spot issues where deals might be getting stuck.
  • Open Pipeline by Rep/Month: A stacked bar chart showing the total value of the open pipeline, broken down by sales rep and expected close month.
  • Sales Cycle Length: The average time it takes from when a deal is created to when it's closed. A shortening cycle means your team is becoming more efficient.

Team Activity Metrics

  • Key Activities by Rep: Charting the number of calls, emails, and meetings logged by each rep. This helps you understand if activity levels are translating into results.
  • Lead Response Time: The average time it takes for a salesperson to follow up on a new inbound lead. A crucial metric for sales and marketing alignment.

Final Thoughts

Building a CRM dashboard in Looker organizes your sales data into actionable information, turning a sea of metrics into a clear command center for your entire team. While the traditional process of setting up LookML models and building each chart manually provides a ton of control, new AI features are making this process faster and more accessible than ever before.

At Graphed, we're taking this idea even further by starting with natural language from day one. Instead of navigating a complex BI interface, you simply connect your data sources - like Salesforce, HubSpot, or Google Analytics - and describe the dashboard you want. You can ask for "A sales performance dashboard showing me win rates by rep and a pipeline funnel for this quarter," and we instantly build the entire dashboard for you, powered by live data. Our goal is to eliminate the reporting busywork entirely, so you can spend less time building and more time acting on your data.

Related Articles