This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Product Data Scientist at Reddit. Community Health needs to identify the most engaged comment threads — specifically, those with the deepest reply chains. A thread is rooted at any top-level comment (parent_comment_id IS NULL); every reply, reply-to-reply, etc. extends its depth. The Trust & Safety team uses these depths to flag long brigading chains; the Growth team uses them to surface viral discussions.
You are a Product Data Scientist at Reddit. Community Health needs to identify the most engaged comment threads — specifically, those with the deepest reply chains. A thread is rooted at any top-level comment (parent_comment_id IS NULL); every reply, reply-to-reply, etc. extends its depth. The Trust & Safety team uses these depths to flag long brigading chains; the Growth team uses them to surface viral discussions.