I have seen that this badge exists for users who visit the forum consecutively for 10 or 365 days, but I want to create an automatic badge in my forum that is awarded to a person who visited the forum for 30 consecutive days. Above all, what I’m interested in is getting the SQL. [image]

FWIW, you can find the existing queries using the Data Explorer. e.g: SELECT * from badges WHERE query LIKE '%10 days%' Here’s the one for 365 days: WITH consecutive_visits AS ( SELECT user_id , visited_at , visited_at - (DENSE_RANK() OVER (PARTITION BY user_id ORDER BY visited_at))::int s FROM u…

30 days visitor badge

Support

system (system) Closed September 8, 2020, 8:35pm 7

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Checking badge eligibility Data & reporting sql-query	4	454	July 16, 2020
'Seen in last X days' badge? Data & reporting sql-triggered-badge	12	123	August 26, 2016
Does Discourse track consecutive days active? Data & reporting badges , sql-query	4	54	January 30, 2025
Devotee Badge and Timezones, relaxing requirements? Feature badges	3	1346	March 17, 2020
Help optimize SQL query for a custom badge extracting number of words and images, and counting days posted in a topic Data & reporting sql-triggered-badge	2	464	February 8, 2020

30 days visitor badge

Related topics