This article will help you learn about the fields available in the Customer First Purchase 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 created as a real-time query that runs within Looker against the database and has the following fields available/visible for use:
| Field Name | Field Type | Description | Source / Calculation |
| First SKU Purchased | Filter | Select the SKU of the first purchase | Generates a list of unique_customer_id whose initial purchase contains the SKU selected |
Explores
This view is part of the following explores:
- Lifetime Value
- Order & Order Line Revenue
Transformation Code
This view is created within Looker as part of a Dynamic query which selects the following data from source tables to generate the final output from the query
and leverages the following joins
