Admin Center: Plan Insights

The plan insights usage dashboard helps you evaluate how your team uses Smartsheet in their daily processes. 

Who can use this?

Plans:

  • Business
  • Enterprise
  • Smartsheet Advance Package

Permissions:

  • System Admin

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

The plan usage report offers key metrics and trends on plan information, Members, Member growth, asset creation, and any advanced capability evaluations. 

 

  • To access the dashboard, sign in to Admin Center, and then select Plan Insights from the left menu. 
  • To share the report, select Download as PDF from the top of the screen.

    The plan usage report updates once per day. 


Plan Usage dashboard

The dashboard displays the following metrics:

  • Plan information: Displays plan type and renewal date with a link to detailed plan and billing information.
  • Assets and workspaces: Total numbers for each asset and assets created during the previous 91 days.
  • Advance capability evaluations: If your plan has advanced capability evaluations in progress, then metrics are visible; if there are no evaluations, these metrics don’t appear.

Use the information from plan insights to understand your internal Smartsheet use and growth. Work with your account manager or customer success manager to forecast and budget for your future needs accordingly.

Metrics and definitions

MetricDefinitionTimeframe

Plan type

Type of the high-level plan

Current

Renewal date

Contract renewal date

Current

Groups

Total number of active groups present during the reported duration

Current

Total assets (total of all types of assets)

Total of all active assets for the reported time period. Includes sheets, reports, and dashboards. (Excludes workspaces).

Current

Total number of sheets, reports, dashboards, forms, workspaces.

Total number of the active assets by sheet, report, dashboard, and workspaces

Current

Created assets

Total number of assets created during the reported period by sheet, report, dashboard, and workspaces. Excludes deleted assets.

Last 91 days

Asset views

Total number of data consumption events (includes loads, downloads, exports, and prints)

All views regardless of current asset status by sheet, report, dashboard, and workspaces.

Last 91 days

Edits - assets *

Total number of the times edits were made to any asset in the plan (Activity Log based)

Last 91 days

* Edit actions include:

  • Activate
  • Deactivate
  • Delete
  • DisabledByUser
  • Enabled
  • Insert
  • Publish
  • Remove
  • SaveAsNew
  • SaveAsTemplate
  • Unpublish
  • Update
  • UpdateAndReenable
  • Updateoverlay
  • Updatepublish

Advanced Capability Plan Insights 

Plan insights show data and usage metrics for Data Shuttle and Dynamic View. The usage reports update once per day.

You must have a Data Shuttle or Dynamic View subscription or an evaluation of one of those capabilities or an Advanced Work Management subscription. If you're in an evaluation, your report timeline is scoped for the evaluation duration. Learn more about advance capability evaluations.

Data Shuttle

You can see insights data that include the total number of workflows created, rows processed, executions, active users, and errors. The data displayed calculates at the plan level from the previous 90 days. 

MetricDefinition
Rows processed

The sum of the number of rows:

  • Added, updated, or deleted by each merge mode workflow on your plan
  • Added by each replace mode workflow on your plan
  • Offloaded by each offload workflow on your plan
Active workflowsTotal number of workflows created and not deleted/archived 
Active usersTotal number of users with at least one executed Data Shuttle workflow
Workflows createdTotal number of workflows created in the plan
ExecutionsTotal number of workflows executed (ran) during the reporting period aggregated at the plan level
ErrorsTotal number of workflows that have errors 
Brandfolder Image
plan insights data

Dynamic View

You can see insights data that include the total number of views created, rows updated, executions, active users, errors, and more. The data displayed calculates at the plan level from the previous 90 days. 

MetricDefinition
Views createdTotal number of Dynamic Views created during the reporting period
Rows updatedTotal number of rows updated in all Dynamic Views
Shared viewsTotal number of Dynamic views that are shared to collaborators in the plan
Active viewsTotal count of Dynamic Views that are not deleted
Shared collaboratorsTotal number of collaborators who are shared to Dynamic Views
Active usersCount of all unique users who have accessed/viewed a specific Dynamic View or created a Dynamic View
Brandfolder Image
plan insights data

