Reporting on the time and source IP of page hits
Content
Hi All,
We recently had an unusual number of page hits on a single day, and therefore would like to see the sources (IP addresses) and exact times of these page hits. I'm having trouble getting the desired results, and would appreciate some guidance.
A couple of ways I have explored:
1. Using the clickstreams table and filtering on the "Source" action, I am able to get IP Addresses. However I am unable to join it with the Answers table to see which answers were viewed, and not sure which date filter to use.
2. Using a 'total answers viewed' report (ans_stats.hits), I was able to drill-down to the number of page hits during particular time intervals of the specific day. E.g. on 07/09/2016, between 9-10 there were 3000+ hits, of which 800+ were on answer ID ****, 500+ were on answer ID yyy...etc. However, I'm not sure how to see the IP and exact time of each of those page hits, and would really like to see that.