What this script does

• Downloads all of the built in 'Popularity and Search Reports' for SharePoint 2013
• Modifies the Usage.xlsx report to define a custom range for the chart
• Uploads reports to a specified library in SharePoint

If your farm is relatively new, you might not like the charts that are generated with two years of historical data. Instructions on picking a custom range are included in the script.

Apply a windows timer job to run this script daily, and an Excel Web Access web part to point to whichever report you like for an automated and up to date view of these reports.

I got tired of manually retrieving these reports for upper management, so I combined a couple scripts I've found here and there and got this.