Building an Ecommerce Analytics Dashboard: Step-by-Step Guide
Why a Custom Dashboard Beats Checking Individual Platforms
The average ecommerce store owner uses 6 to 10 different tools to run their business, each with its own analytics section. GA4 for traffic and conversion data, Shopify or WooCommerce for order and product data, Google Ads for paid search performance, Meta Ads Manager for social advertising, Klaviyo or Mailchimp for email metrics, and potentially more tools for automation, inventory, and customer service. Checking each platform individually takes 20 to 30 minutes per day, and the mental effort of synthesizing data across tools means that important patterns go unnoticed.
A dashboard solves this by pulling data from all your tools into one view. When revenue, traffic, conversion rate, and ad spend appear side by side, you instantly see relationships that are invisible when checking tools separately. A revenue drop on the same day as an ad spend decrease tells a different story than a revenue drop with stable ad spend. A conversion rate spike coinciding with a successful email campaign tells you exactly what worked. These connections are the foundation of data-driven decision making, and they require seeing all your data in one place.
Before You Start
You need a configured GA4 property with enhanced ecommerce tracking enabled. You need a Google account for Google Looker Studio (the recommended free dashboard tool). You need login credentials for any additional data sources you want to include, such as your ad accounts or email marketing platform. And you need a clear idea of which metrics matter most to your business at its current stage, which the KPIs guide helps you determine.
Step-by-Step Setup
A dashboard that tries to show everything shows nothing useful. Select 8 to 12 metrics that you need to check daily, grouped into three categories. Revenue metrics: total revenue, number of orders, average order value. Traffic and conversion metrics: total sessions, conversion rate, revenue per visitor. Marketing metrics: ad spend, return on ad spend, email revenue. Customer metrics: new vs. returning customer ratio. Write these down before opening any tool. The dashboard should reflect your decision-making needs, not the available data. If a metric would not change any decision you make this week, leave it off the main view.
Google Looker Studio (formerly Data Studio) is free, connects directly to GA4, Google Ads, and Google Sheets, and produces professional dashboards that you can share via link. It is the best starting point for most ecommerce stores. Databox ($0 for 3 data sources, $72/month for more) offers native connectors for Shopify, Klaviyo, Facebook Ads, and 70+ other tools, with a mobile app for checking metrics on your phone. Klipfolio ($90+/month) and Geckoboard ($44+/month) provide similar multi-source dashboards with different design and collaboration features. For most stores under $500,000 per year in revenue, Looker Studio is more than sufficient and the price (free) cannot be beaten.
In Looker Studio, click Create Report, then Add Data. Select Google Analytics to connect your GA4 property, which gives you access to all traffic, conversion, and ecommerce data. To add Google Ads data, select the Google Ads connector and link your ad account. For Shopify data, you can use a third-party connector like Supermetrics ($39+/month for Looker Studio) or export key data to Google Sheets and connect the sheet as a data source. For email marketing data from Klaviyo or Mailchimp, the Google Sheets intermediary approach works well: export weekly campaign summaries to a shared spreadsheet that Looker Studio reads automatically.
Your main dashboard page should answer the question "how did we do yesterday?" in under 30 seconds. Start with scorecards across the top showing yesterday's revenue, orders, sessions, conversion rate, and AOV, each with a comparison to the same day last week (percentage change). Below the scorecards, add a line chart showing daily revenue for the past 30 days to visualize trends. Below that, add a table showing traffic sources with columns for sessions, conversion rate, and revenue, so you can quickly see which channels performed well yesterday. This single page covers 80% of what you need to know each morning.
Create a second dashboard page focused on paid advertising performance. Include scorecards for total ad spend, total ad-attributed revenue, and blended ROAS (total revenue divided by total ad spend). Add a table showing each advertising channel with its spend, conversions, cost per conversion, revenue, and ROAS. Add trend charts for spend and ROAS over the past 30 days to spot patterns. If you run campaigns across Google Ads and Meta, seeing them side by side reveals budget allocation opportunities: if Google delivers a 5x ROAS and Meta delivers a 2x ROAS, shifting budget from Meta to Google (up to the point where Google's ROAS starts declining) improves overall efficiency.
In Looker Studio, click the Schedule Email Delivery button (clock icon) and configure a daily or weekly email that delivers a dashboard snapshot to your inbox. Set it to arrive 30 minutes before you typically check metrics so the data is waiting for you. For more sophisticated alerting, set up custom alerts in GA4 (Admin, Custom Alerts) that email you when conversion rate, revenue, or sessions deviate from their baseline by more than a threshold you define. These alerts catch problems (broken checkout, traffic drops) within hours instead of waiting until your next manual dashboard check.
Dashboard Layout Best Practices
Put the most important metrics in the top left corner of the page. Eye-tracking studies show that people scan dashboards in an F-pattern, starting at the top left, scanning right, then dropping down to the next row. Your revenue and conversion rate scorecards should be the first things visible because those are the numbers that trigger action if they look unusual.
Use comparison periods for every metric. A standalone number like "$4,230 revenue" is meaningless without context. The same number shown as "$4,230 revenue, up 12% vs. last week" tells you whether to celebrate or investigate. Looker Studio scorecards support comparison periods natively: select the metric, set the date range to "Yesterday," and set the comparison to "Same day last week" or "Previous period."
Limit each dashboard page to one screen (no scrolling required on a standard laptop display). If you need more data than fits on one screen, create additional pages that you navigate to when you need deeper analysis. The daily overview should never require scrolling because scrolling means important metrics might go unchecked. Keep the main view tight and let secondary pages hold the detail.
Use consistent color coding across all charts and tables. Green for positive trends, red for negative, and a neutral color for comparisons within normal range. This visual shorthand lets you scan the entire dashboard in seconds and spot problems without reading individual numbers. If everything looks green, your store had a good day. A red scorecard immediately draws your eye to the metric that needs attention.
What to Include on Your Dashboard by Business Stage
Early stage (under 100 orders/month): Keep it simple. Revenue, sessions, conversion rate, AOV, and top traffic sources on a single page. You do not have enough data for ROAS analysis or cohort dashboards to be meaningful. Focus on validating that your tracking is working correctly and building the daily review habit.
Growth stage (100 to 1,000 orders/month): Add marketing channel performance, email campaign revenue, and new vs. returning customer breakdown. This is the stage where dashboard insights start directly influencing budget decisions. Include a 7-day and 30-day comparison view to distinguish short-term noise from genuine trends. Add your core KPIs with benchmarks so you can see at a glance whether each metric is above or below your target.
Scale stage (1,000+ orders/month): Add product performance analytics, CLV by channel, cohort retention views, and funnel analysis. At this volume, you have enough data for sophisticated analysis and the revenue impact of small percentage improvements is large enough to justify dedicated dashboard pages for each analytical dimension. Consider adding a separate operational dashboard page showing inventory levels, shipping times, and customer service response metrics.
Free Dashboard Template for Looker Studio
To get started quickly, build your Looker Studio dashboard with this structure. Page 1: Daily Overview with 5 scorecards (revenue, orders, sessions, conversion rate, AOV), a 30-day revenue trend line, and a traffic source table. Page 2: Marketing Performance with ad spend scorecards, channel comparison table, and 30-day ROAS trend. Page 3: Product Performance with a table showing product name, revenue, units sold, and conversion rate. Connect GA4 as the primary data source, which covers all three pages. Add Google Ads and Google Sheets connections as needed for the marketing page.
The entire build takes about 60 to 90 minutes for someone new to Looker Studio. The visual editor is drag-and-drop, and most chart types can be configured by selecting the data source, choosing the metric, and setting the date range. Save your dashboard and bookmark the URL so you can access it with one click each morning. Share it with business partners or team members by clicking Share and entering their email addresses.