I have a 1 year log report, but it is possible I extract the individual day's statistic into excel file?

Avatar
  • updated
  • Answered
Avatar
Michael
There are three ways to get a report for one day:

1. You can choose a log for one day only in the profile settings and generate a report for it. The problem is that log are usually rotated not exactly at 12:00 AM in the time zone you need, so if you analyze a daily log you'll probably see part of activity on one day and the remaining on the next day. You can set the report format to CSV (that can be opened using Excel) in Profile Properties > Report.

2. You can set the profile to analyze all you logs, and set the time range you need in Profile Properties > Time Range. If you have never analyzed these logs before, the program will need to read all the logs once to determine their time range. If you analyzed them before, the program should already have their time ranges in cache, so it will quickly analyze the logs you need. You can set the report format to CSV in Profile Properties > Report.

3. If you use dynamic HTML reports (available in the Enterprise edition) and already generated a report, you can choose any time range while viewing the report. You can also export the current page to CSV while viewing the report, while it's not possible to get the whole report as single CSV file in this case.
Avatar
Rosanna
Thank you so much Michael for the information! Appreciated!