Forum Discussion
How to connect SharePoint site access user details via Google Analytics data studio
Hi Experts, Good day, I would like to create new reports in Google data studio (Google Analytics), with the data source coming from SharePoint. I need to import site access user counts, inclu...
I'd suggest having a look at some of the managed properties you get with search. See an example below that returns document views and viewers stats across a library.
https://YOURTENANT.sharepoint.com/sites/YOURSITE/_api/search/query?querytext='isDocument%3atrue path%3ahttps://YOURTENANT.sharepoint.com/sites/YOURSITE/YOURLIBRARY/'&enableinterleaving=false&rowsperpage=500&rowlimit=5&enablequeryrules=false&selectproperties='Filename%2cTitle%2cCreated%2cLastModifiedTime%2c
ViewsLast1DaysUniqueUsers%2cViewsLast2DaysUniqueUsers%2cViewsLast3DaysUniqueUsers%2cViewsLast4DaysUniqueUsers%2cViewsLast5DaysUniqueUsers%2cViewsLast6DaysUniqueUsers%2cViewsLast7DaysUniqueUsers%2c
ViewsLastMonths1Unique%2cViewsLastMonths2Unique%2cViewsLastMonths3Unique%2cViewsLifeTimeUniqueUsers%2cViewsLast1Days%2cViewsLast2Days%2cViewsLast3Days%2cViewsLast4Days%2cViewsLast5Days%2cViewsLast6Days%2cViewsLast7Days%2cViewsLastMonths1%2cViewsLastMonths2%2cViewsLastMonths3%2cViewsLifeTime'&clienttype='ContentSearchRegular'