op3_new_vs_returning
op3_new_vs_returningSplit a show's listeners into first-time and returning by comparing a recent window against a longer baseline, showing if the show reaches new people or serves the same audience repeatedly.
Instructions
Split a show's listeners in a window into first-time and returning, by comparing against a longer baseline period immediately before it. Answers whether a show is reaching new people or serving the same audience repeatedly. The baseline length matters: a short baseline calls a monthly listener new, so it defaults to four times the window and both sizes are reported so you can judge the answer.
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. | |
| baseline_multiplier | No | How many window-lengths of history to treat as the baseline. Higher is more accurate and slower. 4 means a 30-day window is compared against the 120 days before it. |