Jun 11, 2021

How to increase sales on your Shopify store with data and insights: 5 practical tips

5-MINUTE READ | By Joy Huynh

Ecommerce AnalyticsShopify

[ Updated Oct 4, 2023 ]

Growing a Shopify store isn’t as simple as putting up your products on the web and having fingers crossed that somebody will buy from you. 

You need to help your customers find you, assist them in finding the right products and give them an exceptional shopping experience. There’s one thing that will help you get these things right: data.

In this article, we’re going to show you how you can drive more sales to your Shopify store with data. 

Psst! This blog post is based on a podcast episode we did with Duane Brown, Founder & Head of Strategy at Take Some Risks. Check out the full episode.

Ready? Let’s dive in.

What Shopify metrics should you track?

Tracking and making sense of all your data can be a daunting and challenging task — because your store generates tons of data.

Here’s the good news: you don’t have to track anything and everything you find. You just need to pay attention to the metrics that can actually help you grow your business.

Typically, they’re revenue, ROAS (return on ad spend), new vs. returning customers, cost per add to cart, cost per checkout initiated, and average order value.

Revenue

Revenue or total sales is your north star metric. It tells you how much money your store is generating.

“At the end of the day, your goal is to make enough money to support your advertising efforts, paying fees and people on your team.”

Duane Brown, Founder & Head of Strategy, Take Some Risks

However, looking at your sales number alone doesn’t move the needle. You need to dive deeper to understand what really influences your sales — both negatively and positively.

There are several ways that you can use to analyze your numbers. For example, you can break down your revenue by channel to see which marketing channels drive the most sales. Where does your traffic come from? What channels bring in the most high-quality traffic?

Alternatively, you can also monitor your revenue by month, date, or time to see when your customers will likely purchase from you. Do they shop more on weekends and holidays?

Return on ad spend

Return on ad spend (ROAS) is a good metric to measure your paid campaigns’ success. It tells you if you’re bringing more revenue than what you’re spending on ads. 

According to Duane, stores that run a lot of promotion and sale campaigns usually generate a good ROAS. However, it’s not a sustainable way to grow your business in the long term. That’s why when running paid campaigns, you’ll want to get to people who are willing to pay full price for the products.

New vs. returning customers

As your business continues to grow, you’ll want to understand how many new and returning customers are visiting your store.

While new customers are people who have never purchased your products, returning customers, on the other hand, are familiar with you and (typically) happy to shop at your online store. The cost to acquire a new customer is usually higher than the cost to return a customer. 

Let’s say you’re spending $50 to acquire a customer— considering your average order value is $45. Your customer acquisition cost (CAC) may be high if the customer just makes a one-off purchase. However, if that customer comes back to your store and makes more purchases, then your CAC, in this case, is fairly cheap.

Cost per add to cart and cost per checkout initiated

Cost per add to cart and cost per checkout initiated help you understand your store visitors’ purchase intent.

Cost per add to cart tells you how much you’re paying for each item added to a customer’s cart.

As a rough example, your cost per add to cart may be too high if you’re spending $100 for two adds to cart —that’s $50 per one add to cart— when your average order value is $75. It’s hard to be profitable if you’re paying so much to get someone to add an item to their shopping cart.

You can lower your cost per add to cart by:

  • Improving the copy on your website.
  • Improving the on-site experience, e.g., making sure your website is mobile-friendly.
  • Making your CTAs noticeable.
  • Changing your target audience. You may have the best copy on your website, but they’re not going to convert if you pick the wrong audience.

Similarly, cost per checkout initiated shows how much you’re paying each time a customer starts a checkout.

It may surprise you how often someone abandons their cart. You want to make sure your ads attract the right audience and successfully move them further down the funnel.

Average order value

Average order value (AVO) shows the average amount of money a customer spends in one transaction. According to Duane, AOV is an important metric because it helps you understand how much you can spend on advertising.

“Knowing what your average order value helps you figure out, based on your profit margin, how much money you can spend on ads and everything else that isn’t directly related to producing the product and getting it out the door to the customer.”

Duane Brown, Founder & Head of Strategy, Take Some Risks

Let’s say your profit margin is 20%, and your AOV is $100. In that case, you only have $20 to spend on acquiring a customer if you want to break even. Realistically, you may not be able to attract new customers with $20 through any paid channels. But as long as you know your AOV and profit margin, you can easily choose a channel that fits the budget and works for you. For example, SEO or organic social media.

5 tips for driving more Shopify sales with data

Now, let’s take a look at five different ways you can analyze your data to help increase your sales:

  • Analyze your store overview performance.
  • Monitor your inventory.
  • Calculate the time between orders.
  • Calculate the ROAS of your paid channels.
  • Analyze the customer behavior on your online store.

Analyze your store overview performance

The easiest way to monitor your store performance is to create a Shopify overview dashboard. This report helps you understand:

  • Your current performance.
  • Opportunities to grow your store.

Take this Shopify report for Google Looker Studio as an example. The overview page gives you a glimpse into your total sales. You’ll see:

  • A breakdown of your total sales by channel, vendor, country, and product.
  • The number of products you’ve sold so far.
  • Your inventory quantity and value.
Shopify store performance dashboard

Swipe this template for free.

Moving on to the order and customer tables page From there, you’ll find data about your customers, orders, and inventory. You’ll see the:

  • A total number of orders and returns by month.
  • Total sales and order by customer details.
  • Breakdown of your inventory by product.

