Ecommerce data and tracking is becoming more sophisticated each year. In this article we look at our favourite ecommerce dashboards for Looker Studio (formerly Google Data Studio) in 2023. As an eCommerce businesses you probably deal with mountains of data on a daily basis. It’s crucial for you to be able to easily, intuitively and simply access and make sense of this data. Having the right data visualisation tool could be make or break.
Google Looker Studio (Data Studio) provides an elegant solution for presenting marketing data for eCommerce businesses. Many digital marketing platforms are easily connected to Looker Studio. Since eCommerce business are setup to track revenue and transactions, this data can be pushed through to Looker Studio seamlessly.
There are many great templates available for Google Looker Studio (formerly Google Data Studio). Rather then build your own, often a better solution is to plug into one of the great templates already available. In this post, we take a look at the best eCommerce Looker Studio Templates from across the web.
1. The Ecommerce Speed Dashboard
View Template: https://datastudio.google.com/u/0/reporting/0B-7yurpNRXouUzNibGNsYlBzT2s/page/kKrB
If you are running an eCommerce site, you know that a slow site means fewer conversions and lost revenue. The eCommerce report from Canonicalized demonstrates the relationship between your site speed and bottom line.
What’s impressive about this dashboard is that Canonicalized has broken down the answer into a dashboard that is not only easy to understand but also easy to integrate.
This dashboard shows sessions compared to average page load time. It also shows average page load time by device category: desktop, tablet, and mobile.
If you are looking to see how each page performs, there is a table that shows each page along with sessions, average page load time, and average server response time.
Despite being a one-page minimalistic template, you can take real action based on the insights. For example, say you notice that most of your sessions are from the United States, but your USA page load times are slower than any other place. You could use a CDN or even migrate your site to a server in the USA.
This dashboard made our ‘best’ list because it fits the definition “less is more”. The dimensions and metrics are presented concisely, allowing you to see all the data on one page.
This dashboard is good for UX experts, web designers, SEO experts and webmasters whose goal is to make the site as user-friendly as possible. It allows them to see data at both a macro level (continents, countries, aggregated page load times and sessions) as well as a micro level, such as page load time by page.
You will certainly need to combine this with other dashboards to get a fuller picture of site performance
2. Google Merchandise Store Report
View Template: https://datastudio.google.com/u/0/reporting/0B2-rNcnRS4x5UG50LTBMT0E4aXM/page/nQN
The Google Merchandise Store Report is developed by Google. To use this template, you need an eCommerce store that’s integrated with Google Analytics.
This dashboard includes all the important dimensions and metrics such as sessions, product add to carts, revenue, cart-to-detail rate as both an aggregate and per product or medium basis. You can filter the data by device category, country, user type, and source/medium.
We like that the dashboard allows you to see overall trends and also provides product specific information. Google has done a good job giving you the option to hone in on product-specific info while including top-level info all on the same view.
The template is quite simplistic. It’s a nice concise report but lacks some detail.
3. The Merchandise Store Website Performance Report
View Template: https://datastudio.google.com/u/0/reporting/1lK4qQV1orRoyd1s_mYeNt-Mbye4f40YT/page/sfjO
This is another one-page eCommerce dashboard, but this time this dashboard contains a lot more detail. The template is sectioned into 5 categories: Performance, Conversions, Audience, Acquisition & Behaviour.
The level of detail provided is significant. All this info is jam-packed onto 1 page, which can make it slightly overwhelming at first glance. However, on closer inspection it really packs a lot of punch and is a great dashboard. The diversity of information in such a small amount of screen space is phenomenal.
The dashboard answers many of the questions an eCommerce website manager would ask including: What is my performance right now? How has this changed compared to the previous period? Where do visitors come from? How do they behave? etc…
There are filters for the date, user type, and device category. This is a nice way to disect the data, as you can quickly adjust to see the information just for new visitors. This is a dimension often overlooked by marketers.
This dashboard is good for eCommerce businesses that want to keep their finger on the pulse and if something seems off, such as sales, they can instantly take action and get to the bottom of things.
Developed By: Data Runs Deep
4. The Enhanced Ecommerce Funnel Template
View Template: https://datastudio.google.com/u/0/reporting/1arhrkUyjC8IJM2fYK_52AUTxZuZyuKbu/page/5Bws
This template visualizes the data from the shopping behaviour report in Google Analytics and it does a pretty good job of replicating the report completely.
The dashboard shows you the percentage of users who pass through your sales funnel, ultimately making that buying decision. It shows all sessions, then sessions with product views, then sessions with add to cart, then sessions with checkout and finally, sessions with ka-ching!
We like this dashboard because, in addition to displaying the people moving from one stage to a subsequent one, it shows you how many dropped off along the way. There is even a table that shows the actions and abandonments by device category.
The dashboard makes our ‘best’ list because if you are in eCommerce, you want to know when you lose a significant proportion of visitors at a certain step. For example, say after product page views, very few people add products to cart. This could indicate a problem with your product pages. This could indicate content or technical problems.
This dashboard is good for conversion optimization experts, whose job is to increase the number of conversions and revenue with the same amount of traffic. They want to increase the proportion of people moving through each stage as much as possible.
5. The Enhanced eCommerce Dashboard
View Template: https://bymarketers.co/product/enhanced-ecommerce-dashboard/
The Enhanced eCommerce template is tailored for eCommerce businesses that have set up enhanced eCommerce tracking on Google Analytics. If you run an eCommerce site and would like to see detailed information arranged in a better way than in Google Analytics, this report is for you.
You can share the dashboard with other people in your company to stimulate discussions around sales and revenue. The template shows year-on-year revenue, purchases, and revenue per purchase.
The template also shows data on product views and add to carts. With custom filters provided out of the box, the dashboard allows you to filter data based on date, the Analytics profile, source, country, and user type.
This dashboard breaks down eCommerce data into several logical sections. These are clearly named as Financing, Conversion, Customers, and Product. You can see the current data, its comparison to the previous period, and the trend.
The dashboard aims to answer key questions in a clear way: How much revenue are we getting? How many people are converting, and how does their conversion vary by landing page and source/medium? What are the demographics of our customers? Which products do customers buy the most?
Developed By Us! 😉
6. The Sales and Shopping Behavior Dashboard
View Template: http://datastudio.google.com/reporting/310e1265-b8e9-4bb8-9cd9-0b3d67145ed4
The ‘Sales and Shopping Behaviour Report’ has been beautifully designed by ‘My Digital Lab’. The template does just what it proclaims to do. It provides insight into shopping and sales performance for eCommerce websites. It also gives insights into Channels and Devices as a bonus.
What is striking about this template is the design it provides. The top part of the template provides a number of intuitive filters that are great to use and can also easily be combined. The use of large icons and graphs to shout out sections and highlight information has also been well done. The attention to detail on this dashboard is high and it’s the key reason we have included it in this review.
This design allows the dashboard to stand out and provide strong insights to the user. If you are interested in sales and shopping behavior you have most of the info you need here including a funnel. It shows unique purchases, quantity purchased, revenue, and average price. It shows the basket-to-detail rate, buy-to-detail rate, brand performance, product performance, channel performance, and device performance.
This dashboard is good for eCommerce businesses doing a monthly or quarterly introspective of their business. You can dissect your eCommerce data through a plethora of filters and date ranges. With this template, your long sales meetings can finally be productive!
Developed By: My Digital Lab
7. The Facebook Campaign Template
View Template: https://datastudio.google.com/u/0/reporting/1hSOTY3Ea_fMmdylPu5ZVxow4-YkvCDYK
The Facebook Campaign template by NextAd is designed to provide a review of your Facebook ad campaigns. It has 5 pages and provides a good level of detail for Facebook campaigns.
We have included this in our top eCommerce review as it has information on eCommerce. On the front page, it provides some detail on purchases and revenue. On page 4 it also has a funnel overview which provides some detail on low funnel campaigns.
Since this template gives a wide overview of Facebook campaigns it is certainly not as in-depth as other eCommerce specific templates for eCommerce website managers, however, it is difficult to find good Facebook templates that are geared towards eCommerce so we have included it.
On the summary page, the template breaks down your Facebook data by cost and impressions, clicks, and purchases. It also has a table that breaks down your campaigns by objective, the amount spent, revenue, results, cost per result, impressions, and ROAS.
The dashboard has six pages: overview (live data), audience breakdown (the who), creative breakdown (the why), funnel overview (the when), and campaign level.
We also liked the clean design of the dashboard. The information is nicely spaced, easy on the eyes and easy to understand.
There is some configuration required with this dashboard. It appears you need to be a client of ‘The Next Ad’ to use the template as well. This is a significant downside to the dashboard, it is not plug and play and requires subscribing to their account and using their connector.
Developed By: NextAd
8. The Aro Digital eCommerce Dashboard
View Template: https://datastudio.google.com/u/0/reporting/1mqTA-aptRwBcxpFUeZZ66CcPHhOTUVK6/page/VgD
The Aro Digital template is also a more generalist template but has a lot of information included on eCommerce transactions. The template connects to four different data sources: GA, Google Ads, Search Console and Facebook Ads. It’s great for getting a solid overview of key traffic sources for your eCommerce site.
The template is well designed and has a good selection of KPIs. Consequently, you can segment your data to hone in on a specific location, channel or demographic.
The template consists of 4 pages, covering most of the key search marketing elements a website eCommerce manager would want to see
The design is a bit busy on this template. However clever use of colours make it look professional and readable. They are packing in a lot of information into 4 pages. We think they have done well to incorporate key information from the key traffic sources.
Developed By: Aro Digital