# SKU Hierarchy

You can leverage the SKU Hierarchy sheet to analyze your data based on your chosen Attributes. For Example: 

## What size shoe is our best selling?

## Which Flavor is most often bought on a first orders?

## Did our new Fall Collection sell better than our Winter Collection?

## Which color shirt is preferred by our high-value customers?

## Did our Glass picture frame outsell our Acrylic picture frame last month?

These attributes are often omitted or condensed into one field when SKUs are entered into yoru Ecommerce platform, such as Shopify. 

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/ytniurVGldFa2gasjDPd/Screen%20Shot%202023-08-14%20at%2010.56.01%20AM.png" alt=""><figcaption><p>SKU Attribue Dimensions in Shopify</p></figcaption></figure>

To analyze the data via your Ecommerce store is a tedious manual process. You can input your attributes in the SKU Hierarchy Sheet and build reports in Daasity using this data.&#x20;

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/uzdsDsy2Fgy9JPjbW77r/Screen%20Shot%202023-08-14%20at%2010.58.27%20AM.png" alt=""><figcaption><p>The Dimensions will update based on your SKU Attributes in your BSD</p></figcaption></figure>

## Adding SKU Attributes

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/GslAJMNsNlqbwJro3I1h/Screen%20Shot%202023-08-14%20at%2010.59.32%20AM.png" alt=""><figcaption><p>You can edt the Column Headers in Green to add your SKU Attributes</p></figcaption></figure>

Edit the Green Column Headers with your SKU Attributes and add your SKUs in the SKU Column

{% hint style="warning" %}
**NOTE: The Maximum Number of Attributes is 10**
{% endhint %}

## Where to Find Your Data

[Order and Order Line Revenue Explore](https://help.daasity.com/core-concepts/data-models/data-explores/digital-analytics-unified/ecommerce-orders-and-revenue-by-order-date-explore)

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/zH1wDsKWsJaq8wOXTRIm/order%20line%20revenue%20explore.png" alt=""><figcaption><p>Order &#x26; Order Line Revenue Explore</p></figcaption></figure>

[Transactional Sales Report Explore](https://help.daasity.com/core-concepts/data-models/data-explores/digital-analytics-unified/transactional-sales-report-explore)

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/iy7bfXRUn2B2TuJMbTJc/transactional%20sales%20report%20explore.png" alt=""><figcaption><p>Transactional Sales Report Explore</p></figcaption></figure>