As far as I know (@community: correct me if I am wrong), your report with the top 20 visited sites will not be possible out of the box. This is because in the url field of the logs you have the full url. So for example for every search on google of a user you have a different url log entrywith different url's. To make this report usable you have to extract only the FQDN from the log and create the report with this data. This could be done for example with splunk. For the other report with the spent time on a website it's kind of the same. To create this, you need to link the url log entry with the session start and end entries from the traffic log. But even then the report will not produce reliable output, because the session in the browser of a user could remain open even the user is not looking at the website anymore and is now doing something else on his computer.
... View more