rank_posts
Rank Substack posts by any email metric—views, open rate, signups, or more—in ascending or descending order. Returns paginated results with total count for continuation.
Instructions
Rank posts by one metric from Substack's dashboard email statistics: views, opened, sent, open_rate, click_through_rate, signups, subscribes, estimated_value or post_date, descending or ascending. Returns 10 rows by default, at most 20 (Substack's page limit), with total and next_offset for continuation. One read; nothing is changed. Values are passed through as Substack reports them: this server does not recompute, fill in or estimate metrics, and Substack does not document rate denominators. Each row marks the ranked value as reported, null or absent; null and absent are not zero, and null rates can appear among numeric rows. For one post's stats by ID, use get_post_analytics.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| metric | No | views | |
| offset | No | ||
| direction | No | desc |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| limit | Yes | ||
| total | Yes | ||
| metric | Yes | ||
| offset | Yes | ||
| source | Yes | ||
| has_more | Yes | ||
| ordering | Yes | ||
| returned | Yes | ||
| direction | Yes | ||
| semantics | Yes | ||
| next_offset | Yes | ||
| publication | Yes | ||
| unreported_in_page | Yes |