Skip to main content

Products

A view showing performance at the product level from the Shopify platform.

Adam z Data Octopus avatar
Written by Adam z Data Octopus
Updated over a week ago

VIEW DESCRIPTION - SHOPIFY PRODUCTS

A data view presenting sales results at the product level, based on data from the Shopify e-commerce platform. The analysis covers all transactions processed by the online store, focusing on product sales while taking into account their variants.

The report aggregates sales data directly from the Shopify platform, providing a complete picture of purchasing activity at the individual product level. The view enables detailed analysis of the sales performance of each product in the store's offering.

TIME DATA RANGE

The report presents data from a selected time range that can be customized using a datepicker (available options: Last 7 Days, Last 14 Days, Last 30 Days, Last 60 Days, Last 90 Days, This month, Last month, and the ability to select custom dates). The default setting is the last 30 days range.

EXAMPLE INSIGHTS FROM THE DATA VIEW:

Analyze gross sales values (Gross Revenue) of individual products along with percentage changes to identify best-selling items and products that are gaining or losing popularity.

Compare the quantity of units sold (Purchase Quantity) with sales value to identify products with the highest sales efficiency and average unit value.

Monitor product age (Product Age Days) in combination with sales results and change trends to assess how the length of a product's presence in the offering affects its popularity and whether new products effectively replace older ones.

Analyze percentage change trends across all metrics to identify products that are growing, stable, and declining in popularity, which will allow for optimization of product strategy.

Examine relationships between brands (Brand) and sales results to assess the performance of individual brands in the portfolio and make decisions about developing supplier cooperation.

Use categorization (Category Level 1, 2, 3) to analyze the performance of product groups and identify categories requiring strengthening or optimization.

Compare changes in the number of customers with orders to understand whether sales growth results from acquiring new customers or increasing the activity of existing ones.

DATA SCHEMA SPECIFICATION

Product identifiers:

Product Name - Full product name displayed in the Shopify store.

Product Variant ID - Unique identifier of the product variant in the Shopify system (e.g., different sizes, colors of the same product).

Product Group ID - Product group identifier used to link different variants of the same base product.

Brand - Product brand.

Product categorization:

Category Level 1 - Main product category (first level of categorization).

Category Level 2 - Product subcategory (second level of categorization).

Category Level 3 - Detailed product category (third level of categorization).

Sales data:

Orders - Total number of unique orders for a given product in the current period. If a customer placed two separate orders for the same product, the value will be 2.

Clients - Number of unique customers who purchased the product in the current period. Even if a customer bought multiple units of the product, they count as one client.

Purchase Quantity - Total quantity of product units sold in the current period. Sum of all units sold across all orders.

Gross Revenue - Gross sales value of the product in the current period.

Net Revenue - Net sales value of the product in the current period.

Analytical data:

Product Age Days - Number of days since the product was introduced to the store offering, calculated from the date the product card was created in the Shopify system to the current day.

TIME RANGE DATA COMPARISON

The view offers advanced capabilities for comparing data between periods through "Show Previous Period" and "Show Change Values" functions. Detailed information about using period comparisons, interpreting Previous Period Value, Change (Value), and Change (%) values can be found in the Functionality description - time period comparison.

Did this answer your question?