# Data & reporting **URL:** https://meta.discourse.org/c/community-building/data-reporting/148.md?page=23 [אחרונות](https://meta.discourse.org/latest.md) · [קטגוריות](https://meta.discourse.org/categories.md) · [תגיות](https://meta.discourse.org/tags.md) **Page:** 24 --- ## [Top 50 posters](https://meta.discourse.org/t/top-50-posters/275115)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **תשובות:** 0\ **עדכון אחרון:** [12 בפברואר,‏ 2018,‏ 1:06pm UTC](https://meta.discourse.org/t/top-50-posters/275115 "2018-02-12T13:06:00Z")
Top 50 posters Returns the top 50 posters for a given monthly period. Results are ordered by post\_count. It accepts a ‘months\_ago’ parameter, defaults to 0 to give results for the current month. -- \[params\] -- int :mont… --- ## [Topics solved by staff (lists topics)](https://meta.discourse.org/t/topics-solved-by-staff-lists-topics/275114)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **תשובות:** 0\ **עדכון אחרון:** [12 בפברואר,‏ 2018,‏ 12:56pm UTC](https://meta.discourse.org/t/topics-solved-by-staff-lists-topics/275114 "2018-02-12T12:56:00Z")
Topics solved by staff (lists topics) Returns topics solved by staff over a given monthly period, ordered by solution\_date. The query accepts a ‘months\_ago’ parameter, defaults to 0 to give the results for the current mo… --- ## [Topics solved by regular users (lists topics)](https://meta.discourse.org/t/topics-solved-by-regular-users-lists-topics/275113)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **תשובות:** 0\ **עדכון אחרון:** [12 בפברואר,‏ 2018,‏ 12:45pm UTC](https://meta.discourse.org/t/topics-solved-by-regular-users-lists-topics/275113 "2018-02-12T12:45:00Z")
Topics solved by regular users (lists topics) Returns topics solved by regular users over a given monthly period, ordered by solution\_date. The query accepts a ‘months\_ago’ parameter, and defaults to 0 to give the result… --- ## [Solved count by staff (monthly)](https://meta.discourse.org/t/solved-count-by-staff-monthly/275112)
**Author:** [@vinothkannans](https://meta.discourse.org/u/vinothkannans)\ **תשובות:** 0\ **עדכון אחרון:** [12 בפברואר,‏ 2018,‏ 12:03pm UTC](https://meta.discourse.org/t/solved-count-by-staff-monthly/275112 "2018-02-12T12:03:00Z")
Solved count by staff (monthly) Count of topics solved by staff(defaults to last month) -- \[params\] -- int :months\_ago = 1 WITH query\_period AS ( SELECT date\_trunc('month', CURRENT\_DATE) - INTERVAL ':months\_ago months'… --- ## [Solved count by members (monthly)](https://meta.discourse.org/t/solved-count-by-members-monthly/275111)
**Author:** [@vinothkannans](https://meta.discourse.org/u/vinothkannans)\ **תשובות:** 0\ **עדכון אחרון:** [12 בפברואר,‏ 2018,‏ 11:36am UTC](https://meta.discourse.org/t/solved-count-by-members-monthly/275111 "2018-02-12T11:36:00Z")
Solved count by members (monthly) Count of topics solved by regular members (defaults to last month) -- \[params\] -- int :months\_ago = 1 WITH query\_period AS ( SELECT date\_trunc('month', CURRENT\_DATE) - INTERVAL ':month… --- ## [Top 50 active topics (and their associated categories)](https://meta.discourse.org/t/top-50-active-topics-and-their-associated-categories/275110)
**Author:** [@vinothkannans](https://meta.discourse.org/u/vinothkannans)\ **תשובות:** 0\ **עדכון אחרון:** [12 בפברואר,‏ 2018,‏ 11:15am UTC](https://meta.discourse.org/t/top-50-active-topics-and-their-associated-categories/275110 "2018-02-12T11:15:00Z")
Top 50 active topics (and their associated categories) Returns the top 50 active topics per month. It’s based on the number of replies created for a topic in a given month. The query accepts a ‘months\_ago’ parameter, def… --- ## [New topics per category (by month)](https://meta.discourse.org/t/new-topics-per-category-by-month/275047)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **תשובות:** 0\ **עדכון אחרון:** [12 בפברואר,‏ 2018,‏ 10:37am UTC](https://meta.discourse.org/t/new-topics-per-category-by-month/275047 "2018-02-12T10:37:00Z")
New topics per category (by month) Returns the number of new topics created in each category for a given month, ordered by topic\_count. The query accepts a ‘months ago’ parameter, defaults to 0 to give the results for th… --- ## [New topics (by month)](https://meta.discourse.org/t/new-topics-by-month/275046)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **תשובות:** 0\ **עדכון אחרון:** [12 בפברואר,‏ 2018,‏ 9:15am UTC](https://meta.discourse.org/t/new-topics-by-month/275046 "2018-02-12T09:15:00Z")
New topics Lists all new topics created with a given month, ordered by category and creation\_date. The query accepts a ‘months\_ago’ parameter. It defaults to 0 to give you the stats for the current month. -- \[params\] --… --- ## [Users who like flagged posts](https://meta.discourse.org/t/users-who-like-flagged-posts/275027)
**Author:** [@ChrisBeach](https://meta.discourse.org/u/ChrisBeach)\ **תשובות:** 0\ **עדכון אחרון:** [11 בפברואר,‏ 2018,‏ 12:10am UTC](https://meta.discourse.org/t/users-who-like-flagged-posts/275027 "2018-02-11T00:10:08Z")
Users who like flagged posts A pattern I’ve spotted on my forum: one or two users habitually “like” posts that break our community guidelines. These users may not intentionally be trolling, but their “likes” are serving… --- ## [Help modifying a query to return usernames, instead of user ID numbers](https://meta.discourse.org/t/help-modifying-a-query-to-return-usernames-instead-of-user-id-numbers/275025)
**Author:** [@BenLeong](https://meta.discourse.org/u/BenLeong)\ **תשובות:** 2\ **עדכון אחרון:** [25 בינואר,‏ 2018,‏ 4:53am UTC](https://meta.discourse.org/t/help-modifying-a-query-to-return-usernames-instead-of-user-id-numbers/275025 "2018-01-25T04:53:04Z")
Hi! I’m looking for a bit of help modifying a query to return usernames, instead of user ID numbers. This is what I’ve been using so far (modified from @DavidGNavas’ excellent Network Chart thread) WITH pairs AS ( … --- ## [פיצוץ פתאומי בצפיות ב-Crawler בגרסה 2.0 beta 1](https://meta.discourse.org/t/sudden-explosion-in-crawler-views-in-2-0-beta-1/78696)
**Author:** [@RyanK](https://meta.discourse.org/u/RyanK)\ **תשובות:** 1\ **עדכון אחרון:** [23 בינואר,‏ 2018,‏ 12:12am UTC](https://meta.discourse.org/t/sudden-explosion-in-crawler-views-in-2-0-beta-1/78696 "2018-01-23T00:12:38Z")
ראיתי עלייה של מעל 200% ב-PVs של סורקי הרשת (על פני שיא השבוע הקודם) למרות שאין שינויים משמעותיים באזורים אחרים. קרה משהו או שאולי זה באג בניתוחים? --- ## [New users within the past week (formatted usernames)](https://meta.discourse.org/t/new-users-within-the-past-week-formatted-usernames/275023)
**Author:** [@outofthebox](https://meta.discourse.org/u/outofthebox)\ **תשובות:** 2\ **עדכון אחרון:** [18 בינואר,‏ 2018,‏ 1:26pm UTC](https://meta.discourse.org/t/new-users-within-the-past-week-formatted-usernames/275023 "2018-01-18T13:26:55Z")
Hi, can anyone provide a data explorer query that provides a list of all new users within the past week and month? It’d be ideal if the format was so they were already @mentioned, making it easy to copy-paste it into a n… --- ## [מישהו משתמש באפליקציית Google Analytics של Cloudflare?](https://meta.discourse.org/t/anyone-using-cloudflares-google-analytics-app/76464)
**Author:** [@SouperC](https://meta.discourse.org/u/SouperC)\ **תשובות:** 3\ **עדכון אחרון:** [28 בדצמבר,‏ 2017,‏ 6:56pm UTC](https://meta.discourse.org/t/anyone-using-cloudflares-google-analytics-app/76464 "2017-12-28T18:56:10Z")
תוהה אם מישהו אחר כאן השתמש ב- Google Analytics "אפליקציה" ב- cloudflare והבחין בזינוק גדול ב bounce ובירידה בצפיות העמודים המדווחות מאז עדכון הגרסה (כשלושה שבועות אחורה). בתחילה הקוד... --- ## [Data Explorer query help: metrics to understand unique individual participants](https://meta.discourse.org/t/data-explorer-query-help-metrics-to-understand-unique-individual-participants/72385)
**Author:** [@southpaw](https://meta.discourse.org/u/southpaw)\ **תשובות:** 9\ **עדכון אחרון:** [4 בדצמבר,‏ 2017,‏ 10:18am UTC](https://meta.discourse.org/t/data-explorer-query-help-metrics-to-understand-unique-individual-participants/72385 "2017-12-04T10:18:11Z")
When I look at an individual topic, I can unfold a list of individuals who have posted on the topic, and the number of times they have done so: Could someone please help me build a query in Data Explorer to determine… --- ## [Discourse metrics](https://meta.discourse.org/t/discourse-metrics/75387)
**Author:** [@testingsoftware](https://meta.discourse.org/u/testingsoftware)\ **תשובות:** 7\ **עדכון אחרון:** [5 בדצמבר,‏ 2017,‏ 10:00pm UTC](https://meta.discourse.org/t/discourse-metrics/75387 "2017-12-05T22:00:25Z")
Hi, I know that if I want more details than the metrics offered by Discourse I need Google Analytics or Piwik… but before adding anything, I‘d like to understand the metrics offered in the Dashboard and About page. I… --- ## [Google Analytics](https://meta.discourse.org/t/google-analytics/74004)
**Author:** [@dfrick](https://meta.discourse.org/u/dfrick)\ **תשובות:** 3\ **עדכון אחרון:** [22 בנובמבר,‏ 2017,‏ 9:48am UTC](https://meta.discourse.org/t/google-analytics/74004 "2017-11-22T09:48:56Z")
Hi - I’m wondering if there’s a way to connect to the reporting data inside Discourse’s dashboard? I’d like to build a dashboard that includes some of the metrics / data that isn’t available via Google Analytics, such as… --- ## [Participation Histograms](https://meta.discourse.org/t/participation-histograms/275022)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **תשובות:** 0\ **עדכון אחרון:** [17 בנובמבר,‏ 2017,‏ 2:42pm UTC](https://meta.discourse.org/t/participation-histograms/275022 "2017-11-17T14:42:55Z")
Participation Histograms (Output from these used to make graphs shown in this post). Posts Read User Counts Number of users who have read at least N posts over the specified time period. -- \[params\] -- int :from\_days\_a… --- ## [User participation](https://meta.discourse.org/t/user-participation/275012)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **תשובות:** 0\ **עדכון אחרון:** [17 בנובמבר,‏ 2017,‏ 2:39pm UTC](https://meta.discourse.org/t/user-participation/275012 "2017-11-17T14:39:42Z")
User participation Shows the following columns over a specified time range (in days): user\_id, username, name, email, visits, topics\_viewed, posts\_read, posts\_cr… --- ## [Awarding badges multiple times with custom SQL](https://meta.discourse.org/t/awarding-badges-multiple-times-with-custom-sql/71279)
**Author:** [@barryvan](https://meta.discourse.org/u/barryvan)\ **תשובות:** 2\ **עדכון אחרון:** [25 באוקטובר,‏ 2017,‏ 10:12am UTC](https://meta.discourse.org/t/awarding-badges-multiple-times-with-custom-sql/71279 "2017-10-25T10:12:32Z")
I have a badge that’s awarded to people who attend one of our regular events. Because it’s not straightforward to grant badges en masse, I’m using custom SQL to grant the badge. What’s not working, though, is receiving t… --- ## [Global statistics on how the number of pageviews correlate to the earnings from ads shown](https://meta.discourse.org/t/global-statistics-on-how-the-number-of-pageviews-correlate-to-the-earnings-from-ads-shown/72271)
**Author:** [@meglio](https://meta.discourse.org/u/meglio)\ **תשובות:** 1\ **עדכון אחרון:** [17 באוקטובר,‏ 2017,‏ 3:13pm UTC](https://meta.discourse.org/t/global-statistics-on-how-the-number-of-pageviews-correlate-to-the-earnings-from-ads-shown/72271 "2017-10-17T15:13:51Z")
Any global statistics on how the number of pageviews correlate to the earnings from ads shown? Will it make any sense to display advertisements for 200k pageviews / month, or will it bring just cents / a few dollars per … --- ## [List best posts forum-wide based on likes](https://meta.discourse.org/t/list-best-posts-forum-wide-based-on-likes/72025)
**Author:** [@LeoB](https://meta.discourse.org/u/LeoB)\ **תשובות:** 2\ **עדכון אחרון:** [13 באוקטובר,‏ 2017,‏ 9:45pm UTC](https://meta.discourse.org/t/list-best-posts-forum-wide-based-on-likes/72025 "2017-10-13T21:45:37Z")
I’m looking for a way for me, as admin, to see a list of the most popular posts, forum-wide, based on the number of likes. Basically a posts-centered version of… Discourse Meta, which lists and allows sorting of users,… --- ## [Difference between Discourse Stats and Google Analytics](https://meta.discourse.org/t/difference-between-discourse-stats-and-google-analytics/70793)
**Author:** [@phani](https://meta.discourse.org/u/phani)\ **תשובות:** 1\ **עדכון אחרון:** [26 בספטמבר,‏ 2017,‏ 10:52am UTC](https://meta.discourse.org/t/difference-between-discourse-stats-and-google-analytics/70793 "2017-09-26T10:52:34Z")
Hi All, Observed 1 million page views in Discourse Dashboard. But my Google Analytics Dashboard shows only 441000 views. There is almost 500K visit difference between Discourse stats and Google Analytics stats. --- ## [יצא רשימה של אנשים שענו לנושא מסוים](https://meta.discourse.org/t/export-a-list-of-people-who-replied-to-a-specific-topic/68756)
**Author:** [@alefattorini](https://meta.discourse.org/u/alefattorini)\ **תשובות:** 7\ **עדכון אחרון:** [25 באוגוסט,‏ 2017,‏ 7:00pm UTC](https://meta.discourse.org/t/export-a-list-of-people-who-replied-to-a-specific-topic/68756 "2017-08-25T19:00:38Z")
לפעמים אני צריך להזכיר קבוצה מסוימת של אנשים שהגיבו לנושא ספציפי לנושא חדש. זה כי אני רוצה לערב אותם בדיון דומה. איך אני עושה את זה במהירות? יש איזה שהוא...? --- ## [Posts per category (with deleted and without deleted)](https://meta.discourse.org/t/posts-per-category-with-deleted-and-without-deleted/275010)
**Author:** [@david](https://meta.discourse.org/u/david)\ **תשובות:** 1\ **עדכון אחרון:** [17 ביולי,‏ 2017,‏ 7:03pm UTC](https://meta.discourse.org/t/posts-per-category-with-deleted-and-without-deleted/275010 "2017-07-17T19:03:35Z")
Posts per category (with deleted and without deleted) I think that by default deleted topics/posts will be included in data-explorer statistics. Doing some quick experimentation on a category where we delete a lot of st… --- ## [Run report of digest Unsubscribes](https://meta.discourse.org/t/run-report-of-digest-unsubscribes/64678)
**Author:** [@SouperC](https://meta.discourse.org/u/SouperC)\ **תשובות:** 3\ **עדכון אחרון:** [4 ביולי,‏ 2017,‏ 9:20pm UTC](https://meta.discourse.org/t/run-report-of-digest-unsubscribes/64678 "2017-07-04T21:20:33Z")
Is there a way I can run a report on which users have unsubscribed from the Discourse digest for my site? I’d like to flag them elsewhere (ActiveCampaign) too so that they don’t have to unsubscribe in to places. Or get … --- ## [Badges predicated on getting a series of other badges?](https://meta.discourse.org/t/badges-predicated-on-getting-a-series-of-other-badges/22471)
**Author:** [@downey](https://meta.discourse.org/u/downey)\ **תשובות:** 4\ **עדכון אחרון:** [24 בנובמבר,‏ 2014,‏ 6:55pm UTC](https://meta.discourse.org/t/badges-predicated-on-getting-a-series-of-other-badges/22471 "2014-11-24T18:55:58Z")
Story: As an admin, I’d like to create a badge that is automatically granted if (and only if) a user has received a certain list of other badges, so that we can create a list of accomplishments/tasks in our community, an… --- ## [Users ordered by creation date](https://meta.discourse.org/t/users-ordered-by-creation-date/275009)
**Author:** [@jomaxro](https://meta.discourse.org/u/jomaxro)\ **תשובות:** 0\ **עדכון אחרון:** [22 ביוני,‏ 2017,‏ 12:37am UTC](https://meta.discourse.org/t/users-ordered-by-creation-date/275009 "2017-06-22T00:37:26Z")
Users ordered by creation date SELECT users.username, users.created\_at FROM users WHERE users.created\_at \< '2017-05-10'::timestamp ORDER BY users.created\_at --- ## [SQL query in Data Explorer to pull latest topics?](https://meta.discourse.org/t/sql-query-in-data-explorer-to-pull-latest-topics/63908)
**Author:** [@sunnyt7](https://meta.discourse.org/u/sunnyt7)\ **תשובות:** 10\ **עדכון אחרון:** [6 ביוני,‏ 2017,‏ 3:25am UTC](https://meta.discourse.org/t/sql-query-in-data-explorer-to-pull-latest-topics/63908 "2017-06-06T03:25:24Z")
Hey there, I’m looking to display something like this on my Wordpress homepage: I’m using @meglio’s Twig Anything to do this, which can pull data from any JSON feed. I’ve tried just using https://meta.discourse.org/… --- ## [Who messaged the most?](https://meta.discourse.org/t/who-messaged-the-most/63963)
**Author:** [@hnaseri](https://meta.discourse.org/u/hnaseri)\ **תשובות:** 7\ **עדכון אחרון:** [5 ביוני,‏ 2017,‏ 6:27pm UTC](https://meta.discourse.org/t/who-messaged-the-most/63963 "2017-06-05T18:27:00Z")
I am seeing suspicious activity in my user to user private message chart. Its been 20 times more in 3 successive days. now how can I detect who has messaged others the most on those days? --- ## [Who has been sending the most messages in the last week?](https://meta.discourse.org/t/who-has-been-sending-the-most-messages-in-the-last-week/275007)
**Author:** [@fefrei](https://meta.discourse.org/u/fefrei)\ **תשובות:** 0\ **עדכון אחרון:** [5 ביוני,‏ 2017,‏ 3:04pm UTC](https://meta.discourse.org/t/who-has-been-sending-the-most-messages-in-the-last-week/275007 "2017-06-05T15:04:05Z")
Who has been sending the most messages in the last week? SELECT user\_id, count(\*) AS message\_count FROM topics WHERE archetype = 'private\_message' AND subtype = 'user\_to\_user' AND age(created\_at) \< interval '7 days' GROU… [Previous page](https://meta.discourse.org/c/community-building/data-reporting/148.md?page=22) [Next page](https://meta.discourse.org/c/community-building/data-reporting/148.md?page=24)