Microsoft 365 usage analytics data model

Data for the Microsoft 365 usage analytics tables

Microsoft 365 usage analytics connects to an API that exposes a multidimensional data model. The APIs that Microsoft 365 usage analytics uses to generate its data are from the various, generally available, Graph APIs. The function of the Microsoft 365 usage analytics API by itself isn't generally available.

This API provides information about the monthly trend of usage of the various Microsoft 365 services. For the exact data returned by the API refer to the table in the following section.

Data tables returned by the Microsoft 365 Reporting API

Table name Information in the table Date range
Tenant Product Usage
Contains monthly totals of enabled, active users, month-over-month retained users, first-time users, and the cumulative active users.
Contains monthly aggregated data for a rolling 12-month period including the current partial month.
Tenant Product Activity
Contains monthly totals of activities and active user count for various activities within the products.
See active user definition for information about the activities within a product that are returned in this data table.
Contains monthly aggregated data for a rolling 12-month period including the current partial month.
Tenant Office Licenses
Contains data about number of Microsoft Office subscriptions assigned to users
Contains end-of-month state data for a rolling 12-month period including the current partial month.
Tenant Mailbox Usage
Contains data about the user's mailbox, for total mailbox count and how storage is used.
Contains end-of-month state data for a rolling 12-month period including the current partial month.
Tenant Client Usage
Contains data about the number of users actively using specific client/devices to connect to Exchange Online, Skype for Business and Viva Engage.
Contains monthly aggregated data for a rolling 12-month period including the current partial month.
Tenant SharePoint Online Usage
Contains data about the SharePoint sites, covering Team or Groups sites such as total number of sites, number of documents on site, file count by activity type and storage used.
Contains end-of-month state data for a rolling 12-month period including the current partial month.
Tenant OneDrive for Business Usage
Contains data about the OneDrive accounts such as number of accounts, number of documents across OneDrives, storage used, file count by activity type.
Contains end-of-month state data for a rolling 12-month period including the current partial month.
Tenant Microsoft 365 Groups Usage
Contains data about Microsoft 365 Groups usage including Mailbox, SharePoint, and Viva Engage.
Contains end-of-month state data for a rolling 12-month period including the current partial month.
Tenant Office Activation
Contains data about number of Office subscription activations, count of activation per device (Android/iOS/Mac/PC), activations by service plan, for example, Microsoft 365 Apps for enterprise, Visio, Project.
Contains end-of-month state data for a rolling 12-month period including the current partial month.
User State
Contains metadata about users, including user display name, products assigned, location, department, title, company. This data is about users who were assigned a license during the last complete month. Every user is uniquely represented by a user ID.
This data is about users that had a license assigned during the last complete month.
User Activity
Contains per-user level information about activity performed by licensed users.
See active user definition for information about the activities within a product that are returned in this data table.
This data is about users that performed an activity in any of the services during the last complete month.

Expand the following sections to see the detailed information for each data table.

Data table - User State

This table provides user level details for all users that have a license assigned to them during the last complete month. It brings in data from the Microsoft Entra ID.

Column name Column description
UserId
Unique user ID that represents a user and enables joining with other data tables within the data set.
Timeframe
Month value for which this table has data for.
UPN
User principal name, uniquely identifies the user to be able to join with other external data sources.
DisplayName
User's display name.
IDType
ID type is set to 1 if the user is a Viva Engage user who connects by using their Viva Engage ID or 0 if they connect to Viva Engage by using their Microsoft 365 ID.
Value is 1 to represent that this user connects to Viva Engage with their Viva Engage ID and not their Microsoft 365 ID
HasLicenseEXO
Set to true if user is assigned a license and enabled to use Exchange on the last day of the month.
HasLicenseODB
Set to true if user is assigned a license and enabled to use OneDrive for Business on the last day of the month.
HasLicenseSPO
Set to true if user is assigned a license and enabled to use SharePoint Online on the last day of the month.
HasLicenseYAM
Set to true if user is assigned a license and enabled to use Viva Engage on the last day of the month.
HasLicenseSFB
Set to true if user is assigned a license and enabled to use Skype For Business on the last day of the month.
HasLicenseTeams
Set to true if user is assigned a license and enable to use Microsoft Teams on the last day of the month.
Company
Company data represented in Microsoft Entra ID for this user.
Department
Department data represented in Microsoft Entra ID for this user.
LocationCity
City data represented in Microsoft Entra ID for this user.
LocationCountry
Country/region data represented in Microsoft Entra ID for this user.
LocationState
State data represented in Microsoft Entra ID for this user.
LocationOffice
User's office.
Title
Title data represented in Microsoft Entra ID for this user.
Deleted
True if the user has been deleted from Microsoft 365 in that last complete month.
DeletedDate
Date when the user was deleted from Microsoft 365.
YAM_State
States of the user in the Viva Engage system, can be active, deleted, or suspended.
YAM_ActivationDate
Date the user entered the state of being active in Viva Engage.
YAM_DeletionDate
Date the user entered the state of being deleted in Viva Engage.
YAM_SuspensionDate
Date the user entered the state of being suspended in Viva Engage.

