This article will help you learn about the fields available in the SKU Hierarchy 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
The view is linked to the [bsd.sku_attributes] table which is a replica of the SKU Attributes Brand Supplied Data Google Sheet. Your customization of the SKU Attributes BSD will flow into the view and enable the following fields to be available/visible for use.
| Field Name | Field Type | Description | Source / Calculation |
| Attribute 1 Label | Dimension | Your entry in in the Green for Attribute 1 will populate as the Field Name | attribute_1 |
| Attribute 2 Label | Dimension | Your entry in in the Green for Attribute 2 will populate as the Field Name | attribute_2 |
| Attribute 3 Label | Dimension | Your entry in in the Green for Attribute 3 will populate as the Field Name | attribute_3 |
| Attribute 4 Label | Dimension | Your entry in in the Green for Attribute 4 will populate as the Field Name | attribute_4 |
| Attribute 5 Label | Dimension | Your entry in in the Green for Attribute 5 will populate as the Field Name | attribute_5 |
| Attribute 6 Label | Dimension | Your entry in in the Green for Attribute 6 will populate as the Field Name | attribute_6 |
| Attribute 7 Label | Dimension | Your entry in in the Green for Attribute 7 will populate as the Field Name | attribute_7 |
| Attribute 8 Label | Dimension | Your entry in in the Green for Attribute 8 will populate as the Field Name | attribute_8 |
| Attribute 9 Label | Dimension | Your entry in in the Green for Attribute 89will populate as the Field Name | attribute_9 |
| Attribute 10 Label | Dimension | Your entry in in the Green for Attribute 10 will populate as the Field Name | attribute_10 |
Explores
This view is part of the following explores:
- Lifetime Value First Order SKU
- Product Affinity
- Email Campaign Performance Details
- Current Inventory Level
- Loop Returns
- Order & Order Line Revenue
- Transactional Sales Report
- Shipstation
Extractor
This view is generated from the following Brand Supplied Data sheet: