I am trying to figure out a way to find out how many viewers (logged in or not) viewed a certain topic during a certain period. I searched for an answer but couldn’t find an exact solution. Using the Data Explorer, I tried to study the tables that mention the viewers and try to use SQL to filter out the result; however, I have not been able to get to know exactly how many users viewed a certain topic during a certain day for example.
I will explain the tables that I have studied! You can correct me if I’m wrong or if there’s something that I can add to fix it, please! Thanks!
The table topic_views lists the first_viewed_at and so it’s not possible to know if the user visited the topic for a second time or not; however, although the table topic_users lists the first_viewed_at as well as the last_viewed_at the last view might be a third or fourth view after the period that I’m inquiring about. For example, if today was their last view and before yesterday was the first view, I won’t be able to know if the user viewed the topic yesterday. The views from the topics table doesn’t help much because it doesn’t mention when; nor does the post_timings table either because it doesn’t mention when the reading occurred.
Is there any other table or method that I missed?