Analytics & Tracking

Looker Studio eCommerce Dashboard: Metrics That Belong on One Page

Build a one-page Looker Studio eCommerce dashboard: which profit metrics to show, which to drop, the sources to connect and how to avoid GA4 quota errors.

TL;DR
  • A useful eCommerce dashboard answers one weekly question: did we make more money, and why? That puts contribution margin and new-customer cost at the top, not sessions and impressions.
  • Use your store platform for orders and revenue, ad platforms for spend, a simple cost sheet for COGS, shipping and fees, and GA4 for the funnel. Blending them on date is what turns a traffic report into a profit report.
  • Reports built on the GA4 connector are subject to GA4 Data API quotas. Owner credentials, fewer charts, one shared data source per property and a BigQuery export keep the page loading when the team needs it.

Why does an eCommerce store need a one-page dashboard?

Most stores already have plenty of reports: Shopify, each ad platform and Google Analytics 4. None of them shows profit, and each counts revenue its own way.

A one-page dashboard puts the numbers that decide whether the business is healthy in one place, calculated the same way every week. The founder reads it in five minutes, the growth team knows what to dig into, and nobody argues about whose number is right.

A note on names: Google renamed Looker Studio back to Data Studio in April 2026, and existing reports moved over automatically. We use the better-known name here.

What metrics belong on a one-page eCommerce dashboard?

Build the page in four bands, from the outcome down to the drivers. The top band tells you whether the week was good. The lower bands tell you why.

Band Metric Source Why it earns a place
Profit Net revenue (after discounts and refunds) Store platform The revenue number finance will recognize
Profit Contribution margin after marketing Store platform + cost sheet + ad spend What is left to pay fixed costs and profit
Profit Marketing efficiency ratio (MER) Store platform + all ad spend Blended efficiency that no single platform can inflate
Customers New customers and new-customer CAC Store platform + ad spend Growth you paid for, and what it cost
Customers Returning customer revenue share Store platform How much of the week came from people you already won
Customers First-to-second order rate (monthly cohort) Store platform The earliest sign of LTV moving
Acquisition Spend, platform ROAS and break-even ROAS by channel Ad platforms + margin Shows which channels clear the bar
Funnel Sessions, conversion rate, AOV GA4 + store platform The three levers behind revenue

Contribution margin sits at the top because revenue can rise while profit falls. The marketing efficiency ratio sits beside it because it divides total revenue by total spend, so no single platform can inflate it.

The customer band separates growth you bought from growth you kept. The first-to-second order rate moves months before lifetime value does. Our guide to eCommerce KPIs covers the reasoning behind each metric.

What should you leave off the page?

A one-page dashboard is defined as much by what it leaves out. Cut anything that cannot change a decision this week.

  • Pageviews, impressions and reach. Activity, not outcome.
  • Bounce rate on its own. In GA4 it is the inverse of engaged sessions, and without context it starts debates rather than ending them.
  • Summed platform-reported revenue. Meta, Google and your email platform will each claim some of the same orders. Adding them together produces a number larger than your real revenue.
  • Email open rates. Apple Mail Privacy Protection inflates them. Show revenue per recipient in a separate retention report if you need it.
  • Every key event in GA4. The dashboard needs the purchase. Micro-conversions belong in a funnel report. Our guide to GA4 key events explains which key events to mark in the first place.

Put these on drill-down pages linked from the summary.

Which data sources and connectors do you need?

Looker Studio has Google-built connectors for GA4, Google Ads, Search Console, BigQuery and Google Sheets. Shopify, WooCommerce, Meta Ads and TikTok Ads have no Google-built connector, so their data arrives through a partner connector, a scheduled export to Google Sheets, or a data warehouse.

Data Best source of truth How it usually reaches Looker Studio
Orders, net revenue, new vs returning customers Store platform (Shopify, WooCommerce, Magento) Partner connector, warehouse or scheduled sheet
COGS, shipping, payment fees Your finance numbers Google Sheet, updated monthly
Google Ads spend and conversions Google Ads Google-built connector
Meta, TikTok and other ad spend Each ad platform Partner connector or sheet
Sessions, funnel steps, landing pages GA4 Google-built connector or BigQuery export
Organic queries and clicks Search Console Google-built connector

The rule that saves the most arguments: revenue comes from the store platform, not GA4, which rarely matches the order system because of consent, ad blockers and refunds. Our article on GA4 and Shopify revenue discrepancies explains the usual gaps. Use GA4 for behavior and ratios, and the store platform for money.

How do you build the dashboard, step by step?

1. Write down the questions first

List the five or six questions the page must answer, such as “Is new-customer CAC rising?” Every chart must answer one. This list becomes your KPI framework.

