Looker Studio Sales Dashboard Tutorial: Build in 6 Steps

Building a Looker Studio sales dashboard takes under two hours. Connect your CRM as a data source, define the six KPIs that drive revenue decisions - pipeline value, win rate, sales velocity, average deal size, quota attainment, and churn - then arrange scorecards and time-series charts on a single canvas. Share a view-only link or schedule a PDF email delivery without any additional software license.

Key Takeaways

• Looker Studio is Google's free browser-based reporting tool; it is not the same product as Google Looker, the enterprise platform with LookML data modeling - the distinction matters at budget time.
• Any CRM that exports to Google Sheets, BigQuery, or a supported connector can feed a Looker Studio sales dashboard with minimal setup.
• Six KPIs cover the full revenue cycle: pipeline value, win rate, sales velocity, average deal size, quota attainment, and net revenue retention.
• Sharing is link-based with Google account controls - no additional software license is required for viewers.
• Healthcare and finance teams in the US, UK, and Canada must configure data-residency and access controls before sharing dashboards outside the organization.

What Is a Looker Studio Sales Dashboard?

A Looker Studio sales dashboard is a live, browser-rendered report that pulls CRM data into visual KPIs, refreshed on a schedule or in near-real time. Unlike a static spreadsheet export, it updates automatically when the underlying source changes, giving CIOs, finance directors, and data team leads a single shared view of revenue performance without manual data pulls each morning.

One terminology point that matters for budget conversations: Looker Studio (formerly Google Data Studio) is a free, browser-based reporting layer. It is a different product from Google Looker, the enterprise analytics platform that uses LookML for semantic data modeling and carries an enterprise license cost. The Looker Studio vs Power BI 2026 comparison covers how both tools fit into a mid-market analytics stack. For sales reporting at the mid-market level, Looker Studio is typically the faster and lower-cost starting point.

For organizations building a more complex multi-source dashboard with row-level security, working with a Certified Looker Studio consulting partner accelerates the architecture and data pipeline setup from the outset.

How Do You Connect a CRM Data Source to Looker Studio?

Looker Studio connects to CRM data through native connectors, partner connectors, or an intermediate layer such as Google Sheets or BigQuery. The right path depends on your CRM vendor, data volume, and refresh requirements.

Option A - Google Sheets (Fastest Setup)

If your CRM can schedule a daily export to Google Sheets, Looker Studio's built-in Google Sheets connector reads that file directly. This path works well for teams with fewer than 50,000 rows per sheet and a daily or weekly refresh cadence. A US SaaS finance team managing a mid-size inside sales operation might export pipeline data to Sheets each morning and connect it to Looker Studio in under 20 minutes.

Setup steps:

1. In your CRM, schedule a daily export of the Opportunities or Deals object to a Google Sheet in your organization's Google Workspace account.

2. Open Looker Studio (lookerstudio.google.com) and select Create > Report.

3. Choose the Google Sheets connector, select your spreadsheet and the relevant worksheet tab.

4. Click Add to Report. Looker Studio lists detected fields automatically.

5. Open Resource > Manage added data sources and rename fields for clarity - for example, rename "Amount" to "deal_value" and "CloseDate" to "close_date".

Option B - BigQuery (Production-Grade)

For datasets exceeding 50,000 rows, near-real-time refresh needs, or row-level access controls, route CRM data to BigQuery first, then connect Looker Studio using the native BigQuery connector. Per Google's Looker Studio documentation (2025), the BigQuery connector supports scheduled query refreshes and row-level security through authorized views. This is the recommended path for US healthcare revenue cycle teams operating under HIPAA, where access to patient-adjacent financial records must be restricted to named individuals and logged for audit.

Setup steps:

1. Configure a CRM export pipeline to BigQuery - most enterprise CRMs support this natively or through an ETL connector.

2. In Looker Studio, select Create > Report > BigQuery.

3. Choose your project, dataset, and table or saved view.

4. Apply authorized views in BigQuery to enforce row-level access before Looker Studio renders any data.

Option C - Partner Connectors

Looker Studio's connector gallery lists hundreds of integrations built by third-party vendors. Before using a partner connector in a production environment, verify that it stores no data beyond a session cache. This is a compliance requirement for UK and EU organizations under GDPR, and for Canadian firms subject to PIPEDA, where third-party data processors must be documented and contractually bound before any personal or financial data flows through them.

What Are the 6 Core Sales KPIs for a Looker Studio Sales Dashboard?

The following six metrics span the full revenue cycle, from early-stage pipeline through post-sale retention. The table maps each KPI to its Looker Studio chart type, required data fields, and recommended refresh frequency.

Pipeline Value is the aggregate deal value of all open opportunities. Create a calculated field using `SUM(deal_value)` and apply a filter to exclude "Closed Lost" records. A UK fintech firm tracking multi-currency pipelines can add a currency dimension and an interactive filter control so each regional sales director views only their own territory without seeing competitors' deal details.

Win Rate is won deals divided by all closed deals in a period. Create a scorecard with the calculated field `COUNT_IF(stage = "Closed Won") / COUNT(deal_id)`, formatted as a percentage. Add a date range control above the scorecard so users can adjust the measurement window without editing the underlying report.

Sales Velocity measures the pace at which revenue moves through the pipeline. The composite formula is: `(number of qualified deals x average deal size x win rate) / average sales cycle in days`. Because Looker Studio does not perform row-level date arithmetic natively, calculate this metric upstream in a BigQuery view or Google Sheets formula column before import.

