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

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: 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://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).

[email protected]

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://appsheet.com/newshortcut/6fb80a26-04ae-4b96-8d27-4bc851e0cf2c

 

Browser link

Link to access app in a browser.

https://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: 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://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.

[email protected]

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: 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://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).

[email protected]

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

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Contact us Tell us more and we’ll help you get there
true
Search
Clear search
Close search
Google apps
Main menu
1875221748621270612
true
Search Help Center
true
true
true
false
false