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.
One report, one table, example
Three source tables, one reporting table of 644 rows, and five charts that all reconcile to 4,140 orders
August to October 2026, 92 days
Three source tables
shop_ordersOne row per order
4,140 rows
4,140 orders, £310,500 revenue
ga4_sessions_dailyOne row per day per channel, six channels
552 rows
186,300 sessions
ad_spend_dailyOne row per day per paid channel, two channels
184 rows
£41,400 spend
One reporting table
rpt_channel_dailyOne 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
Show the numbers
| Chart | Figure | Value |
|---|---|---|
| Scorecard, Orders | 4,140 | |
| Scorecard, Orders per session | 2.22% | |
| Line, Revenue by month | August | £98,900 |
| Line, Revenue by month | September | £101,200 |
| Line, Revenue by month | October | £110,400 |
| Line, Revenue by month | Total | £310,500 |
| Bar, Orders by channel | Organic search | 1,242 |
| Bar, Orders by channel | Paid search | 1,035 |
| Bar, Orders by channel | Paid social | 621 |
| Bar, Orders by channel | 552 | |
| Bar, Orders by channel | Direct | 276 |
| Bar, Orders by channel | Referral | 138 |
| Bar, Orders by channel | Not matched in GA4 | 276 |
| Bar, Orders by channel | Total | 4,140 |
| Table, Cost per order | Paid search: £24,840 ÷ 1,035 | £24.00 |
| Table, Cost per order | Paid social: £16,560 ÷ 621 | £26.67 |
What this fixes
What you get from a Looker Studio consultant
How a Looker Studio dashboard project runs
- 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
Build
The reporting table reconciles to its sources before any page exists.
- 3
Handover
Someone on your side adds a chart without help, and we check it.
- 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
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
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.