Site Traffic Hits Report on Every Item on a SharePoint Site

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;
using System.Data;
using System.Diagnostics;
using System.IO;

namespace SharePoint.AdminReport
{
    class GetSiteUsageReport
    {
        //Method to Convert Data Table to CSV
        public static string ToCSV(DataTable table, string webURL)//, string listURL) 
        { 
            var result = new StringBuilder();

              foreach (DataRow dr in table.Rows)
              {
                  result.Append(webURL + "\t" + (dr["Folder"].ToString() == "" ? "" : "/") + dr["Folder"].ToString() + "/" + dr["Page"].ToString() + "\t" + dr["Total Hits"].ToString() + "\t" + dr["Most Recent Day"].ToString() + "\n");
              }
            return result.ToString(); 
        } 

        //Method to Get Usage Data
        public static DataTable GetWebUsageData(SPWeb oSPWeb)
        {
            try
            {
                //DataTable for Hits result - Because GetUsageData returns DataTable!
                DataTable dtHits = new DataTable();

                dtHits = oSPWeb.GetUsageData(SPUsageReportType.url, SPUsagePeriodType.lastMonth);
                if (dtHits != null)
                {
                    return (dtHits);
                }
                else
                {
                    return (null);
                }
            }
            catch (Exception Ex1)
            {
                return (null);
            }
        }


        static void Main(string[] args)
        {
            string site;

            try
            {
                if (args.Length == 0)
                {
                    Console.WriteLine("Enter the Site Collection URL:");
                    site = Console.ReadLine();
                }
                else
                {
                    site = args[0];
                }

                SPSite tmpSite = new SPSite(site);
                //objects for the CSV file generation
                StreamWriter sw = new StreamWriter("c:\SiteUsageReport.csv",false); 

                //Write the CSV Header
                sw.Write("Site \t Page \t Total Hits \t Most Recent Day \n");
                    
                   //Enumerate through each sub-site
                    foreach (SPWeb tmpWeb in tmpSite.AllWebs)
                    {
                            //DataTable for Hits set - Because GetUsageData returns DataTable!
                            DataTable dtHits = new DataTable();
                            dtHits = GetWebUsageData(tmpWeb);

                            if (dtHits != null)
                            {

                            string result = ToCSV(dtHits, tmpWeb.Url);

                                     sw.Write(result);
                            }
                    }
                //Dispose of the Root Site Object
                sw.Close();
                tmpSite.Dispose();
            }

            catch (Exception ex)
            {
                System.Diagnostics.EventLog.WriteEntry("Site Usage Report", ex.Message);
            }
               
        }
    }
}

[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
 
#Functions to Imitate SharePoint 2010 Cmdlets in MOSS 2007
function global:Get-SPWeb($url) 
{
  $site= New-Object Microsoft.SharePoint.SPSite($url)
        if($site -ne $null) 
        {
              $web=$site.OpenWeb();       
        }
    return $web
}
 
#Method to Get Usage Data
Function GetWebUsageData($Web)
{
	try
	{
		#DataTable for Hits result - Because GetUsageData returns DataTable!
		$dtHits = New-Object System.Data.DataTable  

		$dtHits = $Web.GetUsageData("url", "lastMonth") 

		if ($dtHits -ne $null)
		{
			return ($dtHits);
		}
		else
		{
			return ($null);
		}
	}
	catch 
	{
		Write-Host $_.Exception.Message -ForegroundColor Red
		return ($null);
	}
}

$WebURL = "https://sharepoint.crescent.com/operations/sfdc/"

$CurrentPath = Split-Path -Parent -Path $MyInvocation.MyCommand.Definition
$OutPutFile = Join-path $CurrentPath "SiteUsageReport.txt"

#Get the Web
$Web = Get-SPWeb $WebURL


#create a CSV file
"Page `t Total Hits `t Last Accessed" > $OutPutFile #Write the Headers in to a text file

#Get the Hits Data
$HitsDT = GetWebUsageData($Web)
if ($HitsDT -ne $null)
{ 
	foreach($dr in $HitsDT)
	{
	  
	  $result = $webURL +"/" + $dr["Folder"]+"/"+$dr["Page"] + "`t" + $dr["Total Hits"] + "`t" + $dr["Most Recent Day"]
	  $result >> $OutPutFile  #append the data
	}
}