Competitor Deep Dive
Scrape social data and use AI to analyze engagement, sentiment, and strategy.
LinkedIn Company Scraper
How to Scrape
- Create a free account on Apify if you haven't already.
- Go to the actor page linked above.
- In the "Start URLs" field, paste the LinkedIn Company Page URL (e.g., https://www.linkedin.com/company/example).
- Click the green "Start" button at the bottom.
- Wait for the run to finish (Status: Succeeded).
- Click "Export" and download the Excel or JSON file.
AI Analysis Prompt
Upload the downloaded Excel/JSON to ChatGPT/Claude and use this prompt:
I have uploaded a dataset of LinkedIn posts from a competitor. Please analyze
it and provide a report covering:
1. **Engagement Metrics**: Average likes, comments, and shares per post.
2. **Top Content**: Identify the top 3 posts by engagement and explain WHY they worked (topic,
format, tone).
3. **Sentiment Analysis**: Analyze the comment text (if available) or reaction types to gauge
audience sentiment (positive/negative/neutral).
4. **Hashtag Strategy**: Which hashtags are driving the most visibility?
5. **Posting Schedule**: What days and times receive the highest engagement?
Summarize their core LinkedIn strategy and suggest 3 gaps we can exploit.
Instagram Scraper
How to Scrape
- Open the Apify Instagram Scraper tool.
- Enter the Instagram Username or Profile URL in the input field.
- Adjust "Max items" to limit how many posts to scrape (e.g., 50 for a quick audit).
- Click "Start" and wait for completion.
- Export the data as Excel or JSON.
AI Analysis Prompt
Analyze this Instagram dataset for [BRAND NAME]. Focus on:
1. **Visual Strategy**: Based on captions and media types (Video vs Image), what performs best?
2. **Engagement Rate**: Calculate average engagement (Likes + Comments) / Follower Count (use approx
follower count if missing).
3. **Audience Sentiment**: Read through the comments in the data. Are users excited, complaining, or
asking questions?
4. **Reels vs Posts**: Compare the performance metrics of Reels vs static posts.
5. **Caption Hooks**: Extract the first sentence of the top 5 posts. What hooks are they using?
Provide a "Stop/Start/Continue" recommendation for our own Instagram strategy based on this
competitor.
Facebook Page Scraper
How to Scrape
- Go to the Facebook Page Scraper actor.
- Paste the Facbook Page URL under "Start URLs".
- Set "Max items" (e.g., 20-50 posts).
- Run the scraper and wait for the status "Succeeded".
- Download the "Dataset" in Excel format.
AI Analysis Prompt
Analyze this Facebook page export. I need insights on:
1. **Community Engagement**: Analyze the ratio of Likes to Comments to Shares. Are people talking or
just scrolling?
2. **Reaction Breakdown**: Look at the reaction types (Love, Haha, Angry). What is the overall
emotional sentiment?
3. **Content Mix**: What % of content is Video vs. Link vs. Photo? Which type drives the most
shares?
4. **Customer Service**: Identify any comments that look like support complaints. How fast is the
brand responding (if timestamps exist)?
5. **Virality Checks**: Identify any posts with outlier performance (10x average). What made them
unique?
Give me a bullet-point executive summary of their Facebook strengths.