Monitor your team as described in the following sections:
- Monitor team app activity by using Audit History
- Monitor AppSheet database activity
- Monitor team app usage by email
- Monitor team app usage by user
- Monitor team membership
Monitor team app activity by 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 details for a specific user.
- Click Log for an app to view related activity by using Audit History.
See also Monitor app activity using Audit History.
Monitor AppSheet database activity
To monitor AppSheet database activity:
- Sign in to AppSheet.
- Select My team in the account profile drop-down.
- Click Usage.
- Expand the details for a specific user.
- Click Log for an AppSheet database to view related activity in the database audit log.
See also Manage and monitor databases in your account.
Monitor team app usage by email
Monitor team app usage by email. See also Monitor app usage statistics.
In this report, if a user signs in to AppSheet using multiple identity providers, app usage for each email is logged separately.
Use the UI
To monitor team app usage by email 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.
To monitor your team app usage by email using the API, issue a GET
request to:
https://{appsheet-region}/api/v2/admin/reports/usage
Where:
Variable | Description |
|
Domain used to invoke the API based on the supported data residency regions. Valid values include:
Note: The |
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.
The 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 app usage by user
Monitor team app usage by user.
In this report, if a user signs in to AppSheet using multiple identity providers, app usage for each email is grouped together and logged as a single user. In this way, the team app usage accurately reflects the total usage by a single user.
- You must have team root or admin privileges to access team app usage by user.
- You can access up to 30 days of billing information.
- You can disregard the User ID column that is returned in this report. It has no relevance and does not equate to the number of licenses required.
Use the UI
To monitor team app usage by user:
- Sign in to AppSheet.
- Select My team in the account profile drop-down.
- Click Billing.
- 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.
To monitor team app usage by user using the API, issue a GET
request to:
https://{api-domain}/api/v2/admin/reports/billing
Where:
Variable | Description |
|
Domain used to invoke the API based on the supported data residency regions. Valid values include:
Note: The |
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.
The team app usage CSV file contains the following columns.
Column |
Description |
Example values |
User Id |
Note: You can disregard the User ID column that is returned in this report. It has no relevance and does not equate to the number of licenses required.
|
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 |
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
To monitor your team membership by using the API, issue a GET
request to:
https://{api-domain}/api/v2/admin/reports/membership
Where:
Variable | Description |
|
Domain used to invoke the API based on the supported data residency regions. Valid values include:
Note: The |
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.
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 |