View: SKU Level Repurchase Rates

This article will help you learn about the fields available in the SKU Level Repurchase Rates view, the field types, descriptions and how the fields are calculated

Key Topics

Click on the links below to take you to the section where you can learn more about this View and where it is used and how it is created

View Definition

This view is linked to the [drp.sku_level_repurchase_rates] table which generated as part of the Daasity transformation process and has the following fields available/visible for use.


Field Name Field Type Description Source / Calculation
First SKU Order Date Dimension Group Date the SKU was first ordered first_sku_order_date
Average Purchases Before SKU Dimension Average number of purchases customers make BEFORE purchasing this SKU average_purchases_before_sku
First Order Customers Purchasing Again Dimension Number of customers with SKU in first purchase and repurchasing that SKU fo_customers_purchasing_again
SKU Dimension Stock Keeping Unit (SKU) sku
Average Days Between First and Second Order Measure Average days between first and second order of SKU AVG(first_to_second_order_average_days)
Average Days Between Orders Measure Average days between orders of SKU AVG(average_days_between_orders)
Count Customers Repurchased Measure Total customers repurchasing SKU ever (meaning they bought the SKU at some point and then bought it again later, so more than one order with that SKU in it) COALESCE(SUM(repurchased_customers_count), 0)
Count First Order Customers Measure Total customers with SKU in first purchase COALESCE(SUM(first_order_sku_customers_count), 0)
Count Orders Measure Count of all the orders with this SKU COALESCE(SUM(total_orders_count), 0)
Count Unique Customers Measure Total number of customers purchasing COALESCE(SUM(total_unique_customers_count), 0)
Count Unique SKUs Measure Number of unique SKUs COUNT(DISTINCT(sku))
Total Units Purchased Measures Total units purchased for the SKU COALESCE(SUM(total_units), 0)


This view is part of the following explores:

  • SKU Level Repurchase Rates

Transformation Code

This view is a Daasity derived table generated by the following code:

  • [4325_OLR_CTM_sku_level_repurchase_rate.sql]