How to make a simple Ecommerce dashboard in Google Data Studio

By 25th Oct 2019Blog, Google Data Studio
How to make a simple Ecommerce dashboard in Google Data Studio

In this post I’ll show you how to make a simple Ecommerce dashboard in Google Data Studio. This report gives you a quick overview of how your online store is performing.

Below is the Data Studio report, and below I’ll show you how each of the charts is created.

Creating the various charts in the Ecommerce dashboard

I’ll run through the various charts and tables and show you how they are constructed.

The dashboard is based on Enhanced Ecommerce dimensions and metrics from the Google Analytics Merchandise store demo account.

The scorecards

At the top of the report are two scorecards. The first shows the total amount of Product Revenue and the other shows the total Quantity of good sold. They’re simply scorecards that compare data to the previous period, to show whether revenue or quantity have increased or decreased.

simple Ecommerce dashboard showing total product revenue

The Product Revenue time series

The next chart shows the amount of product revenue and quantity of purchases over time. You can switch between the two metrics by using the Optional Metrics selector just above the chart, as shown below.

The next chart shows the amount of product revenue and quantity of purchases over time.

Our data is setup as shown below, with Product Revenue as our default metric and Quantity as our optional metric.

Our data is setup as shown below, with Product Revenue as our default metric and Quantity as our optional metric.

The Product table

The next item on our dashboard is a table showing the Product Revenue and Quantity of each Product.

In our simple Ecommerce dashboard is a table showing the Product Revenue and Quantity of each Product.

It’s a Table with a Heatmap that has Product Revenue and Quantity as its two metrics. There are also comparison columns showing the performance relative to the previous time period.

It's a Table with a Heatmap that has Product Revenue and Quantity as its two metrics. There are also comparison columns showing the performance relative to the previous time period.

The Country and City table

The next table shows the location of the revenue and quantity of product purchases. It is a table with a Drill Down function that lets you look at the Country and City of purchases.

The next table in our simple Ecommerce dashboard shows the location of the revenue and quantity of product purchases. It is a table with a Drill Down function that lets you look at the Country and City of purchases.

To get a drill down feature, we add in our two dimensions and turn on ‘Drill down’ with the ‘Default drill down level’ being Country.

To get a drill down feature, we add in our two dimensions and turn on 'Drill down' with the 'Default drill down level' being Country.

The Channel, Source, Medium table

The next table shows the gives a breakdown of the default channel grouping, and drills down into Source, Medium and Source / Medium.

It’s setup the same ways as the previous table. The dimensions this time are Default Channel Grouping, Source, Medium and Source / Medium.

It's setup the same ways as the previous table. The dimensions this time are Default Channel Grouping, Source, Medium and Source / Medium.

Other blog posts

If you liked this blog post, you might enjoy some of these other blog posts I’ve previously written!