How to Set Up Daily E-Commerce Reports in Google Analytics

Nov 29, 2016 by Lina Vashurina, Ecwid Team
How to Set Up Daily E-commerce Reports in Google Analytics
Posted Nov 29, 2016 by Lina Vashurina, Ecwid Team

We often associate analytics with two main issues: the difficulty of understanding the metrics and the time-consuming process of getting the necessary data.

Did you know that you can set up a daily, weekly, or monthly report that is automatically sent to your inbox? And that you can pick up the metrics you WANT to track and customize the report so that it becomes easy to understand?

It’ll only take an hour of your time to set up the report once, and you will never spend more than five minutes a day on analytics. Here’s how to do it.

What Data You Should Track

When studying a report, analysts usually look for the number of visits, page views, referrers, etc. But those data do not say anything about the performance of the store.

You can have thousands of visitors per day and no orders. Or you advertise on five advertising channels, but you do not know who the most generous customers are, and where you are spending your money for nothing.

To evaluate the cost-effectiveness of an online store, you need to look at the following data:

  • total revenue
  • transactions
  • average order value
  • average revenue per session
  • average revenue per user
  • products
  • revenue per traffic source
  • e-commerce conversion rate per traffic source
  • revenue per product

In order to regularly receive relevant data on these indicators, it’s not necessary to spend a lot of time on the statistical analysis. The only thing you need to do is to set up a summary report once.

That page will contain all the data you need and regularly update them. One look, and you’ll know all the sales of your store in a day, month, or another period.

Report creation does not replace statistical systems, but it does facilitate your daily work. If you can see from the summary that your store is doing great, there is no need to log in. A deep analysis of the data will determine if something went wrong, and the daily report can tell you that.

Your Dashboard in Google Analytics

Once you have configured a sales summary report with Google Analytics, you can get all the information on what is happening with the shop on a daily basis in a couple of minutes. No need to wander through the reports and build segments. All the data are collected on a single page.

In addition, you can schedule how often reports are sent to your inbox: daily, weekly, or monthly.

This will also reduce the time for the daily statistics authorization systems. Every morning you can get a report on the results of the previous day; every Monday, a report for the previous week; and on the first day of each month, you can expect a full report with the data for the previous month.

You can customize any summary as you wish, or use the one that we offer:

Google Analytics Dashboard

Widgets

Each summary includes widgets, which are individually configurable blocks. The maximum number of widgets available in one summary is 12. In our example, we use them all. The choice of widgets is based on the principle of maximum utility.

Widgets are placed in columns. There are six accommodation options available for widgets in the summary.

layout options

There are two kinds of widgets:

  • standard widgets, reflecting data for the selected time interval; and
  • widgets that show data in real time. These work well for regular ongoing monitoring.

The widgets are categorized into types:

  1. metric
  2. timeline
  3. geomap
  4. table
  5. pie
  6. bar

add a widgetOptimal widgets for building sales reports are a metric and table. Notice that the maximum number of rows is ten, and for columns it’s three. If there are more rows in the table, it displays the first ten rows, sorted by the first metric.

We picked the following widgets for the report:

1. Sessions

Sessions

This metric shows the total number of site visits for a specific period.

2. Total Revenue

Total revenue

As you can see in the picture, this widget shows the total revenue for a specific period.

3. Average Revenue per User

Average revenue per user

This widget shows the average amount of revenue per user.

4. Transactions

Transactions

Again, it’s clear that the widget shows the number of transactions for a specific period.

5. E-commerce Conversion Rate

E-commerce conversion rate

This is your conversion rate — the number of transactions divided by the number of visits.

6. Average Order Value

Average order value

This widget displays the average order value.

7. Quantity

Quantity

This widget displays the number of sold products.

8. Average Revenue per Session

Average revenue per session

This widget shows the average revenue that one visit brings (i.e. the total revenue divided by the number of visits).

9. Products

Products

This table shows the number of sold products and their revenue.

10. Revenue / Traffic Sources

Revenue/traffic sources

This widget tells you where your visitors come from and how much money they spend in your store.

11. Revenue / Channels

revenue/channels

This widget shows you the average order value for different sales channels.

12. E-commerce Conversion Rate / Traffic Sources

e-commerce conversion rate

Find out the number of transactions from every traffic source and their conversion rate.

Setting Up the Report for Your Online Store

To make a similar summary that contains all the data you need, do the following:

  1. Add Google Analytics to your store.
  2. Configure the store to e-commerce tracking data.

Learn more: The Beginner’s Guide To Google Analytics For E-commerce Stores

When you’re done with steps 1 and 2, log in to Google Analytics and click on this link.

Then you can choose the account and the view of your report.

dashboard configuration

Now you can open the report whenever you need it.

It’s always there on your Dashboards —> Private —> Sales. To create a report for a certain period, choose the dates in the top right corner. If you want to edit the widgets, just click on them.

Sales in Google Analytics

Sending Automatic Reports to Your Inbox

You can export the report, and send it to yourself or to a colleague.

Export report from google analytics

But the best part is that Google Analytics can send it to you automatically — daily, weekly, monthly, or only once. You just need to set up the frequency and type in your email address.

Using advanced options, you can also limit the time during which you’ll get the reports — from one to 12 months.

email report sales

About The Author
Lina is a content creator at Ecwid. She writes to inspire and educate readers on all things commerce. She loves to travel and runs marathons.

Stay up to date!

Get free e-commerce tips, news and inspiring ideas delivered directly to your inbox