# Community Building **URL:** https://meta.discourse.org/c/community-building/65.md?ascending=true&page=14 [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) **Page:** 15 --- ## [Working around the 10,000 result limit of data explorer?](https://meta.discourse.org/t/working-around-the-10-000-result-limit-of-data-explorer/315395)
**Author:** [@vladyslav](https://meta.discourse.org/u/vladyslav)\ **Replies:** 2\ **Last updated:** [June 26, 2024, 5:49pm UTC](https://meta.discourse.org/t/working-around-the-10-000-result-limit-of-data-explorer/315395 "2024-06-26T17:49:44Z")
Is there any way to bypass this limit? I want to download all unlisted topics, and there are a lot of them. A lot more than 10k --- ## [Tips for Exporting User Data](https://meta.discourse.org/t/tips-for-exporting-user-data/313711)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 0\ **Last updated:** [June 26, 2024, 12:04am UTC](https://meta.discourse.org/t/tips-for-exporting-user-data/313711 "2024-06-26T00:04:06Z")
When users need customized or detailed data exports that go beyond the basic User Data Export available from their preference page, administrators can perform user data exports using the Data Explorer plugin. This proc… --- ## [Dashboard Report - Consolidated Pageviews with Browser Detection](https://meta.discourse.org/t/dashboard-report-consolidated-pageviews-with-browser-detection/312968)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 5\ **Last updated:** [June 21, 2024, 7:49pm UTC](https://meta.discourse.org/t/dashboard-report-consolidated-pageviews-with-browser-detection/312968 "2024-06-21T19:49:57Z")
This is an SQL version of the Dashboard Report for Consolidated Pageviews with Browser Detection. This Data Explorer report provides a view of daily site pageviews with browser detection over a specified date range. The… --- ## [How do you deal with flag spammers?](https://meta.discourse.org/t/how-do-you-deal-with-flag-spammers/166164)
**Author:** [@Terrapop](https://meta.discourse.org/u/Terrapop)\ **Replies:** 43\ **Last updated:** [June 21, 2024, 12:53pm UTC](https://meta.discourse.org/t/how-do-you-deal-with-flag-spammers/166164 "2024-06-21T12:53:08Z")
We have one user who is constantly flagging many posts per day. Some flags are ok, most of them are not. His flag score is very bad, but the user is congesting the review queue. Would it be feasible to have an option ta… --- ## [Understanding what our users are posting about](https://meta.discourse.org/t/understanding-what-our-users-are-posting-about/312382)
**Author:** [@SStrong](https://meta.discourse.org/u/SStrong)\ **Replies:** 9\ **Last updated:** [June 20, 2024, 11:20am UTC](https://meta.discourse.org/t/understanding-what-our-users-are-posting-about/312382 "2024-06-20T11:20:32Z")
I would like to create a sql based report that can provide an understanding as to what type of thing our users are posting about. Categories, topics, tags - these are the fields I have ascertained that will provide this… --- ## [Discourse has slowly been solving a fatigue I didn't realize I had](https://meta.discourse.org/t/discourse-has-slowly-been-solving-a-fatigue-i-didnt-realize-i-had/308520)
**Author:** [@jordan-violet](https://meta.discourse.org/u/jordan-violet)\ **Replies:** 11\ **Last updated:** [June 20, 2024, 3:48am UTC](https://meta.discourse.org/t/discourse-has-slowly-been-solving-a-fatigue-i-didnt-realize-i-had/308520 "2024-06-20T03:48:26Z")
…death by a thousand (sometimes literally) enterprise applications. I’m fatigued today (and so seem to be many others) by having 1,000 different applications for everything in enterprise today. Inconsistency in UX/UI, ac… --- ## [Community Onboarding on discourse](https://meta.discourse.org/t/community-onboarding-on-discourse/312468)
**Author:** [@saurabhmithal](https://meta.discourse.org/u/saurabhmithal)\ **Replies:** 1\ **Last updated:** [June 18, 2024, 2:21am UTC](https://meta.discourse.org/t/community-onboarding-on-discourse/312468 "2024-06-18T02:21:35Z")
I am leading a community of creatives that is hosted on discourse. https://www.purple.space what tools/best practices do other communities use to help the new members start engaging without feeling overwhelmed? Communi… --- ## [Any tips for starting a new community?](https://meta.discourse.org/t/any-tips-for-starting-a-new-community/311856)
**Author:** [@Micah\_hoffmann](https://meta.discourse.org/u/Micah_hoffmann)\ **Replies:** 4\ **Last updated:** [June 15, 2024, 2:43pm UTC](https://meta.discourse.org/t/any-tips-for-starting-a-new-community/311856 "2024-06-15T14:43:33Z")
I’m installed and logged in as admin :+1: I want to focus on finding the right people to discourse with. In your experience, what are good ways and where are good places to drop your community link? Also, I don’t want… --- ## [How do I calculate the token usage of every user in Discourse AI?](https://meta.discourse.org/t/how-do-i-calculate-the-token-usage-of-every-user-in-discourse-ai/311706)
**Author:** [@whitewaterdeu](https://meta.discourse.org/u/whitewaterdeu)\ **Replies:** 5\ **Last updated:** [June 13, 2024, 2:32am UTC](https://meta.discourse.org/t/how-do-i-calculate-the-token-usage-of-every-user-in-discourse-ai/311706 "2024-06-13T02:32:11Z")
i am using official discourse ai plugin with openai api key Is there any way to calculate the token usage of every user? --- ## [How to properly identify a spammer?](https://meta.discourse.org/t/how-to-properly-identify-a-spammer/228103)
**Author:** [@Canapin](https://meta.discourse.org/u/Canapin)\ **Replies:** 6\ **Last updated:** [May 26, 2022, 1:49pm UTC](https://meta.discourse.org/t/how-to-properly-identify-a-spammer/228103 "2022-05-26T13:49:20Z")
Hey guys. I have several spammers a day on one of my forums. Most of them (95% at least) are recognized either by Discourse, or by Akismet, or are flagged by users when the post is obviously spam. But some spammers lo… --- ## [Sign-up stats](https://meta.discourse.org/t/sign-up-stats/311595)
**Author:** [@Isambard](https://meta.discourse.org/u/Isambard)\ **Replies:** 1\ **Last updated:** [June 11, 2024, 3:53pm UTC](https://meta.discourse.org/t/sign-up-stats/311595 "2024-06-11T15:53:25Z")
Continuing the discussion from Why would the number of all time sign-ups ever decrease?: I imported users from and old forum and they show up in the sign-up stats in About. I set these users as TL1 and set them to inac… --- ## [About fediverse](https://meta.discourse.org/t/about-fediverse/311401)
**Author:** [@David\_Ghost](https://meta.discourse.org/u/David_Ghost)\ **Replies:** 2\ **Last updated:** [June 10, 2024, 9:52pm UTC](https://meta.discourse.org/t/about-fediverse/311401 "2024-06-10T21:52:45Z")
Hey guys, I’m reading about fediverse. I don’t really understand the concept. I have a gamer forum. How can this help improve my community? I need to publish all my posts in the fediverse? I also saw that people use a… --- ## [The road so far](https://meta.discourse.org/t/the-road-so-far/311433)
**Author:** [@eisammy](https://meta.discourse.org/u/eisammy)\ **Replies:** 0\ **Last updated:** [June 10, 2024, 6:35pm UTC](https://meta.discourse.org/t/the-road-so-far/311433 "2024-06-10T18:35:07Z")
I’ve to thankful to Discourse to keep the open source and for fight for a free and respectfully discourses on internet I’ve my own instance did 2 months and 1 day and I’m so glad to help this community to grown around th… --- ## [A discourse community for community admins](https://meta.discourse.org/t/a-discourse-community-for-community-admins/310735)
**Author:** [@saurabhmithal](https://meta.discourse.org/u/saurabhmithal)\ **Replies:** 5\ **Last updated:** [June 7, 2024, 12:42am UTC](https://meta.discourse.org/t/a-discourse-community-for-community-admins/310735 "2024-06-07T00:42:23Z")
Hi, I was wondering if there is a space where the admins of communities (hosted on discourse) can connect. Especially the ones who do not have a tech background. If there is one, please direct me to that. If not, may… --- ## [Discourse vs Reddit](https://meta.discourse.org/t/discourse-vs-reddit/9741)
**Author:** [@Ricky\_Mason](https://meta.discourse.org/u/Ricky_Mason)\ **Replies:** 42\ **Last updated:** [June 6, 2024, 10:20pm UTC](https://meta.discourse.org/t/discourse-vs-reddit/9741 "2024-06-06T22:20:42Z")
This is a question that has popped up in recent conversation between myself and a friend of mine. Personally, I am a big forum user. I love forums, and its easy to see the difference between the quality of discussion i… --- ## [Using the IN operator in Data Explorer](https://meta.discourse.org/t/using-the-in-operator-in-data-explorer/310503)
**Author:** [@albertocottica](https://meta.discourse.org/u/albertocottica)\ **Replies:** 3\ **Last updated:** [June 4, 2024, 1:40pm UTC](https://meta.discourse.org/t/using-the-in-operator-in-data-explorer/310503 "2024-06-04T13:40:07Z")
Hi all, I noticed a strange behavior when editing and running a query in Data Explorer. I am trying to use the WHERE and IN operators to select only posts from topics in certain categories: WHERE t.category\_id IN (… --- ## [Counting number of times a word has been said](https://meta.discourse.org/t/counting-number-of-times-a-word-has-been-said/310282)
**Author:** [@codergautam](https://meta.discourse.org/u/codergautam)\ **Replies:** 1\ **Last updated:** [June 2, 2024, 8:49pm UTC](https://meta.discourse.org/t/counting-number-of-times-a-word-has-been-said/310282 "2024-06-02T20:49:48Z")
I have been curious about checking trends of specific word usage on my forum, is there any query I could use to see how many times a substring has been mentioned by week? --- ## [Badge for popular topic](https://meta.discourse.org/t/badge-for-popular-topic/309938)
**Author:** [@Shauny](https://meta.discourse.org/u/Shauny)\ **Replies:** 5\ **Last updated:** [June 1, 2024, 9:40am UTC](https://meta.discourse.org/t/badge-for-popular-topic/309938 "2024-06-01T09:40:29Z")
Is there a way to grant a badge to someone who created a topic which then got many replies? Say, 100 replies? I’d call it “Popular Topic” and it would encourage people to think of new topic ideas that will generate lots… --- ## [Accessing Postgres Database for Analytics Pipeline](https://meta.discourse.org/t/accessing-postgres-database-for-analytics-pipeline/310045)
**Author:** [@mqmenchaca](https://meta.discourse.org/u/mqmenchaca)\ **Replies:** 2\ **Last updated:** [May 31, 2024, 5:47pm UTC](https://meta.discourse.org/t/accessing-postgres-database-for-analytics-pipeline/310045 "2024-05-31T17:47:29Z")
Hello all, I didn’t quite find a similar post to this, so here goes: My org is building out our analytics dashboards (within Snowflake) and are hoping to integrate the user data we have in Discourse. Currently, we are … --- ## [Very Thankful for Discourse](https://meta.discourse.org/t/very-thankful-for-discourse/309976)
**Author:** [@SethWilliams](https://meta.discourse.org/u/SethWilliams)\ **Replies:** 0\ **Last updated:** [May 30, 2024, 1:52pm UTC](https://meta.discourse.org/t/very-thankful-for-discourse/309976 "2024-05-30T13:52:41Z")
I’ve been running an online community for several years. From 2020 - 2024, we had our forum operating on a different software, and after limping along with it for years, I finally migrated everything back to Discourse. … --- ## [I am pretty impressed with Claude 3 🎉](https://meta.discourse.org/t/i-am-pretty-impressed-with-claude-3/309370)
**Author:** [@Don](https://meta.discourse.org/u/Don)\ **Replies:** 3\ **Last updated:** [May 30, 2024, 5:37am UTC](https://meta.discourse.org/t/i-am-pretty-impressed-with-claude-3/309370 "2024-05-30T05:37:06Z")
Hello :waving\_hand: I want to share a little hint for those who want to set up topic summary AI feature. I tried a lot of model and I was looking for the model which is cheap for massive usage and can recognise the lang… --- ## [Top X posters in a given timeframe](https://meta.discourse.org/t/top-x-posters-in-a-given-timeframe/309724)
**Author:** [@ecki](https://meta.discourse.org/u/ecki)\ **Replies:** 3\ **Last updated:** [May 28, 2024, 3:36pm UTC](https://meta.discourse.org/t/top-x-posters-in-a-given-timeframe/309724 "2024-05-28T15:36:50Z")
Stupid question, is there an reason why there is no “Topics created by User in Timeframe” and “Posts created by User in Timeframe” reports? Seems to me its a commonly asked metric - who was most productive in a given tim… --- ## [Lessons learned from Stacker.news](https://meta.discourse.org/t/lessons-learned-from-stacker-news/309434)
**Author:** [@lisandro\_iaffar](https://meta.discourse.org/u/lisandro_iaffar)\ **Replies:** 2\ **Last updated:** [May 26, 2024, 5:46pm UTC](https://meta.discourse.org/t/lessons-learned-from-stacker-news/309434 "2024-05-26T17:46:43Z")
I would like to share with the community some things I learned from Stacker.news lately, which I think that have a place on Discourse. It all boils down to their economic scheme, regarding how they reward users and how … --- ## [Admin Dashboard number of Views and Views Shown by a DE query are too different](https://meta.discourse.org/t/admin-dashboard-number-of-views-and-views-shown-by-a-de-query-are-too-different/309441)
**Author:** [@Bathinda](https://meta.discourse.org/u/Bathinda)\ **Replies:** 3\ **Last updated:** [May 26, 2024, 12:08pm UTC](https://meta.discourse.org/t/admin-dashboard-number-of-views-and-views-shown-by-a-de-query-are-too-different/309441 "2024-05-26T12:08:44Z")
The number of total views for today 26/5/2024 (excluding crawlers) in the Admin Dashboard are 719 But a Data Explorer query which tracks all topics views separately, topic wise, shows total views to be equal to merel… --- ## [Is there a way to insert a selectable 'mood' emoji next to users?](https://meta.discourse.org/t/is-there-a-way-to-insert-a-selectable-mood-emoji-next-to-users/183611)
**Author:** [@1101010](https://meta.discourse.org/u/1101010)\ **Replies:** 7\ **Last updated:** [May 22, 2024, 7:02pm UTC](https://meta.discourse.org/t/is-there-a-way-to-insert-a-selectable-mood-emoji-next-to-users/183611 "2024-05-22T19:02:21Z")
Hi, We’ve been having some discussion about community harmony and it’s touched on the way a jokey response from one user can be misinterpreted by another, particularly depending on how each is feeling. It was suggested… --- ## [How to improve my Discourse community?](https://meta.discourse.org/t/how-to-improve-my-discourse-community/273833)
**Author:** [@AquaL1te](https://meta.discourse.org/u/AquaL1te)\ **Replies:** 4\ **Last updated:** [April 30, 2024, 1:52pm UTC](https://meta.discourse.org/t/how-to-improve-my-discourse-community/273833 "2024-04-30T13:52:43Z")
Hi, I host the Discourse forum below. I think it’s well designed, I focus the design on making it easy for new and experienced users to get engaged. I think the content that’s being posted is also great, it’s in the c… --- ## [Consolidated API Requests](https://meta.discourse.org/t/consolidated-api-requests/308810)
**Author:** [@Truest](https://meta.discourse.org/u/Truest)\ **Replies:** 0\ **Last updated:** [May 21, 2024, 4:14am UTC](https://meta.discourse.org/t/consolidated-api-requests/308810 "2024-05-21T04:14:31Z")
In the Consolidated API Requests chart, shouldn’t the volume of API key requests from AIs like GPT be included in the statistics for Regular APIs? --- ## [Feedback on our forum & help with email summary template](https://meta.discourse.org/t/feedback-on-our-forum-help-with-email-summary-template/148117)
**Author:** [@Sam\_Gane](https://meta.discourse.org/u/Sam_Gane)\ **Replies:** 2\ **Last updated:** [May 18, 2024, 8:19am UTC](https://meta.discourse.org/t/feedback-on-our-forum-help-with-email-summary-template/148117 "2024-05-18T08:19:18Z")
Hi everyone, We recently launched Made to Measure the Geckoboard community focused on bringing together dashboard users from all over the world to talk metrics, design, setting goals and lots more. I would really love … --- ## [Is there an ideal amount of flags to set before a post is hidden?](https://meta.discourse.org/t/is-there-an-ideal-amount-of-flags-to-set-before-a-post-is-hidden/308233)
**Author:** [@Deads](https://meta.discourse.org/u/Deads)\ **Replies:** 6\ **Last updated:** [May 18, 2024, 8:08am UTC](https://meta.discourse.org/t/is-there-an-ideal-amount-of-flags-to-set-before-a-post-is-hidden/308233 "2024-05-18T08:08:05Z")
Hi all, Just wondering based on your experience of this feature if there is an ideal amount of flags which can be used before a post is hidden? I was thinking of setting it to 3 flags, but just wanted to check to see i… --- ## [Why you should use Discourse internally for your company/team instead of Slack (4 years use case)](https://meta.discourse.org/t/why-you-should-use-discourse-internally-for-your-company-team-instead-of-slack-4-years-use-case/296983)
**Author:** [@Alon1](https://meta.discourse.org/u/Alon1)\ **Replies:** 21\ **Last updated:** [May 16, 2024, 8:44am UTC](https://meta.discourse.org/t/why-you-should-use-discourse-internally-for-your-company-team-instead-of-slack-4-years-use-case/296983 "2024-05-16T08:44:55Z")
We have been using Discourse as the main tool for communication, record keeping, research documenting, lab journaling tool for over 4 years. I will argue that most companies would greatly benefit from having Discourse a… [Previous page](https://meta.discourse.org/c/community-building/65.md?ascending=true&page=13) [Next page](https://meta.discourse.org/c/community-building/65.md?ascending=true&page=15)