---
title: "View: Email & SMS Campaign Details"
description: This article will help you learn about the fields available in the Email Campaign Details 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: Email & SMS Campaign Details

## This article will help you learn about the fields available in the Email Campaign Details 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](https://support.daasity.com/migrated/knowledge/view-uns-notification-campaign-detail#view-definition)
- [Explores](https://support.daasity.com/migrated/knowledge/view-uns-notification-campaign-detail#explores)
- <https://support.daasity.com/migrated/knowledge/view-uns-notification-campaign-detail#_Extraction_Table_1>[Transform Code](https://support.daasity.com/migrated/knowledge/view-uns-notification-campaign-detail#transform-code)

### View Definition

This view is linked to the [drp.notification_campaign_detail] 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** |
| --- | --- | --- | --- |
| Campaign Start Date | Dimension Group | The date the campaign or automation first sent a notification | campaign_start_date |
| Send Date | Dimension Group | The date the campign or automation sent a notification | send_date |
| Automation Name | Dimension | Automation ID that triggers a series of notification | automation_name |
| Campaign ID | Dimension | The Campaign ID from the Source system | source_campaign_id |
| Campaign Name | Dimension | Name for the Campaign | campaign_name |
| Email | Dimension | Email address that received notifications | email |
| Bounce Rate | Measure | Bounces/Sends | 1.00 * COALESCE(SUM(bounces), 0) / NULLIF(COALESCE(SUM(sends), 0), 0) |
| Click Rate | Measure | Click to Open Rate - Unique Clicks/Unique Opens | 1.00 * COALESCE(SUM(unique_clicks), 0) / NULLIF(COALESCE(SUM(unique_opens), 0), 0) |
| Open Rate | Measure | Unique Opens/Sends | 1.00 * COALESCE(SUM(unique_opens), 0) / NULLIF(COALESCE(SUM(sends), 0), 0) |
| Spam Rate | Measure | Spam/Sends | 1.00 * COALESCE(SUM(spams), 0) / NULLIF(COALESCE(SUM(sends), 0), 0) |
| Total Bounces | Measure | Count the number of emails bounced | COALESCE(SUM(bounces), 0) |
| Total Campaigns | Measure | Count the number of campaigns | COUNT(DISTINCT campaign_id) |
| Total Clicks | Measure | Count the number of emails clicked | COALESCE(SUM(clicks), 0) |
| Total Opens | Measure | Count the number of emails opened | COALESCE(SUM(opens), 0) |
| Total Sends | Measure | Count the number of emails sent | COALESCE(SUM(sends), 0) |
| Total Spams | Measure | Count the number of emails that marked spam | COALESCE(SUM(spams), 0) |
| Total Unique Clicks | Measure | Count the number of distinct emails clicked | COALESCE(SUM(unique_clicks), 0) |
| Total Unique Opens | Measure | Count the number of distinct emails opened | COALESCE(SUM(unique_opens), 0) |

### 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:

- [7030_NTF_BAS_notification_campaign_detail_performance.sql]