Most people know about the Web Analytics Reports that come built in with SharePoint, but there is a way to run a report on specific Document Libraries that show how many times each file was accessed and opened.

Before you do this, you must go to Site Actions/Site Settings/Site Collection Administration/Site Collection audit settings and click on the checkbox titled ‘Opening or downloading documents, viewing items in lists, or viewing item properties’.

First off, let me tell you that you will need Site Collection Admin permissions to do all this, but it’s not really that hard at all. The link to get there to be able to run the reports is not with the Web Analytics under Site Actions (in Site Settings).

Instead, when you’re in Site Settings, under the Site Collection Administration section, click on ‘Audit log Reports’. This gets you to the page (in the Custom Reports section) where you will be able to run a custom report.

Click on the link that is titled ‘Run a custom report’ (duh!). Here, you will designate a file location for saving the report. then, in the location section, you will either designate a specific list/library in the site or not, then choose the date range (start/end) and then finally, click the checkbox titled ‘Opening or downloading documents, viewing items in lists, or viewing item properties’. There are quite a few other options you can explore here too. You don’t need to enter a user, but you can if you’d want.

Click the ‘OK’ button and you’re done. There will be a link to the document (Excel worksheet) to view it if you’d like.