> ## Documentation Index > Fetch the complete documentation index at: https://docs.sourcemedium.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # rpt_subscriptions_performance_daily > Daily subscription growth, churn, active subscriptions, and MRR reporting. ```yaml theme={null} 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](/docs/help-center/core-concepts/data-definitions/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.