--- title: "View: Product Level Performance - View Through" description: This article will help you learn about the fields available in the Product Level Performance - View Through view, the field types, descriptions and how the fields are calculated --- [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) # View: Product Level Performance - View Through ## This article will help you learn about the fields available in the Product Level Performance - View Through 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 - Explores - Transform Code ### View Definition This view is linked to the [drp.notification_product_purchase_view_through] table which generated as part of the Daasity transformation process and has the following fields available/visible for use.   | **Field Name** | **Field Type** | **Description** | **Source / Calculation** | | --- | --- | --- | --- | | Order Date | Dimension Group | Date of Orders associated with the email/SMS send | order_date | | Days after Email/SMS Sent | Dimension | Days Delta Between Order Date and Sent Date | days_after_notification_sent | | Days after Email/SMS Sent (Tiers) | Dimension | Days Delta Tiers Between Order Date and Sent Date ie. < 2, >= 2 and < 5, >= 5 and < 10, >= 10 and < 30, >= 30 and < 61, and >= 61 | CASE WHEN COALESCE(days_after_notification_sent,0) < 2.0 THEN '< 2.0' WHEN COALESCE(days_after_notification_sent,0) >= 2.0 AND COALESCE(days_after_notification_sent,0) < 5.0 THEN '>= 2.0 and < 5.0' WHEN COALESCE(days_after_notification_sent,0) >= 5.0 AND COALESCE(days_after_notification_sent,0) < 10.0 THEN '>= 5.0 and < 10.0' WHEN COALESCE(days_after_notification_sent,0) >= 10.0 AND COALESCE(days_after_notification_sent,0) < 30.0 THEN '>= 10.0 and < 30.0' WHEN COALESCE(days_after_notification_sent,0) >= 30.0 AND COALESCE(days_after_notification_sent,0) < 61.0 THEN '>= 30.0 and < 61.0' WHEN COALESCE(days_after_notification_sent,0) >= 61.0 THEN '>= 61.0' ELSE 'Undefined' END | | Product Name | Dimension | SKU Purchased During 7-Day View Through Window | item_upc | | SKU | Dimension | Product Purchased During 7-Day View Through Window | product_name | | AOV | Measure | Average Order Value - Sales/Orders | SUM(product_amount ) / NULLIF(COUNT(DISTINCT order_id), 0) | | Conversion Rate | Measure | Orders/Clicks | 1.00 *COUNT(DISTINCT order_id) / SUM(notification_campaign_detail.sends) | | Orders per Unique Send | Measure | Orders / Unique Sends | 1.00 * SUM(product_amount) / SUM(notification_campaign_detail.sends) | | Sales ($) per Unique Send | Measure | Sales ($) / Unique Sends | 1.00 * SUM(product_amount) / SUM(notification_campaign_detail.sends) | | Total Orders | Measure | Total Number of Orders Placed after Email Sent | COUNT(DISTINCT order_id) | | Total Sales ($) | Measure | Total Product Revenue Coming Directly from Email | SUM(product_amount) | | Total Units | Measure | Total Number of Units Placed after Email Sent | SUM(units) | ### Explores This view is part of the following explores: - Email & SMS Campaign Performance Details ### Transformation Code This view is a Daasity derived table generated by the following code: - [7040_NTF_BAS_notification_campaign_purchase_view_through.sql]