Home

365 Admin Center Custom Reporting - Email

%3CLINGO-SUB%20id%3D%22lingo-sub-390093%22%20slang%3D%22en-US%22%3E365%20Admin%20Center%20Custom%20Reporting%20-%20Email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390093%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20wondering%20if%20anyone%20knows%20of%20the%20capability%20of%20365%20Admin%20Center%20to%20allow%20you%20to%20build%20and%20create%20custom%20reports%20off%20the%20back%20of%20it.%20Now%20as%20it%20stands%20I'm%20not%20the%20current%20admin%20of%20our%20system%20but%20I%20have%20been%20asked%20to%20look%20into%20the%20possibility%20of%20the%20reporting%20capabilities%20on%20the%20email%20out%20of%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20I%20know%20we%20can%20export%20a%20file%20from%20the%20Admin%20Center%20that%20will%20tell%20me%3A%20Display%20Name%2C%20Last%20Activity%20Date%2C%20Send%20Count%2C%20Receive%20Count%2C%20Read%20Count%20and%20the%20Report%20Period.%20From%20this%20I%20gather%20that%20it%20is%20displaying%20say%20the%20last%2030%20days%20totals%20for%20each%20person%20by%20header%20based%20on%20when%20I%20refresh%20the%20report.%20Where%20I%20would%20like%20it%20to%20go%20is%20to%20almost%20flip%20this%20and%20say%20by%20person%20by%20day%20In%20my%20period%20selected%20what%20are%20the%20totals%20for%20each%20separate%20day%20by%20the%20same%20headers.%20Is%20something%20like%20this%20possible%20without%20having%20to%20extract%20multiple%20reports%20or%20daily%20reports%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20cool%20this%20would%20be%20to%20see%20who%20has%20been%20sending%20me%20emails%20so%20I%20can%20do%20a%20count%20by%20client%20and%20see%20who%20is%20emailing%20in%20more%20often.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThoughts%20please%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-390093%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%20Center%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Administration%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Management%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-390324%22%20slang%3D%22en-US%22%3ERe%3A%20365%20Admin%20Center%20Custom%20Reporting%20-%20Email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390324%22%20slang%3D%22en-US%22%3E%3CP%3EOffice%20365%20reports%20pretty%20much%20cover%20the%20basics%2C%20you%20have%20almost%20zero%20customizability%20with%20them.%20If%20you%20want%20something%20more%20robust%2C%20you%20can%20use%20the%20available%20PowerShell%20cmdlets%20and%20the%20Graph%20API%20to%20fetch%20the%20data%20yourself%20and%20present%20it%20in%20a%20manner%20more%20useful%20to%20you.%20Or%20use%20one%20of%20the%203rd%20party%20tools%20that%20specialize%20in%20O365%20reporting.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
jack9790
Visitor

Hello All

 

I was wondering if anyone knows of the capability of 365 Admin Center to allow you to build and create custom reports off the back of it. Now as it stands I'm not the current admin of our system but I have been asked to look into the possibility of the reporting capabilities on the email out of 365.

 

Currently I know we can export a file from the Admin Center that will tell me: Display Name, Last Activity Date, Send Count, Receive Count, Read Count and the Report Period. From this I gather that it is displaying say the last 30 days totals for each person by header based on when I refresh the report. Where I would like it to go is to almost flip this and say by person by day In my period selected what are the totals for each separate day by the same headers. Is something like this possible without having to extract multiple reports or daily reports?

 

Another cool this would be to see who has been sending me emails so I can do a count by client and see who is emailing in more often.

 

Thoughts please

 

 

1 Reply
Highlighted

Office 365 reports pretty much cover the basics, you have almost zero customizability with them. If you want something more robust, you can use the available PowerShell cmdlets and the Graph API to fetch the data yourself and present it in a manner more useful to you. Or use one of the 3rd party tools that specialize in O365 reporting.

Related Conversations
Moving Away from MS Access
Office_365_Admin in Access on
1 Replies
OneDrive for business - IT security check
yasothadevi in SharePoint on
2 Replies
Struggling how to do a calculation
Tim_Jevans in Excel on
11 Replies
Office 365 dependencies
JM206 in Office 365 on
0 Replies
Sharepoint Online Migration
Gaius1050 in SharePoint on
2 Replies