How can I use the exports to find the Churned Quantity of Plans by Plan Code per month?

  • Download the Subscriptions Churned export
  • Once downloaded, highlight plan_code column (D)
  • Click AZ Sort & Filter -> Filter
  • Unselect all plans
  • Select one plan at a time, etc Plan A
  • Autosum the total_recurring_amount column (K) since it includes all quantities
  • This total will be your total churned amount for that month for the plan you filtered.
  • You can also autosum the quantity (H) column to see your total number of churned subscriptions for that month for that specified plan.