Following is the code to fetch the number of Page views from a SharePoint site using the RequestUsage Table

We must enable Usage and Health Reporting from Central Administration with the important event being Page Requests.  Enabling this will create a new database, named WSS_Logging.This Database contains the table RequestUsage which will be used for Reporting the PageViews.

select Userlogin ,ServerUrl,SiteUrl,weburl,DocumentPath,LogTime  from RequestUsage
where  serverurl = ''  --webappurl
and siteurl = '/blog/blog1'   --sitecollectionurl
and weburl = '/user'    --weburl
and DocumentPath = '/default.aspx'  --page for which the number of views needs to be determined
order by logtime desc

Refrence Links