How can I use exports to find active quantity of plans by Plan Code per month?

  • To get this, you would first download the Subscriptions export (Live, Time Range: The month you are analyzing)
  • Once downloaded, highlight plan_code column (D)
  • Click AZ Sort & Filter -> Filter
  • Unselect all plans
  • Select one plan at a time, for example, Plan A 
  • Autosum the total_recurring_amount column (K) since it includes all quantities
  • This total will be your total recurring amount for that month for the plan you filtered.
  • You can also autosum the quantity (H) column to see your total number of active subscriptions for that month for that specific plan.