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.

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.

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.

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.

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.

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.

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.

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.

DiskUsed

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.

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.

DiskUsed

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.

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.

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.

Related Topics

Microsoft 365 usage analytics

Enable Microsoft 365 usage analytics

Navigating and utilizing the reports in Microsoft 365 usage analytics

Customizing the reports in Microsoft 365 usage analytics

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×