SharePoint Web Parts
& Office 365 Apps
by VirtoSoftware

How To Approach Microsoft Teams Reporting


The introduction of Microsoft Teams to a wide audience has become a real breakthrough in terms of collaboration opportunities. Unfortunately, it’s not uncommon for the potential of MS Teams to be suppressed by age-old problems, such as lack of knowledge, inactive Teams groups acting as a dead weight, and so on.

Even though Microsoft Teams is a rather flexible platform, it can still become rather problematic to manage all of the different groups at once, especially when some of them are no longer active in the first place. There’s also the fact that some of the groups might just be temporary in the first place, and they’ll stay unused after their purpose is served.

Microsoft Teams reporting feature

The obvious way out of this problem would be to clean up inactive groups on a regular basis – and, luckily enough, Microsoft Teams does have the toolset to help you with that – it’s their Teams usage report. It can be used to get a quick recap of how many people are using specific features of MS Teams, the number of active users, channels and messages in general, and similar numbers for each separate team.

microsoft teams admin center

It is worth noting that generating reports for Microsoft Teams requires for users to have a specific status or role: either reports reader, global admin, or a product-specific admin. These are the only roles that have access to a Teams Admin Panel, and thus are capable of generating these reports – even the channel owner role does not have such permissions.

Teams usage reports can be generated using the Usage reports tab, located under the Analytics & reports section of your MS Teams admin center. After that, you’ll see the Analytics & reports page with two tabs available – View reports and Downloads. The purpose of both of those tabs should be relatively obvious.

To generate a new Teams usage report, you’ll have to select it under the Report section of the page. 

microsoft teams admin center reports

There are also several other options available for this feature, such as: 

  • Teams device usage – a report on which devices Teams users are using to connect to Teams; capable of grouping information into different device types and listing each user’s activity history when it comes to accessing Teams with different devices.
  • Teams user activity – presenting information on different types of activities that your Teams users are performing, including unscheduled meetings, scheduled meetings, participation rates, chat communication statistics, and more.
  • Teams live event usage – activity overview in regards to various live events performed in your organization, including event status, view count, event start time, production type, and many other parameters.
  • Apps usage – as the name suggests, this report is focused strictly on which applications are used by your Teams users, how much they are used, who is the creator of said app, multiple filtering options, and other information
  • PSTN blocked users – a list of MS Teams users who are blocked from making PSTN calls, as well as the reason for blocking, the personal phone number of each user, and more.
  • PSTN minute and SMS (preview) pools – an overview of both calling and audio conferencing activity within your company, with parameters such as the number of minutes spent on those activities, license usage by location, the total number of minutes available, and more.
  • PSTN and SMS (preview) usage – a slightly different approach to an overview of audio conferencing and calling activity in your company, includes both Calling Plans if Microsoft is your carrier, and Direct Routing if you’re using another carrier.
  • Information protection license – reserved for specific apps that have subscribed to change notification events to listen to either updated, generated, or deleted messages at the level of a tenant (includes either /chats/getAllMessages, or /teams/getAllMessage), only happens when the user in question has the license to perform such actions.

an example of a report on user activity within Teams

In this case, we’re looking at the Teams usage report, and you can also choose the timespan for this report – be it 7, 30, or 90 days. To generate this report, click the Run report button.

This generates a variation of Microsoft Teams reporting dashboard, with both the diagram in the middle and a list of Teams groups below it. It can also be customized to your liking in several different ways. For example, after the initial generation you’ll be able to see:

  • Post messages
  • Active channels
  • Mentions
  • Total active users
  • Reply messages
  • Channel messages

All of those are presented in a single diagram as a centerpiece of your report. However, you have the ability to filter out some of these parameters by clicking on them under the diagram, in the so-called legend section. Additionally, there’s an entire list of your Teams groups under said diagram, offering you a detailed breakdown of how many channels, guests, and messages each of those groups has.

There are also more categories that you can add to this list, such as mentions, reactions, meetings organized, and more. You can enable or disable each and every one of them by clicking the gear icon in the upper-right part of the page. Below we’ve presented a screenshot with an abundance of columns available for Teams user activity report – Teams usage report works in a similar fashion. While we’re there, it’s also possible to export your entire report to Excel (clicking the Excel button near the Settings button)

teams user activity columns

While the Teams usage report is rather helpful if you only need the basic information about your organization’s statistics in Teams. However, it may not be enough to draw a definite conclusion about how successful or productive your Teams groups are, or which ones are inactive/obsolete.

Another issue that you might not even notice with the Microsoft Teams reporting dashboard is that it only goes as far back as 90 days, meaning that if a specific group was not active for more than that – this report won’t show you anything about it whatsoever.

