Get top visited pages in Sitecore per site with multi-site setup

TopViews.cs

public IEnumerable<Dictionary<string, object>> TopViewedPages(int topPagesToGet, string siteName, int daysInterval, string language)
{
    var provider = (ReportDataProvider)Factory.CreateObject("reporting/dataProvider", true);
    var query = new ReportDataQuery(string.Format(@"SELECT TOP {0} 
                                                    ItemId,
                                                    F.LanguageId,
                                                    SUM(Views) PageViewsCount,
                                                    SUM(Visits) PageVisitsCount
                                                FROM Fact_PageViewsByLanguage F
                                                INNER JOIN SiteNames S ON S.SiteNameId = F.SiteNameId
                                                INNER JOIN Languages L ON L.LanguageId = F.LanguageId
                                                WHERE S.SiteName = '{1}'
                                                AND F.Date BETWEEN DATEADD(DAY,-{2},GETDATE()) AND GETDATE()
                                                AND L.Name = {3}
                                                GROUP BY ItemId, F.LanguageId
                                                ORDER BY PageViewsCount DESC, PageVisitsCount desc", 
                                                topPagesToGet, siteName, daysInterval, language));
 
    var response = provider.GetData("reporting", query, new CachingPolicy { NoCache = true }); // You can set your own caching policy as per requirement
    var datatable = response?.GetDataTable();
    return datatable?.Select()?.Select(row => row.ItemArray
                       .Select((column, count) => new { Name = datatable.Columns[count].ColumnName, Value = column })
                       .ToDictionary(column => column.Name, column => column.Value));
}