Views
      Back to home
      1. Help Center
      2. Daasity Platform | Business User Analytics
      3. Views

      View: Unsubscribes

      This article will help you learn about the fields available in the Unsubscribes 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 [uns.unsubscribes] 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
      Unsubscribe Date Dimension Group Date of the Unsubscribe event event_at
      Total Unsubscribes Measure Total number of unsubscribes COUNT(DISTINCT unsubscribe_id)

      Explores

      This view is part of the following explores:

      • Email & SMS Unsubscribes

      Transformation Code

      This view is a part of the Daasity Unified Notification Schema (UNS) that enables Daasity to combine different Email/SMS platforms into a single data model.

      Growth & Pro support the following code:

      • [1083_UNS_BAS_KLAVIYO_unsubscribes.sql]
      • [1283_UNS_BAS_ATTENTIVE_unsubscribes.sql]

      Pro supports the following code if the optional code is enabled:

      • [1183_UNS_BAS_RETENTION_SCIENCE_unsubscribes.sql]
      • [1383_UNS_BAS_ITERABLE_unsubscribes.sql]
      • [1383_UNS_BAS_OMETRIA_unsubscribes.sql]
      • [1313_UNS_BAS_SAILTHRU_campaign_unsubscribes.sql]
      • [1314_UNS_BAS_SAILTHRU_triggered_unsubscribes.sql]