90 Days Of
Content Strategy
From Real Data

You are my content strategist. Your job is to help me pick the right 8 competitors to scrape and analyze for my Gap Finder run. The wrong competitors waste my Apify credits and produce a useless analysis. The right ones surface the real opportunities in my niche. My inputs: - My niche in one sentence: [DESCRIBE. E.g. "AI education for non-technical professionals"] - The platforms I post on: [Instagram / TikTok / YouTube / LinkedIn / multiple] - My current follower count and average engagement: [NUMBERS] - 3 creators or brands I KNOW I want analyzed: [LIST handles] - My monthly content goal: [followers / leads / sales / authority / saves / shares] - One angle I want to own that I haven't seen anyone else do well: [DESCRIBE OR "NOT SURE YET"] Do five things. 1. CONFIRM OR REPLACE MY 3 PICKS For each of the 3 creators I named, tell me whether they are actually a good competitor to study (right audience size, posting in my niche, engaged audience). If any of them is a bad pick, replace them with a stronger choice and explain why. 2. ADD 3 DIRECT COMPETITORS I HAVEN'T NAMED Find 3 creators or brands in my exact niche, in my follower-count range or one tier above me. These are the people whose playbook I'm trying to read. For each: handle, follower count, why they're on this list, what I think they're doing that's working. 3. ADD 2 ADJACENT CREATORS Find 2 creators in adjacent niches whose audience overlaps with mine but who aren't direct competitors. Crossover audiences are where the next 1,000 followers usually come from. For each: handle, follower count, the overlap with my niche, what content style of theirs I might steal. 4. THE FINAL LIST OF 8 Give me a clean numbered list of all 8 handles I should scrape, in the format I can paste directly into Apify. Use the @username format for Instagram and TikTok. For YouTube, give me the channel URL. 5. WHAT I'M LOOKING FOR IN EACH ONE For each of the 8, write ONE sentence on the specific question I should answer after analyzing their content (e.g., "For @username: do their high-engagement posts skew to talking-head or screen-recording format?"). This guides the Step 8 analysis prompt. Be specific and honest. If my 3 named picks are weak, say so. If my niche is too broad to analyze, push me to narrow it before we start scraping.

You are my Senior Content Strategist. Your job is to read every CSV in my "Gap Finder / [DATE]" folder in Google Drive and hand me a publishable content strategy backed by real engagement data, not vibes or guesses. Read the data carefully before you write a single line of analysis. Cite specific posts as evidence. INPUTS YOU'LL FIND IN THE DRIVE FOLDER - instagram-scrape.csv: caption, hashtags, likes, comments, views, video URL, post URL, timestamp, ownerUsername for every Instagram post - tiktok-scrape.csv: same columns for TikTok - youtube-scrape.csv: title, views, duration, upload date, description, channel for every YouTube video - instagram-transcripts.csv: full transcripts of the top 10 Reels per competitor - tiktok-transcripts.csv: full transcripts of the top 10 TikToks per competitor - youtube-transcripts.csv: full transcripts of the top YouTube videos per channel MY CONTEXT - My niche: [PASTE] - My platforms: [PASTE] - My current follower count and engagement: [PASTE] - My content goal next 90 days: [followers / leads / sales / authority / saves / shares] - My non-negotiables (topics I won't make, brands I won't reference): [PASTE OR "NONE"] - My voice in 3 words: [PASTE] DO SIX THINGS. PRODUCE EACH AS A NUMBERED SECTION. 1. THE ENGAGEMENT BASELINE For each competitor, compute their average likes, comments, and view-to-follower ratio across the scrape. Identify their top 5 highest-engagement posts in absolute terms AND in ratio terms (some 100K accounts get more engagement on a "small" post than 500K accounts). Rank competitors by engagement health, not follower count. Surface the one competitor who is punching above their weight (best ratio of engagement to followers). They are the one to study hardest. 2. THE 10 PATTERNS THAT ARE WORKING Read the transcripts AND the captions. Find the 10 patterns that show up across multiple competitors' top posts. For each pattern, give me: - The pattern name (e.g., "the 60-second screen-recording walkthrough with a $-saved hook") - The format (Reel / Carousel / Long-form video / Static image) - The angle / hook (the specific opening line or framing that does the work. Quote real examples from the transcripts) - 3 specific example posts with URLs from my scraped data - Why it works (the emotional or status trigger underneath) - Confidence score 1-10 that this would work for me too, given my voice and goal Rank by confidence. Number them 1 through 10. 3. THE 5 GAPS NOBODY IS TOUCHING Now look at what is missing across this entire competitor set. For each gap, give me: - The topic - Why it's a gap (specifically: is the audience asking for this in the comments of competitor posts? Is there a paid product solving this? Is there a recent news event nobody has covered cleanly?) - The angle I should take given my voice - The first 3 pieces of content I would make in this opening, each with the exact one-line hook - Confidence score 1-10 Rank by confidence. Top 5. 4. THE COMMENT-SECTION INSIGHT Open every top-engagement post's comments (use the post URLs to fetch them if the data isn't already in the CSV). What are people ASKING for that competitors are not delivering in follow-up content? Surface the 3 most common comment-section questions across the dataset. These are content briefs handed to you for free. 5. THE 90-DAY CONTENT CALENDAR Build me a 90-day calendar with 12 specific pieces of content (1 per week, slightly under "post 1x/week" cadence to leave room for trial reels and inspiration drops). 8 are "ride the wave" pieces from Section 2, 4 are "own the gap" pieces from Section 3. For each piece: - Week number (1-12) and platform (Instagram / TikTok / YouTube / cross-post) - Working title and hook (one sentence) - Format (Reel, carousel, long-form, etc.) - The specific competitor post(s) I'm taking inspiration from (with URLs) - The angle that makes mine different from theirs - The single metric I'm watching to know if it worked 6. THE SHARPER POSITIONING Based on what's saturated in my niche AND what's missing, write me a sharpened one-sentence positioning statement I should add to my bio, my email signature, and my LinkedIn headline. Then write 3 hook variations of that statement I can A/B test as Instagram bio lines for the next 90 days. VOICE GUARDRAILS - Write in clear, direct English. No "synergies", no "elevate", no copywriter-coded language. - Cite real post URLs and real transcript quotes. Never make up examples. - When you're not sure or the data is sparse, say so explicitly. - Push back on my non-negotiables if the data shows I'm leaving money on the table by avoiding a topic. END WITH ONE BLUNT PARAGRAPH Tell me the one thing I should stop doing immediately based on what the data shows about my niche. Specific, not motivational. (Example tone: "Stop posting carousel-format hot takes on Tuesdays. Across 6 of the 8 accounts I analyzed, that format underperformed talking-head Reels by 4-7x. The data is consistent enough that this is the single highest-leverage change you can make this week.")