Note that the Account object in Zuora has its own ‘Status’ field, of which one possible status is ‘Active’. Zuora sets the status of an Account to Active once created regardless if there is a subscription or not. Listing Accounts by account status may include accounts that are yet to bill or have finished billing at some time in the past. Therefore, to view "active customers", Zuora recommends listing the customer accounts that have subscriptions actively billed.
To get a list of customers that are being actively billed, run the Zuora standard "MRR by Account" report:
- Navigate to Reporting > Reporting in Zuora.
- Navigate to Standard Reports > Booking > Drivers.
- Navigate to MRR by account, and click the down arrow next to Run Detail Report.
- In the expanded drop-down menu, click Run Summary Report.
A list of all customers you are actively billing will be displayed grouped by Currency.
See the video Make Sense of Standard Report for how to customize a Zuora report if you are to customize the report.