View: Subscription Profiles

This article will help you learn about the fields available in the Subscription Profiles 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
  • Explores
  • Transform Code

View Definition

This view is linked to the [drp.subscription_profiles] 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 Recurring Order Date Dimension Group Date of the first recurring order in a subscription first_recurring_order_date
Subscription Begin Date Dimension Group Date the subscription began subscription_start_date
Subscription End Date Dimension Group Date the subscription ended (if the subscription has ended) subscription_end_date
Cancellation Reason Dimension Cancellation reason entered into Recharge when subscription is cancelled cancellation_reason
Cancelled Before First Recurring Order Flag Dimension Yes if customer cancelled before their first recurring order cancel_before_first_repurchase_flag
Days Active Dimension Number of days subscription has been active days_active
First Order Subscriber Flag Dimension Yes if customer became a subscriber on their first order first_order_subscriber_fla
First Subscription Order Channel Dimension The channel of the first subscription order from GA transactions that has been fixed using channel mapping first_sub_order_dw_channel
Frequency of Shipments (days) Dimension The number of days between shipments shipping_interval_frequency_days
Subscriber ID Dimension The Subscriber ID from Recharge subscriber_id
Subscription ID Dimension Subscription ID from Recharge recharge_subscription_id
Product Title Dimension Name of product subscribed to product_title
Quick Cancel Flag Dimension Yes if the subscription was cancelled within 24 hours of the start date quick_cancel_flag
Recurring Order Completion Flag Dimension Yes if the customer completed a recurring order recurring_order_completion_flag
Recurring Shipments Completed Dimension Number of recurring shipments made shipments_completed
Subscription Status Dimension The status of the subscription subscription_status
Unique Customer ID Dimension The unique customer ID from the customer profiles table unique_customer_id
Valid Orders Before Subscription Started Dimension The number of valid orders before the first subscription date valid_orders_before_sub
Average Days Active Measure Average number of days subscriptions have been active AVG(days_active)
Average Shipments Completed Measure Average number of shipments completed AVG(shipments_completed)
Average Valid Orders Before Subscription Measure Average number of valid orders before subscription start AVG(valid_orders_before_sub)
Total Days Active Measure Total number of days subscriptions have been active COALESCE(SUM(days_active), 0)
Total Subscription Count Measure Count of Subscriptions COUNT(DISTINCT recharge_subscription_id)
Total Valid Orders Before Subscription Measure Total number of valid orders before subscription start COALESCE(SUM(valid_orders_before_sub), 0)


This view is part of the following explores:

  • Subscribers

Transformation Code

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

  • [4820_SUB_BAS_subscription_profile.sql]