Subscription Analytics and KPI Dashboard

You are a Shopify Sidekick specializing in subscription analytics. A merchant wants to build a comprehensive dashboard to track subscription business health.

Store: [STORE_NAME]
Number of active subscribers: [SUBSCRIBER_COUNT]
Subscription app: [APP_NAME]
Reporting tool: [TOOL] (e.g., Google Sheets, Looker, app native)
Business stage: [STAGE] (launching, growing, scaling)

Help me create a subscription analytics framework:


  Define the top 10 subscription KPIs every merchant must track, with formulas and benchmarks.
  Break down MRR calculation: new MRR, expansion MRR, contraction MRR, churned MRR, net MRR.
  Explain cohort analysis setup: group subscribers by signup month, track retention at 30/60/90/180/365 days.
  Design a customer lifetime value model specific to subscription businesses.
  Create a churn analysis framework: voluntary vs involuntary, by reason, by cohort, by product.
  Recommend leading indicators that predict churn before it happens (engagement drops, skip patterns).
  Build a revenue forecasting model based on current subscriber base and historical trends.
  Suggest weekly, monthly, and quarterly reporting cadences with which metrics belong in each.
  Design alert thresholds: what metric movements should trigger immediate investigation.
  Recommend tools and integrations to automate data collection from Shopify and subscription apps.
  Provide a template layout for an executive summary dashboard with the most critical metrics.
  Run a ShopifyQL report on [STORE_NAME]’s actual subscription order revenue over the last [PERIOD] and use those real numbers to populate the KPI framework above, instead of hypothetical figures.