View: Customer First Order SKU

This article will help you learn about the fields available in the Customer First Order SKU 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.customer_fo_sku_lkp] table which is 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 Order SKU Dimension SKU from a customers first order. If a customer has more than one SKU in their first order they will show in the LTV curve for each SKU in their first order sku
Top 10 SKU Flag Dimension Yes if a SKU is in the top 10 of all SKUs for net sales top_10_sku_flag

Explores

This view is part of the following explores:

  • Lifetime Value First Order SKU

Transformation Code

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

  • [4630_CUS_BAS_customer_fo_sku_lkp.sql]