Docs

Data Operations Articles & FAQ

export, subscription, Units, usage, metered, download, report

41075087

2022-08-24T13:09:41Z

2025-02-12T08:24:12Z

248

0

0

255415

Is it possible to build a report to show all the customers and the total amount of usage (units)?

Is it possible to build a report to show all the customers and the total amount of usage (units)? 

Scope

Is it possible to build a report to show all the customers and the total amount of usage (units)?

How to download a subscription with metered usage?

We need a report of subscriptions with high usage recorded.

Summary

You can filter Subscriptions with Quantity using the condition from the Advanced Filter Option on Subscription Index Page and from Export Data using Add Filter list > Subscription > Quantity.

If you are to perform a bulk operation for existing data from Chargebee you may have to export the data from Chargebee and update those data to the import sheet from Bulk Operations. Earlier the export data format and import data format varied which involves a lot of manual intervention. With the new enhanced Export file option, you can either export a file using Download Data or use Download import-friendly file from Settings > Import & Export Data > Product Catalog. Refer to this link for more information.

Solution

Navigate to Subscription > All Subscriptions > Add Filter list > Subscription > Quantity

You can find the list of conditions below to filter usage as per your requirements:

  • equals
  • greater than
  • greater than or equal
  • less than
  • less than or equal

Once you add a condition, say for example 'greater than' and mention the quantity limit as '4', then click 'Apply Filter'

Note: On the recent UI enhancement you can now scroll the index pages - Customers, Subscriptions, Invoices, and Credit Notes vertically. Earlier, the pages will be paginated which may prolong your search however with the new enhancement as you scroll down the list it will load all other data in a single page as highlighted below on the screenshot. Refer to this link for more information. 

Then you can click on 'Export' and click 'Export as CSV' to export.%%% cbext

Was this article helpful?
Loading…