Microsoft 365 usage analytics data model

Data for the Microsoft 365 usage analytics tables

Microsoft 365 usage analytics connects to an API which exposes a multidimensional data model. The APIs are in preview and can be accessed at https://reports.office.com/pbi/v1.0/\<tenantid\> (replace the <tenant id> with your tenant GUID).

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

Data tables returned by the Office 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 activity and active user count for various activity 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, in terms of 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 Yammer.
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 Office 365 Groups Usage
Contains data about Office 365 Groups usage including Mailbox, SharePoint, and Yammer.
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, Office Proplus, 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 licenses 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 an license assigned to them during the last complete month. It brings in data from the Azure Active Directory.

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 Yammer user who connects by using their Yammer ID or 0 if they connect to Yammer by using their Office 365 ID.
Value is 1 to represent that this users connects to Yammer with their Yammer id and not their Office 365 id
HasLicenseEXO
Set to true if user is assigned a license and enabled to use Exchange.
HasLicenseODB
Set to true if user is assigned a license and enabled to use OneDrive for Business.
HasLicenseSPO
Set to true if user is assigned a license and enabled to use SharePoint Online.
HasLicenseYAM
Set to true if user is assigned a license and enabled to use Yammer.
HasLicenseSFB
Set to true if user is assigned a license and enabled to use Skype For Business.
HasLicenseTeams
Set to true if user is assigned a license and enable to use Microsoft Teams.
Company
Company data represented in Azure Active Directory for this user.
Department
Department data represented in Azure Active Directory for this user.
LocationCity
City data represented in Azure Active Directory for this user.
LocationCountry
Country data represented in Azure Active Directory for this user.
LocationState
State data represented in Azure Active Directory for this user.
LocationOffice
User's office.
Title
Title data represented in Azure Active Directory for this user.
Deleted
True if the user has been deleted from Office 365 in that last complete month.
DeletedDate
Date when the user was deleted from Office 365.
YAM_State
States of the user in the Yammer system, can be active, deleted or suspended.
YAM_ActivationDate
Date the user entered the state of being active in Yammer.
YAM_DeletionDate
Date the user entered the state of being deleted in Yammer.
YAM_SuspensionDate
Date the user entered the state of being suspended in Yammer.

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 Yammer user who connects by using their Yammer ID or 0 if they connect to Yammer by using their Office 365 ID.
Value is 1 to represent that this users connects to Yammer with their Yammer id and not their Office 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 email read activity the user performed, it could be multiple times reading the 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 cancelled.
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.
ODB_FileSharedExternally
Number of files this user shared externally from any OneDrive for Business.
ODB_AccessByOwner
Number of files the user interacted with that reside on their own OneDrive for Business.
ODB_AccessOthers
Number of files this user interacted with which reside on another user's OneDrive for Business.
SPO_GroupFileViewedModified
Number of files with this user interacted on any group site.
SPO_GroupFileSynched
Number of files this user synchronized on any group site.
SPO_GroupFileSharedInternally
Number of files this user shared internally from any group site.
SPO_GroupFileSharedExternally
Number of files this user shared externally from any group site.
SPO_GroupAccessByOwner
Number of files the user interacted with that reside on a group site that they own.
SPO_GroupAccessByOthers
Number of files 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.
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.
SPO_TeamFileSharedExternally
Number of files this user shared externally from any team site.
SPO_TeamAccessByOwner
Number of files the user interacted with that reside on a team site that they own.
SPO_TeamAccessByOthers
Number of files 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 Yammer message this user posted.
YAM_MessageLiked
Number of Yammer message this user liked.
YAM_MessageRead
Number of Yammer message 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.

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 Office 365. The Office 365 value represent active usage in either of the products.

Column name Column description
Product
Name of products for which the usage information is summarized. Office 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 timeframe 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 timeframe 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 big gap in their activity they will neve 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 activity 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 Office 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 mailboxes. It contains end of month state across all user mailboxes. The data in this table is not 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 Office 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 Yammer. This table does not yet have client use data for SharePoint Online and OneDrive for Business.

Column name Column description
Product
Name of the product within Office 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 5 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 7 total that use 5MB 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.
DiskQuota
Total allocated storage quota summed across all sites 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).
Any represents any of the file activity was performed.
SitesWithOwnerActivities
Number of active sites, where the site owner performed a particular file activity on their own sites.
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.
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 5 documents that used 10 MB of storage, and then deleted a few and added more files so that at the end of month he has 7 files that use 5 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
DiskQuota
Total allocated storage quota summed 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 Office 365 Groups Usage

This table provides data about how Office 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 which have file accessed activities.
SPO_FileSyncedActiveGroups
Number of SharePoint groups which have file synchronized activities.
SPO_FileSharedInternallyActiveGroups
Number of SharePoint groups which have shared internally activities.
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 internally activities.
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 Yammer groups.
YAM_ActiveGroups
Number of active Yammer groups.
YAM_LikedActiveGroups
Number of Yammer groups which have like activities.
YAM_PostedActiveGroups
Number of Yammer groups which have post activities.
YAM_ReadActiveGroups
Number of Yammer groups which have read activities.
YAM_TotalActivities
Number of Yammer activities.
YAM_LikedActivities
Number of Yammer like activities.
YAM_PostedActivties
Number of Yammer post activities.
YAM_ReadActivites
Number of Yammer read activities.

Data table - Tenant Office Activation

The table provides data about the number of Office subscription activations across the service plans, for example, Office Proplus, 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.