← Back to home

Making Claude Code My Head of Growth — Handing It a Month of Cross-Platform Data

Long-Form Video · EP0034 June 9, 2026 10:14
What this episode covers

Nearly a month of daily posting, 32 videos, over ten thousand new followers across all platforms. This episode I try something different: dump the backend data from five platforms into Claude Code and let it act as my "head of growth" for a full review.

First it merges the Excel exports from each platform into one master table — strong performers get dark cells, weak ones light cells, so you can tell them apart at a glance. Then it digs into completion rate, follower growth, and cover click-through platform by platform, and finds the real reason each piece did well or badly. Finally it hands me an immediately actionable optimization checklist and a topic bank per platform, and writes all of it into memory so it iterates automatically on the next episode's publishing run — which means the post you're looking at was itself made to its own recommendations.

Companion downloads · Feed them to your Claude Code

I’ve been posting daily for nearly a month now — 32 videos so far, roughly ten thousand-plus new followers across all platforms. Not bad. Today I’ll try something different: dump all the backend data from all five of my platforms into Claude Code and see what kind of analysis, and what next-step recommendations, today’s AI can give me at the level of a short-video growth lead.

First, merge into one master table

Open the page and it starts with five core conclusions, telling me roughly where each platform stands. I’d exported the per-video data from every platform as Excel and handed all of it over, so it merges those sheets into one complete master table with the key metrics from each platform folded in — strong performers get a dark background cell, weak ones a light cell. A genuinely clear data overview.

Completion rate can’t be compared across the board

Next it goes platform by platform. For WeChat Channels, for instance, it built a quadrant chart showing me which episodes had both a high completion rate and solid view counts.

On completion rate, it classifies the videos first. Because WeChat Channels currently gives extra distribution support to videos over 10 minutes, it splits videos into two buckets — over 10 minutes and under 5 minutes 30 seconds — and compares within each. Long videos naturally have lower completion rates, so it doesn’t label a long video’s low completion as a bad result.

One more thing that matters a lot: because I write every episode’s full transcript with Claude Code, every one of them is on file, so it can analyze exactly why the underperformers underperformed — was the opening hook badly designed, or did the middle drag long enough that people lost patience? It also generalizes why the strong episodes hit high completion, turning that into validated “good opening formulas.” It does the same generalization for the weak ones.

Xiaohongshu: growth off one viral post isn’t actually healthy

Xiaohongshu is its own animal. The AI’s first read was that Xiaohongshu’s follow conversion looked excellent — two thousand-plus new followers. Then it dug in and found that a single viral post accounted for nearly 75% of that, which makes the number a lot less healthy than it looks. Unlike WeChat Channels, where every post picks up some followers and the platform is fairly forgiving of content, on Xiaohongshu a lot of posts get essentially zero distribution.

It also examined a rumor: the recent claim that content with a high save rate performs better overall on views and follow conversion. But in my own data, cover click-through rate is actually the single biggest driver of overall performance. It also gave me recommendations on how to optimize Xiaohongshu covers specifically for my audience and subject matter.

Douyin: off-platform traffic is the kill shot

Douyin’s problem is worse — after 30-plus episodes I’ve gained only 200-odd followers. The most fatal part: Douyin transcribes videos to text and runs content analysis on them, and the moment it catches you pointing viewers off-platform, it drops that post’s views to zero and tells you the content is unsuitable for public release.

By comparison, Xiaohongshu — and especially WeChat Channels — are far more forgiving; saying “comment and I’ll send you the link” in a video isn’t penalized there. But Douyin’s penalties are extremely strict, and its content red lines are tighter too. Some episodes did great on WeChat Channels — say, how to ban-proof CC, or how to do Netflix subtitles with AI — and got zero distribution on Douyin, blocked outright, with a warning that this category of content will keep causing problems.

Bilibili and YouTube: change the packaging, not the aspect ratio

Bilibili and YouTube share a typical situation: both are primarily landscape long-video platforms, my content is vertical, and I haven’t reworked any of it into landscape yet — so I’m naturally at a disadvantage on both. And both are slow-burn platforms: until the platform is confident you’ll keep producing quality consistently, it won’t push much distribution your way.

Bilibili also has a cover problem: even though I have AI produce covers in three different aspect ratios, those three ratios aren’t tuned per platform — and cover format varies enormously from platform to platform, as does how much it moves views. On Bilibili, content mentioning celebrities or trending topics converts better, while certain topics are very unpopular.

YouTube is even more clear-cut, since it’s currently aimed at overseas markets. The analysis shows the US accounts for 10% of traffic, with Southeast Asian countries also a meaningful share. But average watch time from US viewers is pretty long — over two minutes forty seconds — which tells you the people watching my videos on YouTube are actually overseas Chinese, because if you don’t understand Chinese there’s no way you’d watch that long. It also concluded that YouTube’s bottleneck is the cover, plus the language in my video descriptions: I’d naively used mixed Chinese-English titles at the start, but since the audience is Chinese speakers, mixing English in actually hurts overall CTR. So I’ll just optimize for overseas Chinese speakers. And since YouTube only uses 16:9 covers, I can optimize a dedicated version just for it.

Next-step recommendations per platform

After all that analysis, it gives me next-step recommendations per platform — topic selection, delivery pacing. Right now I actually don’t write a transcript at all; I talk as it comes to me, which is the better way for me to keep producing consistently given how busy I am. Even if it wrote one for me, it’d be hard to match my voice and quirks in the short term, and reading from a script also kills efficiency. So it gave me a middle path: skip the full transcript, but really polish and optimize the first 15 to 30 seconds so overall completion and retention improve.

For Xiaohongshu, the P0 is how topics and titles are phrased: listicles, or “here’s the tool I used,” don’t really pull Xiaohongshu users in. What works better is “I solved a bind you’re in, I have a better solution.” It also noted that switching to a business account’s lead-capture component would let me point people off-platform legitimately, instead of getting penalized for it the way I was before.

For Douyin, it recommends I run a self-check as soon as I finish recording, looking for anything that points viewers off-platform plus any sensitive keywords, and it reminds me to fix those at the editing stage. It also suggests publishing both a long and a short version on Douyin — cutting a highlights version. It recommends fixed publishing times on both Douyin and WeChat Channels. And I have found that, since my content is aimed at industry experts, senior executives, and some small business owners, publishing roughly between six and eight in the evening produces the best overall distribution — so publishing in a fixed window and controlling the relevant variables does help. For Bilibili and YouTube it’s a packaging-layer reset: don’t change the landscape-format content, just optimize the cover and the publishing copy.

It remembers on its own and iterates on the next episode

Finally, for later content positioning and topic selection, it built me a checklist and a to-do list, flagging item by item what I can do on each platform next. It also optimizes my daily production workflow the same way — anyone who’s watched my earlier videos knows that every day I finish recording, hand it to Claude Code, say “go publish it,” and it runs the whole pipeline. So it writes the next round of publishing-copy and cover fixes into its own memory and applies them on the next episode’s publishing run.

It also built me a topic bank I can keep pulling from for new content. Or if I just want to cover a certain topic today, it reviews it for me and tells me whether the topic is a fit and which angle I could take for better results — and I do adjust my short-video content to its recommendations.

Let’s come back in another month and see how the next month goes. That’s it for today, and I’ll see you in the next one.

Every day I finish recording, hand it to Claude Code, say "go publish it" — and it runs the whole pipeline.