View: Email & SMS File Size History - Monthly

This article will help you learn about the fields available in the Email File Size History - Monthly 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

This view is linked to the [drp.notification_file_size_monthly] 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
Event Date Dimension Group Timestamp that events happened event_at
File Size Date Dimension Group The date (month, quarter, year) when the notification file size was calculated calendar_month
Email Status Dimension Subscribed, unsubscribed or pending status
Count Members Measure Count number of members COUNT(DISTINCT LOWER( contact_id ) )

Explores

This view is part of the following explores:

  • Email File Size History - Monthly

Transformation Code

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

  • [7050_NTF_BAS_notification_file_size_monthly.sql]