A Looker Studio dashboard for Shopify and GA4: what to build, page by page

Shopify knows your sales. GA4 knows your traffic. Your ad platforms know your spend. A Looker Studio dashboard puts the three side by side, so your weekly review takes five minutes instead of an hour of tab-switching. This guide shows how to connect the data, the five pages I build for Shopify stores, the calculated fields you need, and the traps to avoid.

Step 1: connect your data

GA4

Looker Studio has a free, native GA4 connector. Add your property as a data source, and you’re done. Two caveats: GA4’s API quotas limit how many requests a report can make, so heavy pages with many charts can show errors; and data is subject to GA4’s thresholds when Google signals are on.

Shopify

There is no free native Shopify connector, so you have three options:

Option	How it works	Best for
Google Sheets export	Export orders or a Shopify report to a Google Sheet (manually or with an app) and connect the sheet	Small stores, weekly reviews
Partner connector	A paid connector (for example Supermetrics, Coupler.io, Porter or Windsor.ai) pulls Shopify data into Looker Studio or a sheet on a schedule	Most stores: reliable, little maintenance
BigQuery	Shopify data loaded to BigQuery with an ETL tool, joined with the free GA4 BigQuery export	Larger stores, custom analysis, order-level reconciliation

Ad spend

Google Ads has a native connector. Meta, TikTok and others need a partner connector or a sheet. To calculate MER, you need total spend from every platform in one place.

Step 2: the five pages

Page 1: weekly overview

The page you open every Monday. Scorecards with comparison to the previous period and to last year:

• Net sales, orders and AOV (Shopify)
• Sessions and conversion rate (GA4 or Shopify)
• Total ad spend and MER
• New and returning customers
• Tracking capture rate

Add one time series of daily net sales against last year, and nothing else. The twelve KPIs and how to read them are in 12 KPIs every Shopify owner should check weekly.

Page 2: acquisition

• A table by session default channel group: sessions, conversion rate, purchases, revenue.
• A table by session source / medium and campaign for paid traffic, with spend and ROAS where available.
• A filter control for device category and country.

If paypal.com / referral appears in the top rows, fix it first: see fixing paypal.com / referral.

Page 3: funnel

• Event counts for view_item, add_to_cart, begin_checkout, add_shipping_info, add_payment_info and purchase.
• Step-to-step rates as calculated fields.
• A breakdown by device: mobile problems show up here first.

Page 4: products

• A table by item name: items viewed, added to cart, purchased, item revenue.
• Calculated view-to-purchase rate, to find products that attract interest but don’t sell.
• Shopify’s net sales and returns by product, if your Shopify data includes them.

Page 5: data quality

The page most dashboards forget. Daily Shopify online orders next to daily GA4 purchases, with the capture rate as a line. A sudden drop tells you tracking broke before your ad results do. If you have BigQuery, add a table of orders missing in GA4, by payment method and device.

Step 3: calculated fields

Create these in the data source (Resource → Manage added data sources → Edit → Add a field):

Conversion rate      = SUM(Ecommerce purchases) / SUM(Sessions)
Add-to-cart rate     = SUM(Add to carts) / SUM(Sessions)
Checkout completion  = SUM(Ecommerce purchases) / SUM(Checkouts)
AOV                  = SUM(Net sales) / SUM(Orders)
MER                  = SUM(Net sales) / SUM(Total ad spend)
Capture rate         = SUM(GA4 purchases) / SUM(Shopify online orders)

Field names depend on your connectors. For metrics that combine two sources (MER, capture rate), create a blend joined on date, then add the calculated field in the chart.

Step 4: design rules that keep it useful

• One question per page. If a page answers three questions, nobody reads it.
• Shopify for money, GA4 for behaviour. Don’t show GA4 revenue on the overview: it will never match Shopify, and the discussion will be about the gap instead of the business.
• Default date range: last full week (Monday to Sunday), compared with the previous year.
• Label every metric with its source in the chart title, for example “Orders (Shopify)”.
• Fewer than ten charts per page, also to stay within GA4’s API quotas.

Avoid the quota trap

Looker Studio queries GA4 live every time someone opens or filters a report. Large reports hit GA4’s API quotas and show “quota exceeded” errors, usually on Monday morning when everyone opens them. To avoid it:

• Keep GA4 pages light, and split them across pages rather than stacking charts.
• Use extract data sources for GA4 on pages that don’t need real-time data.
• For larger stores, use the GA4 BigQuery export as the source instead of the API.
• Not sure BigQuery is worth it? See GA4 BigQuery export for Shopify stores: when it’s worth it.

Make it read itself

• Schedule email delivery of the overview page every Monday morning.
• Set alerts on daily purchases and capture rate, so a tracking failure reaches you within a day.
• Review the dashboard after every tracking change, as part of your tracking QA.

Frequently asked questions

Is there a free Shopify connector for Looker Studio?

Not a native one from Google. Free options are a Google Sheets export or a GA4-only dashboard; reliable automated Shopify data usually needs a paid connector or BigQuery.

Can I build the dashboard with GA4 data only?

Yes, and it’s the cheapest start. But GA4 revenue never matches Shopify, so you lose the order-level truth and the reconciliation page. Add Shopify data when the dashboard drives decisions.

Are there ready-made Looker Studio templates for Shopify?

Several connector vendors and template sellers offer them. They save time, but check that the definitions (revenue, conversion rate, new customers) match yours before you trust them.

Looker Studio or a dedicated tool?

Looker Studio is free and fully yours, but you build and maintain it. Tools like Polar Analytics or Triple Whale give you ready-made Shopify dashboards for a monthly fee. I compare them in Shopify analytics tools compared.

A dashboard is only as good as the data behind it. If you want the tracking and the reporting set up together, a measurement plan (from 1,600€) defines your KPIs and sources, and my Shopify tracking packages make sure the data is right. Book a free 30-minute call to talk about your reporting.