# כמה צופים צפו בנושא במהלך תקופה מסוימת?

**URL:** <https://meta.discourse.org/t/how-many-viewers-viewed-a-topic-during-a-certain-period/203486>\
**Category:** Data & reporting\
**Created:** [14 בספטמבר,‏ 2021,‏ 6:56am UTC](https://meta.discourse.org/t/how-many-viewers-viewed-a-topic-during-a-certain-period/203486 "2021-09-14T06:56:19Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![gassim](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/gassim/32/220910_2.png) [@gassim](https://meta.discourse.org/u/gassim)\
**Post date:** [14 בספטמבר,‏ 2021,‏ 6:56am UTC](https://meta.discourse.org/t/how-many-viewers-viewed-a-topic-during-a-certain-period/203486/1 "2021-09-14T06:56:19Z")

</div>

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](https://meta.discourse.org/t/32566?silent=true)**, 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?

#### Thank you so much! (:

---

_[View the full topic](https://meta.discourse.org/t/how-many-viewers-viewed-a-topic-during-a-certain-period/203486)._
