Export SharePoint Site Analytics

%3CLINGO-SUB%20id%3D%22lingo-sub-304212%22%20slang%3D%22en-US%22%3EExport%20SharePoint%20Site%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304212%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20we%20export%20data%20from%26nbsp%3B%3CSTRONG%3E%2F_layouts%2F15%2Fsiteanalytics.aspx%3Fview%3D19%3C%2FSTRONG%3E%3F%3C%2FP%3E%3CP%3EI%20would%20like%20to%20get%20data%20on%26nbsp%3B%3CSTRONG%3EMost%20Viewed%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EMost%20Unique%20Viewers.%20%3C%2FSTRONG%3ECurrently%2C%20it%20only%20shows%20Past%207%20days.%20There%20is%26nbsp%3Bno%20way%20to%20change%20it.%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-304212%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-361200%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20Site%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-361200%22%20slang%3D%22en-US%22%3E%3CP%3EWhy%20do%20Microsoft%20make%20life%20so%20difficult%3F%20Exporting%20stats%20should%20be%20basic%20stuff.%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304480%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20Site%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304480%22%20slang%3D%22en-US%22%3EThis%20link%20provides%20the%20documentation%20for%20the%20activity%20API%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Foffice-365-management-api%2Foffice-365-management-activity-api-reference%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Foffice-365-management-api%2Foffice-365-management-activity-api-reference%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304319%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20Site%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304319%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F180%22%20target%3D%22_blank%22%3E%40Alan%20Marshall%3C%2FA%3E%2C%20thank%20you%20so%20much.%20Is%20there%20documentation%20on%20how%20to%20achieve%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304266%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20Site%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304266%22%20slang%3D%22en-US%22%3EYou%20need%20to%20use%20the%20office%20365%20management%20API%20for%20usage%20and%20retrieve%20the%20data%20on%20a%20schedule%20and%20store%20in%20your%20own%20database%2C%20you%20can%20then%20use%20PowerBI%20to%20report%20on%20top%20of%20that.%20You%20need%20to%20register%20an%20Azure%20AD%20app%20and%20give%20it%20permissions%20to%20use%20this%20API.%20If%20you%20have%20a%20Flow%20P1%20you%20could%20use%20this%20to%20query%20the%20API%20on%20a%20schedule%20and%20SQL%20Server%20connector%20to%20write%20to%20a%20database%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-872951%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20Site%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-872951%22%20slang%3D%22en-US%22%3Emy%20thoughts%20exactly%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-896329%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20SharePoint%20Site%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-896329%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReally%20would%20like%20to%20show%20it%20in%20a%20power%20bi%20report%2C%20there%20should%20be%20a%20direct%20way%20to%20push%20it%20to%20reporting%20tools%20like%20powerbi%2C%20or%20any%20export%20method%20to%20get%20the%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Can we export data from /_layouts/15/siteanalytics.aspx?view=19?

I would like to get data on Most Viewed and Most Unique Viewers. Currently, it only shows Past 7 days. There is no way to change it.

Please help.

 

6 Replies
You need to use the office 365 management API for usage and retrieve the data on a schedule and store in your own database, you can then use PowerBI to report on top of that. You need to register an Azure AD app and give it permissions to use this API. If you have a Flow P1 you could use this to query the API on a schedule and SQL Server connector to write to a database

@Alan Marshall, thank you so much. Is there documentation on how to achieve this?

Why do Microsoft make life so difficult? Exporting stats should be basic stuff.

Rob
Los Gallardos

my thoughts exactly

@RobElliott 

Really would like to show it in a power bi report, there should be a direct way to push it to reporting tools like powerbi, or any export method to get the data.