Email reports

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Develop your talent with more than 10,000 online courses from LinkedIn Learning

Now in the previous lesson we looked at some general reports on Office 365 usage. In this one, we will look at some specific reports about Office 365 usage, specifically here we're dealing with mail reports. So we look at, first, the Reports dashboard, which you now know how to get to very easily, and then in this drop-down, Select a report, we're looking under Exchange for our Email reports, so we have three to choose from here.

Email activity, Email app usage, and Mailbox usage. So I'll go ahead and click on Email activity if you want to get a quick gauge of how much email is being sent and received throughout your enterprise, you can give the Email activity report a quick look. You'll see here as this thing loads here, that once again you have this timeframe of seven days, 30, 90, and 180 days, and then you've got two choices here, Activity or users, so you've got two charts that are going to populate depending on which of these two tabs that you click on, so the Activity chart lets you understand the trend, the overall amount of email activity going on in your Office 365 tenant.

So here's a chart that you might review to look at email send or received activities. The Users chart will let you understand the trend of the amount of unique users who are generating email, so you can look at the trend of users performing send, receive email activities here. Once more in the bottom section of the report, you have this Details table here where you can click on this button to add additional columns, but you see the defaults here, User name, Last activity, Send actions, and so on, and if I scroll over you can see the others that are in the default table here.

Then you can export this table. In terms of the information that you will be able to get from here if you click on columns, you can add additional columns. So of course, User name is the email address of the user. The Display name is the full name of the user, so that is one that I typically add there, because sometimes it's difficult to know which user, because you sometimes have initials, so you want to know exactly the display name to help you pinpoint the user.

If you choose to add the column of Deleted, Deleted refers to the user whose current state is Deleted, but was active at some point of the reporting period that you've chosen when you generate this report. The Deleted date is the date the user was deleted. The Last activity date is the last time the user performed a read, send, or receive email activity. Email sent is the last date the user performed email send activity.

Email received of course is the last time that they received an email. Email read, the last date that a user read an email. Finally, Product assigned is the Office 365 products that have been assigned to this user, so that's another one that can help you get quick information about the user in your organization, and what kinds of products that they've been assigned, so that's always a good one to add. So that's a quick look at the email activity report, and the place that you can generate it of course once again is under the Exchange heading here, and it's this first one in the chart.

LinkedIn Learning

LinkedIn Learning is an online learning platform that combines industry-leading content from with LinkedIn’s professional network of more than 500 million member profiles to provide highly personalized course recommendations and a more intuitive learning experience. Learn more.


  • Learn from recognized industry experts, and get the business, tech, and creative skills that are most in demand.

  • Receive personal recommendations based on your LinkedIn profile.

  • Stream courses from your computer or mobile device.

  • Take courses for every level – beginner to advanced.

  • Practice while you learn with quizzes, exercise files, and coding windows.

  • Provide learning for your team or entire organization, with an easy to use experience for managing users, curating content and measuring engagement

For businesses with 150+ licenses Request Office 365 onboarding assistance from FastTrack

You can request remote and personalized assistance with onboarding. Our FastTrack engineers will help you plan your Office 365 project, assess your technical environment, provide remediation guidance, and provide user adoption assistance. For businesses with at least 500 licenses, Microsoft also provides personalized assistance to migrate data to Office 365.

See the FastTrack Center Video:

Get started today:

Tip: Businesses with 1-149 licenses still have access to FastTrack guidance via links in the Admin Center and also available at

If you're preparing for exam 70-346, Managing Office 365 Identities and Requirements, or you just want to improve your Office 365 administration skills, then this course is for you. Instructor Brian Culp looks at three objectives in the Monitor and Troubleshoot Office 365 Availability and Usage section of the exam—analyzing reports, monitoring service health, and isolating service interruptions. By the end of this course, you'll be better prepared to tackle this section of the exam, and will have a better understanding of the troubleshooting and reporting tools available to Office 365 admins.

Topics include:

  • Navigating the Office 365 reports dashboard

  • Generating and interpreting usage, email, and auditing reports

  • Generating and interpreting mail protection and mail hygiene reports

  • Showing and hiding user-level detail information in reports

  • Understanding the service health dashboard

  • Monitoring Office 365 Health

  • Retrieving data with the Management Pack

  • Using PowerShell for Office 365

  • Creating a service request

  • Using the Remote Connectivity Analyzer, the Connectivity Analyzer tool, and the free/busy troubleshooter

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.