2. Build a cost sheet

Create a Google Sheet with one row per month for COGS as a share of net revenue, shipping cost per order and payment fees. Rough is fine to start. Our guide to contribution margin shows how to set these numbers.

3. Connect each source once

Create one reusable data source per system. Duplicate sources for the same GA4 property waste quota and cache less.

4. Add calculated fields

Keep the formulas in plain text in a notes page inside the report, so anyone can check them:

  • Contribution margin after marketing = net revenue minus COGS minus shipping minus payment fees minus ad spend
  • MER = net revenue ÷ total ad spend
  • New-customer CAC = total marketing spend ÷ new customers
  • Break-even ROAS = 1 ÷ contribution margin before marketing (as a decimal)

5. Blend on date

Blend store revenue, the cost sheet and ad spend on date (or date plus channel), with only the fields you need.

6. Lay out the page

Profit scorecards across the top, each compared with the previous period. A date control defaulting to the last full week. One time series of contribution margin and ad spend. A channel table with spend, platform ROAS and break-even ROAS, flagging any channel below break-even.

7. Share and schedule

Share with viewers using owner’s credentials, and schedule a PDF delivery for Monday morning so the page gets read before the weekly meeting.

Worked example: reading one week of the dashboard

All numbers below are illustrative.

A store’s dashboard shows the following for last week compared with the week before. Its COGS, shipping and payment fees together come to 55% of net revenue, so contribution margin before marketing is 45%.

Metric Previous week Last week Change
Net revenue $109,000 $120,000 +10%
Ad spend $24,000 $30,000 +25%
Contribution before marketing (45%) $49,050 $54,000 +10%
Contribution after marketing $25,050 $24,000 -4%
MER 4.5 4.0 Down

A revenue-only report would call this a good week. The profit band says otherwise: the store spent $6,000 more to earn $4,950 more contribution before marketing, so profit fell by $1,050.

The drill-down explains why. Break-even ROAS is 1 ÷ 0.45, about 2.2. The channel table shows one prospecting campaign scaled from $4,000 to $10,000 with platform ROAS falling to 1.9, below break-even. The decision is clear before the meeting starts: pull that campaign back or fix its creative, and check next week whether new-customer CAC recovers.

How do you keep GA4 quota errors from breaking the dashboard?

Google’s troubleshooting guide states that reports connected to GA4 data are subject to GA4 Data API quotas. When a property runs out, charts show errors such as “This property has issued too many requests in the last day,” often just as the team opens the report before a meeting.

Google’s recommendations:

  • Use owner’s credentials, so viewers share cached data instead of each spending quota.
  • Consolidate duplicate GA4 data sources into one reusable source per property.
  • Reduce the number of charts, especially on pages that load by default.
  • Avoid embedding the report on high-traffic pages.
  • Extract the data into a static snapshot for charts that do not need live numbers.
  • Export GA4 to BigQuery and connect through the BigQuery connector, which does not draw on the GA4 Data API quota.

The one-page approach helps: fewer charts mean fewer queries, and the revenue numbers do not depend on GA4 at all.

One-page dashboard checklist

  • [ ] Five or six written questions, and every chart answers one of them.
  • [ ] Net revenue comes from the store platform, not GA4.
  • [ ] A cost sheet holds COGS, shipping and payment fees by month.
  • [ ] Contribution margin after marketing is the first scorecard.
  • [ ] Break-even ROAS is shown next to platform ROAS for each channel.
  • [ ] First-to-second order rate appears by monthly cohort.
  • [ ] Platform-reported revenue is never summed across channels.
  • [ ] One reusable data source per system, shared with owner’s credentials.
  • [ ] Charts that do not need live data use extracted data or BigQuery.
  • [ ] A PDF is scheduled before the weekly meeting.

FAQ

Is Looker Studio free?

Yes. Google’s 2026 announcement of the Data Studio name says the product continues to offer free individual analysis and visualization, with a paid Pro tier for teams that want AI and enterprise features. Partner connectors for Shopify or Meta Ads usually carry their own subscription fees.

Should the dashboard show GA4 revenue or Shopify revenue?

Show store platform revenue as the headline number and use GA4 for the funnel: sessions, conversion rate and landing page behavior. GA4 is useful for ratios and trends, but it will rarely match the order system exactly, and the gap changes with consent rates and ad blockers.

How often should we review the dashboard?

Weekly for the summary page, with a monthly look at cohort metrics such as first-to-second order rate. Daily reviews tend to cause overreaction to normal noise.

Turn this into a plan for your store

The Free Profit Audit scans your store, sizes your biggest profit leaks and builds a 90-day plan.

Free Profit Audit