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.

Answer 2

Splunk has a tutorial almost about the same as you are asking. The downside that it is a commercial program (free up to 500 MB of data per day).

Otherwise have a look at the ELK stack, combining Elastic (to index the data), Logstash (to get them into Elastic) and Kibana (to display them) should fit your list.