View: Product Level Performance - Last Click

This article will help you learn about the fields available in the Product Level Performance - Last Click 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

NOTE: This View is only available to merchants with the Pro version of Daasity who have enabled the optional transformation code

This view is linked to the [drp.notification_product_purchase_last_click] 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
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.clicks)
Orders per Unique Send Measure Orders / Unique Sends 1.00 *COUNT(DISTINCT order_id) / SUM(notification_campaign_detail.sends)
Sales ($) per Unique Send Measure Sales ($) / Unique Sends 1.00 * SUM(product_amount) / SUM(notification_campaign_detail.sends)
Total Direct Orders Measure Total Number of Orders Placed after Email Sent COUNT(DISTINCT order_id)
Total Direct Sales ($) Measure Total Product Revenue Coming Directly from Email SUM(product_amount)
Total Direct Units Measure Total Number of Units Placed after Email Sent SUM(units)

Explores

This view is part of the following explores:

  • Notifications Campaign Performance Details

Transformation Code

This view is a Daasity derived table generated by the following optional code:

  • [7080_NTF_BAS_notification_campaign_purchase_last_click.sql]