Top 10 Documents

Each month, I publish usage reports. I know, I can automate these, but for now, I will assume that you are in the same boat as me (cannot do development, or use SharePoint Designer).

1. Go into the usage reports / Top Pages section of your site. (https://[YOURSERVER]/_layouts/SpUsageWebTopPages.aspx).
2. Export to Excel
3. Go through and remove all of the pages you want to exclude from your report. I exclude images and aspx pages. Assuming your URL is in column A, and Column C is blank, You can use the Excel formula in column C to sort and categorize the documents by type: "=RIGHT(A2,4)". Autofill the entire column C with the formula. This gives the last four characters of the URL. Sort by this, and remove the rows you want to exclude from the report.
4. Enter the formula into column D: =SUBSTITUTE(RIGHT(A2,LEN(A2)-33), "/", " : ") and autofill down the column. We are removing the first 33 characters of the URL; see that number 33 there, that is the name of my server and document library and "https:". We are also substituting the "/" with SPACE COLON SPACE characters to represent a friendly name for the URL folder structure. You can get really creative and put: =SUBSTITUTE(SUBSTITUTE(RIGHT(A2,LEN(A2)-33), "/", " : "), ".", " [") & "]" instead, which will have the friendly name and document type neatly bracketed for you: like this: "[doc]".
5. Now, in column E, we want to build the friendly looking URL. Enter the formula: "=HYPERLINK(A2,D2)". Autofill Column E with that URL.
6. Sort the list by the hit count, and eliminate all but the top 10.
7. Now, you can paste the URL (column E) and Hit count into your Links list using datasheet view and you will have a friendly link to the top 100 documents in your library or site.

I hope that helps you!