Views
      Back to home
      1. Help Center
      2. Daasity Platform | Business User Analytics
      3. Views

      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]