How Barie Researches Trending Topics, Builds a 90-Day Content Calendar, and Generates the Leadership Deck — One Prompt

Content Strategy  ·  SEO + Social Intelligence  ·  Ahrefs + Reddit + LinkedIn  ·  Updated April 2026

Barie scans live discussions on Reddit, Quora, and LinkedIn, cross-references them with Ahrefs keyword data, identifies the topics that are both trending in conversations and driving search volume, builds a 90-day content calendar prioritised by SEO opportunity and buyer journey stage, then auto-generates a slide deck for your leadership review. Research to boardroom — one prompt.

The problem with how most content calendars get built

A content strategist at a B2B software company spent her Monday morning building the Q2 content calendar. She scrolled LinkedIn for trending posts, ran a few keyword searches in Ahrefs, checked what was popular on Reddit in the relevant subreddits, and pulled together a spreadsheet of 30 topic ideas. Then she spent an afternoon prioritising them by gut feel, formatting the calendar, and building a slide deck to present to the marketing director.

The whole process took two days. At the end of it, the calendar had 30 topics but no systematic way to know whether they were the right 30. The prioritisation was based on her knowledge of the audience, which was valuable but not verified. Three topics she had included turned out to have almost no search volume. Two high-volume topics the audience was actively discussing on Reddit had not made the list because she had not checked those threads that week.

Content calendars built from manual research are always partial. The person building them can only scan so many sources in the time available. The prioritisation is always subjective. And the presentation to leadership is always a second task that takes additional time after the calendar is already built.

What Barie does in one prompt: Barie scans Reddit, Quora, LinkedIn, and live keyword data simultaneously before the first topic makes it onto the calendar. Every topic that enters the calendar has a confirmed search volume from Ahrefs and a verified engagement signal from at least one social platform. Prioritisation is objective and data-based. The slide deck is generated from the same data in the same session. The total workflow replaces two days of manual work.

Your prompt

Task prompt: “Research trending topics in our niche, build a 90-day content calendar, and generate the slide deck to present it to leadership.”

One sentence. Three deliverables. Barie identifies the relevant platforms and keyword categories for your niche, runs parallel scans across social discussions and search data, scores each topic by opportunity, builds the 90-day calendar with format and buyer journey assignments, and generates the leadership presentation. Here is the full workflow.

Step 1: Parallel discovery across live conversations and keyword data

LIVE TOPIC DISCOVERY

Before scoring a single topic, Barie runs four discovery threads simultaneously. Reddit reveals what your audience is actually asking, arguing about, and searching for in the communities most relevant to your category. Quora surfaces the specific questions people are phrasing when they are in research mode. LinkedIn shows the professional conversations generating the most engagement among your buyer personas right now. Ahrefs confirms which of the topics surfaced from those conversations have real search volume, so social trends and search demand are validated against each other rather than treated separately.

Sources: Reddit live threads  ·  Quora question data  ·  LinkedIn post engagement  ·  Ahrefs keyword volume  ·  Media Watcher brand context

Firecrawl retrieves the live content from each source. LunarCrush scores the social engagement velocity for each topic so Barie can distinguish between a topic that has been popular for months and one that is breaking now. The combination produces a topic pool that is grounded in both real audience behaviour and search demand, not in what seemed interesting at the last brainstorm.

Only topics that pass the dual-signal filter make the calendar: A topic must have both a social engagement signal and a confirmed Ahrefs search volume to qualify for calendar placement. Topics that are trending socially but have no search demand are flagged as social-only opportunities and assigned to social post formats rather than long-form content. Topics with search volume but no current social traction are flagged as emerging opportunities worth moving on before competitors notice.

Step 2: Topics scored, buyer journey assigned, format recommended

TOPIC SCORING AND PRIORITISATION

Every qualifying topic is scored across four dimensions before it enters the calendar. Search volume and keyword difficulty data from Ahrefs determine the SEO opportunity. Social engagement velocity from Reddit and LinkedIn determines the current audience interest. Buyer journey classification identifies whether the topic addresses someone who is unaware of the problem, actively researching solutions, or comparing alternatives before purchase. Content format recommendation identifies whether the topic should be a long-form blog post, a short-form video, a social post series, or a case study.

Topic: Why AI research tools produce confident wrong answers — and what to do about it

[ToFU]  [Trending Reddit]

High engagement on r/MachineLearning and r/productivity in the last 14 days. 847 upvotes on top thread. Ahrefs confirms 6,200 monthly searches for closely related queries with low competition. Strong awareness-stage article opportunity that introduces the hallucination problem your product solves.

