It’s not obvious to me what the unit is on the read_time column in the user_visits table. I want to think it’s minutes, but looking at my data… I don’t really believe any one person has spent 224 minutes reading in my community today. Unfortunately.
1 Like
The time_read is the number of seconds that the user has spent on the site.
I wonder if there’s anything that could be done to make that obvious in the data that’s displayed on the Data Explorer sidebar.
2 Likes
Thanks.
That wasn’t my assumption, given that I have users with user_visit records with 0s/NULL form both posts_read and time_read.
I assumed that meant they loaded the site and looked at a list of posts(?) but didn’t click through…?
4 Likes
Yes, I think it is the time spent on a topic page, but I was wondering about the unit whether it’s seconds or minutes. I tested by checking my username and I had not spent any time reading any topic post so I clicked on a topic and waited a little bit then came back and it was 217 so it’s seconds. It’s 100% not time spent on the site because I’ve been working on the Data Explorer for more than an hour! 
1 Like