1.4. Live Workshop: Creating an eCommerce Dashboard in Looker Studio - Part 1

Learning Objectives

  1. Learn how to create, customize, and manipulate different types of charts.
  2. Understand how to add interactive components, such as controls and filters, to a dashboard.

Looker Studio Masterclass - YT - Free - Slides - C01_2_page-0005.jpg

Building a Simple eCommerce Dashboard with Looker Studio

With these basics covered, you're ready to start building your e-commerce dashboard. Let’s dive in and explore the power of Looker Studio!

A Simple eCommerce Report

Imagine a simple eCommerce report connected to Google Analytics, displaying essential KPIs like sessions, transactions, average order value, eCommerce conversion rate, and revenue for a specific time period.

This report also allows you to change the date range and updates the data accordingly. It includes a map of transactions by US states, a time series chart for sessions and new users, a horizontal bar chart broken down by device category, male vs. female users, and new users and revenue from various source mediums.

Ready to recreate this in Looker Studio? Let's start!

Setting Up the Grid

First, let's organize our report by setting up the grid. Head to Theme and Layout and adjust the grid size to 20 pixels.

Adding Scorecards

Now, let's add scorecards for our metrics. Scorecards display a single aggregated value, like a number, ratio, or currency.

Add a scorecard, resize it, and snap it to the grid for a clean layout.

To change the metric, search for the desired field (e.g., "sessions") and drag it onto the scorecard.

You can also include comparisons to previous periods by adjusting the Default Date Range and Comparison Date Range settings.