Data table - User Activity

This table contains data about each user who had an activity in any of the services in the previous month.

Column name Column description
UserID
Unique user ID that represents a user and enables joining with other data tables within the data set.
IDType
ID type is set to 1 if the user is a Viva Engage user who connects by using their Viva Engage ID or 0 if they connect to Viva Engage by using their Microsoft 365 ID.
Value is 1 to represent that this user connects to Viva Engage with their Viva Engage ID and not their Microsoft 365 ID
Timeframe
Month value for which this table represents data for.
EXO_EmailSent
Number of emails sent.
EXO_EmailReceived
Number of emails received.
EXO_EmailRead
Number of emails read activity the user performed, it could be multiple times reading an already read email, or an email received previously.
EXO_AppointmentCreated
Number of appointments created.
EXO_MeetingAccepted
Number of meetings accepted.
EXO_MeetingCancelled
Number of meetings canceled.
EXO_MeetingDeclined
Number of meetings declined.
EXO_MeetingSent
Number of meetings sent.
ODB_FileViewedModified
Number of files this user interacted with on any OneDrive for Business (for example, created, updated, deleted, viewed, or downloaded).
ODB_FileSynched
Number of files this user synchronized on any OneDrive for Business.
ODB_FileSharedInternally
Number of files this user shared internally from any OneDrive for Business, or with users within groups (that might include external users).
ODB_FileSharedExternally
Number of files this user shared externally from any OneDrive for Business.
ODB_AccessedByOwner
Number of sites the user interacted with that reside on their own OneDrive for Business.
ODB_AccessedByOthers
Number of sites this user interacted with which reside on another user's OneDrive for Business.
SPO_GroupFileViewedModified
Number of files this user interacted with on any group site.
SPO_GroupFileSynched
Number of files this user synchronized on any group site.
SPO_GroupFileSharedInternally
The count of files that have been shared with users within the organization, or with users within groups (that might include external users).
SPO_GroupFileSharedExternally
Number of files this user shared externally from any group site.
SPO_GroupAccessedByOwner
Number of sites the user interacted with that reside on a group site that they own.
SPO_GroupAccessedByOthers
Number of sites the user interacted with that reside on a group site that another user owns.
SPO_OtherFileViewedModified
Number of files with which this user interacted on any other site.
SPO_OtherFileSynched
Number of files this user synchronized from any other site.
SPO_OtherFileSharedInternally
Number of files this user shared internally from any other site, or with users within groups (that might include external users).
SPO_OtherFileSharedExternally
Number of files this user shared externally from any other site.
SPO_OtherAccessedByOwner
Number of sites the user interacted with that reside on other site that they own.
SPO_OtherAccessedByOthers
Number of sites the user interacted with that reside on other site that another user owns.
SPO_TeamFileViewedModified
Number of files with which this user interacted on any team site.
SPO_TeamFileSynched
Number of files this user synchronized from any team site.
SPO_TeamFileSharedInternally
Number of files this user shared internally from any team site, or with users within groups (that might include external users).
SPO_TeamFileSharedExternally
Number of files this user shared externally from any team site.
SPO_TeamAccessedByOwner
Number of sites the user interacted with that reside on a team site that they own.
SPO_TeamAccessedByOthers
Number of sites the user interacted with that reside on a team site that another user owns.
Teams_ChatMessages
Number of chat messages sent.
Teams_ChannelMessage
Number of messages posted to channels.
Teams_CallParticipate
Number of calls the user participated in.
Teams_MeetingParticipate
Number of meetings the user joined.
Teams_HasOtherAction
Boolean value if the user performed other actions in Microsoft Teams.
YAM_MessagePost
Number of Viva Engage messages this user posted.
YAM_MessageLiked
Number of Viva Engage messages this user liked.
YAM_MessageRead
Number of Viva Engage messages this user read.
SFB_P2PSummary
Number of peer-to-peer sessions this user took part in.
SFB_ConfOrgSummary
Number of conference sessions this user organized.
SFB_ConfPartSummary
Number of conference sessions this user participated in.

