cotera

Twitter Competitor Content Analyzer

Break down your competitors' Twitter strategy. See what content works for them, what falls flat, and where you can steal their playbook.

Competitive analysisContent strategySocial benchmarkingMarket research

The Challenge

You know your competitors are active on Twitter, but you have no idea what's actually working for them. Which tweets get traction? How often do they post? Are they riding news cycles or creating their own? Manually auditing competitor feeds is tedious, and by the time you compile a spreadsheet, the data is already stale.

What This Prompt Does

Profile Comparison

Compare follower counts, posting frequency, and engagement rates side by side

Content Breakdown

Categorize each tweet type and see what mix each competitor uses

News Cross-Reference

See which press stories drove Twitter engagement spikes

Export to Sheets

Log per-tweet data to a spreadsheet for ongoing benchmarking

The Prompt

The Prompt

Task

Use @Twitter/Get Profile and @Twitter/Get PostsName it "Twitter/Get Posts" and call it with @Twitter/Get Posts to pull competitor Twitter accounts and their recent content. Use @Twitter/Search TweetsName it "Twitter/Search Tweets" and call it with @Twitter/Search Tweets to find audience reactions and mentions. Use @NewsAPI/Search EverythingName it "NewsAPI/Search Everything" and call it with @NewsAPI/Search Everything to cross-reference with recent press coverage. Export the full analysis to @Google Sheets/Append RowName it "Google Sheets/Append Row" and call it with @Google Sheets/Append Row for ongoing tracking.

Example: Analyze the Twitter strategy of HubSpot, Salesforce, and Intercom. Identify their top-performing tweets, posting cadence, and content themes. Export the breakdown to a spreadsheet.

Input

The user will provide:

  1. List of competitor Twitter handles (2-5 accounts)
  2. Google Sheets URL for export
  3. Optional: specific time window or content themes to focus on

Example: "Analyze the Twitter content strategy for @HubSpot, @Salesforce, and @Intercom. Export to https://docs.google.com/spreadsheets/d/xyz. Focus on product announcements and thought leadership."

Context

What to Analyze

Per competitor, pull:

  • Profile stats: followers, following, tweet count, bio, verification status
  • Last 20 tweets: text, engagement metrics (likes, retweets, replies, views)
  • Content mix: what percentage is promotional, educational, engagement bait, announcements, replies

Content performance metrics:

  • Average engagement rate (likes + retweets + replies / followers)
  • Top 3 tweets by total engagement
  • Worst 3 tweets by engagement (to spot what fails)
  • View-to-engagement ratio (if views available)

Strategy signals:

  • Posting frequency (tweets per day/week)
  • Peak engagement times (when their best tweets were posted)
  • Content format preferences (text-only, images, video, threads, polls)
  • Hashtag usage patterns
  • Tone of voice (professional, casual, humorous, provocative)

NewsAPI cross-reference:

  • Search for each competitor in recent news
  • Note which news stories they amplified on Twitter
  • Identify product launches or announcements that drove engagement spikes

Analysis Framework

  1. Pull profiles for all competitors
  2. Get the last 20 posts from each account
  3. Calculate engagement metrics per post and averages per account
  4. Classify each post into content categories
  5. Search Twitter for audience reactions to each competitor
  6. Search NewsAPI for recent coverage of each competitor
  7. Cross-reference news spikes with Twitter engagement spikes
  8. Export structured data to Google Sheets
  9. Synthesize findings into a comparative report

What Counts as a Valid Result

  • Use real engagement numbers — do not estimate or round without noting it
  • If a competitor has fewer than 20 recent tweets, note the actual count
  • Compare engagement rates, not raw numbers (a 10M-follower account getting 500 likes is worse than a 10k-follower account getting 500 likes)
  • Note any anomalies (viral outliers, deleted tweets, ratio'd posts)

Output

Competitor Twitter Overview:

| Competitor | Followers | Avg Engagement Rate | Posts/Week | Top Content Type | Tone | |------------|-----------|--------------------:|------------|------------------|------| | @[handle] | [count] | [rate]% | [count] | [type] | [tone] |

Top Performing Content:

For each competitor:

  1. "[Tweet excerpt]" -- [likes] likes, [retweets] RTs, [replies] replies, [views] views
  2. "[Tweet excerpt]" -- [engagement metrics]
  3. "[Tweet excerpt]" -- [engagement metrics]

Content Mix Breakdown: | Competitor | Promotional | Educational | Engagement | Announcements | Replies | |------------|------------:|------------:|-----------:|--------------:|--------:| | @[handle] | [%] | [%] | [%] | [%] | [%] |

News Coverage Cross-Reference:

  • [Competitor]: "[Headline]" ([Publication]) -- Tweeted about it on [date], got [engagement]
  • [Competitor]: No major news coverage in the period

Key Takeaways:

  1. [Who is winning on Twitter and why]
  2. [Content formats or themes that consistently perform well]
  3. [Gaps or opportunities your brand could exploit]
  4. [Specific content ideas inspired by competitor successes]

Google Sheets: Rows appended with per-tweet data for each competitor.

Example Usage

Try asking:

  • →"Compare the Twitter strategies of HubSpot, Salesforce, and Intercom"
  • →"Which of our competitors gets the most engagement on Twitter and why?"
  • →"Analyze @competitor1 and @competitor2 Twitter content, export to my spreadsheet"