6,200 monthly searches  ·  KD 28 — achievable  ·  Format: Long-form blog  ·  Week 2

Topic: How to build a competitive analysis in under an hour

[MoFU]

Steady LinkedIn engagement across the last 30 days with multiple posts from practitioners generating comment discussions. Ahrefs shows 3,800 monthly searches. This is a product-adjacent topic that reaches buyers who are actively researching how to improve their research workflows — your ideal mid-funnel audience.

3,800 monthly searches  ·  KD 34 — moderate  ·  Format: How-to + video  ·  Week 5

Topic: Barie vs Perplexity — which one is actually right more often

[BoFU]  [Rising fast]

Quora question posted three weeks ago has accumulated 14 detailed answers and 2,400 views. Comparison search queries in this category are growing 38% month-on-month in Ahrefs. Bottom-of-funnel buyers are explicitly comparing options. This topic has direct conversion potential.

2,100 monthly searches  ·  KD 22 — low  ·  Format: Comparison page  ·  Week 4

Step 3: The 90-day content calendar — every slot scored, sourced, and format-assigned

90-DAY CONTENT CALENDAR

36 Pieces scheduled  ·  90 Day window  ·  4 Formats across ToFU MoFU BoFU  ·  100% Dual-signal verified

The calendar is structured across the full 90-day window with a deliberate balance of buyer journey stages. Weeks one through four are weighted toward awareness-stage content to build organic traffic at scale. Weeks five through eight introduce mid-funnel content that captures buyers actively researching solutions. Weeks nine through thirteen include bottom-funnel comparison and case study content to convert the audience the awareness content has built. Every piece is tied to the topic scoring data and includes the Ahrefs keyword it is targeting.

90-Day Content Calendar — Barie Research Output

MONTH 1 — AWARENESS FOUNDATION

Wk 1: Why AI research tools hallucinate — and what the alternative looks like  |  Blog post  |  ToFU  |  4,800/mo

Wk 2: Why AI research tools produce confident wrong answers  |  Blog post  |  ToFU  |  6,200/mo  |  Trending Reddit · KD 28

Wk 3: 5 research workflows the best content teams have automated  |  Social series  |  ToFU  |  2,900/mo  |  LinkedIn trending

Wk 4: Barie vs Perplexity — which is actually more accurate  |  Comparison page  |  BoFU  |  2,100/mo  |  Quora trending

MONTH 2 — MID-FUNNEL BUILD

Wk 5: How to build a competitive analysis in under an hour  |  Video + Blog  |  MoFU  |  3,800/mo  |  LinkedIn + Ahrefs

Wk 6–13: 31 additional calendar entries across MoFU, BoFU, and evergreen slots — all dual-signal verified — full export in Airtable and Google Sheets

The calendar is built for execution, not just presentation: Every row in the calendar includes the target keyword, the platform where the topic was trending, the format recommendation, and the buyer journey classification. When this lands in Airtable, each row is a fully briefed content task. The content team does not need to reverse-engineer a topic brief from the calendar entry. The brief is already in the row.

Step 4: The leadership presentation — auto-generated from the calendar data, downloadable as .pptx

LEADERSHIP SLIDE DECK GENERATED

The moment the calendar is complete, Barie generates the leadership presentation from the same data. The deck does not summarise the calendar in prose. It presents the strategic rationale behind it: the traffic opportunity the calendar is designed to capture, the competitive gap it addresses, the buyer journey logic behind the topic sequencing, and the 90-day projection for organic traffic impact. Every slide is built from the data that produced the calendar, so the leadership team is looking at a strategy backed by evidence rather than a formatted spreadsheet.

Content Strategy Deck — 10 Slides — Barie Output

• Slide 01: The opportunity — Total addressable organic traffic from 36 calendar topics. Current vs competitor share. (Ahrefs data)
• Slide 02: Trending now — Top 5 topics generating live discussion on Reddit and LinkedIn this week. (Live social data)
• Slide 03: Buyer journey map — ToFU, MoFU, and BoFU topic distribution across the 90-day window. (Calendar data)
• Slide 04: Month 1 calendar — 8 pieces across awareness and comparison formats. Top keywords and expected traffic. (Ahrefs volumes)
• Slide 05: Month 2 calendar — 14 mid-funnel pieces including video and how-to formats. Workflow topic cluster. (Calendar data)
• Slide 06: Month 3 calendar — 14 pieces across BoFU comparisons, case studies, and evergreen guides. (Calendar data)
• Slide 07: Video content plan — 6 video topics with AI generation brief. ElevenLabs voiceover workflow outlined. (Video module)
• Slide 08: Traffic projection — 90-day organic traffic estimate if calendar executes at industry average CTR by position. (Ahrefs CTR data)
• Slide 09: Resource requirements — Content pieces by format. Writer hours, video production, and distribution effort estimates. (Calendar breakdown)
• Slide 10: Success metrics — Organic sessions, keyword rankings, and conversion metrics to track at 30, 60, and 90 days. (Ahrefs benchmarks)

