This article describes how to export billing account statistics in ActivityInfo.
Do you need a global overview of all the user permissions and Databases on your billing account? You can export information about all the users added in all of the Databases on your billing account.
Exporting billing account statistics allows you to retrieve the following information about your users:
- Databases
- Unique users
- User ID
- Last login to the user account
- Activation status
- Database(s) in which are users have been invited to and have a role assigned.
- The license type required for each user ( Full, Basic, or None)
The billing account statistics export does not provide details on the role assigned to users in each Database. To obtain this information, follow the steps in Exporting user permissions for all Databases in a billing account.
You can use the billing account statistics report to clean up user access across your account.
Exporting account statistics
The billing account page contains various information about your users and subscription, including your account statistics.
To export the account statistics report, follow these steps:
- Click on the Account button located in the top right navigation menu.
- From the drop-down menu, select "Billing account."
- Click the "Export account statistics" option. The system automatically initiates the export process.
- After the export is completed, the statistics are downloaded as an Excel workbook to your device.
Understanding the account statistics report
The account statistics Excel contains the following information on separate worksheets:
- Databases: a list of all Databases that are counted towards your billing account.
- Unique users: a list of all individual users invited to the Databases listed in the “Databases” worksheet.
Regarding Unique users in the report, consider the following:
- If the same individual is invited to multiple Databases owned by your billing account, they are only counted once towards your user limit, and appear in one row in the “unique users” worksheet.
- The last login time is included for each user. If the cell is blank, the user has not yet logged into ActivityInfo.
- Users may be invited to Databases owned by different billing accounts. The last login time is the time of their last login to their ActivityInfo account, not necessarily viewed or interacted with on your billing account.
- The “Email delivery status” column in the exported file can be an indication that a user has left their role within an organization. For more information, see Email delivery status.
- The “License type” column indicates the type of license required for the user. For more information on how licenses are determined, see Managing user license requirements.