In this post I’ll show you how to create some of the different sections of a detailed Ecommerce report in Google Data Studio.
Ecommerce in Google Analytics allows you to monitor the performance of your online business. Google Data Studio allows you to create custom reports that suit your own needs.
If you would like to purchase this Ecommerce Report Template you can visit Data Studio Templates to download it.
Here’s a breakdown of how to make the various charts in the Data Studio report.
1. A Table showing various Ecommerce metrics by Source/Medium
Here’s a big, colourful table with ten metrics. I’ll go through each of them with official definitions from Google Analytics.
- Pageviews – Pageviews is the total number of pages viewed. Repeated views of a single page are counted.
- Product Detail Views – Number of times users viewed the product-detail page.
- Product Detail Views / Pageviews – A custom field.
- Product Adds To Cart – Number of times the product was added to the shopping cart.
- Cart-to-Detail Rate – Product adds divided by views of product details.
- Product Checkouts – Number of times the product was included in the check-out process.
- Quantity – The number of units sold in ecommerce transactions.
- Buy-to-Detail Rate – Unique purchases divided by views of product-detail pages.
- Product Revenue – Revenue from individual product sales.
This table has four different possible dimensions, which you can drill down into.
There are several other tables in this dashboard constructed the same way, so I won’t repeat the steps for each of them.
2. A bar chart showing Ecommerce metrics by Channel Grouping
This bar chart shows some of the key Ecommerce metrics. It shows them in the order a potential customer would interact with them. First is Product Detail views, then Product Adds To Cart, Product Checkouts and final the quantity of products purchased. These metrics are listed as ‘Optional Metrics‘ so you can choose which of the four to display in the bar chart.
Next, we can create this bar chart by adding three dimensions (making sure Drill down is activated, so we can switch between them) and adding four metrics (making sure Optional Metrics are activated, so we can exclude some of them if we want).
3. A time series chart with eight optional metrics
The next chart is a time series chart showing various metrics over time. These are all optional metrics, with only one (Pageviews) being shown by default. You can pick and choose which metric you’d like to see.
Below you can see the data tab for the time series chart, showing the default Pageviews metric and all the other optional metrics.
4. A Geo Map showing Countries, Regions and Cities
Geo maps are usually fun and visually interesting to include in a dashboard. On page two of the Data Studio dashboard I include one. It has optional metrics, and more importantly it has three geographic dimensions that you can drill down into; country, region and city.
In the image below we see we can drill down to see the revenue by country, region and city.
Below is the data tab from the geomap. We can see the three geographic dimensions, the default metric Revenue and the two optional metrics; Quantity and Product Detail Views.
5. A Treemap with multiple Optional Metrics
Another colourful way to display data is by using a Treemap. Treemaps display the value of dimensions by size and colour.
I’ve added five metrics to this treemap, and you can choose to switch between them by clicking the optional metrics icon.
This is how the treemap is setup. I’ve chosen to only display one dimension which is Product Category. You can see below that Product Revenue is the default metric and there are four other optional ones.
6. A Scatter Chart with multiple Dimensions
The final chart type I have in this dashboard is a Scatter Chart. This chart shows a dimension with three different metrics attached to it. One metric determines each dimension bubble’s place on the y-axis, the other on the x-axis and the third determines the size of each dimension bubble.
You can use the drill down arrows to switch between the various dimensions, as shown below.
Below is the data tab from the Scatter chart. You can see the four dimensions and three different metrics that make up the chart.
7. The finished Ecommerce report in Google Data Studio.
Below is the finished Google Data Studio report that you can use to understand how your online business is peforming.
This template is available for purchase at Data Studio Templates.
My Other Blog posts
I hope you enjoyed the blog post about how to make a detailed Ecommerce report in Google Data Studio. You might like to check out some of my previous blog posts.