Orders are pouring in to your Ecwid store, due to your clever and creative selling strategies.
However, while you happily look at the total revenue numbers in your Ecwid dashboard, a few niggling thoughts occur to you: How many products are selling? Which customers haven’t purchased in a while? What are the top selling categories? And other pertinent questions that you wish you can have the answers to, without being hunched over complicated spreadsheets for hours, and finding yourself staring at the 8th cup of coffee with glazed eyes.
The good news is that there are two easy methods for you to get the data you need, quickly and efficiently.
The first way, involves downloading orders from your Ecwid control panel into Microsoft Excel, and using Excel’s built in tools to analyze your data. While the second method is far easier and quicker — just install an advanced dashboard app directly into your Ecwid Control Panel.
Let’s have a look at both methods.
Method 1: Microsoft Excel — Step By Step Tutorial
In this tutorial, we will clearly show you how to get started with analyzing your Ecwid data via Excel.
- The first step is to download all of the orders from Ecwid into Excel. To do this:
- Go to your Ecwid control panel, Click on the My Sales tab, then click on the Orders sub tab.
- Scroll down and click on the Export All button.
- On popup screen, make sure Comma is selected in the Delimiter option, and then click on All, and click on Download CSV file button.
- Report Filter — this allows you to only view results from the filtered option.
- Row Labels — this represents all fields in which the data is in rows and shows values and is not a calculation.
- Column Labels — This is similar to the above window, the only difference being this will represent the data across columns. You can have both rows and columns in use simultaneously (a common scenario would have the items in the row window and the year in the column window).
- Values — The most important field, in which the data can be summed, counted, max, min, averaged, and more.
- Sum — which totals all the underlying data for that row.
- Count — the number of times this value appears.
- Average — Best used if you want to determine an average among a specific dataset.
- Max — Highest value, very useful when trying to determine latest date.
- Min — Lowest value, similarly useful when determining lowest value on specific field.
- There are other options that you’ll most probably rarely use.
After selecting desired Pivot Chart, you can enhance the way it looks, just as a regular chart. For example, you can add data lines, change chart colors, manipulate axis, dynamic title, and much more.
Although there are many advanced uses of Pivot Tables, such as: slicers; timelines; one Pivot Table off of another Pivot Table; calculated fields; and much more, the above tutorial will help you with some basic analysis on your Ecwid sales data.
Method 2: Business Insighter Dashboard App
Remember the part at the beginning of this post: there are two easy methods for you to get the data you need, quickly and efficiently? Turns out that the second way is actually far easier, and more advanced!
Ecwid users have an option to quickly get a terrific overview of their online sales via our dashboard app. This app is packed with features: key stats; top items, customers and categories; open bills; shipping status; and more, in a beautifully designed and easy to use dashboard.
There’s no need to download excel sheets and try to determine what’s selling and what’s not, we do that for you instantly. It is also worth noting, that there are features in here that Google Analytics does not offer.
Additionally, in this app you will get to drill down to a specific product and see the various customers that purchased that specific item. Conversely, you can drill down to a specific customer, and see his order status, any open invoices and how long it’s been open for, as well as most frequently purchased items, and more. This app will give you the data you need, in order for you to manage the business you love.
Try this app for free with our 7 Day Free Trial — No Credit Card Required.