Note

Teams_HasOtherAction means user is considered active but has a zero value for the Chat Messages, 1:1 calls, Channel Messages, Total Meetings, and Meetings organized.

Data table - Tenant Product Usage

This table provides month-over-month adoption data in terms of enable, active, returning, and first-time users for each product within Microsoft 365. The Microsoft 365 values represent active usage in either of the products.

Column name Column description
Product
Name of products for which the usage information is summarized. Microsoft 365 value in the product column represents activity across any of the products
Timeframe
Month value. There will be one row per product per month for the last 12 months including the current partial month.
EnabledUsers
Number of users enabled to use the product for the time-frame value, if a user was enabled for portion of the month, they are still counted.
ActiveUsers
Number of users who performed an intentional activity in the product for the time-frame value.
A user is counted as active for a product in a particular month, if they have performed one of the key activities in the product. The key activities are available in the Tenant Product Activity table.
CumulativeActiveUsers
Number of users who are enabled to use a product and have used the product up to the timeframe month at least once since data collection started in the new usage system.
MoMReturningUsers
Number of users who are active in the timeframe month and also were active in the previous month.
FirstTimeUsers
Number of users who became active in the timeframe for the first time since data collection in the new usage system.
A user is counted as a first-time user in a particular month, if we detect their activity for the first time since the beginning of data collection in this new reporting system. Once counted as a first-time user, even if this user has a large gap in their activity they'll never be counted again as a first-time user
Content Date
If timeframe shows current month, this value will represent the latest date of the current month for which data is available.
If Timeframe shows previous month, this value will represent the last date of the timeframe month.

Data table - Tenant Product Activity

This table provides monthly totals of activity and active user count for various activities within the products.

Column name Column description
Timeframe
Month value. There will be one row per product per month for the last 12 months including the current partial month.
Product
Name of the product within Microsoft 365 for which usage data is available.
Activity
Name of the activity in a product that is used to showcase active use of product.
ActivityCount
This is the total number of actions counted for each activity performed within the product across all active users.
Note: For SharePoint Online and OneDrive for Business activities, this value represents the number of distinct documents with which users interacted with.
ActiveUserCount
Number of users who performed the activity within the product.
TotalDurationInMinute
Amount of duration in minutes across all active users who used audio or video session in an applicable Skype for Business activity.
Content Date
If timeframe shows current month, this value will represent the latest date of the current month for which data is available.
If Timeframe shows previous month, this value will represent the last date of the timeframe month.

Data table - Tenant Mailbox Usage

This table consists of summary data across all licensed Exchange Online users who have a user mailbox. It contains end of month state across all user mailboxes. The data in this table isn't additive across multiple months. Latest month's data in this table represents the most recent state.

Column name Column description
TotalMailboxes
Number of user mailboxes for Microsoft 365 subscription.
IssueWarningQuota
Total quota for issuing warning across all users' mailboxes.
ProhibitSendQuota
Total quota for prohibit send across all user mailboxes.
ProhibitSendReceiveQuota
Total quota for prohibit send receive quota across all user mailboxes.
TotalItemBytes
Amount of storage used across all user mailboxes in bytes.
MailboxesNoWarning
Number of user mailboxes that were under the storage warning limit.
MailboxesIssueWarning
Number of user mailboxes that were issued a warning for storage quota.
MailboxesExceedSendQuota
Number of user mailboxes that have exceeded the send quota.
MailboxesExceedSendReceiveQuota
Number of user mailboxes that have exceeded the send/receive quota.
DeletedMailboxes
Number of users mailboxes deleted in the timeframe.
Timeframe
Month value.
Content Date
If timeframe shows current month, this value will represent the latest date of the current month for which data is available.
If Timeframe shows previous month, this value will represent the last date of the timeframe month.

