---
title: "View: Notification Customer Segments"
description: This article will help you learn about the fields available in the Notification Customer Segments 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: Notification Customer Segments

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

### View Definition

**NOTE:** This View is only available to merchants with the Pro version of Daasity

This view is linked to the [drp.customer_notification_summary] 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** |
| --- | --- | --- | --- |
| Clicks in Last One Month | Dimension | Total clicks in last one month for all emails sent to that email address | click_one_month |
| Clicks in Last Six Months | Dimension | Total clicks in last six months for all emails sent to that email address | click_six_month |
| Clicks in Last Three Months | Dimension | Total clicks in last three months for all emails sent to that email address | click_three_month |
| Clicks in Last Twelve Months | Dimension | Total clicks in last twelve months for all emails sent to that email address | click_twelve_month |
| Had a Click in Last One Month | Dimension | True if had at least one click in the last month | (CASE WHEN click_one_month > 0 THEN 'Yes' ELSE 'No' END) |
| Had a Click in Last Six Months | Dimension | True if had at least one click in the last six months | (CASE WHEN click_six_month > 0 THEN 'Yes' ELSE 'No' END) |
| Had a Click in Last Three Months | Dimension | True if had at least one click in the last three months | (CASE WHEN click_three_month > 0 THEN 'Yes' ELSE 'No' END) |
| Had a Click in Last Twelve Months | Dimension | True if had at least one click in the last twelve months | (CASE WHEN click_twelve_month > 0 THEN 'Yes' ELSE 'No' END) |
| Domain Name | Dimension | The domain name of the email address | domain_name |
| Domain Name Group | Dimension | The Domain Group: Gmail, Yahoo, hotmail/msn/outlook/live as Microsoft, me/mac/icloud as Apple, Comcast, AOL | domain_name_group |
| Had an Open in Last One Month | Dimension | True if had at least one open in the last month | (CASE WHEN open_one_month > 0 THEN 'Yes' ELSE 'No' END) |
| Had an Open in Last Six Months | Dimension | True if had at least one open in the last six months | (CASE WHEN open_six_month > 0 THEN 'Yes' ELSE 'No' END) |
| Had an Open in Last Three Months | Dimension | True if had at least one open in the last three months | (CASE WHEN open_three_month > 0 THEN 'Yes' ELSE 'No' END) |
| Had an Open in Last Twelve Months | Dimension | True if had at least one open in the last twelve months | (CASE WHEN open_twelve_month > 0 THEN 'Yes' ELSE 'No' END) |
| Opens in Last One Month | Dimension | Total opens in last one month for all emails sent to that email address | open_one_month |
| Opens in Last Six Months | Dimension | Total opens in last six months for all emails sent to that email address | open_six_month |
| Opens in Last Three Months | Dimension | Total opens in last three months for all emails sent to that email address | open_three_month |
| Opens in Last Twelve Months | Dimension | Total opens in last twelve months for all emails sent to that email address | open_twelve_month |
| Had a Send in Last One Month | Dimension | True if had at least one send in the last month | (CASE WHEN send_one_month > 0 THEN 'Yes' ELSE 'No' END) |
| Had a Send in Last Six Months | Dimension | True if had at least one send in the last six months | (CASE WHEN send_six_month > 0 THEN 'Yes' ELSE 'No' END) |
| Had a Send in Last Three Months | Dimension | True if had at least one send in the last three months | (CASE WHEN send_three_month > 0 THEN 'Yes' ELSE 'No' END) |
| Had a Send in Last Twelve Months | Dimension | True if had at least one send in the last twelve months | (CASE WHEN send_twelve_month > 0 THEN 'Yes' ELSE 'No' END) |
| Sends in Last One Month | Dimension | Total sends in last one month for all emails sent to that email address | send_one_month |
| Sends in Last Six Months | Dimension | Total sends in last six months for all emails sent to that email address | send_six_month |
| Sends in Last Three Months | Dimension | Total sends in last three months for all emails sent to that email address | send_three_month |
| Sends in Last Twelve Months | Dimension | Total sends in last twelve months for all emails sent to that email address | send_twelve_month |
| Total Clicks Last Month | Measure | The total number of clicks in the last month | SUM(click_one_month) |
| Total Clicks Last Six Months | Measure | The total number of clicks in the last six months | SUM(click_six_month) |
| Total Clicks Last Three Months | Measure | The total number of clicks in the last  three months | SUM(click_three_month) |
| Total Clicks Last Twelve Months | Measure | The total number of clicks in the last  twelve months | SUM(click_twelve_month) |
| Total Opens Last Month | Measure | The total number of opens in the last month | SUM(open_one_month) |
| Total Opens Last Six Months | Measure | The total number of opens in the last six months | SUM(open_six_month) |
| Total Opens Last Three Months | Measure | The total number of opens in the last  three months | SUM(open_three_month) |
| Total Opens Last Twelve Months | Measure | The total number of opens in the last  twelve months | SUM(open_twelve_month) |
| Total Sends Last Month | Measure | The total number of sends in the last month | SUM(send_one_month) |
| Total Sends Last Six Months | Measure | The total number of sends in the last six months | SUM(send_six_month) |
| Total Sends Last Three Months | Measure | The total number of sends in the last  three months | SUM(send_three_month) |
| Total Sends Last Twelve Months | Measure | The total number of sends in the last  twelve months | SUM(send_twelve_month) |

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

- [7060_NTF_BAS_customer_notification_summary.sql]