Looker Studio dashboards (now Data Studio)

You get Looker Studio dashboards where the totals agree from chart to chart, because every chart reads one reporting table joined in your warehouse. Each metric links to its written definition, and the report lives in Data Studio, the name Google now uses for the tool.

Last reviewed

One report, one table, example

Three source tables, one reporting table of 644 rows, and five charts that all reconcile to 4,140 orders

Example data

August to October 2026, 92 days

Three source tables

  • shop_orders

    One row per order

    4,140 rows

    4,140 orders, £310,500 revenue

  • ga4_sessions_daily

    One row per day per channel, six channels

    552 rows

    186,300 sessions

  • ad_spend_daily

    One row per day per paid channel, two channels

    184 rows

    £41,400 spend

One reporting table

  • rpt_channel_daily

    One row per day per channel, six GA4 channels plus "Not matched in GA4"

    644 rows

    4,140 orders, £310,500 revenue, 186,300 sessions, £41,400 spend

    644 = 92 days × 7 channel values. That's 552 GA4 rows plus 92 "Not matched" rows.Orders join GA4 purchases on transaction ID upstream: 3,864 matched, 276 not matched, 4,140 in all.

Five charts

  • Scorecard

    Orders

    4,140

    Scorecard

    Orders per session

    2.22%

  • Line

    Revenue by month

    Total £310,500

    Table

    Cost per order

    • Paid search£24.00£24,840 ÷ 1,035
    • Paid social£26.67£16,560 ÷ 621
  • Bar

    Orders by channel

    • Organic search1,242
    • Paid search1,035
    • Paid social621
    • Email552
    • Direct276
    • Referral138
    • Not matched in GA4276276 orders with no GA4 match keep their own row, so the total still reads 4,140

    Total 4,140

Example data: an invented shop's three months of orders, sessions and ad spend. The three tables are joined once in the warehouse, and every chart reads the result. Orders with no matching GA4 purchase keep their own row, so all five charts agree with the shop's 4,140 orders and £310,500.
Show the numbers
The five charts and the figures behind them, example data
ChartFigureValue
Scorecard, Orders4,140
Scorecard, Orders per session2.22%
Line, Revenue by monthAugust£98,900
Line, Revenue by monthSeptember£101,200
Line, Revenue by monthOctober£110,400
Line, Revenue by monthTotal£310,500
Bar, Orders by channelOrganic search1,242
Bar, Orders by channelPaid search1,035
Bar, Orders by channelPaid social621
Bar, Orders by channelEmail552
Bar, Orders by channelDirect276
Bar, Orders by channelReferral138
Bar, Orders by channelNot matched in GA4276
Bar, Orders by channelTotal4,140
Table, Cost per orderPaid search: £24,840 ÷ 1,035£24.00
Table, Cost per orderPaid social: £16,560 ÷ 621£26.67

What this fixes

The totals don't matchThe orders scorecard and the channel chart give different totals, because each chart blends its own sources.
The report takes an age to openEach chart sums the raw GA4 and ad rows itself every time it loads.
Nobody knows what "conversion" meansThree people give three different formulas for the conversion rate on page three.
The template doesn't match financeThe report came from a downloaded template, and its revenue never matches the figure finance reports.

What you get from a Looker Studio consultant

The reporting tableOne table in your warehouse holds the grain the charts need, such as one row per day per channel, and rebuilds on a schedule.
The reportEvery chart in Data Studio reads that one table.
The definitions linksEach metric links to its line in your definitions log, with its formula and owner.
The reconciliation checkThe check compares row counts and totals with the source tables at each step, as in the exhibit above, and reruns after any change.
HandoverThe report is in your organisation's Google account from the first day, and whoever maintains it gets a recorded walkthrough.

How a Looker Studio dashboard project runs

  1. 1

    Scoping

    We agree the questions, the source tables and the grain of the reporting table, and each metric gets a definition and an owner.

  2. 2

    Build

    The reporting table reconciles to its sources before any page exists.

  3. 3

    Handover

    Someone on your side adds a chart without help, and we check it.

  4. 4

    After handover

    The report, the table and the scheduled rebuild have been in your accounts from the start.

Where Looker Studio dashboards go wrong

Joins set up chart by chartTwo charts that blend the same tables differently show two totals, and the page gives no clue why. One table joined upstream leaves one join to check.
Charts on raw event dataA chart that reads a raw GA4 event export sums every raw row itself. The charts read a table already summed to the grain they show.
Orders that quietly go missingDrop the orders that don't match GA4 and the order count falls below the shop's. A "Not matched in GA4" row stays in view, and if it grows, that's tracking work.

In the example, the 276 orders not matched in GA4 have no channel, so they stay out of cost per order and still count in the 4,140.

Looker Studio templates and what they leave out

A template can't know whether your revenue is counted before or after refunds, or on the order date or the dispatch date, and those definitions decide every number on the page. So we agree the definitions with you before anyone touches the layout. The finance dashboard in the KPI library shows the result, and if your team works in Microsoft 365, the Power BI consultant page covers the same approach.

Looker Studio dashboards by industry

EcommerceThe table holds one row per day per channel, with shop orders matched to GA4 purchases by transaction ID.
Subscription and mediaThe table holds one row per day per acquisition channel, with sign-ups, renewals and cancellations from the subscription system.

Questions people ask

Can you fix our existing Looker Studio report?

Yes, and the pages can stay. The report's blends move into one reporting table, the charts repoint at it, and the old blends go only once each total matches the source.

Do you sell Looker Studio templates?

No. A template gives you a layout, and your definitions decide every number in it. The finance dashboard in the KPI library shows how a pack is set out, on example data.

Do we need BigQuery for this?

You need somewhere to keep the reporting table, and Data Studio connects to BigQuery, Google Sheets and many other sources. Ad spend that Fresh Sheets, our Google Sheets add-on, puts in a sheet can be one of the source tables.

Is Data Studio free?

Yes, Google makes Data Studio available at no charge for creators and report viewers. Your warehouse bills you separately, so the plan sets how often the table rebuilds and how many rows it holds. Data Studio Pro is a paid edition.

Do you build Looker Studio dashboards for ecommerce?

Yes. A shop's reporting table has one row per day per channel, with shop orders matched to GA4 purchases by transaction ID. Unmatched orders keep their own row, so the order count equals the shop's.

Do two charts in your report disagree?

During the call we trace both totals back to the tables they read.

Book a call

Free 30 min call