Data table - Tenant Client Usage

This table provides month-over-month summary data about the clients that the users are using to connect to Exchange Online, Skype for Business and Viva Engage. This table doesn't yet have client use data for SharePoint Online and OneDrive for Business.

Column name Column description
Product
Name of the product within Microsoft 365 for which client usage data is available.
ClientId
Name of each device used to connect to product.
UserCount
Number of users that used each of the clients for each product.
Timeframe
Month value
Content Date
If timeframe shows current month, this value will represent the latest date of the current month for which data is available.
If Timeframe shows previous month, this value will represent the last date of the timeframe month.

Data table - Tenant SharePoint Online Usage

This table consists of month over month summary data about the usage or activity of SharePoint Online sites. This only covers Team Sites and Group sites. The end of month state of SharePoint Online sites is represented in this column, for example, if a user created a five documents and used 10 MB for total storage, and then deleted some files, and added more files so that at the end of month state for files is seven total that use five MB of storage, the value of represented in this table is end of month state. This table is hidden to avoid duplicate count of aggregations and is used as a source to create two reference tables.

Column name Column description
SiteType
Site type value (any/team/group) (any represents either of these 2 sites types).
TotalSites
Number of sites that existed at the end of the timeframe.
DocumentCount
Total number of documents that existed on the site at the end of the timeframe.
Diplansed
Total storage used summed across all sites at the end of the timeframe.
ActivityType
Number of sites that recorded the various types of file activity (any/active files/ files shared EXT/INT/files synched).
Represents any of the file activity that was performed.
SitesWithOwnerActivities
Number of active sites, where the site owner performed a particular file activity on their own sites. You can get the site owner from the PowerShell command get-sposite. This is the person who is responsible for the site.
SitesWithNonOwnerActivities
Number of active sites summed up for the month, where the users other than the site owner performed a particular file activity on sites. You can get the site owner from the PowerShell command get-sposite. This is the person who is responsible for the site.
ActivityTotalSites
Number of sites that recorded any activity during the timeframe. If a site that had activity earlier in the timeframe, and was deleted by the end of the timeframe, it would still be counted in the active site total for that timeframe.
Timeframe
This column has the date value. Used as Many to one relationship for Calendar table.
Content Date
If timeframe shows current month, this value will represent the latest date of the current month for which data is available.
If Timeframe shows previous month, this value will represent the last date of the timeframe month.

Data table - Tenant OneDrive Usage

This table provides data about the OneDrive accounts such as number of accounts, number of documents across OneDrive accounts, storage used, file count by activity type. The end of month state of OneDrive for Business accounts is represented in this table. For example, if a user created a Five documents that used 10 MB of storage, and then deleted a few and added more files so that at the end of month they have seven files that use Five MB of storage, then the end of the month value is represented in this table at the end of the month.

Column name Column description
SiteType
Value is "OneDrive".
TotalSites
Number of OneDrive for Business accounts that existed at the end of the timeframe.
DocumentCount
Total number of documents that existed across all OneDrive for Business accounts at the end of the timeframe
Diplansed
Total storage used summed across all OneDrive account at the end of the timeframe.
ActivityType
Number of accounts that recorded the various types of file activity (any/active files/ files shared EXT/INT/files synched).
Any represents any of the file activity was performed
SitesWithOwnerActivities
Number of active OneDrive for Business accounts, where the account owner performed a particular file activity on their own account.
SitesWithNonOwnerActivities
Count of OneDrive for Business accounts where file activity was performed by users other than the owner of the account.
ActivityTotalSites
Number of OneDrive for Business accounts that recorded any activity during the timeframe. If a OneDrive for Business account had activity earlier in the timeframe, and was deleted by the end of the timeframe, it would still be counted in the active OneDrive for Business account for that timeframe.
Timeframe
This column has the date value. Used as Many to one relationship for Calendar table.
Content Date
If timeframe shows current month, this value will represent the latest date of the current month for which data is available.
If Timeframe shows previous month, this value will represent the last date of the timeframe month.

