Looker Studio for Ecommerce: Building Dashboards with GA4 Data

GA4's native reports will get you started, but they're generic. Looker Studio (Google's rebranded Data Studio) is where you actually take control. You can pull data from GA4, Google Ads, Facebook Ads, Shopify, your own databases, whatever you need. Stack it all in one place.

For ecommerce managers, that single command center beats checking five different tools every morning. I've built dashboards that saved my team hours each week just by cutting down the data hopping.

What Is Looker Studio?

It's Google's free visualization tool. Connect your data sources, drag components around, and you've got a report. Nothing fancy about the premise, but the flexibility is what makes it valuable.

Dashboards are interactive, so your team can filter by date range, traffic source, whatever makes sense for their role. They automatically update as new data flows in. Share them with a link.

For ecommerce specifically, the strength is combining multiple sources. One Looker Studio dashboard can show you GA4 traffic data, Google Ads spend, Facebook conversion costs, even your margin data if you've got it in a spreadsheet. That complete picture is rare. Most people cobble together screenshots from five platforms.

Connecting GA4 as a Data Source

First step: connect GA4 to Looker Studio.

Head to looker.studio and create a new report. Select GA4 as your data source. Authorize Looker Studio to access your GA4 account, and you're ready.

You'll see all your GA4 properties available in the source selector. If you manage multiple stores or brands, you can add them all to the same report.

Picking the Right Metrics and Dimensions

GA4 has hundreds of dimensions (characteristics of users, sessions, events) and metrics (the actual numbers like revenue, conversion rate). Most of them aren't worth your time.

For ecommerce dashboards, these metrics matter:

Revenue, transactions, conversion rate, average order value, customer acquisition cost (especially when cross-referenced with ad spend), engagement rate, bounce rate, sessions, users, and event-based stuff like add_to_cart and page_view.

Dimensions that actually help:

Traffic source, campaign, country, device type, user properties, product category, and date.

Pick the right combination and you can answer your real business questions without wading through noise.

The Dashboards You Actually Need

Most ecommerce teams need several dashboards, not one. Build them separately so people can find what they're looking for.

Revenue Scorecard

A big, obvious number showing today's or this week's revenue. New people get oriented in one second.

Always compare it to the previous period. Up 15% week-over-week or down 5%? That comparison matters for deciding whether you're on track.

Conversion Rate Trend

Show conversion rate over time. Weekly or daily depending on your traffic volume. This tells you whether your site's actually getting better at turning visitors into buyers.

Filter by traffic source so you can compare how organic converts versus paid search versus social.

Revenue by Source

Bar chart showing which channels actually make you money. Organic, direct, paid search, social, affiliates, whatever applies.

Once you can see this, you can make smarter budget calls. A channel bringing in 40% of revenue deserves more money than one bringing in 5%.

Average Order Value Over Time

Track what each customer spends on average. Revenue growth comes from two places: more customers or more money per customer.

If revenue jumped 20% but AOV only grew 5%, you're acquiring more customers. Invest there. If AOV is growing but customer count is flat, you need a demand generation push.

Product Funnel

Build a funnel showing view product, add to cart, and purchase. It immediately shows you where people bail.

1,000 product views but only 10 sales? Something's wrong between those steps.

Traffic Overview by Source

A table with sessions, users, engagement rate, and bounce rate for each traffic source. This tells you which channels are actually delivering quality traffic.

High-traffic channels with low engagement usually need better targeting or better landing pages. Sometimes a small channel with high engagement is worth more than you think.

Top Products by Revenue

What's actually selling. Show revenue and units sold, plus revenue per product view so you can spot products people see but don't buy.

Mobile vs. Desktop Conversion Rate

Bar chart comparing mobile, tablet, and desktop conversion rates. Mobile is almost always worse than desktop.

If mobile converts at half the rate of desktop, mobile optimization needs to move up your priority list.

Your First Dashboard

Start with one that answers a single question: How much revenue did we make this period, and where did it come from?

Create a new report and add:

Revenue scorecard showing total
Revenue by source bar chart
Revenue by campaign bar chart
Daily revenue trend line

Add a date range filter and a source filter so people can drill into what they care about.

This takes 10 minutes and has immediate utility. Your team can check it daily.

Your Second Dashboard

Build one that tracks conversion journey. How many users actually move through your funnel?

Include:

Shopping funnel (view items > add to cart > checkout > purchase)
Conversion rate by traffic source
Average order value by source
Bounce rate by source

This shows you both what's working and where friction exists.

Adding Ad Spend Data

GA4 shows you what happened on your site. It doesn't show you what you paid for those results. If you want to calculate actual ROI, you need to add ad platform data.

Connect Google Ads the same way you connected GA4. Pull in cost, clicks, impressions, CPC. Then create visualizations combining GA4 revenue with ad spend.

Build a simple table: Campaign Name, Cost, Revenue, ROAS (calculated as Revenue / Cost). That one table gives you everything you need to manage budget allocation.

Combining Multiple Ad Platforms

Running ads on Google, Facebook, and LinkedIn? Add each as a data source.

Create a calculated field that standardizes metric names across platforms so everything lines up. All platforms have "cost" and "conversions," just pulling from different sources.

One unified dashboard showing ROAS across all platforms tells you which channels deserve more budget.

Custom Calculations and Blending Data

This is where Looker Studio stops being a basic reporting tool and becomes actually useful.

Formulas You'll Use

Create calculated fields. Cost per purchase: Cost / Conversions. Customer acquisition cost: Ad Spend / New Users. Revenue per session: Revenue / Sessions.

GA4 doesn't calculate these natively. But Looker Studio can, and they matter way more than most of the default metrics.

Pulling Multiple Data Sources Together

Combine GA4, Google Ads, Facebook data, spreadsheets, whatever. You might blend:

GA4 revenue with Google Ads spend to calculate ROAS. Facebook ad cost with GA4 conversions attributed to Facebook traffic. Your product margin spreadsheet with GA4 revenue by product to see actual profit.

The whole is definitely greater than the sum of parts here.

Chart Types That Actually Work for Ecommerce

Different questions need different visuals.

Line Charts

Trends over time. Revenue over 90 days, conversion rate trend, average order value.

Raw numbers hide patterns. A line chart makes them obvious.

Bar Charts

Comparing values across categories. Revenue by source, conversion rate by device, sales by product.

Horizontal bars work better when your category names are long.

Pie and Donut Charts

What percentage of revenue comes from each channel? Only works well with 4-5 categories though. Ten sources in a pie chart is garbage.

Funnels

Show progression through stages. It immediately reveals where people drop off.

Tables

Detailed data. Top products, campaign performance, conversion metrics by source. Tables hold more information but require more focus to read.

Scorecard

Single large number. Daily revenue, weekly conversions, whatever KPI you're obsessed with.

Use the comparison feature to show period-over-period change.

Getting Dashboards into People's Hands

Once it's built, share it.

Click the share button, choose who can view. Set them as "Viewer" so they can't accidentally break anything.

Scheduled Delivery

You can set Looker Studio to email reports on a schedule. Weekly dashboard every Monday morning, monthly summary on the first of the month.

Automated delivery keeps people informed without you having to think about it.

Scheduling from GA4

GA4 has its own scheduling function. Set up an email that goes out on a schedule with a link to your Looker Studio dashboard.

How to Not Build a Terrible Dashboard

Build with your audience in mind. CEO dashboard should show revenue and key metrics. Marketing manager dashboard shows channel performance in detail.

Focus each dashboard on one purpose. A dashboard trying to be everything is a dashboard nobody uses.

Label things clearly. "Revenue" is less useful than "Weekly Revenue by Traffic Source."

Use filters. Date range filter, source filter, campaign filter. Let people customize.

Keep your definitions consistent. If conversion equals purchase on one dashboard, make sure it means the same thing everywhere.

Advanced Moves

Attribution Modeling

GA4 defaults to last-click attribution, but you can change it. Create dashboards showing revenue under different models. What would budget allocation look like if you used first-click instead?

Cohort Analysis

Group users by acquisition source or signup date, then track how they behave over time.

Build a table showing revenue, retention, repeat purchase rate by cohort. You'll almost always discover that certain acquisition sources bring better customers than others.

Predictive Insights

GA4 provides predictive audiences and churn predictions. Use them.

A dashboard showing percent of users at churn risk by source helps you spot which channels bring less loyal customers.

Using ORCA with Looker Studio

Looker Studio handles visualization and historical reporting. ORCA provides predictive analytics and automated anomaly alerts.

They work together. Looker Studio shows what happened and current state. ORCA flags anomalies and forecasts.

Revenue down 10% this week? Looker Studio shows it. ORCA flags it as abnormal if it's outside expected ranges and points to potential causes.

Together they give you complete visibility: what happened historically plus what's coming.

Get Started

Build one dashboard. Revenue tracking, conversion funnel, channel performance. All three take a few hours if you actually do them.

Once you're comfortable, layer in ad data, blend multiple sources, add calculated fields. Share with stakeholders and set up scheduled delivery.

Most ecommerce teams skip Looker Studio's customization because the default GA4 reports feel sufficient. They're not. A custom dashboard built for your actual business beats generic reports every time.

Start this week. Add complexity as you get comfortable. In a month you'll have reporting infrastructure that actually drives decisions.

Word count: 1,587