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.