The Net Sales by New vs Returning Customers metric shows the revenue generated by customers who are either new to the store or have made a repeat purchase. It helps to identify which group brings in more revenue and informs customer acquisition and retention strategies.
With Databox you can track all your metrics from various data sources in one place.
Used to show comparisons between values.
Databox is a business analytics software that allows you to track and visualize your most important metrics from any data source in one centralized platform.
To track Net Sales by New vs Returning Customers using Databox, follow these steps:
Shopify metrics in Databox are Event type metrics and Databox obtains the relevant data based on calculations of data for the specific event entity, such as an Order. Each entity received via the API will be stored in our database as a separate entry and each entry will have its own timestamp associated with it – the moment the event occurred. As a consequence, in cases when the Order that occurred in the past is edited, changed, or deleted in the Shopify User Interface after it has already been completed and synced to Databox, Databox cannot report on such historical data changes, which will result in discrepancies when data from Shopify is compared to values in Databox for the past Date Range.
Shopify can distinguish between returning and new customers differently in their User Interface than Databox can from their API, therefore the data discrepancy might be present for this metric in the following case.
Databox obtains data on the current state of a customer, so if the customer had never placed an order before and then placed two separate orders one after the other in the selected Date Range, Databox sees it as a ‘Returning’ customer with value 2 (Orders) present in the API. This would then indicate that both these orders were made from a ‘Returning’ customer, which is not technically correct since the first order made by the customer should be counted as made by a ‘New’ customer.
Hence, in Databox the value for the ‘Returning’ dimension will be higher and the value for the ‘New’ dimension lower than in the Shopify User Interface when the new customer is making multiple orders right after their first purchase.
Unfulfilled orders is a metric that measures the number of orders that have not yet been shipped or delivered to the customer. It helps merchants keep track of outstanding orders and ensure timely fulfillment.
Pending (Unprocessed) Orders metric in Shopify refers to the number of orders that have been created by customers but are yet to be fulfilled or shipped out. These orders require action from the store owner or staff to process and fulfill them.
Equates to product Selling Price x Ordered Quantity during specified Date Range split up by Product Vendor.
Equates to Gross Sales - Discounts - Returns + Taxes + Shipping Charges during the specified Date Range split up by Top Sold Products.
Equates to Gross Sales - Discounts - Returns + Taxes + Shipping Charges during the specified Date Range split up by Billing City.
Equates to Gross Sales - Discounts - Returns + Taxes + Shipping Charges during specified Date Range split up by Tag.
The Net Quantity by Top products metric provides insight into the overall sales performance of a store's top products by tracking the total quantity sold versus the quantity returned or canceled, resulting in a net quantity sold.
This metric allows Shopify store owners to track the effectiveness of their discount campaigns based on the location of the customer's billing city. It provides insights on which cities are responding well to discounts and can aid in targeting future promotions.