How to analyze httpd (apache webserver) logs in CentOS 7

Question

I have configred a static IP on my server that is using CentOS 7. Here httpd is the webserver. Now I have to analyze following things.

1. Total number of queries per day (or toall)
2. Total requests sent and served.
3. Unique visitors details
4. List of queries recieved. (status etc.)
5. HOSTs/OS/Browsers that request for query
6. Errors etc.
7. Should be able to save it in CSV etc. format so that I can import it to excel.

Can anyone suggest me some log analyzer that will fullfill above requirements ?

Answer 1

I think goaccess will fulfill your requirements.