Slide 07 connects to the video creation module: The deck includes a dedicated video content plan slide that outlines the six video topics in the 90-day calendar and provides the AI video generation brief for each. Using Minimax for visual generation and ElevenLabs for voiceover, each video brief can be executed from Barie in a follow-on session without returning to the research step. The calendar and the production pipeline connect directly.

Step 5: Calendar and deck distributed to your content and operations tools

DISTRIBUTE ACROSS YOUR CONTENT STACK

The calendar does not sit in a document waiting to be rebuilt in a different tool. Barie routes each component to where your team works. The full 90-day calendar lands in Airtable as individual content task records, each with the topic brief, target keyword, format, buyer journey classification, and scheduled date pre-populated. Writers can be assigned and status can be tracked without any manual reformatting. Notion holds the full research brief, the topic scoring methodology, and a linked version of the calendar for strategic reference.

For operational teams, the calendar entries trigger task creation in Asana or Monday automatically, with milestone dates and content format labels already set. HubSpot receives each piece as a marketing asset linked to the relevant campaign and buyer journey stage. Amplitude tracks which calendar pieces drive the highest session depth and conversion rate so the next calendar iteration can be built on performance data, not only research signals.

Barie Connectors used

• Ahrefs — Keyword volumes, difficulty scores, and CTR benchmarks confirming every topic before calendar placement
• Airtable — Full 90-day calendar as task records with topic brief, keyword, format, stage, and schedule pre-filled
• PowerPoint — 10-slide leadership deck downloaded as an editable .pptx, ready for board presentation without reformatting
• Notion — Full research brief with topic scoring, source data, and linked calendar as team strategy reference
• Asana — Calendar entries trigger content tasks with milestone dates and format labels automatically assigned
• HubSpot — Calendar pieces linked to campaign assets and buyer journey stage for pipeline attribution
• Amplitude — Performance tracking for each published piece — session depth, scroll rate, and conversion signals
• Minimax + ElevenLabs — Six video topics in the calendar briefed for AI video generation and voiceover in follow-on sessions

Re-run quarterly with the same prompt: Configure Barie to run the same topic discovery and calendar build every quarter. Each run refreshes the trending topic data, updates the Ahrefs keyword scores, and produces a new calendar from the current signals. The Airtable base updates automatically and a new deck is generated for the next leadership review. The whole process that took two manual days now takes one monthly prompt.

What you get

A live trending topic research brief covering Reddit, Quora, LinkedIn, and Ahrefs data. Every qualifying topic dual-signal verified with a social engagement score and a confirmed search volume. A structured 90-day content calendar with 36 pieces across blog, video, social, and case study formats, each scored by buyer journey stage and SEO opportunity. A 10-slide leadership deck generated from the same data, downloadable as a .pptx ready for the next board review. The full calendar distributed to Airtable, Notion, Asana, HubSpot, and Amplitude in one session. The six video topics in the calendar briefed for AI video generation using Minimax and ElevenLabs via Barie Connectors.

What it would take a content strategist two days to research and build, Barie delivers before the morning stand-up. Every topic evidence-based. Every priority data-driven. Leadership deck already in their inbox.

The Verdict

A content calendar built from manual research is always partial and always biased toward what the researcher happened to check that week. Barie scans every relevant source simultaneously, scores every topic against dual social and search signals, and builds a calendar where the prioritisation is objective and the evidence is visible. The leadership presentation is not a second task that takes another half-day after the calendar is done. It is generated from the same data in the same session. From trending topic to boardroom deck in one prompt. That is what a content strategy process should look like.

Barie features used in this task

Next steps

→ Barie Connectors — Ahrefs, Airtable, Asana, Minimax, ElevenLabs, and 70+ more

→ Deep Research overview — how Barie scans live discussions and keyword data in parallel

→ Prompt Library — content strategy, calendar building, and SEO research templates