Monitor your team as described in the following sections:
- Monitor team app activity using Audit History
- Monitor team app usage statistics
- Monitor team membership
- Monitor team billing information
Monitor team app activity using Audit History
To monitor team app activity using Audit History:
- Sign in to AppSheet.
- Select My team in the account profile drop-down.
- Click Usage.
- Expand the app details for a specific user.
- Click Log under the Usage column for an app to view related activity using Audit History.
See also Monitor app activity using Audit History.
Monitor team app usage statistics
Monitor detailed app usage information for management purposes. See also Monitor app usage statistics.
Use the UI
To monitor team app usage statistics using the AppSheet UI:
- Sign in to AppSheet.
- Select My team in the account profile drop-down.
- Click Usage.
- To download usage data for all team apps as a CSV file, click Download usage data.
- To view usage data for a specific app:
- Expand the app details for a specific user.
- Click x monthly users under the Usage column for an app to view relevant usage details.
Use the API
To monitor your team app usage, issue a GET
request to the following API:
https://www.appsheet.com/api/v2/admin/reports/usage
Headers
You must pass the AccessKey
and UserId
headers, as described in Manage and monitor your team using the API.
Example
For example:
curl https://www.appsheet.com/api/v2/admin/reports/usage \
-X GET \
-H "AccessKey: DcTx1-TFq3c-7ka6t-PcnnI-7d0dO-M4wTm-vWwx0-1KBte" \
-H "UserId: 1234567"
If successful, the API call returns 200 OK
and the CSV is downloaded to your local drive in the current directory.
CSV file
The monitor team app usage CSV file contains the following columns.
Column |
Description |
Example |
User Id |
User account ID for the team member that accessed the app. The total number of User Ids in a report is equivalent to the total number of AppSheet app owners (different from billable users). |
1234567 |
User Email |
Email for the team member that accessed the app. The total number of User Emails in a report is equivalent to the total number of AppSheet app owners (different from billable users). |
user@example.com |
App ID |
ID of the app that was accessed. The total number of App Ids in a report is equivalent to the total number of AppSheet apps in the team account, regardless of their deployment status. |
6fb80a26-04ae-4b96-8d27-4bc851e0cf2c |
App Internal Name |
Internal name of the app that was accessed. The total number of App Internal Names in a report is equivalent to the total number of AppSheet apps in the team account, regardless of their deployment status. |
MyFirstApp |
Install link |
Link to install app on mobile device. |
https://www.appsheet.com/newshortcut/6fb80a26-04ae-4b96-8d27-4bc851e0cf2c
|
Browser link |
Link to access app in a browser. |
https://www.appsheet.com/start/6fb80a26-04ae-4b96-8d27-4bc851e0cf2c |
Runnable? |
Flag that specifies whether the app is able to run. For example, if there is an error in your app preventing it from being run, this flag is set to FALSE. |
TRUE |
Deployed? |
Flag that specifies whether the app is deployed. See Deployment. |
TRUE |
Public Sample? |
Flag that specifies whether the app is a public sample. See Share sample apps in your public portfolio. |
TRUE |
Team Sample |
Flag that specifies whether the app is a team sample. See Share team sample apps. |
TRUE |
Secure |
Flag that specifies whether the app is secure. See How to require user sign-in. |
TRUE |
Auth Provider |
Authorization provider used by the app. See How to require user sign-in. |
|
Allow all signed-in users |
Flag that specifies whether all signed-in users are able to access the app. See Share your app with all signed-in users. |
FALSE |
Monthly users |
Total active users in current monthly billing cycle. An active user is anyone who accessed your app within the last 30 days. See also What is an active user? |
10 |
Most recently used |
Date and timestamp that the app was most recently used in the last month. Useful for time-based reporting such as confirming that an app is no longer being accessed after it is deprecated. |
12/2/2021 10:33:56 AM |
Least recently used |
Date and timestamp that the app was first used in the last month. Useful for time-based reporting such as determining when a new app was first accessed. |
11/11/2021 2:19:36 PM |
App Public Name |
Public name of app. See Customize the About page. |
My App |
Version |
Version of app. See Customize the About page. |
1.000005 |
Short description |
Short description of the app. See Customize the About page. |
Sample App |
Description |
Description of the app. See Customize the About page. |
A sample app with sample data |
User Guidance |
App user guidance. See Customize the About page. |
Some user guidance |
About Url |
URL for about app information. See Customize the About page. |
about.example.com |
Privacy policy Url |
URL for app privacy policy. See Customize the About page. |
privacy-policy.example.com |
Category |
Category of the app. See Customize the About page. |
Tracking Apps |
Function |
Function of the app. See Customize the About page. |
Inventory Management |
Industry |
Industry for the app. See Customize the About page. |
Retail |
Purpose |
Purpose of the app. See Customize the About page. |
Track item details and log incoming and outgoing inventory amounts. |
Design Details |
App design details. See Customize the About page. |
Some design details |
Reference Url |
URL for app reference information. See Customize the About page. |
reference-url.example.com |
Owner Id |
Account ID of app owner. |
1899830 |
Monitor team membership
Monitor detailed team membership information for governance and management purposes.
Use the UI
To monitor team membership using the AppSheet UI:
- Sign in to AppSheet.
- Select My team in the account profile drop-down.
- Click Members.
- To download membership data for all team apps as a CSV file, click Download membership data.
- To view details for a specific team member, expand the associated section
Use the API
To monitor your team membership, issue a GET
request to the following API:
https://www.appsheet.com/api/v2/admin/reports/membership
Headers
You must pass the AccessKey
and UserId
headers, as described in Manage and monitor your team using the API.
Example
For example:
curl https://www.appsheet.com/api/v2/admin/reports/membership \
-X GET \
-H "AccessKey: DcTx1-TFq3c-7ka6t-PcnnI-7d0dO-M4wTm-vWwx0-1KBte" \
-H "UserId: 1234567"
If successful, the API call returns 200 OK
and the CSV is downloaded to your local drive in the current directory.
CSV file
The monitor team membership CSV file contains the following columns.
Column |
Description |
Example values |
User Id |
User account ID for the team member that accessed the app. The total number of User Ids in a report is equivalent to the total number of AppSheet team members (different from AppSheet users). |
1234567 |
User Email |
Email for the team member that accessed the app. The total number of User Emails in a report is equivalent to the total number of AppSheet team members (different from AppSheet users). |
user@example.com |
User Name |
Name of the user. If a recipient is sent an email team invitation and they manually accept it in the email, their display name will appear in this column. If, however, the admin use the Adopt my entire domain feature, then this column is empty for signed-in users. |
|
User Plan |
Subscription plan. |
Core (Google Workspace) |
User Role |
Role of user, such as Member, Admin, Root. |
Member |
Date Created |
Date and timestamp that the user was created. |
12/2/2020 10:33:56 AM |
Last App Edit |
Last time an app was edited by the user. |
11/11/2021 2:19:36 PM |
App Count |
Number of apps owned by the user. |
10 |
Monitor team billing information
Monitor detailed user information for billing purposes.
- You must have team root or admin privileges to access team billing information.
- You can access up to 30 days of billing information.
Use the UI
To monitor team billing information:
- Sign in to AppSheet.
- Select My team in the account profile drop-down.
- Click Usage.
- To download billing information for all team apps as a CSV file, click Download billing data.
- Expand the plan details for a specific user to view more information.
Use the API
To monitor your team billing information, issue a GET
request to the following API:
https://www.appsheet.com/api/v2/admin/reports/billing
Query parameters
Optionally, you can pass the following as query parameters. If not specified, billing information is returned for the last 30 days.
Query parameter |
Description |
|
Start date for the billing information. The value must be in the following URL-encoded form: For example:
|
|
End date for the billing information. The value must be in the following URL-encoded form: For example:
|
Headers
You must pass the AccessKey
and UserId
headers, as described in Manage and monitor your team using the API.
Example
For example:
curl https://www.appsheet.com/api/v2/admin/reports/billing \
-X GET \
-H "AccessKey: DcTx1-TFq3c-7ka6t-PcnnI-7d0dO-M4wTm-vWwx0-1KBte" \
-H "UserId: 1234567"
If successful, the API call returns 200 OK
and the CSV is downloaded to your local drive in the current directory.
CSV file
The monitor team usage CSV file contains the following columns.
Column |
Description |
Example values |
User Id |
User account ID for the team member that accessed the app. The total number of User Ids in a report is equivalent to the total number of AppSheet users for the billing period. |
1234567 |
User Email |
Email for the team member that accessed the app. The total number of User Emails in a report is equivalent to the total number of AppSheet users for the billing period. |
user@example.com |
App Count |
Number of apps that the user has accessed or edited. |
10 |
Deployed App Count |
Number of deployed apps that the user has accessed or edited. |
9 |
App Names |
Comma-separated list of apps that the user has accessed. |
App1, App2, App3, … |
Last access |
Date and timestamp of the user's last access. Useful for time-based reporting. |
12/2/2021 10:33:56 AM |