← All AI writing use cases
Content ideation

Feed a year of channel analytics to AI and ask for your next 10 videos

Tools:
Claude, ChatGPT
Who it's for

Founders with a YouTube channel, newsletter or podcast that has a year of data

What they report

No metric reported. Ali Abdaal downloaded 365 days of YouTube analytics as a CSV and asked Claude for the next 10 videos to maximize views and subscriber growth. It also noted his top videos averaged about 35 minutes and suggested 30 to 40 minute videos. He then asked for 'a level two and three response' to go deeper.

Example

Abdaal's follow-up: 'You've given me a level one response. I want you to go deeper and give me a level two and three response.' He calls it a fun thing to try with almost any prompt.

from source

How to do it

  1. Export 12 months of analytics (YouTube Studio advanced mode, newsletter platform, or X).
  2. Upload the CSV and run the prompt.
  3. Ask for level two and level three answers.
  4. Pick ideas that fit what you actually know.

The prompt

Fill in the [brackets]
Copy prompt

This is analytics data from my [YouTube channel / newsletter] for the last 12 months. Analyze it and, based on the data, suggest the next 10 [videos / issues] I could make if I wanted to maximize views and subscriber growth. For each, give the title and the data pattern it's based on. (Then:) You've given me a level one response. I want you to go deeper and give me a level two and three response.

Prompt:
Adapted from the prompts spoken in the source
Source:
Ali Abdaal, 'How I use AI to save 10+ hours per week' (YouTube, Feb 14, 2025)
Read the original ↗
Legacy Builder Lab

Want help putting these to work every week?

Legacy Builder Lab is Clifton Sellers' community for founders who write their own content with AI. Members get his prompts and bot setups, five new post templates every Monday and a monthly live teardown.

Join the Lab waitlist
Run by Clifton Sellers, who also curates this library.