Free Data Studio Template: Ecommerce Edition

/

free-data-studio-template-ecommerce
Our first free Data Studio template for Google Analytics focused on high-level metrics for a monthly overview of site performance. But if customers spend money on your site, you’ll want a report that highlights ecommerce metrics, too. We’re happy to help!

If you haven’t used Data Studio yet, allow me to introduce you to this new tool from Google. Data Studio makes it easy to create and share interactive reports with your colleagues, using data from one or more sources in the same report.

We’ve created a Data Studio ecommerce report that shows only data from Google Analytics, because it’s based on the free Google Analytics Demo Account. If you don’t have your own ecommerce data, the demo data lets you experiment and learn Data Studio with our free template.

Our Data Studio report for Ecommerce adds a few new tricks to the overview template!

Get Free Data Studio Template: Ecommerce Edition

Step 1. Add Your Own Data Source or Use the Demo Account

Click the template button, but do not request access. Instead, add your own data source following Steps 1 through 8 for our Data Studio overview template. Or you can use the Google Analytics Demo Account as I did throughout this post. Read the linked article to get demo account access if you don’t already have it.

Step 2. Check out the Sparklines!

Data Studio ecommerce metrics with sparklines

Data Studio comes with nine chart options. A sparkline isn’t one of them, so we created our own. Sparklines under each of our top row metrics give a quick snapshot of those trends for the past month. (See that mid-month spike? Better investigate!)

To create a sparkline, choose the Time Series chart option. On the Style tab, un-check “Show axes” and select “No Legend”. Re-size. It’s that simple!

Data Studio sparkline step 1

Data Studio sparkline step 2

Step 3. Try a Bar Chart with Two Axes

Our bar chart conveys a lot of information in one visual. Using two axes, you can easily compare the relationship of average order value vs. the number of transactions for two different groups. (Women buy less often, but spend 2X more per purchase!)

Data Studio bar chart with two axes

We’re comparing based on gender, because the demo account has Demographic Reporting enabled in Google Analytics. But you can replace “female/male” in this chart with any dimension that has only a few values. For example, you could compare User Type (New vs. Returning). You could also use one of your own custom dimensions to define audiences for this purpose.

Click the Edit toggle at the top right of the report and then click the chart to see our bar chart options. On the Data tab we added a second metric, and on the Style tab we checked “Show data labels” and “Show axes” (Double). For both the left and right axis we checked “Show axis title”.

Step 4. Build a Table with Product Data

Product data in Google Analytics comes with its own special set of metrics. We’ve chosen to show Product Revenue and Quantity. (Water bottles are the most popular item, but notebooks make more money!)

You can also sort the table Product Revenue by clicking on that column header. (Try it and see which product made even more money than notebooks!)

If you have Enhanced Ecommerce data, you can add metrics like Buy-to-Detail Rate, which show how often someone who viewed a product actually bought that product. Or you could change the Product dimension to Product Category, for a roll-up view of your product performance.

It’s easy to change the metrics and dimensions in Data Studio – make sure your Edit toggle is in Edit mode and then select a chart to change the options on the Data tab.

Edit toggle and Data tab

Step 5. Don’t Forget the Filters

We kept the filters from our original Data Studio template so you can explore your ecommerce data the same way! You can edit the filter options as well. Add another filter or revise an existing one.

For example, you might want to create a filter based on a custom dimension. The Google Analytics Demo Account has a custom dimension for “Sales Region” which you can try with this template if you have access to the demo data. The screen shots below show how to change the Country filter to a filter for Sales Region – edit the Filter control properties and choose the custom dimension by searching the list.

Filter control properties in Data Studio

Choose another filter dimension in Data Studio

Search for your own custom dimensions and change the filters to make them more useful and relevant for your ecommerce reporting!

Stay tuned for more Data Studio goodness from LunaMetrics!

We have lots more Data Studio ideas coming your way soon. And we’re always happy to hear from you about unique challenges or discoveries. Please share in the comments!

Dorcas Alexander is the Analytics Department Supervisor. Her path to LunaMetrics followed stints in ad agency creative, math, and computer science. Dorcas has a master's degree in language and information technologies from Carnegie Mellon University, where she helped build precursors to a Universal Translator. One of the top-rated tournament Scrabble players in Pennsylvania, Dorcas has an insatiable drive to compete and win.

  • https://vk.com/iosiuk Діма Осіюк

    Thanks!)

  • Olga Khomyakova

    Unfortunately, it seems that Data Studio doesn’t work in my country 🙁

  • Nick Guebhard

    This is great thanks, Dorcas. I’ve adapted it for my own purpose and added some enhanced ecom metrics. https://datastudio.google.com/open/0B-BgMx6QNUyJTnB5alBDR3E3LUk

    Some of my changes are due to Stephen Few’s recommendations to reduce or minimise “non data ink” and include more context (i.e. historical performance and comparison to previous). Not saying mine is better; just a different focus. I ran into some difficulty with creating a rolling 12 month graph. I can only see the option to select last quarter for rolling graphs. As a result, I had to use fixed date graphs. Do you know if there is a way to achieve a rolling 12 month graph with Data Studio?

    Thanks
    Nick

    • Dorcas Alexander

      Nick, I love your version of the report! I am not aware of how to achieve a rolling 12-month graph, but will check into it.

Contact Us.

LunaMetrics

24 S. 18th Street, Suite 100,
Pittsburgh, PA 15203

Follow Us

1.877.220.LUNA

1.412.381.5500

getinfo@lunametrics.com

Questions?
We'll get back to you
in ONE business day.