Forum Discussion

Gokul_G16's avatar
Gokul_G16
Copper Contributor
Apr 16, 2025

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, including the number of views and counts.

 

I know that we can export this data via the Microsoft 365 Compliance Center, but my client does not allow tenant access due to data privacy concerns.

 

Could you please advise on how we can achieve this? Specifically, I need to collect SharePoint document and file access user details daily and connect this data to Google Analytics on daily basis. 

If you have step by step instruction details or if you have alternate way to achieve this let me know.

Regards,
Gokul

2010
2013
2016
accessibility
admin
Document Library
files
microsoft lists
Microsoft365
Permissions

2 Replies

  • Sarim-Zia's avatar
    Sarim-Zia
    Copper Contributor
    Jun 29, 2025

    Getting SharePoint access data into Google Data Studio is tricky without tenant-level access. Since Compliance Center is restricted, you might consider setting up a Power Automate flow to log file access events to a SharePoint list or Excel file, then use a connector like Power BI or a third-party bridge (e.g., Power Automate → Google Sheets → Data Studio). It’s not native, but it works around the tenant access limitation.

  • grant_jenkins's avatar
    grant_jenkins
    Iron Contributor
    Jun 29, 2025

    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'

     

Resources