An e-commerce operator running a Shopify store constantly bounces between three interfaces: Shopify Analytics for sales, GA4 for behavior, and the Ads Managers for campaigns. Each tells a slightly different story — we covered why in our attribution mismatch guide. A well-built Looker Studio dashboard doesn’t make those differences disappear: it places them side by side, with the right number in the right spot, so weekly decisions take five minutes instead of an hour of tab-switching.
Here’s how to build it, connector by connector, and the pitfalls that produce dashboards that look professional but are quietly wrong.
Connectors: the choice that shapes everything
GA4 → Looker Studio: native and free
The official GA4 connector is free and covers the essentials: sessions, conversions, revenue by channel, e-commerce funnel. Its main limitation: API quotas. A frequently viewed dashboard with lots of charts can hit GA4’s quota and show loading errors. Two workarounds: limit the number of charts per page, or export data to BigQuery (GA4’s native export, free up to a comfortable volume) and connect Looker Studio to BigQuery instead — the approach we favor for higher-traffic accounts, since it removes quotas and locks in historical data that GA4 eventually samples.
Shopify → Looker Studio: no native connector
This is the main friction point: Shopify doesn’t offer an official Looker Studio connector. Three practical options:
- Third-party connectors (Supermetrics, Windsor.ai, Coefficient…): quick to set up, monthly subscription, variable quality depending on the metric (watch out for refunds and canceled orders, handled differently across tools).
- Shopify export → Google Sheets → Looker Studio: free, good enough for simple weekly reporting, but fragile (manual exports or sync apps) and limited in historical depth.
- Shopify API → BigQuery: the robust solution — raw order data lands in BigQuery, gets joined in SQL with the native GA4 export, and feeds the dashboard without quotas or sampling. It’s more upfront work, but it’s the only option that lets you finely reconcile Shopify orders with GA4 sessions.
For a store just getting started, option 2 is enough. Once paid media crosses a few thousand dollars a month, option 3 pays for itself quickly because it makes the numbers budgets get argued over actually trustworthy.
Ad platforms
Meta Ads and Google Ads have connectors available (native for Google Ads, third-party for Meta). The key point: pull spend from every platform into the dashboard to calculate blended metrics (see below), rather than displaying each platform’s self-reported ROAS as if they were directly comparable to each other.
The 4-page structure that works
After many iterations on e-commerce dashboards, the structure that holds up over time is almost always the same:
Page 1 — Executive view. The 6-8 KPIs for steering: revenue (Shopify source), orders, average order value, blended ROAS (total revenue ÷ total spend across all platforms), conversion rate, traffic. Comparison against the previous period. This is the page the founder checks on Monday morning — it needs to answer “are we good or not?” in ten seconds.
Page 2 — Acquisition. Sessions, conversions, and revenue by channel (GA4 source, same rules applied to every channel), plus spend and metrics per platform. This is where the logic from the attribution article applies: GA4 to compare channels against each other, platform-native numbers to optimize within each one.
Page 3 — Behavior and funnel. The view_item → add_to_cart → begin_checkout → purchase funnel with drop-off rates between each step — provided the events are actually firing correctly (see our guide to GA4 e-commerce events). An abnormal drop-off between two steps localizes the problem: checkout friction, shipping costs, a mobile bug.
Page 4 — Products. Top products by revenue and by volume, cross-referencing views versus purchases to spot products that get a lot of views but few sales (a pricing, listing, or stock issue).
The pitfalls that produce broken dashboards
Mixing sources without labeling them. Showing Shopify revenue next to GA4 conversion rate side by side without stating each number’s source guarantees confusion. Every scorecard should indicate its source — a simple mention in the label is enough.
Misaligned timezones. GA4, Shopify, and Meta can each be configured on different timezones; a given day’s data then doesn’t cover the same 24 hours across tools, and daily comparisons drift. Check alignment across all three before anything else.
Ignored refunds. Shopify Analytics deducts refunds from revenue; most third-party connectors and GA4 don’t (GA4 has a refund event that’s rarely implemented). On a store with 5-10% return rates, the gap becomes structural. Pick a convention (gross or net revenue) and apply it everywhere.
Currency. Multi-currency stores mean orders get converted differently depending on the tool and the date of the exchange rate. Here again, BigQuery lets you enforce a single, consistent conversion.
Too many metrics. A dashboard displaying 40 indicators never gets looked at twice. Every page should answer one specific question; if a metric doesn’t trigger a decision, it doesn’t belong.
Where to start, concretely
If you’re starting from zero: build page 1 only, with the native GA4 connector and a weekly Shopify export to Sheets. Use it for two weeks. You’ll then know precisely what’s missing — and you’ll build the following pages around your real questions instead of a generic template. A useful dashboard is built through short iterations, not one exhaustive mockup.
FAQ
Is Looker Studio really free? Yes, the tool itself is free with no limit on dashboards or users. The occasional costs come from third-party connectors (Shopify, Meta) and BigQuery beyond the free tier — expect anywhere from $0 to a few dozen dollars a month depending on architecture.
Do I need a real-time dashboard? Almost never. E-commerce decisions (budget, products, campaigns) happen on a daily or weekly cadence. Daily refresh is enough and avoids API quotas — real-time is a comfort feature that costs a lot for marginal benefit.
How long does it take to build a full dashboard? With the native GA4 connector and a Sheets export: one day for a clean V1. With a full BigQuery architecture (GA4 + Shopify + ad platforms): budget one to two weeks including SQL modeling and validating the numbers against source.
This closes our core GA4 + Shopify + paid media loop: from connecting GA4 to diagnosing revenue gaps to centralizing everything here.
Want this dashboard built for you, connectors and pitfalls handled? Check out our Shopify Dashboards offer or book a free 30-minute call.