# Counting pageviews per topic using the Data-Explorer plugin

**URL:** <https://meta.discourse.org/t/counting-pageviews-per-topic-using-the-data-explorer-plugin/112417>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [March 23, 2019, 5:28pm UTC](https://meta.discourse.org/t/counting-pageviews-per-topic-using-the-data-explorer-plugin/112417 "2019-03-23T17:28:18Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)\
**Post date:** [March 25, 2019, 3:48am UTC](https://meta.discourse.org/t/counting-pageviews-per-topic-using-the-data-explorer-plugin/112417/6 "2019-03-25T03:48:35Z")

</div>

My understanding is that @Alexandra_Diehl wants to see that on Monday 100 people visited the topic and on Wednesday 32 people. We actually store data at that fidelity.

Though we do need a bit of an internal refactor cause we only count any given user once and any given IP once. A simpler rollup table would take up far less storage and give more interesting results.

---

_[View the full topic](https://meta.discourse.org/t/counting-pageviews-per-topic-using-the-data-explorer-plugin/112417)._