← 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 files · Drop them into 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 data analysis, and what next steps, today’s AI can hand me on the growth-ops side of short video.

First, merge into one master table

Open the page and it leads 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 each platform’s key metrics 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 pin down exactly why the underperformers underperformed—was the opening hook badly designed, or did the middle drag long enough that people lost patience? It also works out why the strong episodes hit high completion and turns that into validated “good opening formulas.” It runs the same exercise on 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 went after 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 drives overall performance more than anything else does. It also gave me recommendations on how to optimize Xiaohongshu covers for my particular 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. I do have AI produce covers in three different aspect ratios, but 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 that mentions celebrities or trending topics converts better, while certain topics get no traction at all.

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 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 kills efficiency too. So it gave me a middle path: skip the full transcript, but polish the first 15 to 30 seconds hard, 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. And it wants fixed publishing times on both Douyin and WeChat Channels. That tracks with what I’ve found: my content is aimed at industry experts, senior executives, and some small business owners, and publishing between six and eight in the evening gets me the best distribution overall. Publishing in a fixed window and holding the other variables steady does help. For Bilibili and YouTube it’s a packaging-layer reset: don’t rework the content into landscape, just optimize the cover and the publishing copy.

It remembers on its own and iterates on the next episode

Finally, for content positioning and topic selection down the road, it built me a checklist and a to-do list, flagging item by item what I can do on each platform next. It tunes 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 something today, it reviews the idea and tells me whether it’s a fit and which angle would get better results—and I do adjust my short-video content to what it says.

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.