This article will help you learn about the fields available in the Subscribers 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
WARNING: This view is only available to accounts that have Recharge installed
View Definition
This view is linked to the [drp.subscribers] 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 |
| First Subscription Begin Date | Dimension Group | Date or timeframe first subscription was started | first_sub_start_date |
| First Subscription End Date | Dimension Group | Date or timeframe first subscription ended or will end | first_sub_end_date |
| Most Recent Subscription Begin Date | Dimension Group | Date or timeframe most recent subscription was started | most_recent_sub_start_date |
| Most Recent Subscription End Date | Dimension Group | Date or timeframe most recent subscription ended or will end | most_recent_sub_end_date |
| Email Address | Dimension | The most recent email address associated with this subscriber | email_address |
| Subscriber ID | Dimension | The Subscriber ID from Recharge | subscriber_id |
| Count Active Subscribers | Measure | Count of the number of Subscribers when a Subscriber has at least one active subscription | COUNT(DISTINCT CASE WHEN active_subscription_count > 0 THEN subscriber_id ELSE NULL END ) |
| Count Active Subscriptions | Measure | Count of Active Subscriptions | COALESCE(SUM(active_subscription_count), 0) |
| Count Subscribers | Measure | Count of total number of Subscribers | COUNT(DISTINCT subscriber_id) |
Explores
This view is part of the following explores:
- Subscribers
Transformation Code
This view is a Daasity derived table generated by the following code:
- [4810_SUB_BAS_subscribers.sql]