op3_episode_overlap
op3_episode_overlapCompare a show's busiest episodes to reveal audience overlap. Reports shared listeners and similarity to show whether a spike brought new listeners or just repeated downloads.
Instructions
Which episodes share an audience. For each pair of a show's busiest episodes, reports shared listeners, a symmetric similarity, and the share of the smaller episode's audience that also heard the other. Read the smaller side's share first: for one big episode and one small one the symmetric number is always near zero, while the smaller side's share tells you whether a spike brought genuinely new people or just gave the existing audience another download.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end | No | Window end, same formats as start. Defaults to now. | |
| bots | No | Include downloads from known bots. Off by default, which matches how OP3's own download counts are computed. | |
| start | No | Window start. A relative value like -30d, -8w or -3m, a date like 2026-08-01, or an ISO timestamp. Defaults to -30d. Wider windows are slower: this reads raw rows, not a rollup. | |
| identifier | Yes | An OP3 show uuid, a podcast:guid, or the show's RSS feed URL. | |
| top_episodes | No | How many of the busiest episodes to compare. Pairs grow quadratically, so 6 gives 15 pairs and 15 gives 105. |