---
title: "View: SKU Level Repurchase Rates"
description: 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
---

[Back to home](https://support.daasity.com/migrated/knowledge)

- [ Welcome to Daasity
  
  
  
  ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity) 
    - [ Integration Setup | Connect Your Data Sources ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#integration-setup-connect-your-data-sources)
    - [ Integration Setup | Amazon Seller Central ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#integration-setup-amazon-seller-central)
    - [ Navigating the Daasity App ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#navigating-the-daasity-app)
- [ Daasity Platform | Business User Analytics
  
  
  
  ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics) 
    - [ Brand Supplied Data (BSD) ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#brand-supplied-data-bsd)
    - [ Dashboards ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#dashboards)
    - [ Reports ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#reports)
    - [ Explores ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#explores)
    - [ Views ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#views)
    - [ Audiences ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#audiences)
    - [ Customizations ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#customizations)
- [ ELT+ | Technical User Documentation
  
  
  
  ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation) 
    - [ Platform ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#platform)
    - [ Transformation ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#transformation)
    - [ Integrations ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#integrations)
- [ User Manual and Support
  
  
  
  ](https://support.daasity.com/migrated/knowledge/user-manual-and-support) 
    - [ Daasity Logic and Best Practices ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#daasity-logic-and-best-practices)
    - [ Marketing Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#marketing-analytics)
    - [ Customer Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#customer-analytics)
    - [ Date Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#date-analytics)
    - [ Inventory and Returns Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#inventory-and-returns-analytics)
    - [ Submit a Support Request ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#submit-a-support-request)
- [ Release Updates
  
  
  
  ](https://support.daasity.com/migrated/knowledge/release-updates) 
    - [ Release Updates ](https://support.daasity.com/migrated/knowledge/release-updates#release-updates)

# 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](https://support.daasity.com/migrated/knowledge/view-drp-sku-level-repurchase-rates#view-definition)
- [Explores](https://support.daasity.com/migrated/knowledge/view-drp-sku-level-repurchase-rates#explores)
- <https://support.daasity.com/migrated/knowledge/view-drp-sku-level-repurchase-rates#_Extraction_Table_1>[Transform Code](https://support.daasity.com/migrated/knowledge/view-drp-sku-level-repurchase-rates#transform-code)

### 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) |

### Explores

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]