Psst! If you’d like to learn more about this template, we wrote a detailed guide covering how to use it and some tips to improve your performance. If you’re already familiar with Looker, feel free to swipe the template right away.

Monitor your inventory

As an online store owner, you should always know if you have enough inventory in your warehouse. There’s nothing worse than running out of the products your customers highly demand. When products are out of stock, it results in lost sales, and it can harm your customer experience.

That’s where an inventory report comes in handy. With it, you can effectively manage your stocks.

We’re going to show you how you can easily monitor your inventory with Supermetrics for Google Sheets.

Psst! In case you haven’t installed the Supermetrics add-on, you can get it here.

Next, click on ‘Add-ons’ → ‘Supermetrics’ → ‘Launch sidebar.’

You can use this query to get your inventory data

  • Data source: Shopify.
  • Select accounts: select your Shopify store(s).
  • Select dates: choose the date range you want to monitor your inventory for.
  • Select metrics: inventory value, inventory quantity.
  • Split by dimensions: product ID.
  • Filter and options: you can use these settings to segment your data further. But, in this example, we’ll leave them blank.

Once you’re done with your query, click ‘Get data to table.’ Your report will look something like this.

monitor shopify inventory google sheets with Supermetrics

Another superpower of Supermetrics for Google Sheets is the conditional emailing feature. With this feature, you can trigger an email notification when your products are running low in stock or out of stock.

Let’s say the ‘blue-collar shirt’ is the best-selling item in your store. You may project it’s a good time to reorder a new batch when the shirt only has 50 pieces in the inventory. You can easily set up an email alert to be notified when this happens.

On your Supermetrics sidebar, click the ‘Schedule’ tab and choose ‘Refresh & email’ daily/weekly/monthly.

Then, check the ‘Conditional emailing’ box.

set up conditional-emailing Supermetrics-for Google Sheets

From here, choose the sheet and cell address you want to trigger the notification for. In this case, we’ll choose ‘Inventory report’ and ‘C2.’ Let’s say you get your blue-collar shirt’s inventory quantity in C2.

Then you can optimize your email subject, so you’ll know what’s happening without opening the email. To do that, scroll up to the email setting and click the ‘Advanced setting’ tab.

Use these placeholders to customize your subject line.

For example, our setting is ‘There are only #CELLVALUE_Inventory report_C2# blue-collar shirts left!.

Once you’re done, click on save. And now, whenever your product hits the threshold, you’ll receive an email notification.

Calculate the time between orders

Depending on what you’re selling, the time between someone’s first and second purchase will be different. Understanding how often your customers buy from you helps create better retargeting, cross-promotion, and upselling campaigns.

Let’s say you’re selling skincare products that people rebuy every three months. You can set up an email campaign or show your customers ads when they’ve hit their 90 days.

“You want to work really hard to get those one-off purchases and then turn them into customers who come back for second and third purchases.”

Duane Brown, Founder & Head of Strategy, Take Some Risks

Calculate the ROAS of your paid channels

If you’re growing your online store with paid ads, you’ll want to double down on the channels that bring in sales and stop the ones that don’t work. Instead of going through different platforms to check your performance, you can easily monitor your campaigns with a paid channel mix report.

For example, in this paid channel mix report for Google Looker Studio, you’ll see data from Google Ads, LinkedIn Ads, Twitter Ads, Facebook Ads, and Microsoft Ads. With it, you’ll understand:

  • The general performance of all your paid channels.
  • The evolution of your campaigns over time.
  • Your best-performing channels.
Paid channel mix report template (new design) LS

Use this template >>

Psst! If you’d like to learn more tips about how to use this template to improve your paid performance, check out this article. Or, if you already know your way around Looker Studio, feel free to swipe the template.

Analyze customer behavior on your online store

After putting effort into attracting visitors to your website, you probably hope they’ll convert and become customers. I wish things could be that easy. 

In reality, when customers visit your store, they may browse through different product pages, add some items to their shopping cart, and then leave. They may come back later, remove some items, or even end up buying a different product.

By using data from Google Analytics, you’ll understand how customers behave in your online store. Take this Google Analytics 4 dashboard for Looker Studio as an example.

This 4-page dashboard will show you:

  • An overview of your website performance and user analysis
  • A breakdown of channel performance
  • A deep dive into the best-performing pages
  • A detailed analysis of the best campaigns

Google Analytics 4 Looker Studio template

Swipe our Google Analytics 4 dashboard template >>

Wrapping up

Using data from your Shopify store, marketing channels, and Google Analytics helps you grow your business and provide an excellent customer experience.

I hope these tips will inspire you to dive deeper into your data. If you’d like to share different ways to analyze your ecommerce performance, let me know on LinkedIn.

If you’re ready to take your Shopify analytics to the next level, check out the 14-day free Supermetrics trial.

Want to use data to grow your Shopify store?
See how easy it is to get, transform, and manage your Shopify data and other cross-channel data with Supermetrics. Choose a reporting and analytics destination to get started.
Start free trial

About the author

author profile image

Joy Huynh

Joy is the Content Strategist at Supermetrics. Together with internal and external experts, Joy helps businesses get rid of the data chaos and turn marketing data into opportunity.

Turn your marketing data into opportunity

We streamline your marketing data so you can focus on the insights.

Book Demo