---
title: "View: sku_performance"
description:   All content © Daasity 2021. Do not copy, share or distribute. 
---

[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_performance

### Source Tables Used In Script

| **Schema** | **Table (or Derived Table) Name** | **Table Type** | **Purpose** |
| --- | --- | --- | --- |
| drp | order_line_revenue | database | Primary |
| drp | order_busuiness_unit | database | Lookup |
| drp | sku_launch_date | database | Lookup |
| drp | calendar | database | Lookup |
| drp_staging | sku_combinations | database | Rollup of order_line_revenue and order_business_unit to find unique combinations of sku and store |
| drp_staging | sku_sales | database | Rollup sku sales by unique store, sku and order date |
| drp_staging | sku_dates | database | Holds sku_performance_date |
| drp_staging | sku_performance | database | Pre-insert |
| N/A | first_order_date | derived | Obtain the first date an order was made in a store |
| N/A | sku_performance_date | derived | Obtain a list of skus for every date from the sku's first order date |

### SQL Flow

### Calculated and Derived Fields

| **Target Column** | **Target Column Data Type** | **Source schema.table** | **Source Column** | **Transformation/Logic** |
| --- | --- | --- | --- | --- |
| days_since_launch | INT | drp.sku_launch_date | sku_launch_date | difference in days between sku_launch_date and current date |
| product_sales_amount | DECIMAL | drp.order_line_revenue | product_sales_amount | SUM(product_sales_amount) by each unique store, sku and date combination |
| paid_units | INT | drp.order_line_revenue | num_feature_items | SUM(num_featured_items) by each unique store, sku and date combination |
| total_units | INT | drp.order_line_revenue | num_units | SUM(num_units) by each unique store, sku and date combination |

 

All content © Daasity 2021. Do not copy, share or distribute.