---
title: "Explore: Order & Order Line Revenue"
description: This explore contains all of the order and order line data from sales channels. Find sales metrics, order volume and fulfillment info in this explore.   Exploring data can be insightful and fun! Befor
---

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

# Explore: Order & Order Line Revenue

### Description

This explore contains all of the order and order line data from sales channels. Find sales metrics, order volume and fulfillment info in this explore.

### Common Use Cases

1. Determine metrics like Gross Sales or Gross Margin of orders in a particular time period, or by a particular product.
2. See transit time by carrier.
3. Look at average order value of new customers vs. repeat customers.
4. Look at order data by different stores or store types (retail, ecommerce, etc.)
5. See metrics of order activity by Daasity marketing attribution channel or vendor.

 

| **Filters, Dimensions and Measures** | **Category** | **Description** |
| --- | --- | --- |
| Customer First Purchase SKU: First SKU Purchased | filter | Select the SKU of the first purchase |

| Filters, Dimensions and Measures | Category | Description |
| --- | --- | --- |

### Using Explores

Exploring data can be insightful and fun! Before you start your exploration, make sure to go through our **[Introduction to Explores](https://support.daasity.com/knowledge/explore-introduction-to-explores)** article and the **[associated training](https://docs.looker.com/data-modeling/learning-lookml/lookml-terms-and-concepts#explore)**.

. 

### Views  

| **View** | **Cardinality** | **Relationship** | **Join** |
| --- | --- | --- | --- |
| [order_line_revenue](https://6652466.hs-sites.com/knowledge/view-order-line-revenue) | - | self | - |
| [retail_calendar](https://6652466.hs-sites.com/knowledge/view-retail-calendar) | left_outer | one_to_one | ${order_line_revenue.order_date} = ${retail_calendar.calendar_date} |
| [order_status](https://6652466.hs-sites.com/knowledge/view-order-status) | left_outer | many_to_one | ${order_line_revenue.order_id} = ${order_status.order_id} |
| [orders](https://6652466.hs-sites.com/knowledge/view-orders) | left_outer | many_to_one | ${order_line_revenue.order_id} = ${orders.order_id} |
| [order_discount_codes](https://6652466.hs-sites.com/knowledge/view-order-discount-codes) | left_outer | one_to_many | ${orders.order_id} = ${order_discount_codes.order_id} |
| [order_business_unit](https://6652466.hs-sites.com/knowledge/view-order-business-unit) | left_outer | many_to_one | ${order_line_revenue.order_id} = ${order_business_unit.order_id} |
| [***order_channel (BEING REPLACED)***](https://6652466.hs-sites.com/knowledge/view-order-channel) | left_outer | many_to_one | ${order_line_revenue.order_id} = ${order_channel.order_id} |
| ***[order_attribution (NEW)](https://support.daasity.com/knowledge/view-order-attribution)*** | left_outer | many_to_one | ${order_line_revenue.store_order_id}=${dim__order_attribution.order_id} |
| [order_shipping_service](https://6652466.hs-sites.com/knowledge/view-order-shipping-service) | left_outer | one_to_many | ${orders.order_id} = ${order_shipping_service.order_id} |
| [order_item_fulfillments](https://6652466.hs-sites.com/knowledge/view-order-item-fulfillments) | left_outer | one_to_one | ${order_line_revenue.order_line_id} = ${order_item_fulfillments.order_line_id} |
| [fulfillments](https://6652466.hs-sites.com/knowledge/view-fulfillments) | left_outer | many_to_one | ${order_item_fulfillments.fulfillment_id} = ${fulfillments.fulfillment_id} |
| [sku_attributes](https://6652466.hs-sites.com/knowledge/view-sku-attributes) | left_outer | many_to_one | ${order_line_revenue.sku} = ${sku_attributes.sku} |
| [customer_profiles](https://6652466.hs-sites.com/knowledge/view-customer-profiles) | left_outer | many_to_one | ${order_status.unique_customer_id} = ${customer_profiles.unique_customer_id} |
| [customers](https://6652466.hs-sites.com/knowledge/view-customers) | inner | one_to_one | ${customer_profiles.unique_customer_id} = ${customers.unique_customer_id} |
| customer_sku_first_purchase | inner | one_to_one | ${order_line_revenue.unique_customer_id} = ${customer_sku_first_purchase.unique_customer_id} |

### Flow

 

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