Monitor your team

Monitor your team as described in the following sections:

Monitor team app activity using Audit History

To monitor team app activity using Audit History:

  1. Sign in to AppSheet.
  2. Click My team in the top navigation.
  3. Click Usage.
  4. Expand the app details for a specific user.
  5. 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:

  1. Sign in to AppSheet.
  2. Click My team in the top navigation.
  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, 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.

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 membership

Monitor detailed team membership information for governance and management purposes.

Use the UI

To monitor team membership using the AppSheet UI:

  1. Sign in to AppSheet.
  2. Click My team in the top navigation.
  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, 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.

Note: You can access up to 30 days of billing information.

Use the UI

To monitor team billing information:

  1. Sign in to AppSheet.
  2. Click My team in the top navigation.
  3. Click Usage.
  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 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

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.

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

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false