# Data & reporting **URL:** https://meta.discourse.org/c/community-building/data-reporting/148.md?page=13 [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) **Page:** 14 --- ## [How to find pageview data for a specific topic?](https://meta.discourse.org/t/how-to-find-pageview-data-for-a-specific-topic/228982)
**Author:** [@hequaye](https://meta.discourse.org/u/hequaye)\ **Replies:** 3\ **Last updated:** [June 3, 2022, 9:49pm UTC](https://meta.discourse.org/t/how-to-find-pageview-data-for-a-specific-topic/228982 "2022-06-03T21:49:47Z")
Hello everyone, this may be a silly dumb request… but I can not see pageview stats for one of my topics I posted that’s a top post in my community. How to create your LFID to gain access to LFX Tools, and LF Events or … --- ## [Badge Query for Profile Views](https://meta.discourse.org/t/badge-query-for-profile-views/228182)
**Author:** [@codergautam](https://meta.discourse.org/u/codergautam)\ **Replies:** 1\ **Last updated:** [June 1, 2022, 11:10pm UTC](https://meta.discourse.org/t/badge-query-for-profile-views/228182 "2022-06-01T23:10:42Z")
Is there a way to give a badge if a profile has more than X views? --- ## [Searching for historical assignments](https://meta.discourse.org/t/searching-for-historical-assignments/228716)
**Author:** [@Colin\_Mueller](https://meta.discourse.org/u/Colin_Mueller)\ **Replies:** 2\ **Last updated:** [June 1, 2022, 7:31pm UTC](https://meta.discourse.org/t/searching-for-historical-assignments/228716 "2022-06-01T19:31:02Z")
Hey there. We have a workflow on our forum where we assign threads to a group, and once that group has done what they feel they can do with a given thread, they unassign it from themselves. This makes sure those threads… --- ## [Badge query for topic views](https://meta.discourse.org/t/badge-query-for-topic-views/228174)
**Author:** [@codergautam](https://meta.discourse.org/u/codergautam)\ **Replies:** 3\ **Last updated:** [May 26, 2022, 5:36pm UTC](https://meta.discourse.org/t/badge-query-for-topic-views/228174 "2022-05-26T17:36:33Z")
Is there a badge query that gives the badge if any one of a users topic has over 1,000 views? --- ## [Is there a way to delete the page views statistics for a given day?](https://meta.discourse.org/t/is-there-a-way-to-delete-the-page-views-statistics-for-a-given-day/227925)
**Author:** [@p0fi](https://meta.discourse.org/u/p0fi)\ **Replies:** 0\ **Last updated:** [May 24, 2022, 7:58am UTC](https://meta.discourse.org/t/is-there-a-way-to-delete-the-page-views-statistics-for-a-given-day/227925 "2022-05-24T07:58:29Z")
My site had a DDos attack and therefore got too many “page views”. This amount is making the “Consolidated Pageviews” report pretty useless since the scale is totally distorted. You can see the report in the screenshot b… --- ## [Why are stats not updated in real time?](https://meta.discourse.org/t/why-are-stats-not-updated-in-real-time/227482)
**Author:** [@keff](https://meta.discourse.org/u/keff)\ **Replies:** 2\ **Last updated:** [May 19, 2022, 12:12pm UTC](https://meta.discourse.org/t/why-are-stats-not-updated-in-real-time/227482 "2022-05-19T12:12:38Z")
Hey there, we’re building a front-end around the discourse API, and we’ve encountered a weird behaviour regarding stats not updating in real-time in a couple of places. For one, when fetching /directory\_items.json?peri… --- ## [Data explorer queries similar to dashboard stats](https://meta.discourse.org/t/data-explorer-queries-similar-to-dashboard-stats/226973)
**Author:** [@camilaoliveira](https://meta.discourse.org/u/camilaoliveira)\ **Replies:** 3\ **Last updated:** [May 16, 2022, 8:28pm UTC](https://meta.discourse.org/t/data-explorer-queries-similar-to-dashboard-stats/226973 "2022-05-16T20:28:44Z")
I’d like to know if there’re queries that someone in the community have created that brings similar data as the admin dashboard stats bring. I wish to share some statistic to category moderators using data explorer feat… --- ## [Request: Custom Badge SQL for total Like count](https://meta.discourse.org/t/request-custom-badge-sql-for-total-like-count/226489)
**Author:** [@rapphann](https://meta.discourse.org/u/rapphann)\ **Replies:** 1\ **Last updated:** [May 13, 2022, 10:38am UTC](https://meta.discourse.org/t/request-custom-badge-sql-for-total-like-count/226489 "2022-05-13T10:38:40Z")
Hello! There’s a default badge shipped with the software that I quite like, but would like it tweaked a little. The original: This badge is granted when you have 100 liked posts and give 100 or more likes in return. … --- ## [Read history for a particular category](https://meta.discourse.org/t/read-history-for-a-particular-category/226740)
**Author:** [@Cozdabuch](https://meta.discourse.org/u/Cozdabuch)\ **Replies:** 2\ **Last updated:** [May 11, 2022, 10:21am UTC](https://meta.discourse.org/t/read-history-for-a-particular-category/226740 "2022-05-11T10:21:02Z")
Is there a way to write this specific query: For topics in category (category id: 34) viewed by user(s) not in group (executive\_board) Display user, display topic, display when viewed. --- ## [Setup instructions for Google Analytics 4](https://meta.discourse.org/t/setup-instructions-for-google-analytics-4/167863)
**Author:** [@TechGeek](https://meta.discourse.org/u/TechGeek)\ **Replies:** 9\ **Last updated:** [April 28, 2022, 7:24pm UTC](https://meta.discourse.org/t/setup-instructions-for-google-analytics-4/167863 "2022-04-28T19:24:28Z")
Google has recently released Google Analytics 4, Below are few suggestions for Discourse: Add gtag.js directly to your pages: Add option in Dashboard to add Google Analytics 4 gtag.js directly (Yes, this can be done by… --- ## [Show top users with most posts created using a tag](https://meta.discourse.org/t/show-top-users-with-most-posts-created-using-a-tag/225106)
**Author:** [@Senpai](https://meta.discourse.org/u/Senpai)\ **Replies:** 2\ **Last updated:** [April 24, 2022, 7:08am UTC](https://meta.discourse.org/t/show-top-users-with-most-posts-created-using-a-tag/225106 "2022-04-24T07:08:12Z")
Hi community! I want to get the users with most topics created in each tag category. For example the list of users with most posts on this community using the data-explorer tag. I tried a lot with my rusty SQL skills … --- ## [IDs in Data Explorer](https://meta.discourse.org/t/ids-in-data-explorer/224775)
**Author:** [@ganncamp](https://meta.discourse.org/u/ganncamp)\ **Replies:** 3\ **Last updated:** [April 20, 2022, 6:15am UTC](https://meta.discourse.org/t/ids-in-data-explorer/224775 "2022-04-20T06:15:29Z")
I’ve noticed that if I select an FK ID in a table, I get a beautifully presented, linked name. Whereas if I select a PK ID in a table, I just get a number. For example, when I select the (PK) id field from Posts: Ve… --- ## [How to count likes\_received excluding a specific group](https://meta.discourse.org/t/how-to-count-likes-received-excluding-a-specific-group/224304)
**Author:** [@Ítalo\_Dias](https://meta.discourse.org/u/%C3%8Dtalo_Dias)\ **Replies:** 0\ **Last updated:** [April 14, 2022, 4:58pm UTC](https://meta.discourse.org/t/how-to-count-likes-received-excluding-a-specific-group/224304 "2022-04-14T16:58:59Z")
Hey, folks! How are you doing? I’m kinda new to building queries in SQL for my community, so I’m stuck on one issue. I have to build a query where I get data related to the threads created by a specific group in the co… --- ## [\`DataExplorer::ValidationError: Missing parameter\` when running Data Explorer queries with \[params\] via API](https://meta.discourse.org/t/dataexplorer-missing-parameter-when-running-data-explorer-queries-with-params-via-api/223812)
**Author:** [@md-misko](https://meta.discourse.org/u/md-misko)\ **Replies:** 8\ **Last updated:** [April 10, 2022, 12:54pm UTC](https://meta.discourse.org/t/dataexplorer-missing-parameter-when-running-data-explorer-queries-with-params-via-api/223812 "2022-04-10T12:54:37Z")
There is a bug in Discourse API when running Data Explorer queries containing parameters (both queries below work as expected when run from the browser). Following the instructions from Run Data Explorer queries with th… --- ## [Search for number of solved topics per user](https://meta.discourse.org/t/search-for-number-of-solved-topics-per-user/223364)
**Author:** [@lju](https://meta.discourse.org/u/lju)\ **Replies:** 3\ **Last updated:** [April 6, 2022, 8:42pm UTC](https://meta.discourse.org/t/search-for-number-of-solved-topics-per-user/223364 "2022-04-06T20:42:33Z")
Hi All, I am looking to build a query in the data explorer - and being completely new to it, am not sure where to start! I would like to run the following query: Return the number of topics with a post marked as a sol… --- ## [Forum Posts Triggering Facebook Pixel Twice](https://meta.discourse.org/t/forum-posts-triggering-facebook-pixel-twice/222372)
**Author:** [@Charles\_Hoffman](https://meta.discourse.org/u/Charles_Hoffman)\ **Replies:** 3\ **Last updated:** [April 1, 2022, 7:27am UTC](https://meta.discourse.org/t/forum-posts-triggering-facebook-pixel-twice/222372 "2022-04-01T07:27:32Z")
Hey, I integrated my Facebook Pixel with my forum. Everything is working as expected, except that a PageView Pixel event triggers twice when I load forum post pages. A single PageView Pixel event is triggered on other fo… --- ## [What happened to 'All Time' statistics?](https://meta.discourse.org/t/what-happened-to-all-time-statistics/222596)
**Author:** [@davidkingham](https://meta.discourse.org/u/davidkingham)\ **Replies:** 6\ **Last updated:** [March 31, 2022, 9:04pm UTC](https://meta.discourse.org/t/what-happened-to-all-time-statistics/222596 "2022-03-31T21:04:49Z")
Am I crazy or did there not use to be an option to see statistics in the dashboard from ‘All Time’? Now the furthest I can go back is a year. I would love to see this come back as I am interested to see how traffic ebbed… --- ## [Can I download a user database and sort by time viewed?](https://meta.discourse.org/t/can-i-download-a-user-database-and-sort-by-time-viewed/222118)
**Author:** [@BaneWilliams](https://meta.discourse.org/u/BaneWilliams)\ **Replies:** 3\ **Last updated:** [March 28, 2022, 6:44am UTC](https://meta.discourse.org/t/can-i-download-a-user-database-and-sort-by-time-viewed/222118 "2022-03-28T06:44:13Z")
I notice that Discourse tracks posts viewed and time viewed. We are looking to use Discourse as a product support community, where you are given an account on product registration, with SSO to eliminate the pesky regist… --- ## [Get topic count per month for a certain category](https://meta.discourse.org/t/get-topic-count-per-month-for-a-certain-category/222100)
**Author:** [@helmi](https://meta.discourse.org/u/helmi)\ **Replies:** 1\ **Last updated:** [March 27, 2022, 5:16pm UTC](https://meta.discourse.org/t/get-topic-count-per-month-for-a-certain-category/222100 "2022-03-27T17:16:46Z")
Maybe anyone more used to using Data explorer can help me out here? I want to get a topic count per month statistic for a certain category. Would be good enough if it was for one year from the day it’s running. Thanks … --- ## [Any idea how to send metric reports as private message?](https://meta.discourse.org/t/any-idea-how-to-send-metric-reports-as-private-message/221844)
**Author:** [@jrgong](https://meta.discourse.org/u/jrgong)\ **Replies:** 2\ **Last updated:** [August 15, 2023, 8:34am UTC](https://meta.discourse.org/t/any-idea-how-to-send-metric-reports-as-private-message/221844 "2023-08-15T08:34:52Z")
Hey guys I am currently looking for a simple way to create automated reports for advertisers (number ot topic views, link clicks, replies, etc) for a sponsored topics. Since all our adversisers have registered accounts… --- ## [Assigned a badge based on multiple badge assignment](https://meta.discourse.org/t/assigned-a-badge-based-on-multiple-badge-assignment/221251)
**Author:** [@alefattorini](https://meta.discourse.org/u/alefattorini)\ **Replies:** 8\ **Last updated:** [March 18, 2022, 6:24pm UTC](https://meta.discourse.org/t/assigned-a-badge-based-on-multiple-badge-assignment/221251 "2022-03-18T18:24:02Z")
Hi folks I’d like to assign a badge based on how many time a user obtain a specific badge Alessio obtained at least 10 times foo badge - \> Cool\_foo badge earned Luca obtained at least 15 times foo badge → Super\_foo ba… --- ## [User Data By Date Rage](https://meta.discourse.org/t/user-data-by-date-rage/221152)
**Author:** [@Chris27](https://meta.discourse.org/u/Chris27)\ **Replies:** 1\ **Last updated:** [March 16, 2022, 10:44pm UTC](https://meta.discourse.org/t/user-data-by-date-rage/221152 "2022-03-16T22:44:14Z")
I don’t believe this is possible in the admin, so I thought I’d ask here! I’m looking for engagement data at the user level based on a date range (for all members) As an example for February 2022: Days Visited Po… --- ## [Is the info Top Referred Topics/ Top Traffic Sources stored in a table in the database?](https://meta.discourse.org/t/is-the-info-top-referred-topics-top-traffic-sources-stored-in-a-table-in-the-database/73301)
**Author:** [@ckshen](https://meta.discourse.org/u/ckshen)\ **Replies:** 6\ **Last updated:** [March 16, 2022, 9:45pm UTC](https://meta.discourse.org/t/is-the-info-top-referred-topics-top-traffic-sources-stored-in-a-table-in-the-database/73301 "2022-03-16T21:45:32Z")
Quick question for the community- I see in the dashboard we have a top 10 for Top referred topics and traffic sources. Is this information stored in a table in a database? What I am most interested in is the records ou… --- ## [How can I figure out why I have a big jump in anonymous pageviews](https://meta.discourse.org/t/how-can-i-figure-out-why-i-have-a-big-jump-in-anonymous-pageviews/220415)
**Author:** [@efuetatem1](https://meta.discourse.org/u/efuetatem1)\ **Replies:** 10\ **Last updated:** [March 9, 2022, 6:57pm UTC](https://meta.discourse.org/t/how-can-i-figure-out-why-i-have-a-big-jump-in-anonymous-pageviews/220415 "2022-03-09T18:57:13Z")
Greeting, So I noticed something funny between the 15th to the 16th of February 2022 in our self-hosted DigitalOcean Discourse instance. As the picture below shows, the number of anonymous users per day jumped from roug… --- ## [How to consolidate the Pageviews by Tag?](https://meta.discourse.org/t/how-to-consolidate-the-pageviews-by-tag/108745)
**Author:** [@Viki](https://meta.discourse.org/u/Viki)\ **Replies:** 7\ **Last updated:** [February 11, 2019, 6:06pm UTC](https://meta.discourse.org/t/how-to-consolidate-the-pageviews-by-tag/108745 "2019-02-11T18:06:26Z")
Hello everyone, How to Consolidate the Pageviews of topics by particular tag? For example, I posted 30 topics under one tag called Support. --- ## [Dashboard Reports](https://meta.discourse.org/t/dashboard-reports/219222)
**Author:** [@IAmGav](https://meta.discourse.org/u/IAmGav)\ **Replies:** 3\ **Last updated:** [February 23, 2022, 11:23pm UTC](https://meta.discourse.org/t/dashboard-reports/219222 "2022-02-23T23:23:29Z")
For a newly build community that has a total of 1 member and is set to Login Required & invite only, the dashboard reports/graphs is showing an increase in activity. Something is not making sense at all. --- ## [Understanding anonymous metrics on a login required site](https://meta.discourse.org/t/understanding-anonymous-metrics-on-a-login-required-site/108457)
**Author:** [@caduspa](https://meta.discourse.org/u/caduspa)\ **Replies:** 5\ **Last updated:** [February 6, 2019, 11:31pm UTC](https://meta.discourse.org/t/understanding-anonymous-metrics-on-a-login-required-site/108457 "2019-02-06T23:31:21Z")
My Discourse is open only to active patrons of my Patreon site. In looking at metrics in the consolidate pageviews section I see that a good number of views are listed as from anonymous users and a few crawlers. Is there… --- ## [Report of users and their status towards Trust Level 3 requirements](https://meta.discourse.org/t/report-of-users-and-their-status-towards-trust-level-3-requirements/35954)
**Author:** [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)\ **Replies:** 5\ **Last updated:** [February 6, 2019, 2:10am UTC](https://meta.discourse.org/t/report-of-users-and-their-status-towards-trust-level-3-requirements/35954 "2019-02-06T02:10:32Z")
Now that my site has been running for about a year, I’d like to evaluate the requirements for trust level 3 which so far only 3 people have managed to attain. My gut instinct tells me that the main issue is the 50% in la… --- ## [Page view reports vs topic view reports](https://meta.discourse.org/t/page-view-reports-vs-topic-view-reports/218246)
**Author:** [@ganncamp](https://meta.discourse.org/u/ganncamp)\ **Replies:** 0\ **Last updated:** [February 15, 2022, 2:22pm UTC](https://meta.discourse.org/t/page-view-reports-vs-topic-view-reports/218246 "2022-02-15T14:22:44Z")
Hi, We’re starting to look at the built-in reporting, and find the page view reporting on the admin dashboard interesting. However, I guess that’s all pageviews? So including search results, the /category page, /new, /l… --- ## [Statics shows not correct numbers !?](https://meta.discourse.org/t/statics-shows-not-correct-numbers/216512)
**Author:** [@f1r4s](https://meta.discourse.org/u/f1r4s)\ **Replies:** 3\ **Last updated:** [January 31, 2022, 5:41am UTC](https://meta.discourse.org/t/statics-shows-not-correct-numbers/216512 "2022-01-31T05:41:52Z")
Hello, I’m checking my development discourse system; and i see more than 417 logged users and i’m sure none sign or loggin in the community in this time ? My question how to show real visitors and logged users; etc… … [Previous page](https://meta.discourse.org/c/community-building/data-reporting/148.md?page=12) [Next page](https://meta.discourse.org/c/community-building/data-reporting/148.md?page=14)