Bound the corpus
Select the relevant channels and define a publication period so the ranking answers a research question rather than mixing unrelated histories.
Workflow · Reaction ranking
Find the most reacted Telegram posts in a selected corpus
Rank measured posts from selected Telegram channels by captured reaction total, with reaction breakdowns, snapshot timing, coverage, and citations.
Direct answer. The Ocean can order eligible logical posts from selected channels and an optional period by their latest captured reaction total. Each result keeps views, forwards, reaction types, snapshot age, observation time, text, and a permalink. Because latest snapshots can represent different post ages, close values should be treated cautiously and incomplete coverage cannot establish a global winner.
Research fit
Who this workflow is for
Researchers building a review queue of unusually reacted-to publications who need deterministic ordering and evidence but do not want a popularity list mistaken for credibility or audience sentiment.
Choose reactions only
Make reactions_total the ordering field. Views and forwards remain companion context and cannot silently change the rank.
Deduplicate logical posts
Telegram albums are treated as one logical publication so multiple media parts do not occupy several ranking positions.
Read measurement age
The latest captured snapshot is used for every eligible post, but those snapshots may come from different post ages; disclose that before interpreting small gaps.
Review the leaders
Open each cited post and inspect its wording, media, date, and reaction breakdown before selecting examples or escalating a finding.
Practical module
Reaction-ranked review queue
A useful ranking states exactly what was ordered, which posts were eligible, and why unmeasured publications were excluded.
Rank metricCaptured reactions_total only, sorted descending without a blended or model-generated popularity score.
Eligibility scopeSelected sources, publication dates, logical-post deduplication, and the total number of candidate items.
Measured subsetHow many eligible posts had a usable captured reaction value and how many remained unavailable.
Snapshot contextPost-age horizon and observed-at time for each result, retained to expose unequal measurement ages.
Reaction detailAvailable emoji, custom-emoji, and paid-reaction rows attached to each winning post.
Evidence reviewPost text and permalink used to verify relevance and prevent engagement from substituting for content analysis.
Analysis contract
What the calculation actually does
Postgres selects one logical item per Telegram publication, reads the latest captured snapshot with a non-null reactions_total, sorts descending, and returns at most the configured ranking limit.
Scope
Ready Telegram sources selected for the conversation, optionally constrained by publication start and end times. Posts without a usable captured reaction value remain outside the measured ordering.
Measured fields
- Reaction rank
- Total reactions
- Reaction-type breakdown
- Views and forwards
- Snapshot age
- Measured versus eligible coverage
Coverage rules
- Albums are deduplicated to one logical post
- Null or absent reaction snapshots are excluded, not zero-filled
- Partial measurement prevents a global-winner claim
- Different post ages require caution for close scores
- Every presented row retains post text and citation
Questions to ask
- What are the ten most reacted posts in these channels this month?
- Show the most reacted post from each selected channel with the reaction breakdown.
- Rank reactions for the posts in the previous result and report coverage.
Most-reacted-post ranking recipe
A deterministic ranking specification for turning captured reactions into a bounded evidence-review queue.
Within [selected channels] from [start] to [end], rank the top [N] logical posts by captured reactions_total. Include text, permalink, views, forwards, reaction breakdown, snapshot age, observation time, eligible count, measured count, and missing coverage. Do not call the first row a global winner when coverage is incomplete.
engagement ranking
Sort eligible logical posts descending by latest captured reactions_total; exclude null or missing snapshots and report the measured subset.
Inputs to set
- Selected channels
- The explicit ready-source set included in the ranking.
- Publication period
- A shared start and exclusive end bound for candidate posts.
- Result size
- The top-N limit or one leading result per selected channel.
- Review purpose
- The decision that will be made after opening and reading ranked posts.
Expected output
- Ordered post list by captured reactions
- Companion metrics and reaction types
- Snapshot age and observation timestamp
- Eligible and measured coverage
- Direct evidence link for every result
Coverage rules
- Exclude missing reaction values instead of zero-filling
- Deduplicate albums before ranking
- Warn when snapshots represent different post ages
- Do not infer sentiment from reaction rank
- Open every selected leader before using it externally
Read the complete resource
# Most-reacted-post ranking recipe A deterministic ranking specification for turning captured reactions into a bounded evidence-review queue. ## Calculation - Mode: engagement_ranking - Formula: Sort eligible logical posts descending by latest captured reactions_total; exclude null or missing snapshots and report the measured subset. ## Query Within [selected channels] from [start] to [end], rank the top [N] logical posts by captured reactions_total. Include text, permalink, views, forwards, reaction breakdown, snapshot age, observation time, eligible count, measured count, and missing coverage. Do not call the first row a global winner when coverage is incomplete. ## Inputs - **Selected channels:** The explicit ready-source set included in the ranking. - **Publication period:** A shared start and exclusive end bound for candidate posts. - **Result size:** The top-N limit or one leading result per selected channel. - **Review purpose:** The decision that will be made after opening and reading ranked posts. ## Expected output - Ordered post list by captured reactions - Companion metrics and reaction types - Snapshot age and observation timestamp - Eligible and measured coverage - Direct evidence link for every result ## Coverage checks - [ ] Exclude missing reaction values instead of zero-filling - [ ] Deduplicate albums before ranking - [ ] Warn when snapshots represent different post ages - [ ] Do not infer sentiment from reaction rank - [ ] Open every selected leader before using it externally
Boundaries
What this does not establish
- The ranking covers measured posts inside selected sources only
- Latest snapshots can represent different ages after publication
- Missing metrics are excluded rather than ranked at zero
- High reactions do not prove support, authenticity, or accuracy
- The result is not a global Telegram popularity leaderboard
Founding research pilot
Apply with a reaction-ranking workflow
Bring one recurring research job and a small set of public sources. We will assess fit personally before offering a pilot.
Apply for a 14-day research pilot
30 founding researcher places · rolling admission · personal reply within 2 business days
Analytics cluster
More ways to investigate this result
Continue researching
Related guides
Publication notes. This page was reviewed before publication and is scheduled for review by 2026-12-19. Facts used: product-chat-metric-ranking · product-chat-reaction-breakdown · product-chat-coverage-reasons · product-citations