|
Discourse Narrative Bot Data Explorer Queries :robot:
|
|
3
|
2521
|
May 20, 2017
|
|
Search for keywords across posts
|
|
1
|
1088
|
January 27, 2025
|
|
User(s) in a Group who Haven't Voted
|
|
0
|
4834
|
March 13, 2018
|
|
What does 'top referred topics' measure?
|
|
10
|
1299
|
April 9, 2024
|
|
Query to filter users by sign-up 'custom fields'
|
|
11
|
1739
|
January 17, 2022
|
|
View IP address of guests / anonymous visitors?
|
|
13
|
1461
|
January 13, 2022
|
|
Badge granted to our staff members that have read the guidelines placed in our hidden staff category
|
|
11
|
244
|
March 3, 2015
|
|
Web Crawlers
|
|
11
|
1297
|
July 31, 2023
|
|
Time to first response by group members
|
|
13
|
1062
|
October 12, 2023
|
|
Data Explorer + Tableau
|
|
10
|
1946
|
August 6, 2020
|
|
Query to create some groups based on activity
|
|
11
|
884
|
September 5, 2023
|
|
Member Uploads
|
|
0
|
156
|
June 20, 2016
|
|
Track sign-ups on Google Analytics
|
|
9
|
2729
|
March 9, 2021
|
|
Create a "Diary writer" badge
|
|
0
|
4709
|
September 29, 2016
|
|
Attempting to create Monthly Leaderboard query - head exploding
|
|
18
|
1836
|
October 8, 2018
|
|
A silver badge for _each_ 5 bronze badges
|
|
23
|
1527
|
November 10, 2023
|
|
Hour By Hour Statistics
|
|
10
|
693
|
November 16, 2020
|
|
Grant Badge when user visits link
|
|
26
|
1314
|
August 30, 2023
|
|
Can someone tell me how these pageview statistics are even happening?
|
|
11
|
541
|
April 4, 2024
|
|
Badge query for each time posting on a new topic in a category?
|
|
9
|
504
|
April 21, 2024
|
|
What can crawlers see?
|
|
16
|
835
|
February 5, 2024
|
|
Understanding what our users are posting about
|
|
9
|
327
|
June 20, 2024
|
|
Report number of users that have used each login method
|
|
1
|
1273
|
November 10, 2020
|
|
Average number of members' replies per topic (excluding staff)
|
|
16
|
727
|
January 15, 2024
|
|
Retrospectively pulling number of users each calendar month
|
|
9
|
281
|
November 12, 2024
|
|
Filter users likes out if account created x days prior to topic creation
|
|
9
|
848
|
July 22, 2022
|
|
Inconsistent stats from the "User Participation Statistics" query
|
|
10
|
604
|
November 16, 2022
|
|
Email statistics
|
|
1
|
2159
|
November 5, 2016
|
|
'Seen in last X days' badge?
|
|
12
|
211
|
August 26, 2016
|
|
Badges for posting
|
|
4
|
445
|
August 27, 2024
|
|
Recently Read Topics by User
|
|
0
|
168
|
May 4, 2016
|
|
Data Explorer Tutorial - Part 1 - Writing Your First Query
|
|
0
|
1560
|
September 5, 2023
|
|
Adding a direct link to a topic in a data explorer query
|
|
9
|
154
|
August 28, 2024
|
|
Using VALUES or CASE to make your results more readable
|
|
0
|
441
|
August 22, 2023
|
|
Make a badge for the answer with the most likes in a topic!
|
|
4
|
3357
|
March 29, 2016
|
|
Active Readers (Since N Days Ago)
|
|
0
|
184
|
May 1, 2016
|
|
Formatting Data Explorer Table Results
|
|
0
|
918
|
September 5, 2023
|
|
Badges for reading [ :warning: intensive]
|
|
5
|
282
|
August 7, 2015
|
|
Posts created for period
|
|
0
|
198
|
September 14, 2016
|
|
User participation
|
|
0
|
193
|
November 17, 2017
|
|
Common Discourse data tips
|
|
3
|
487
|
August 22, 2023
|
|
Participation Histograms
|
|
0
|
156
|
November 17, 2017
|
|
Top quality users in last six months
|
|
3
|
229
|
January 30, 2019
|
|
Users who’ve become active
|
|
0
|
142
|
July 12, 2019
|
|
The default badge queries
|
|
1
|
934
|
August 27, 2023
|
|
Data Explorer Tutorial - Part 2 - Discourse SQL Basics
|
|
0
|
1309
|
September 5, 2023
|
|
Help modifying a query to return usernames, instead of user ID numbers
|
|
2
|
130
|
January 25, 2018
|
|
A badge granted when someone posts a reply in a single specified topic
|
|
7
|
400
|
June 19, 2018
|
|
Weekly/Monthly/Yearly Signups
|
|
6
|
657
|
January 21, 2024
|
|
Amount of time spent reading by Discourse groups
|
|
4
|
2394
|
April 22, 2018
|