Live video is big for many writers, and a lot of those shows have more than one person on them. When a show ends, Substack posts the recording. Here is the surprise: it is posted to every co-host's publication, under that person's name.
That is friendly for the guests. It is awkward for a site that wants to say "here are the shows this writer hosts." If a recording is on their publication, it does not mean it was their show.
The numbers from one writer
For one writer we built a site for, the archive held 526 recorded lives. Looking up the host of each one showed that 336 were their own shows and 190 were guest spots on someone else's. More than a third of the lives were visits, not hosting. The two people who hosted them most had 40 and 39 of those shows.
Without a lookup, we would have listed all 526 as that writer's own.
How we find the real host
When the archive is read (crawl.mjs), each post that is a recorded live carries a stream id. For each id, we ask Substack's live stream record who started it. The answer names a user and a publication. If that is the writer or one of their publications, the show is theirs and is stored as 0. Otherwise we store the host's handle, name and publication, so the site can say "Guest spot" and name the host.
Two choices keep this polite:
- One lookup per live, ever. The answer is saved. Later runs only look up new lives, paced about 0.4 seconds apart, and at most 800 in a run.
- A gone show is not asked about again. If Substack says the stream no longer exists, we mark the host as unknown and move on.
This is the same attitude as being a good guest in how we treat platforms: ask once, remember the answer, and don't knock again. The first full run was slow, over ten minutes, because every live needed its own lookup. Later runs are quick.
Counting a show once
The same show often exists several times: a video post, an audio post, and a recording on each co-host's publication. We merge shows when they share a stream id, have the same title, or have the same guests within two days. That way nobody is counted twice. A post that sits on a writer's publication but was not made by them is kept in the archive, but never counted as their show.
The guests A to Z
With hosts and guests known, a second page becomes possible. Substack lists the people on a live as extra bylines, so for each show we keep each guest's handle, name, photo and, when they run one, the publication to subscribe to.
The guests page for that same writer had 182 guests and hosts, 79 of whom have a publication of their own. The page offers:
- An A to Z list with letter headings, or sorted by most shows or most recent.
- A shows view, sorted by date either way.
- A topic menu and a search that matches guest names, show titles and topics.
- One guest's shows when you pick them, with a Subscribe button to their publication, or a Follow link to their Substack profile when they have none.
A site shows the Guests link and the "All guests" shortcut only when a writer has three or more.
Looking ahead too
The upcoming-shows calendar uses the same idea. For a scheduled live, our server function reads both accepted and invited guests (up to 12), so a visitor can see who is joining before it starts.
The lesson is small and general: a platform's data tells you where something was posted, not always who made it. When the difference matters, ask for the source. You can see the result on any creator site with guest spots.
← All posts