As we’ve mentioned before, there are several different types of reports that MS Teams can generate for you, aside from the general usage reports – user activity, device usage, app usage, and more. However, it’s also not the only way to generate reports about your Teams-related activity.

Microsoft 365 reporting feature

Another way to view some of your Teams activity is to use the reporting feature that Microsoft 365 has. It can be found in Microsoft 365 admin center, in the Usage tab under the Reports category. The Usage page allows you to select from a number of possible reports, but you’ll be able to see that there are only two options that are available under Microsoft Teams: user activity report and device usage report.

Let’s choose the user activity report and look at how it’s presented in slightly more detail. In fact, most of the differences between this and Microsoft Teams-based report is in visuals, since both of those services offer you a relatively similar Microsoft Teams reporting dashboard – with a diagram as a centerpiece of the report, and a list of groups/names under it for more details.

Both allow you to filter out parts of a diagram by clicking on them in the so-called legends tab, and most of the columns can be turned on and off, as well. 

The main difference here would be in the type of report chosen – unlike Teams usage report, Teams user activity report is showing a list of activities combined with a number of users that have performed said activity in a specific period of time. By the same logic, Teams device usage is also different since it focuses on types of devices that were used for specific actions in a period of time.

Another notable difference is that Microsoft 365 allows you to switch between different time periods without generating the entire report from scratch – you can always switch between 7, 30, 90, or 180 days of coverage at any time. 

Other means of Microsoft Teams reporting

It would be unfair to say that there are only those two options available when it comes to collecting reports from Microsoft Teams. There are many different options out there, including both the built-in solutions (there’s a separate page with group statistics inside of the Manage team option within MS Teams, as well as cross-team analytics), as well as various third-party solutions.

In fact, there are many cases when third-party analytical tools would be preferable. For example, even though all of the reporting options have a significant delay (reports requested on Nov. 3rd would only include data from Nov. 1st and everything before that day) – Microsoft 365’s usage analytics have a delay of an entire month, or even longer.

Additionally, it’s not uncommon for third-party tools to have more options and details when it comes to Teams reports, in general. The important step here is to choose one method (or one specific third-party software) of reporting that you’re going to be using in the future, since consistency is also incredibly important, and different approaches to report generation could provide different results, adding confusion and misinformation in the mix.

Teams charts and business approach

As a part of the working process, to analyze efficiency, or to get a helicopter view of the project, a common practice is to use charts.

Data analysis on this market can be performed using many different tools and software appliances (link to the 1st post), but the main obstacle to using the analytical tools to their full capacity is the need to manage additional services on top of dozens of those you already use and learn additional interfaces to operate with data.

This necessity goes counter the evolution of tools and services of the modern era. The key to success these days is to integrate services into each other that deep so people would operate in a single window.

This single-window operation philosophy is all-embracing and is essential to the sphere of data analytics. Make it simple and give it to me when and where I need it. As a center of single-window work in the Office 365 platform, Teams becomes an interesting platform to integrate various analytical tools.

But you would also like to know some parts of the analytical information. The majority of the existing analytical tools are built standalone from Office 365. It implies the need for double identification, transfer, storage, and processing of your data on their premises, and in many cases, it’s just a page that standalone service added to the Teams. Data-wise, security-wise, the services are standalone.

Technically, there are several ways to integrate analytics and charts to your teams:

  • you can add a dashboard to the Teams group in a separate tab,
  • add a dashboard to 1:1 teams chat,
  • create a bot to receive data for the person who adds the bot only
  • or run a webhook/bot to send the analytical data to the Teams feed.

If we take Google Analytics, a world-known platform for online statistics, one would imagine that the most useful addition to teams would be to attach a customized dashboard. But instead, Google can only send aggregated updates to the channel feed, something that they can also do by e-mail.

It’s actually not as unreasonable as you might think. When you deal with standalone tools that are integrated into Teams, one of the most challenging pieces is permissions management. Third-party tools cannot easily find out the permissions users have in Office 365 and Teams. There are ways to match accounts but in a software world, any solution that is technologically challenged represents risks, and if you are a big company, accidental access of those who don’t need the data, or lack of access of those who is not acceptable. So, Google cannot risk allowing me to share it’s live charts in a Teams tab. And forcing anyone to sign in to Google account to view the chart attached is not handy at all.

In addition, many third-party tools sell their tools on a per-user base and are not interested in sharing a dashboard through Teams as a proxy, so one person could get a license, and then the whole company can use the insights.

A great response to those challenges is SharePoint-native analytical solutions and charts. Developed by Office365 certified professionals, these solutions keep your data on your side, use your SharePoint or Teams permission management model, and give you the truly integrated single-window work experience.


Leave a Reply

Your email address will not be published. Required fields are marked *