Microsoft 365 Reports in the admin center - Microsoft Teams user activity
The Microsoft 365 Reports dashboard shows you the activity overview across the products in your organization. It enables you to drill in to individual product level reports to give you more granular insight about the activities within each product. Check out the Reports overview topic. In the Microsoft Teams user activity report, you can gain insights into the Microsoft Teams activity in your organization.
How to get to the Microsoft Teams user activity report
In the admin center, go to the Reports, then select Usage.
From the dashboard homepage, click on the View more button on the Microsoft Teams activity card.
Interpret the Microsoft Teams user activity report
You can view the user activity in the Teams report by choosing the User activity tab.
Select Choose columns to add or remove columns from the report.
You can also export the report data into an Excel .csv file by selecting the Export link. This exports data of all users and enables you to do simple sorting and filtering for further analysis. The exported format for audio time, video time, and screen share time follows ISO8601 duration format.
The Microsoft Teams user activity report can be viewed for trends over the last 7 days, 30 days, 90 days, or 180 days. However, if you select a particular day in the report, the table will show data for up to 28 days from the current date (not the date the report was generated).
To ensure data quality, we perform daily data validation checks for the past three days and will be filling any gaps detected. You may notice differences in historical data during the process.
| Metric | Mapped metric in Export | Definition |
|---|---|---|
| User name |
User Principal Name | The email address of the user. You can display the actual email address or make this field anonymous. |
| Tenant name |
Tenant Display Name | The name of an internal or external tenant where a user belongs. If a user belongs to an external tenant, corresponding data metrics (for example, post messages, reply messages, etc.) are calculated based on their interactions in shared channels of the admin’s tenant. Interactions done by the user in their own tenant (outside of shared channels of the given tenant) are not considered for the admin usage report of given tenant. |
| Is external |
Is External | Indicates if the user is an external user or not. |
| Shared channel tenant names |
Shared Channel Tenant Display Names | The names of internal or external tenants of shared channels where the user participated. |
| Channel messages |
Team Chat Message Count | The number of unique messages that the user posted in a team chat during the specified time period. This includes original posts and replies. |
| Posts |
Post Messages | The number of post messages in all channels during the specified time period. A post is the original message in a teams chat. |
| Replies |
Reply Messages | The number of replied messages in all channels during the specified time period. |
| Urgent messages |
Urgent Messages | The number of urgent messages during the specified time period. |
| Chat messages |
Private Chat Message Count | The number of unique messages that the user posted in a private chat during the specified time period. |
| Total meetings |
Meeting Count | Refer to the 'Total participated meetings' metric as defined below, as the current metric and ‘Total participated meetings’ share the same definition. We intend to gradually phase out the current metric with 'Total participated meetings.' |
| 1:1 calls |
Call Count | The number of 1:1 calls that the user participated in during the specified time period. |
| Last activity date (UTC) |
Last Activity Date | The last date that the user participated in a Microsoft Teams activity. |
| Meetings participated ad hoc |
Ad Hoc Meetings Attended Count | The number of ad hoc meetings a user participated in during the specified time period. |
| Meetings organized ad hoc |
Ad Hoc Meetings Organized Count | The number of ad hoc meetings a user organized during the specified time period. |
| Total organized meetings |
Meetings Organized Count | The sum of one-time scheduled, Recurring, ad hoc and unclassified meetings a user organized during the specified time period. |
| Total participated meetings |
Meetings Attended Count | The sum of the one-time scheduled, recurring, ad hoc and unclassified meetings a user participated in during the specified time period. |
| Meetings organized scheduled one-time |
Scheduled One-time Meetings Organized Count | The number of one-time scheduled meetings a user organized during the specified time period. |
| Meetings organized scheduled recurring |
Scheduled Recurring Meetings Organized Count | The number of recurring meetings a user organized during the specified time period. |
| Meetings participated scheduled one-time |
Scheduled One-time Meetings Attended Count | The number of the one-time scheduled meetings a user participated in during the specified time period. |
| Meetings participated scheduled recurring |
Scheduled Recurring Meetings Attended Count | The number of the recurring meetings a user participated in during the specified time period. |
| Is licensed |
Is Licensed | Selected if the user is licensed to use Teams. |
| Other activity |
Has Other Action | The User is active but has performed other activities than exposed action types offered in the report (sending or replying to channel messages and chat messages, scheduling or participating in 1:1 calls and meetings). Examples actions are when a user changes the Teams status or the Teams status message or opens a Channel Message post but does not reply. |
| Audio Duration | - | The sum of the audio duration of a user used during the specified time period and formatted by ISO 8601 - Wikipedia |
| Video Duration | - | The sum of the video duration of a user used during the specified time period and formatted by ISO 8601 - Wikipedia |
| Screen Share Duration | - | The sum of the screen share duration of a user used during the specified time period and formatted by ISO 8601 - Wikipedia |
| Audio Duration In Seconds | Audio Time (Min) | The sum of the audio duration of a user used during the specified time period |
| Video Duration In Seconds | Video Time (Min) | The sum of the video duration of a user used during the specified time period |
| Screen Share Duration In Seconds | Screen Share Time (Min) | The sum of the screen share duration of a user used during the specified time period |
Note
Metric counts include Teams client built-in features, but don't include changes to chat and channel through service integration, such as Teams app posts or replies and emails in the channel.
Make the user-specific data anonymous
To make the data in Teams user activity report anonymous, you have to be a global administrator. This will hide identifiable information (using MD5 hashes) such as display name, email, and Microsoft Entra Object ID in report and their export.
In Microsoft 365 admin center, go to the Settings > Org Settings, and under Services tab, choose Reports.
Select Reports, and then choose to Display anonymous identifiers. This setting gets applied both to the usage reports in Microsoft 365 admin center and Teams admin center.
Select Save changes.