Average Deal Size is a single scorecard using the average aggregation on `deal_value`. Segment by industry, product line, or account tier using a dimension breakdown to help finance directors compare healthcare and commercial contract values side by side in the same view.

Quota Attainment compares achieved revenue to the period target. Add two fields - `SUM(won_deal_value)` and a static or CRM-sourced `quota_target` - and use the scorecard's built-in comparison metric to display the attainment percentage. For Canadian professional services organizations operating under PIPEDA, consider adding rep-level row-level security so each salesperson views only their own attainment row when the report link is shared broadly.

Net Revenue Retention is the metric most relevant to subscription healthcare and SaaS teams. A time-series chart with `churned_arr` displayed as a bar and `expansion_arr` as a line gives leadership a fast read on whether growth offsets attrition. Finance directors at US healthcare IT firms often pair this chart with a quarter-over-quarter comparison metric to track the impact of contract renewal initiatives on overall revenue health.

How Do You Build the Dashboard Layout in Looker Studio?

Layout determines whether a sales dashboard becomes part of the daily workflow or sits unused. A three-zone structure works reliably for sales and finance audiences at the mid-market level.

Zone 1 - Executive Summary (top row)

Place four scorecards across the top: Pipeline Value, Win Rate, Average Deal Size, and Quota Attainment. These answer the CIO's first question - "Are we on track?" - without any click required. Apply your organization's primary brand color to the scorecard background to signal this is the authoritative revenue view, not a draft or sandbox copy.

Zone 2 - Trend Analysis (middle section)

Below the scorecards, place a 12-month time-series chart for Sales Velocity alongside a stacked bar chart of the pipeline stage breakdown by rep or territory. Add a date range control and a dimension dropdown filter as interactive controls at the top of this zone. This lets a data team lead drill into any segment without waiting for a custom data pull from the analytics team.

Zone 3 - Detail Grid (bottom section)

A sortable data table showing individual deal records - deal name, owner, value, stage, and expected close date - gives finance directors the line-item visibility needed for board reporting and audit sign-off. Set a default filter to display only deals closing within the current quarter, and include a clear label so reviewers know how to expand the date range to see historical pipeline.

Branding and theme:

Looker Studio's Theme and Layout panel (File > Report settings > Theme) lets you apply a custom font, color palette, and report-level background. Consistent branding across zones reduces the cognitive load for stakeholders who review multiple reports each morning and need to identify the authoritative source quickly.

For teams benchmarking this layout against a more sophisticated financial reporting environment, the FP&A Dashboard in Power BI build guide covers comparable zone structure and finance-specific KPI definitions in the Microsoft stack.

How Do You Share a Looker Studio Dashboard With Stakeholders?

Looker Studio supports four sharing modes. The right choice depends on the sensitivity of the underlying data and the technical setup of your audience.

Named Google account access is the minimum acceptable control for US healthcare organizations where patient-adjacent financial records appear in the report. For UK and EU firms under GDPR, access to any personal data in the report must be restricted to specific named individuals with a documented legal basis, and that access log must be available for audit on request.

Scheduled email delivery sends a PDF snapshot on a daily or weekly schedule to a distribution list. This satisfies the "morning briefing" use case for board members or executive sponsors who do not hold Google accounts, without requiring them to navigate a web interface or authenticate through a new service.

Embedding the dashboard via iframe works for internal portals and intranet pages. For US healthcare teams, the embedding portal must sit behind your SSO provider to ensure that HIPAA access controls extend to the BI layer. For UK fintech and Canadian financial services firms, document the iframe integration in your third-party data processing register before the dashboard goes live.

For the full governance documentation required when sharing revenue data with external auditors or counterparties, the GDPR Compliant SaaS Financial Reporting checklist covers the steps UK and EU finance teams must complete before any external share.

When Should Sales Teams Use Looker Studio vs a More Advanced BI Platform?

Looker Studio is the right starting point when a team needs a fast, license-free reporting layer over an existing CRM and Google Workspace setup, with a working dashboard delivered in days rather than weeks. It becomes a limiting factor when the data model grows beyond what Google Sheets or simple BigQuery views can express - specifically when multiple fact tables need joining at query time, when semantic consistency across dozens of reports requires a governed data layer, or when row-level security must mirror a complex organizational hierarchy.

At that threshold, organizations tend to evaluate Google Looker's enterprise pricing and LookML governance capabilities to determine whether the benefits justify the license cost. A typical mid-market rollout - suppose a 100-seat North American sales team with CRM data already in BigQuery - can reach a production-ready Looker Studio sales dashboard in two to three weeks, covering data pipeline validation, KPI definition workshops, and stakeholder sign-off on the layout.

For US healthcare systems managing HIPAA-covered revenue cycle data, or Canadian wealth management firms subject to PIPEDA, the audit trail depth and access governance controls available in enterprise platforms often justify the additional investment beyond Looker Studio's baseline capabilities. The build-versus-buy decision for those regulated environments is worth scoping before committing to a reporting architecture.

---

Ready to build a sales dashboard that connects directly to your CRM and meets your compliance requirements? The team at Lets Viz delivers end-to-end dashboard builds through our Certified Looker Studio consulting practice, serving revenue, finance, and healthcare teams across the US, UK, and Canada.

---

About Lets Viz: Lets Viz is a data analytics consultancy serving US healthcare systems, UK fintech firms, Canadian manufacturers, and global SaaS companies since 2020. With a 5.0 Clutch rating and certified expertise across Google Looker Studio, Power BI, and Zoho Analytics, the team builds and maintains production dashboards for revenue, operations, and compliance reporting at the mid-market and enterprise level.