How to Calculate Sales by Product Variant SKU on Shopify

Table of Contents
    Add a header to begin generating the table of contents

    This article will guide you through the straightforward and efficient process of accessing your Sales by Product SKU report on Shopify. You’ll also discover the simple steps to access your Sales by Product Variant SKU report on Shopify and Products Sold by SKU report on By the Numbers.

    How to Access the Sales by Product Variant SKU on Shopify

    1- Access your Shopify store and click on Analytics > Reports

    2- Click on or search for Sales by Product Variant SKU

    How to access Sales by Product Variant SKU on Shopify

    This is what Shopify’s Sales by Product Variant SKU report looks like:

    Shopify's Sales by Product Variant SKU report

    Are you curious to uncover the detailed performance of individual product variants with distinct segments of your audience? By the Numbers’ sophisticated segmentation tools allow you to delve into the ‘Sales by Product Variant SKU’ report with unprecedented depth. Gain insights into the sales volume and different customer segments’ preferences and purchasing patterns. This level of detail will pique your interest and empower you to refine your marketing strategies across platforms like Klaviyo, Google Ads, TikTok Ads, and Meta Ads, ensuring that your campaigns precisely target the appropriate segment with the ideal product variants.

    How to Access the Products Sold by SKU Report on By the Numbers

    Step 1: Install the By the Numbers App

    Install By the Numbers from the Shopify App Store. This will supply insightful data reports to help you monitor and analyze your customer and sales information. 

    Step 2: Access the By the Numbers Dashboard and Navigate to the Sales Reports Section

    Find the Reports Section in the left-hand side menu. 

    Navigate to Report Section

    STEP 3: Select the Products Sold by SKU Report

    Look for the Products Sold by SKU report on the right in the Products section of the reports.

    The following screenshot gives you a better  idea of what By the Number’s Products Sold by SKU report looks like:

    Advantages of leveraging By the Numbers to access your Products Sold Report

    It’s recognized that data loses its potency when it’s overly generic and needs to address the unique profiles of different customer segments. Custom Segmentation is invaluable in this context. It enables the classification of customers based on common characteristics, allowing for more tailored and personal interactions. This detailed approach guarantees that strategies and messaging are finely tuned to satisfy each segment’s specific demands and tastes, thus enhancing the accuracy and impact of your marketing efforts.

    With By the Numbers, you can delve deeply into the ‘Products Sold by SKU’ report using custom and standard filters. This feature is designed to pinpoint particular trends, perform comparative analyses, or investigate sales patterns across various timeframes. It allows you to determine if specific SKUs perform better as individual items or when paired with other products, mirroring your customers’ shopping preferences.

    Moreover, it facilitates performance analysis across designated periods, enabling comparisons. Custom Segmentation is vital to deciphering the varied buying behaviours of your customer segments, providing critical insights into the success of your marketing strategies and the fidelity of your customer base.

    In addition to its robust segmentation capabilities, By the Numbers offers sophisticated retargeting features, allowing you to directly re-engage with specific segments of your customer base through strategic marketing campaigns. This retargeting functionality is supported by the platform’s integrations with Klaviyo, Google Ads, TikTok, and Meta, empowering you to leverage your marketing efforts across the most effective channels for your business.

    Furthermore, By the Numbers enhances your reporting and analysis by incorporating data from these integrations into some reports. Integrating external data sources enriches your insights, enabling a more comprehensive view of your marketing performance and customers’ behaviour. It also provides a powerful toolset to refine and optimize your retargeting strategies for maximum impact.

    Custom Segmentation

    By the Numbers offers a wide range of preset segments and lets you create custom segments for your audience. 

    Use of segments in Products Sold by SKU on By the Numbers

    When you need to access all the segments and create custom ones: 

    1- Sign in to By the Numbers and navigate to the Segments option on the left menu to discover the Preset Segments and Custom Segments tab.

    By the Numbers Segments

    2— If you’re interested in examining the specifics of a particular audience segment, you can create your segments. Navigate to the Custom Segments tab or click the ‘Create Segment’ button at the top right corner. A new window will appear, where you must select the filters you want to use. Segmentation is a fast track to sales success!

    Remember to test your segment after choosing the filters you wish to apply. This will verify that your filters are set up correctly and provide you with valuable data about your customer segment.

    Customer Segment Information

    By the Numbers’ App Integrations

    After custom segmentation, you can retarget those specific customer groups. Imagine the potential increase in sales if you aimed to re-engage customers at risk of churning (those who last made a purchase 6-12 months ago) through targeted campaigns on platforms like Klaviyo, Google Ads, Meta, or TikTok Ads. Another key feature of these applications is the ability to view all your data from Klaviyo, Google Ads, Meta, and TikTok Ads in various reports, enhancing your analytical capabilities beyond retargeting.

    By the Numbers’ app integrations let you do just that: 

    1- After signing into By the Numbers, select Integrations from the left-hand menu in the Settings area.

    2- Choose the integration you wish to add and follow the provided instructions.

    By the Numbers integrations

     the Numbers offers a comprehensive suite of integrations with Klaviyo, Google Ads, TikTok, and Meta, empowering you to execute retargeting campaigns across your preferred channels effectively. A significant benefit of these integrations is the ability to amalgamate data from Klaviyo, Google Ads, Meta, and TikTok Ads into assorted reports, enriching your analysis capabilities. This feature extends your analytical reach beyond the confines of straightforward retargeting strategies, allowing for a deeper understanding of customer engagement and the effectiveness of your marketing efforts.

    Remember, if you ever need assistance understanding your BtN reports, you can always book a free session with a data expert. We’re here to help.

    See Also:


    Get a free demo by a Shopify data expert and see what all the fuss is about!

    Or get started with a Start A Free Trial

    Scroll to Top