Forum Discussion
Create sessions based on timestamp
Hi All, I have some data from GA in which I have session Id and DateTime field. My requirement is to look at the session Id and if the created_timestamp has a time difference of more than 30 mins...
Take a look at my MTBF article, it has a similar kind of issue that it is trying to solve. You should be able to use it to create a column that flags a session as new based upon the duration from the previous row.
If it works for you and gives you what you want, then it is correct! :)
Glad my article could at least point you in the right direction!
Yeah it's working fine and I am getting correct results (as much I tested). thanks a lot for your help sir. Respect.