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.