Analytics for Shopify Customer Segments

Grouping customers with similar characteristics into customer segments is a great way to manage your store, create targeted campaigns, and analyze your results. You can define your customer segments in the Shopify admin or use the default customer segment templates that Shopify provides you with. Then, with Mixtable Analytics you can track the performance of the segments, further optimize them, and learn more about your customers.

Why is Customer Segment analytics Important?

• Customer Segment Analytics helps with data-driven decisions, which will improve customer engagement and conversion rates.
• Identifying customer segment patterns can increase customer retention and revenue from repeat purchases.

How to add Customer Segment analytics to your worksheet

If you have already created a Mixtable workbook for your Shopify store, you can quickly add analytics data to an existing worksheet, filtered for the customer segment you want to analyze. The analytical metrics this can be done for include:

• Net Sales / Gross Sales
• Net / Gross Quantity Sold
• Orders Count
• Orders Net Profit
• Total Refund Amount
• Total Discount Amount
• Refund Count
• Percent of Orders Refunded

Add an analytics column to your Mixtable spreadsheet:

• The worksheet needs to be showing product or collection information. E.g., Products - Complete, Product - Basic, Manual Collections, Automated Collections
• Choose an empty column (or insert a new one) and click the Set Sync button from the column header.

• From the Shopify Sync Settings window, choose Analytics
• Then, Select the metric to show in the column:

• Select the time range that you want the data to be calculated for

  • For all time - all data for the metric you’ve chosen since the creation of the store
  • Fixed date range - show data for a specific period between two dates
  • Dynamic date range - calculate the data for a dynamic time period in the past, e.g., last 7 days, last 30 days. If you select this option, the data will be recalculated daily as the date range window moves forward.
  • Calendar year and month - show the data for a specific year (e.g., 2023) or a specific month (e.g., August 2024)

Filter data by Customer Segment

Use the Filter orders based on Customer Segment defined in Shopify Admin option to select the segment from the dropdown for which to show the metric. If you set this the data shown in the column will only be for the customer segment you select. For example, if you choose Net Sales for calendar year 2024, and add a Customer Segment filter, then only orders bought by a customer in the specified filter will be used to calculate the net sales for 2024.

Note: The customer segments shown in the dropdown are the ones you have defined in your Shopify admin. To add or change your segments please use the Shopify Admin, and Mixtable will reflect your changes automatically.

Data comparison

• Use the same Set Sync option to add multiple columns. You can:

  • map sales from different segments,

  • or add analytics data by customer segment for:

    • order count,
    • quantity sold,
    • discounts, and
    • refunds.

• With Mixtable you can use spreadsheet functions to operate with the data, such as:

  • sort data ascending or descending,
  • find-replace,
  • filter,
  • and using formulas.

Find out more about the Mixtable suite of products here.