Appearance
Source type — the full vocabulary
Recorded vocabulary snapshot. This page is generated from a saved database extract, not a live connection. Rebuilding the site does not refresh its measurements. Draft wording comes from review notes; check recorded decisions for approved meaning. Stored values alone do not prove current prompt or filter behavior.
There are 12 registered values, and 15 more words in use that are not registered.
Where it is stored: content_item.source_type — 13,944 rows carry a value.
How the registry and the data line up: 3 of the 12 registered values appear in the data, and 15 words appear that are not registered.
What this describes
— no definition written yet.
The values
| Value | Stored as | In use | Recorded wording |
|---|---|---|---|
instagram | 2,489 | Instagram post/reel via API | |
| YouTube | youtube | 1,229 | YouTube video via API + yt-dlp |
| Vendor Portfolio | vendor_portfolio | 21 | Studio/agency/production-co case-study page via firecrawl scrape (VENDOR-CASE-STUDY-INGESTION.md) |
| Hls stream | hls_stream | — | — |
| Instagram video | instagram_video | — | — |
| Meta ad video | meta_ad_video | — | — |
| Scene7 video | scene7_video | — | — |
| Tiktok video | tiktok_video | — | — |
| Vimeo video | vimeo_video | — | — |
| RSS | rss | — | Article via RSS feed scraping |
| Website | website | — | Website page via crawl |
| Manual | manual | — | Admin manual upload |
Words in use that nobody registered
Each of these was written into the data without a registry row behind it. A word that is not registered cannot be offered as a choice, defined, or counted on.
| Word | Rows carrying it |
|---|---|
landing_page | 5,908 |
meta_ad | 1,843 |
linkedin_ad | 1,084 |
twitter | 826 |
tiktok | 281 |
newsroom_rss | 131 |
blog_rss | 57 |
newsroom_rss_image | 22 |
blog_rss_image | 16 |
web | 10 |
newsroom_sitemap | 9 |
landing_page_image | 8 |
embedded_video | 4 |
embedded_youtube | 3 |
newsroom_sitemap_image | 3 |
Registered, never used
9 of the 12 registered values have never been written to a row. For a young axis that is expected; for an old one it is a question worth asking.
hls_stream, instagram_video, meta_ad_video, scene7_video, tiktok_video, vimeo_video, rss, website, manual
How complete this page is
Of 12 registered values, 6 carry a written definition (50%) and 0 carry tagging rules (0%). These counts are calculated from the saved database extract. They describe that snapshot, not a fresh database check.
Where to look next
- What this is FOR, in plain language — the Content chapter.
- Every other vocabulary — the vocabulary index.
- What is still undecided about it — the open questions.
- The exact tables and columns — the data reference.