If you have a development team to handles your servers and website, then you are probably going to need to ask them to get you the data, it’s much simpler than getting the data yourself, however, you need to know what to ask for. Here are the essential items you need to request.
So you want to do some server log analysis, but you need to ask your developer for the data.
The basic information you need to make sure they are getting is:
This is the bare minimum needed to do any type of log Analysis. An example of what the data looks like:
Host 22.214.171.124 (Beijing,Beijing,China)
Date 31/07/2015 13:32
Response Code 200 – OK
Referrers No Referrer
User Agent Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)
However this should be the basic information you should be asking for, ask your development team what they actually record and see if any of that information can be useful.
One of the benefits of asking the developer to get you the data is you can request the file format (I.e. excel) saving you the trouble of trying to convert it yourself.
also if large excel files scare you – just ask them for the specific data, Google not activity which triggered a non 200 response code.