You can download a Dynamic View access report at any time by selecting View access report.

The plan usage report offers key metrics and trends on plan information, the licenses and connected users, user growth, asset creation, and any advance capability evaluations.

  • To access the dashboard, sign in to Admin Center, and then select Plan Insights from the left menu. 
  • To share the report, select Download as PDF from the top of the screen.

    The plan usage report updates once per day. Currently, the plan usage report is only available for the last 91 days. You can’t adjust the time frame.


Plan Usage dashboard

The dashboard displays the following metrics:

  • Plan information: Displays plan type and renewal date with a link to detailed plan and billing information.
  • Expanded user reporting: Displays the threshold for licensed users and provides details on connected users. Select Buy more to purchase new licenses directly from the dashboard.
  • Assets and workspaces: Total numbers for each asset and assets created during the reporting period (91 days).
  • Advance capability evaluations: If your plan has advance capability evaluations in progress, then metrics are visible; if there are no evaluations, these metrics don't appear.

Connected users

Connected users in Smartsheet Advance refer to:

  • Licensed users: Users with paid licenses who can create, own, and manage tasks or projects on a plan. Licensed users count as Connected users regardless of their activity with the plan’s Smartsheet items.
  • Internal collaborators: Internal users who have interacted with a plan's items in the past 365 days—typically by working with sheets, reports, and dashboards—while authenticating using the company's domain or subdomain associated with the plan. This doesn’t include licensed users.
  • Previously licensed users: Users who had licenses revoked or deactivated in the past 365 days and no longer interact with a plan's sheets, reports, or other items. Doesn’t include licensed users or internal collaborators.

Connected users represent the total number of users associated with your Smartsheet usage. This number is relevant when you purchase, true up, or renew your account.

What qualifies someone as a Connected User?

A user becomes a Connected User if they meet at least one of the following criteria within the last 365 days:

  • They view or edit any sheets, reports, or dashboards that your plan owns
  • They are currently a licensed user on your plan
  • They were a licensed user on your plan in the last 365 days
  • They complete an update request, approval request, or any workflow that updates an underlying sheet that your plan owns
  • They fill out a Smartsheet Form. When signed in, submitting a form counts as interacting with a sheet

In essence, a connected user is anyone who has authenticated and interacted with content that belongs to your plan within the past 365 days, or any user who held a license during that timeframe. Unauthenticated interactions, such as form submissions or accessing published sheets, don’t count.

Gain insight into your users and licensing

Select Create User Report to generate a sheet with more insight into the users that make up your connected user count. This sheet contains information on who a connected user is, their activity, the department they belong to, and the number of assets they have used.

To generate a connected users report:

  1. Navigate to Admin Center.
  2. In the Plan Insights tile, select Explore Insights from the Plan usage card.
  3. Locate the User accounts tile, and then select Create user report.
  4. The following message displays: “This may take a few minutes...”

    Once the report generation is complete, it will not automatically launch or open a new tab. Users will need to manually access their Sheets Directory/Folder to view or access the generated "Connected Users Report" sheet. You may find multiple sheets created with names such as “Connected Users Report 2024-03-13”.

Use the information from plan insights to understand your internal Smartsheet use and growth. Work with your account manager or customer success manager to forecast and budget for your future needs accordingly.

Metrics and definitions

MetricDefinitionTimeframe

Plan type

Type of the high-level plan

Current

Renewal date

Contract renewal date

Current

Licenses used by the plan

Number of licenses assigned to users associated with the plan. Excludes free licenses.

Current

License threshold

Total number of licenses purchased by the plan

Current

Connected users

Total number of connected users at the plan level

Current

Connected users threshold

Total number of connected users purchased by the plan

Current

Groups

Total number of active groups present during the reported duration

Current

Total assets (total of all types of assets)

Total of all active assets for the reported time period. Includes sheets, reports, and dashboards. (Excludes workspaces).

Current

Total number of sheets, reports, dashboards, forms, workspaces.

Total number of the active assets by sheet, report, dashboard, and workspaces

Current

Created assets

Total number of assets created during the reported period by sheet, report, dashboard, and workspaces. Excludes deleted assets.

