Subscription autopsy: keep / downgrade / cancel with a 10-minute ritual
Caption-backed faceless outline for “Subscription autopsy: keep / downgrade / cancel with a 10-minute ritual” in Frugal living explained: hook, timed timeline, cited facts, and originality notes from 2 uploader-caption reference(s).
Angles
- Caption-timed outline for: Subscription autopsy: keep / downgrade / cancel with a 10-minute ritual
- Caption-backed references: 16vO6nd-fUU (~9:14); Bm_-Gq-H-4Q (~3:51)
- Reuse timed beats and cited facts only — original narration; timestamps on screen
Hook
0:00–0:40: Cold-open on a caption-backed beat from the lead reference (16vO6nd-fUU@0:00): “A few subscriptions you barely use might not seem like a big deal, but over time they could be costing you tens of thousands of dollars.” Promise a usable faceless outline for “Subscription autopsy: keep / downgrade / cancel with a 10-minute ritual” with timed facts — original narration only. 16vO6nd-fUU@0:00 Bm_-Gq-H-4Q@0:07
Structure timelineExpandCollapse
16vO6nd-fUU 0:00–1:06— A few subscriptions you barely use might not seem like a big deal, but over time they could be costing you tens of thousands of dollars.16vO6nd-fUU 1:13–2:27— I've got a row ready to go for my first item. Enter the name, the category, the cost, whether it's monthly or annual.16vO6nd-fUU 2:32–3:48— Now, the subscription count is simply the count of the names. And then just hover your mouse above the column until it turns into the down arrow.16vO6nd-fUU 3:53–4:54— but you can use the drop-downs to sort smallest to largest or largest to smallest. Next, let's summarize the subscriptions by category.16vO6nd-fUU 5:02–6:02— Now I'm just going to hold down Alt and bring it over here to snap it to the cells and resize it.16vO6nd-fUU 6:09–7:19— And I want to return the first column and the fifth column, which is the annual cost.Bm_-Gq-H-4Q 0:07–1:08— THIS MORNING ON "TODAY'S THIS MORNING ON "TODAY'S THIS MORNING ON "TODAY'S CONSUMER," WE'RE HITTING THE CONSUMER," WE'RE HITTING THE CONSUMER," WE'RE HITTING THE RESET BUTTON ON SU…Bm_-Gq-H-4Q 1:08–2:09— YOU LINK THEM TO YOUR BANK YOU LINK THEM TO YOUR BANK YOU LINK THEM TO YOUR BANK ACCOUNT OR YOUR CREDIT CARD ACCOUNT OR YOUR CREDIT CARD ACCOUNT OR YOUR CREDIT CARD ACCOUNT, AND TH…Bm_-Gq-H-4Q 2:09–3:11— GET OUT A HIGHLIGHTER, PRINT OUT GET OUT A HIGHLIGHTER, PRINT OUT GET OUT A HIGHLIGHTER, PRINT OUT YOUR STATEMENTS, GO THROUGH THEM YOUR STATEMENTS, GO THROUGH THEM YOUR STATEMENTS…Bm_-Gq-H-4Q 3:12–3:51— IS THERE AN EASIER WAY TO CANCEL IS THERE AN EASIER WAY TO CANCEL IS THERE AN EASIER WAY TO CANCEL A SUBSCRIPTION SERVICE?
Caption-backed factsExpandCollapse
- A few subscriptions you barely use might not seem like a big deal, but over time they could be costing you tens of thousands of dollars. This Excel subscription audit brings every subscription together, converts monthly and annual fees into one comparable figure, and shows you exactly where your money's going.
16vO6nd-fUU@0:00 - I've got a row ready to go for my first item. Enter the name, the category, the cost, whether it's monthly or annual. And then for the annual cost, I can use the IF function to test if this cell equals Month. If it does, then I need to take my cost times 12.
16vO6nd-fUU@1:13 - Now, the subscription count is simply the count of the names. And then just hover your mouse above the column until it turns into the down arrow. Left-click once to select it and press Enter. The annual cost is the sum of my Annual Cost column, and therefore the monthly cost is the annual cost divided by 12.
16vO6nd-fUU@2:32 - but you can use the drop-downs to sort smallest to largest or largest to smallest. Next, let's summarize the subscriptions by category. And I'll use the GROUPBY function to do this. The values argument will be the annual cost.
16vO6nd-fUU@3:53 - Now I'm just going to hold down Alt and bring it over here to snap it to the cells and resize it. So, with it selected, Ctrl+1 to open the formatting, and let's change the hole size to 55%. And we'll go into the formatting border and select the outer edge of the chart and apply rounded corners just for a more modern effect.
16vO6nd-fUU@5:02 - And I want to return the first column and the fifth column, which is the annual cost. And I can simply reference the Cancel column because, remember, when the checkbox is checked, the cell contains TRUE, which will tell FILTER to include it.
16vO6nd-fUU@6:09 - YOU LINK THEM TO YOUR BANK YOU LINK THEM TO YOUR BANK YOU LINK THEM TO YOUR BANK ACCOUNT OR YOUR CREDIT CARD ACCOUNT OR YOUR CREDIT CARD ACCOUNT OR YOUR CREDIT CARD ACCOUNT, AND THEY WILL PUT ACCOUNT, AND THEY WILL PUT ACCOUNT, AND THEY WILL PUT EVERYTHING IN ONE SINGLE LIST.
Bm_-Gq-H-4Q@1:08 - GET OUT A HIGHLIGHTER, PRINT OUT GET OUT A HIGHLIGHTER, PRINT OUT GET OUT A HIGHLIGHTER, PRINT OUT YOUR STATEMENTS, GO THROUGH THEM YOUR STATEMENTS, GO THROUGH THEM YOUR STATEMENTS, GO THROUGH THEM AND HIGHLIGHT EVERYTHING.
Bm_-Gq-H-4Q@2:09
Beat-by-beat structure
- Hook (0:00–0:40): A few subscriptions you barely use might not seem like a big deal, but over time they could be costing you tens of thousands of dollars. (16vO6nd-fUU@0:00).
- Beat 1: A few subscriptions you barely use might not seem like a big deal, but over time they could be costing you tens of thousands of dollars. This Excel subscription audit brings every subscription togethe… (16vO6nd-fUU@0:00).
- Beat 2: I've got a row ready to go for my first item. Enter the name, the category, the cost, whether it's monthly or annual. And then for the annual cost, I can use the IF function to test if this cell equal… (16vO6nd-fUU@1:13).
- Beat 3: Now, the subscription count is simply the count of the names. And then just hover your mouse above the column until it turns into the down arrow. Left-click once to select it and press Enter. The annu… (16vO6nd-fUU@2:32).
- Beat 4: but you can use the drop-downs to sort smallest to largest or largest to smallest. Next, let's summarize the subscriptions by category. And I'll use the GROUPBY function to do this. The values argumen… (16vO6nd-fUU@3:53).
- Beat 5: Now I'm just going to hold down Alt and bring it over here to snap it to the cells and resize it. So, with it selected, Ctrl+1 to open the formatting, and let's change the hole size to 55%. And we'll … (16vO6nd-fUU@5:02).
- Close: Recap card with three timed citations + sources on screen. Original narration only.
Transitions
- After the cold-open, title card the spine of “Subscription autopsy: keep / downgrade / cancel with a 10-minute ritual” so viewers know the promise.
- Between references, hard-cut with a lower-third showing video id + timestamp so research stays auditable.
- Before the close, freeze a recap card of 3 caption-backed numbers or names from the facts list.
Close / CTA
End on a recap card for “Subscription autopsy: keep / downgrade / cancel with a 10-minute ritual” listing 3 timed citations (16vO6nd-fUU@0:00, 16vO6nd-fUU@1:13, 16vO6nd-fUU@2:32); invite comments for the next sub-angle. Original narration only — reuse beats, not scripts.
Reference compare
- 16vO6nd-fUU: ~9:14, 8 segments, ~8715 caption chars — use for timed beats only.
- Bm_-Gq-H-4Q: ~3:51, 4 segments, ~10159 caption chars — use for timed beats only.
- Split screen time by which tape carries denser on-topic segments; do not give equal minutes by default.
Originality notes
- Write original TTS; put video titles and timestamps in lower-thirds as research citations.
- Do not paste host jokes, sponsor reads, or end-slate CTAs from the references.
- Prefer concrete timed facts over vague ‘experts say’ language.
- If a claim is not backed by a timestamp above, cut it or mark it as your own hypothesis on screen.
Reference videos
- ULTIMATE Subscription Audit & Dashboard in Excel (FREE Template)
16vO6nd-fUU - How to track, manage (and cancel) your subscriptions
Bm_-Gq-H-4Q
Method
yt-dlp VTT captions (uploader-provided, not auto/ASR) → full-caption 60–90s timestamped segments (keyword-locate on long videos) → editorial topic synthesis. Structure only; write original narration.