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

## This article will help you learn about the fields available in the Email File Size History - Daily 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
- <https://support.daasity.com/migrated/knowledge/view-looker-pdt-notification-file-size-daily#_Extraction_Table_1>Transform Code

### View Definition

This view is created as a real-time query that runs within Looker against the database and has the following fields available/visible for use:

 

| **Field Name** | **Field Type** | **Description** | **Source / Calculation** |
| --- | --- | --- | --- |
| File Size Date | Filter | Date calculating the notifications file size | Date entered retrieves all the members that were in the email/SMS platform on or before the entered date |
| Domain Name Group | Dimension | The Domain Group: Gmail, Yahoo, hotmail/msn/outlook/live as Microsoft, me/mac/icloud as Apple, Comcast, AOL | CASE WHEN TRIM(SUBSTRING(email, POSITION('@' IN email)+1, POSITION('.' IN SUBSTRING(email, POSITION('@' IN email)+1, LENGTH(email))))) IN ('gmail.','googlemail.') THEN 'gmail' WHEN TRIM(SUBSTRING(email, POSITION('@' IN email)+1, POSITION('.' IN SUBSTRING(email, POSITION('@' IN email)+1, LENGTH(email))))) IN ('yahoo.') THEN 'yahoo' WHEN TRIM(SUBSTRING(email, POSITION('@' IN email)+1, POSITION('.' IN SUBSTRING(email, POSITION('@' IN email)+1, LENGTH(email))))) IN ('hotmail.','msn.','outlook.','live.') THEN 'microsoft' WHEN TRIM(SUBSTRING(email, POSITION('@' IN email)+1, POSITION('.' IN SUBSTRING(email, POSITION('@' IN email)+1, LENGTH(email))))) IN ('aol.','aim.') THEN 'aol' WHEN TRIM(SUBSTRING(email, POSITION('@' IN email)+1, POSITION('.' IN SUBSTRING(email, POSITION('@' IN email)+1, LENGTH(email))))) = 'qq.' THEN 'qq' WHEN TRIM(SUBSTRING(email, POSITION('@' IN email)+1, POSITION('.' IN SUBSTRING(email, POSITION('@' IN email)+1, LENGTH(email))))) = 'comcast.' THEN 'comcast' WHEN TRIM(SUBSTRING(email, POSITION('@' IN email)+1, POSITION('.' IN SUBSTRING(email, POSITION('@' IN email)+1, LENGTH(email))))) IN ('me.','mac.','icloud.') THEN 'apple' ELSE 'Other' END |
| Notification Status | Dimension | Subscribed, unsubscribed, or pending | status |
| Count Members | Measure | Count number of members | COUNT(DISTINCT contact_id)) |

### Explores

This view is part of the following explores:

- Email File Size History - Daily

### Transformation Code

This view is created within Looker as part of a Dynamic query which selects the following data from source tables to generate the final output from the query

![](https://support.daasity.com/hubfs/snowflake_1628032679306-png.png)

and leverages the following joins

![](https://support.daasity.com/hubfs/snowflake_1628032694481-png.png)