Last 91 days

Asset views

Total number of data consumption events (includes loads, downloads, exports, and prints)

All views regardless of current asset status by sheet, report, dashboard, and workspaces.

Last 91 days

Edits - assets *

Total number of the times edits were made to any asset in the plan (Activity Log based)

Last 91 days

* Edit actions include:

  • Activate
  • Deactivate
  • Delete
  • DisabledByUser
  • Enabled
  • Insert
  • Publish
  • Remove
  • SaveAsNew
  • SaveAsTemplate
  • Unpublish
  • Update
  • UpdateAndReenable
  • Update overlay
  • Updatepublish

Advanced Capability Plan Insights

Plan insights show data and usage metrics for Data Shuttle and Dynamic View. The usage reports update once per day.

You must have a Data Shuttle or Dynamic View subscription or an evaluation of one of those capabilities or an Advanced Work Management subscription. If you're in an evaluation, your report timeline is scoped for the evaluation duration. Learn more about advance capability evaluations.

Data Shuttle

You can see insights data that include the total number of workflows created, rows processed, executions, active users, and errors. The data displayed calculates at the plan level from the previous 90 days.

MetricDefinition
Rows processed

The sum of the number of rows:

  • Added, updated, or deleted by each merge mode workflow on your plan
  • Added by each replace mode workflow on your plan
  • Offloaded by each offload workflow on your plan
Active workflowsTotal number of workflows created and not deleted/archived
Active usersTotal number of users with at least one executed Data Shuttle workflow
Workflows createdTotal number of workflows created in the plan
ExecutionsTotal number of workflows executed (ran) during the reporting period aggregated at the plan level
ErrorsTotal number of workflows that have errors 
Brandfolder Image
plan insights data

Dynamic View

You can see insights data that include the total number of views created, rows updated, executions, active users, errors, and more. The data displayed calculates at the plan level from the previous 90 days.

MetricDefinition
Views createdTotal number of Dynamic Views created during the reporting period
Rows updatedTotal number of rows updated in all Dynamic Views
Shared viewsTotal number of Dynamic views that are shared to collaborators in the plan
Active viewsTotal count of Dynamic Views that are not deleted
Shared collaboratorsTotal number of collaborators who are shared to Dynamic Views
Active usersCount of all unique users who have accessed/viewed a specific Dynamic View or created a Dynamic View
Brandfolder Image
plan insights data

You can download a Dynamic View access report at any time by selecting View access report.

How do you define "last login"? Does this mean a user is signing into the portal and entering their password?

Yes. Last login refers to a successful sign-in using a username and password, SAML, or other login method.

What's the difference between last activity and last login?

Last login refers to the most recent time a user accessed the platform, while last activity indicates the latest interaction a user had with the items owned by the plan.

How do these users show up in the User Management page? Right now, we can’t see any of these users, so we’re unable to manage or deactivate them.

Only users who have received an invitation to join the plan or have been added via the Add User function in Admin Center will show up on the User Management page.

Why do I see different numbers of Licensed users on the Admin Center home page and the Plan Insights page?

The Plan Insights page doesn't show changes right away. Data is updated once a day. 

The licensed user count in Plan Insights doesn’t include pending users – those who haven’t accepted their licenses. The number on the Admin Center home page includes pending users.

Pending users are not included in the Connected User Report Licensed User column.

 

Why are users with no last activity counted as connected users?

Connected users is the total number of licensed users, internal collaborators, and previously-licensed users. If a user is a licensed user or a previously-licensed user, the user will still be counted as a connected user even if there is no activity.

 

Why does a user have a login record on the Access Report in 2022 but the Connected User Report shows the user’s last activity is in 2021?

Last activity counts any user interaction including view, click, submit a form (while logged in), comment, respond to an update request, and more. 

Logging in without interacting does not count as user activity.

 

In the Connected Users Report, what is the difference between Items Edited and Items Viewed?

When the user edits a sheet, report or dashboard, it counts as an item edited. If a user opens an item but does not change anything, it counts as and item viewed.

Items edited does not include items viewed.