Airboxr - No-code querying and data-enrichment interface for GSheets. | Product Hunt

How to build your own Shopify sales report in Google Sheets

The must-have metrics for your Shopify sales report

Shopify generates plenty of analytics data to help you measure the performance of your store. It collates the data and presents them to you in the form of Shopify reports. But it is typically easy to get lost in reports if you don’t prioritize the right metrics.

This guide will go over all the metrics necessary for your Shopify sales reporting. You will also learn how to present your sales data in Google Sheets—one of the most widely used tools for analysis.

We’ll dive deep into the following topics:

Key metrics for your sales report

Gross Sales: The amount of money earned from the sales of your products over a period of time excluding any deductions like taxes, discounts, returns, and shipping.

Reviewing this metric can help you understand the total amount of revenue made by your store. It is also a basis for calculating other important revenue metrics such as net sales and gross profit margins.

While gross sales represents the total revenue of your business, it does not tell you your store’s profit. To get a better overview of your store’s selling performance, you should also track net sales.

Net Sales: The sum of gross sales minus the total deductions.

This metric gives you insights into the effectiveness of your sales strategies as well as your product quality. Net sales along with gross sales can help you understand how well your business is performing and devise plans to sell better.

Total Orders: The total number of orders generated through your Shopify store during the selected period.

Total Discount Amount: Total reduced prices on your products.

Total Shipping Amount: Total shipping fees paid by customers.

Total Refunds and Returns: Refund is the amount of money being returned to the customer who is not satisfied with the products they purchased. On the other hand, return is the process of a customer bringing back a purchased product to your store, but not necessarily to get their money back. Such returned products could be exchanged for other products, store credits, or could also be refunded.

It is important to take note of the total refunds and returns of products in your store. If there are many customers returning the same product then there could be something wrong with the quality and functionality of the product. This understanding could help you take necessary actions to prevent further returns.

Average Order Value (AOV): The average amount your customer spends per order on your store.

This is an important metric to track as it helps you evaluate the effectiveness of your marketing and pricing strategies. A higher AOV indicates better profit margins and growth opportunities for your business.

Sales by Product: Your best-selling products over a given period.

This helps you identify the most popular products in your store. Keeping track of your best-selling products is helpful for inventory planning, making decisions about promotions and discounts, and so on. This can also help you create strategies for the kind of products you want to sell in your store.

Sales by Customers:

Customers are vital to running your business. They help you drive more sales and increase your revenue. So it’s important to identify who your customers are. There’s a lot of customer data on Shopify to help you understand and analyze your customers. Let’s take a look at some of the important customer metrics that you should include in your sales report.

  • Repeat Customers: Customers who return to your store to make more purchases.

The number of repeated customers in your store directly impacts your overall revenue. A repeat customer is more likely to visit your store and make purchases again and again. So it’s important to make strategies to turn your new customers into returning customers.

  • High-Value Customers: Customers who buy higher-value products from your store.

High-value customers are very profitable to a business. They can also influence how other people perceive the brand. You should nurture your high-value customers and come up with strategies to retain them.

  • Customers by Sales Quantity: Customers who buy the maximum number of products from your store.

These customers can be both new as well as repeat customers. Tracking this metric helps you understand the kind of customers you should target to make more sales.

These are some of the key sales metrics that you should pay attention to while preparing your sales report. Besides these, if you want to learn more about other important metrics to track for your store including industry benchmarks then go over our Shopify Whitepaper.

Download our Shopify Whitepaper here.

Sales Reporting in Google Sheets

Now that we have learned about the key sales metrics, let’s get into how to present these data in Google Sheets.

The manual way

One of the ways you can present these data on Google sheets is by exporting them manually from Shopify and adding them to your spreadsheet. To do so, first, you need to know where to access them on Shopify. You can find these metrics under the sales report. To view the sales report, you need to be subscribed to a regular Shopify plan or premium Shopify plan.

Step 1: Go to Analytics → Reports in the left corner of your Shopify Admin Dashboard.

Step 2: Under the Sales section, click on the report that you want to view.

Step 3: Now export the required report.

You can now manually add these reports to your spreadsheet by importing them.

The biggest problem with the manual approach is that it is very time-consuming. You will have to spend hours just to get your data in place. The second biggest problem is the abundance of data. Each of the Shopify sales reports contains more information than you’d probably require. Even if you want to access certain metrics, you’d have to export the entire report. This slows down the process of analysis.

The Airboxr way

Now let’s take a look at a more efficient and effective way- using Airboxr.

First, you need to connect your Shopify to Airboxr. You can find the instructions here.

Once your Shopify is connected, follow the instructions below to present your Shopify sales data on Google Sheets.

Step 1: Launch Airboxr.

Step 2: Go to Import and Select Shopify.

Step 3: Now select the table you want to extract your data from.

Step 4: Select all the columns you need. Notice how you can select only the required metrics here unlike in the manual way.

Step 5. Filter and aggregate your data if needed.

Step 6: Click Import.

You will see your Shopify sales report in your spreadsheet. This method is much easier and faster than the manual way. But can we do better?

The answer is a yes. You can use Airboxr’s built-in Shopify hops to generate your sales report with a click of a button. Let’s see how.

Step 1: Launch Airboxr.

Step 2: Go to Airhops. Scroll down to find all the built-in Shopify hops.

Step 3: Press the red button on the required hop. You can run as many hops as needed to build your sales report.

That's all! ⚡️

With Airboxr, you can generate your own Shopify sales report in seconds.

Use our ready-made Shopify templates consisting of all the sales metrics mentioned above and analyze your Shopify sales performance.

Shopify Sales Dashboard

Product Sales Performance

Repeat Customers Report

Shopify Sales

 
 
 
 

Start your free 14-day trial

Connect your data sources and make smarter decisions in 10 minutes.

Your cart
    Checkout