# TL2 gap - so small yet so large

**URL:** <https://meta.discourse.org/t/tl2-gap-so-small-yet-so-large/221126>\
**Category:** Community Building\
**Tags:** trust-levels\
**Created:** [March 16, 2022, 3:32pm UTC](https://meta.discourse.org/t/tl2-gap-so-small-yet-so-large/221126 "2022-03-16T15:32:09Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![ganncamp](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ganncamp/32/106199_2.png) [@ganncamp](https://meta.discourse.org/u/ganncamp)\
**Post date:** [March 16, 2022, 3:32pm UTC](https://meta.discourse.org/t/tl2-gap-so-small-yet-so-large/221126/1 "2022-03-16T15:32:09Z")

</div>

I’ve been looking at trust level gap reporting lately. Specifically TL2 & what’s keeping users from being promoted from TL1 to TL2.

Looking at usrs’ gaps has made me realize how much of this _is_ about _community_. It’s not just about _my_ questions and _my_ opinions. It’s about engaging with other users too. And that’s great.

And yet I find it kinda depressing to realize how many users are _so close_ to TL2, and are “just” missing… “giving back”.

I’m wondering if anyone (parents of 2-year-olds, perhaps? 😂 ) has any thoughts about how to encourage folks to a spirit of community & thinking of / helping others…?

For reference:

 ![Selection_056](https://global.discourse-cdn.com/meta/original/3X/5/9/5978ff0326cdb583ae8c8677611d0552f10a0206.png)

> **Data Explorer Query**
>
> For those who want the query:
> 
> ```plaintext
> with
> 
> -- Trust Level 1 users
> tl AS (
> SELECT id as user_id, trust_level, last_seen_at
> FROM users
> WHERE trust_level = 1
> ),
> 
> -- Users seen in last 3mo + visits, posts read, reading time
> pr AS (
> SELECT user_id, 
> count(1) as visits,
> sum(posts_read) as posts_read,
> SUM(time_read)/60 as minutes_reading_time,
> DATE(last_seen_at) AS last_seen
> FROM user_visits
> INNER JOIN tl using (user_id)
> WHERE DATE(last_seen_at) >= CURRENT_DATE - INTERVAL '3 month'
> GROUP BY user_id, last_seen
> ORDER BY visits, last_seen DESC
> ),
> 
> -- Topics replied to
> trt as (
> select posts.user_id,
> count(distinct topic_id) as replied_count
> from posts
> INNER JOIN tl using (user_id)
> INNER JOIN topics ON topics.id = posts.topic_id
> WHERE topics.user_id <> posts.user_id
> AND posts.deleted_at IS NULL AND topics.deleted_at IS NULL
> -- AND topics.archetype <> 'private_message'
> AND archetype = 'regular'
> GROUP BY posts.user_id
> ORDER BY replied_count DESC
> ),
> 
> -- Topics Viewed All Time
> tvat as (
> select tv.user_id,
> COUNT(distinct tv.topic_id) AS topic_id
> FROM topic_views tv
> LEFT JOIN topics t on tv.topic_id=t.id
> INNER JOIN tl on tv.user_id=tl.user_id
> WHERE 
> t.archetype = 'regular'
> AND t.deleted_at is null
> group by tv.user_id
> ),
> 
> likes AS (
> SELECT user_id,
> likes_given, likes_received
> from user_stats
> INNER JOIN tl using (user_id)
> )
> 
> SELECT pr.user_id, 
> pr.last_seen as "Last seen",
> -- days visited: 15
> greatest(15-coalesce(pr.visits,0),0) as "Days visited gap",
> -- topic replies: 3
> greatest(3-coalesce(trt.replied_count,0), 0) as "Topic reply gap",
> -- topics entered: 20
> greatest(20-coalesce(tvat.topic_id,0),0) as "Topic viewed gap",
> -- posts read: 100
> greatest(100-coalesce(pr.posts_read,0),0) as "Posts Read gap",
> -- time spent reading posts: 60min
> greatest(60-pr.minutes_reading_time,0) as "Reading time gap",
> -- likes given: 1
> greatest(1-likes.likes_given,0) as "Likes given gap",
> -- likes received: 1
> greatest(1-likes.likes_received,0) as "Likes received gap"
> 
> FROM pr
> left join trt using (user_id)
> left join tvat using (user_id)
> LEFT JOIN likes using (user_id)
> 
> ORDER BY
> pr.visits DESC
>   
> LIMIT 500
> 
> ```

---

_[View the full topic](https://meta.discourse.org/t/tl2-gap-so-small-yet-so-large/221126)._