version: 2
models:
- name: rpt_subscriptions_performance_daily
description: >
Daily subscription performance by store and date. Includes subscription and subscriber
growth, churn, dunning, active counts, and MRR. Grain is one row per store, date, and
placeholder channel.
columns:
- name: sm_store_id
description: SourceMedium's unique store identifier.
- name: date
description: Date represented by the daily subscription metrics.
- name: reporting_timezone
description: Workspace timezone used to determine the reporting date.
- name: sm_channel
description: >
Constant Online DTC placeholder required by the report grain. ReCharge does not supply
marketing channel or geography, so this is not an attributed channel. The published value
stays `Online DTC` and is not normalized like `obt_orders.sm_channel` (`online_dtc`). Do
not join or filter this field as if it segmented subscription activity by marketing channel.
- name: sub_channel
description: >
Constant `Unknown` placeholder required by the report grain. It does not segment
subscription activity.
- name: country
description: Constant `Unknown` placeholder. ReCharge does not supply subscription geography.
- name: country_code
description: Constant `Unknown` placeholder. ReCharge does not supply subscription geography.
- name: subscriptions_new
description: >
First-time and returning subscriptions created on this date, excluding same-day
activation-and-churn rows.
- name: subscriptions_returning
description: >
Returning subscriptions created on this date at subscriber and product grain, excluding
same-day activation-and-churn rows. This count is already included in `subscriptions_new`.
- name: subscriptions_cancelled
description: >
Subscriptions actively cancelled on this date, excluding same-day activation-and-churn
rows.
- name: subscriptions_cancelled_passive
description: >
Subscriptions passively cancelled or expired on this date, excluding same-day
activation-and-churn rows.
- name: subscriptions_active
description: Active subscriptions as of this date.
- name: subscriptions_churned
description: Running count of subscriptions that have been actively cancelled as of this date.
- name: subscriptions_churned_passive
description: >
Running count of subscriptions that have been passively cancelled or expired as of this
date.
- name: mrr_new
description: >
MRR added by `subscriptions_new` on this date, including returning subscriptions and
excluding same-day activation-and-churn rows.
- name: mrr_cancelled
description: MRR removed by subscriptions actively cancelled on this date.
- name: mrr_cancelled_passive
description: MRR removed by subscriptions passively cancelled or expired on this date.
- name: mrr
description: Active MRR as of this date.
- name: subscriptions_dunning_new
description: Subscriptions that entered dunning on this date.
- name: subscriptions_dunning
description: Subscriptions in dunning as of this date.
- name: mrr_dunning_new
description: MRR of subscriptions that entered dunning on this date.
- name: mrr_dunning
description: MRR associated with subscriptions in dunning as of this date.
- name: subscribers_new
description: >
Subscribers starting an activity period on this date, excluding same-day
activation-and-churn periods.
- name: subscribers_first_time
description: Subscribers whose first non-same-day activity period starts on this date.
- name: subscribers_returning
description: Subscribers whose later non-same-day activity period starts on this date.
- name: subscribers_active
description: Active subscribers as of this date.
- name: churn_total
description: >
Subscribers who churned on this date, recorded on the first full day of inactivity and
excluding same-day activation-and-churn periods.
- name: churn_active
description: >
Subscribers who actively churned on this date, recorded on the first full day of
inactivity.
- name: churn_passive
description: >
Subscribers who passively churned on this date, recorded on the first full day of
inactivity.
- name: subscribers_cancelled
description: Same as `churn_active`. Active subscriber churn on this date.
- name: subscribers_cancelled_passive
description: Same as `churn_passive`. Passive subscriber churn on this date.
- name: subscribers_churned
description: Running count of subscribers who have actively churned as of this date.
- name: subscribers_churned_passive
description: Running count of subscribers who have passively churned as of this date.
- name: subscribers_dunning_new
description: Subscribers that entered dunning on this date.
- name: subscribers_dunning
description: Subscribers in dunning as of this date.
- name: subscribers_churn_rate
description: Active subscriber churn divided by beginning-of-day active subscriber stock.
- name: smcuuid
description: Hashed store identifier.
When reporting-currency conversion is enabled, MRR fields use the exchange rate for each report date. Daily MRR can therefore change because of exchange-rate movement as well as subscription activity. See Reporting Currency.
A ReCharge bundle currently lands as multiple component subscriptions. Counts and MRR can be inflated for bundle-heavy stores until SourceMedium can collapse those components. Use
dim_subscriptions.is_bundle_component to measure that exposure.