Is there a method to get a sorted list of users who might become Trust Level 3? Maybe using the Data Explorer plugin and a query (?)

That’s an interesting question. There will be no specific query since each member ‘earns’ TL3 through interaction and engagement, but you could monitor the TL2 users to see who are visiting most regularly and engaging with more content I suppose. Is there a reason to find this in advance rather tha…

I thought about TL3 Requirements Checking which users have the most number of :white_check_mark: Requirements and sort by that

You could do that, write a query to track the key fields and limit it to current TL2 users There are loads of great query ideas for Data Explorer in another thread, and it seems that you could do a version of the User Directory, with the TL2 limit, to answer your query. [图片] …

Though I have no doubt that some form of query could be put together, I have serious doubt that the amount of work needed would justify the questionable value of the results. It is one thing to do this per user from a members admin user page, a whole different story for many accounts all at once. A…

I have the beginnings of this progress towards level 3 report which allows admins to view the progress of users so far, which I want to then use to email out messages of encouragement to users who are close (We like to promote TL3 user who share our tone of voice to moderators) Someone kindly sent …

Great start here, thanks! I made a few tweaks / fixes: Added ‘posts_read > 0’ condition for more accurate user visits calculation Removed ‘visits (all time)’ which didn’t seem to be necessary Fixed ‘topics viewed’ calculations which was using the wrong table Added current trust level (to only get…

This seems to be exactly what I am searching for, however, I get the following error when executing the query: PG::QueryCanceled: ERROR: canceling statement due to statement timeout Any ideas how to make this work?

Hello, This report returns Total topics Total topics in AT but the requirements for TL3 use Total topics excluding private messages. Total topics in AT excluding private messages. Anyone knows how to adapt the query to exclude the private messages? Thanks in advance

[图片] anon54446237: Did you try increasing the threshold parameter? Yes, tried that: 60, 80, 95, 99 → no effect at all, always the same error message.

Here’s a modified version with no parameters: I have lazily (efficiently?) hard-coded the default TL3 requirements into the query. I have expanded the data set slightly to include likes given and received, although not likes/unique days or likes/unique users. Flags, silences and suspensions are also…

找出更可能成为TL3的用户

社区数据与报告

robmc (Robert McIntosh) 2018 年7 月 3 日 17:07 4

你可以这样做，编写一个查询来跟踪关键字段，并将其限制为当前的 TL2 用户。

在另一个主题中有很多关于 Data Explorer 的优秀查询思路，看起来你可以创建一个带有 TL2 限制的“用户目录”版本，来回答你的问题。

仍然很好奇你想通过“预测”TL3 来实现什么目标。听起来像《少数派报告》；)

话题		回复	浏览量
Data Explorer query to show progress towards trust level 3 requirements Data & reporting sql-query	2	2985	2023 年4 月 29 日
Requirements for Trust Level 3 Data & reporting sql-query	0	87	2025 年12 月 15 日
How many TL3 users do you have? Do the TL3 requirements really make sense? Community Building	42	2792	2023 年3 月 12 日
Allow users to see trust level 3 progress on user profile Feature trust-levels	45	6441	2026 年2 月 19 日
Help finding some monthly site stats about topics and user trust levels Data & reporting sql-query	22	5571	2021 年11 月 12 日

找出更可能成为TL3的用户

相关话题