Data table - Tenant Microsoft 365 Groups Usage

This table provides data about how Microsoft 365 Groups is used across the organization.


Column name Column Description
TimeFrame
Month value. There will be one row per product per month for the last 12 months including the current partial month.
GroupType
Type of group (private/public/any).
TotalGroups
Number of groups in each group type.
ActiveGroups
Number of active groups.
MBX_TotalGroups
Number of mailbox groups.
MBX_ActiveGroups
Number of active mailbox groups.
MBX_TotalActivities
Number of mailbox activities.
MBX_TotalItems
Number of mailbox items.
MBX_StorageUsed
Quantity of mailbox storage used.
SPO_TotalGroups
Number of SharePoint groups.
SPO_ActiveGroups
Number of active SharePoint groups.
SPO_FileAccessedActiveGroups
Number of SharePoint groups that have file accessed activities.
SPO_FileSyncedActiveGroups
Number of SharePoint groups that have file synchronized activities.
SPO_FileSharedInternallyActiveGroups
Number of SharePoint groups that have shared activities internally, or with groups (that might include external users).
SPO_FileSharedExternallyActiveGroups
Number of SharePoint groups which have shared externally activities.
SPO_TotalActivities
Number of SharePoint activities.
SPO_FileAccessedActivities
Number of SharePoint file accessed activities.
SPO_FileSyncedActivities
Number of SharePoint file synchronized activities.
SPO_FileSharedInternallyActivities
Number of SharePoint file shared activities internally, or with groups (that might include external members).
SPO_FileSharedExternallyActivities
Number of SharePoint file shared externally activities.
SPO_TotalFiles
Number of SharePoint files.
SPO_ActiveFiles
Number of active SharePoint files.
SPO_StorageUsed
Quantity of SharePoint storage used.
YAM_TotalGroups
Number of Viva Engage groups.
YAM_ActiveGroups
Number of active Viva Engage groups.
YAM_LikedActiveGroups
Number of Viva Engage groups which have like activities.
YAM_PostedActiveGroups
Number of Viva Engage groups which have post activities.
YAM_ReadActiveGroups
Number of Viva Engage groups which have read activities.
YAM_TotalActivities
Number of Viva Engage activities.
YAM_LikedActivities
Number of Viva Engage like activities.
YAM_PostedActivties
Number of Viva Engage post activities.
YAM_ReadActivites
Number of Viva Engage read activities.

Data table - Tenant Office Licenses

This table provides month-over-month summary data about the license assignment for users.

Column name Column description
LicenseName
Name of the license.
AssignedCount
Number of assigned licenses.
Timeframe
Month value.

Data table - Tenant Office Activation

The table provides data about the number of Office subscription activations across the service plans, for example, Microsoft 365 Apps for enterprises, Visio, Project. It also provides data about number of activations per device (Android/iOS/Mac/PC).

Column name Column description
ServicePlanName
List of the service plan name values and counts of activations by devices, as depicted by below columns.
TotalEnabled
Number of users enabled per service plan name by the end of the timeframe.
TotalActivatedUsers
Number of users that have activated each service plan t by the end of the timeframe.
AndroidCount
Number of activations per service plan for Android device by the end of the timeframe.
iOSCount
Number of activations per service plan for iOS device by the end of the timeframe.
MacCount
Number of activations per service plan for MAC device by the end of the timeframe.
PcCount
Number of activations per service plan for PC device by the end of the timeframe.
WinRtCount
Number of activations per service plan for Windows Mobile device by the end of the timeframe.
Timeframe
This column has the date value. Used as Many to one relationship for Calendar table.
Content Date
If timeframe shows current month, this value will represent the latest date of the current month for which data is available.
If Timeframe shows previous month, this value will represent the last date of the timeframe month.