Monitor your team

Note: Teams are supported for Enterprise plans only.

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:

1. Sign in to AppSheet.
2. Select My team in the account profile drop-down.
3. Click Usage.
4. Expand the details for a specific user.
5. Click Log for an app to view related activity by using Audit History.

See also Monitor app activity using Audit History.

As the team root or admin, you can export Audit History logs for your team to BigQuery as described in Export team audit logs to BigQuery.

Monitor AppSheet database activity

To monitor AppSheet database activity:

1. Sign in to AppSheet.
2. Select My team in the account profile drop-down.
3. Click Usage.
4. Expand the details for a specific user.
5. 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.

Note: You must have team root or admin privileges to access team app usage by email.

Use the UI

To monitor team app usage by email using the AppSheet UI:

1. Sign in to AppSheet.
2. Select My team in the account profile drop-down.
3. Click Usage.
4. To download usage data for all team apps as a CSV file, click Download usage data.
5. To view usage data for a specific app:
   1. Expand the app details for a specific user.
   2. 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 by email using the API, issue a GET request to:

https://{appsheet-region}/api/v2/admin/reports/usage

Where:

Variable	Description
{appsheet-region}	Domain used to invoke the API based on the supported data residency regions. Valid values include: Global: www.appsheet.com EU: eu.appsheet.com Note: The api.appsheet.com domain is still supported, but has been deprecated.

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).	[e-mail]
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.	google
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.

Notes:

• 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:

1. Sign in to AppSheet.
2. Select My team in the account profile drop-down.
3. Click Billing.
4. To download billing information for all team apps as a CSV file, click Download billing data.
5. Expand the plan details for a specific user to view more information.

Use the API

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
{appsheet-region}	Domain used to invoke the API based on the supported data residency regions. Valid values include: Global: www.appsheet.com EU: eu.appsheet.com Note: The api.appsheet.com domain is still supported, but has been deprecated.

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
startDate	Start date for the billing information. The value must be in the following URL-encoded form: M%2FD%2FYYYY For example: 1%2F1%2F2021 (1/1/2021)
endDate	End date for the billing information. The value must be in the following URL-encoded form: M%2FD%2FYYYY For example: 1%2F1%2F2021 (1/1/2021)

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.	[e-mail]
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.

Note: You must have team root or admin privileges to monitor team membership.

Use the UI

To monitor team membership using the AppSheet UI:

1. Sign in to AppSheet.
2. Select My team in the account profile drop-down.
3. Click Members.
4. To download membership data for all team apps as a CSV file, click Download membership data.
5. To view details for a specific team member, expand the associated section

Use the API

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
{appsheet-region}	Domain used to invoke the API based on the supported data residency regions. Valid values include: Global: www.appsheet.com EU: eu.appsheet.com Note: The api.appsheet.com domain is still supported, but has been deprecated.

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.

To distinguish between app creators and app users, note that app users won't ever have an entry for Last App Edit or an app count of 0.

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).	[e-mail]
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