I am working with web analysis data. I am trying to figure out the average time elapsed between two pages that may or may not be in sequential order. Key peices of information I have are Timestamps, URLs, and User Names. In another table I have the URLs broken up into components. Which would make the data a little easier to work with.
My primary need is to find the average time it takes to get from the search to the page that the answer is on. So if you click search, you will be given a list of search findings and then you have to click on one of the findings to find the answer. The two pages will generally not be one after the other.
Re: Time elapsed between two non-sequential actions.
People use our site to find information. We have defined a page in our data as the "answer page". So like when people would search in Google, 1.)they would place a search, 2.)get a list of results, and 3.)then click one of the results to find their answer. We want to find the time it took to place the search and get to the answer page. Unfortunately, I cannot post a data set to the community using our actual data, but I can create a small sample in Excel to give you an idea.