Revenue Operations Dashboard in Looker Studio Guide

What a RevOps Dashboard Actually Needs to Show

Most marketing dashboards show metrics that feel like progress but don't connect to revenue: sessions, impressions, email open rates. A Revenue Operations dashboard has exactly one purpose: showing every stakeholder where in the commercial funnel there is a performance gap, with enough detail to diagnose the root cause and act. The key metrics are organized by funnel stage, awareness, engagement, lead quality, pipeline, and revenue, with conversion rates between every stage explicitly displayed. When conversion from MQL to SQL drops from 22% to 14% in a single month, your dashboard should surface that change automatically, not hide it in a raw number.

Data Source Architecture for a Looker Studio RevOps Dashboard

A comprehensive RevOps dashboard requires four data sources connected in Looker Studio: (1) Google Analytics 4 (native connector) for website traffic, engagement, and goal completion data. (2) Google Ads (native connector) for spend, clicks, impressions, and conversion data. (3) HubSpot CRM (via HubSpot's Looker Studio connector or a Google Sheets export) for leads, MQLs, opportunities, deals, and closed revenue. (4) A spend consolidation sheet (Google Sheets) that aggregates spend from all paid channels, Google Ads, Meta, LinkedIn, since Looker Studio can't natively blend multiple ad platform data without a connector. The spend sheet becomes your cost layer, allowing you to calculate true CAC and ROAS across channels.

The Essential Metrics and How to Calculate Them

The RevOps dashboard should display these metrics in order of funnel position: Awareness: Total sessions, organic vs. paid split, cost per session by channel. Engagement: Bounce rate, pages per session, time on site for high-intent pages. Lead Generation: Total leads (form submissions), Cost Per Lead (CPL) by channel, Lead-to-MQL rate. Pipeline: MQLs, MQL-to-SQL conversion rate, average deal size in pipeline, pipeline velocity (avg days from MQL to deal creation). Revenue: Closed Won deals, Closed Won revenue, Close rate (SQL to Won), Customer Acquisition Cost (CAC) by channel, Revenue by original lead source, Return on Ad Spend (ROAS) by campaign. A single page with these metrics, updated daily, tells you everything about commercial health.

Building the Dashboard: Step-by-Step in Looker Studio

Create a new Looker Studio report and add your four data sources as connections. Use a date range control linked to all data sources for time-period filtering. Structure the report in three sections: a top-line KPI row (total revenue, CAC, ROAS, MQL volume this month vs. last month with percentage change scorecards), a funnel conversion chart (bar chart showing conversion rates at each stage, critical for spotting bottlenecks), and channel performance table (spend, leads, MQLs, deals, revenue, CAC by channel as a sortable table). Add a trend chart showing MQL volume and closed revenue over a rolling 13-month period, the seasonality context this provides is essential for correct interpretation of month-over-month changes.

Sharing, Governance, and Action Protocols

A dashboard only has value if it generates action. Share the Looker Studio report with a "view only" link to marketing, sales, and executive stakeholders. Schedule a weekly 30-minute RevOps review meeting where the dashboard is the agenda, everyone looks at the same numbers, and the meeting focuses on the biggest conversion rate decline or unexpected variance. Establish a protocol: any conversion rate that drops more than 15% from the previous 4-week average triggers an immediate root cause investigation within 48 hours. This governance structure turns the dashboard from a passive reporting tool into an active management system. Excel's Growth and Scale packages include a custom Looker Studio RevOps dashboard as a standard deliverable.