Back to Brand Audit

Competitor Deep Dive

Scrape social data and use AI to analyze engagement, sentiment, and strategy.

LinkedIn Company Scraper

Open Apify Actor

How to Scrape

  1. Create a free account on Apify if you haven't already.
  2. Go to the actor page linked above.
  3. In the "Start URLs" field, paste the LinkedIn Company Page URL (e.g., https://www.linkedin.com/company/example).
  4. Click the green "Start" button at the bottom.
  5. Wait for the run to finish (Status: Succeeded).
  6. 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

Open Apify Actor

How to Scrape

  1. Open the Apify Instagram Scraper tool.
  2. Enter the Instagram Username or Profile URL in the input field.
  3. Adjust "Max items" to limit how many posts to scrape (e.g., 50 for a quick audit).
  4. Click "Start" and wait for completion.
  5. 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

Open Apify Actor

How to Scrape

  1. Go to the Facebook Page Scraper actor.
  2. Paste the Facbook Page URL under "Start URLs".
  3. Set "Max items" (e.g., 20-50 posts).
  4. Run the scraper and wait for the status "Succeeded".
  5. 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.