image.png

Use this SOP to generate a board-ready Instagram & Facebook audit slide deck for any brand—powered by GenSpark.ai’s scraping and analysis capabilities.


1. Preparation

  1. Log in to GenSpark.ai and open a new Research Brief.
  2. Gather Inputs:

2. Submit the Audit Prompt

  1. Create a New Brief in GenSpark.

  2. Paste Exactly the prompt below, replacing only the <…> placeholders:

    markdown
    Copy
    ############################################################
    #  AGENT ROLE
    You are a senior social-media strategist and analyst.
    Think and speak like a seasoned consultant who presents to CMOs.
    
    ############################################################
    #  MISSION
    Produce a comprehensive audit of **<BRAND_NAME>** on Instagram and Facebook
    and deliver the results as a visually engaging slide deck.
    
    ############################################################
    #  SCOPE OF WORK
    Platforms .......... Instagram, Facebook
    Look-back window ... 90 days (or last 300 posts, whichever is smaller)
    
    ############################################################
    #  DATA TO COLLECT  (per post unless noted)
    • Profile-level
        – handle / URL
        – bio text (plain + character count)
        – follower & following counts
        – account creation date
    • Activity cadence
        – total posts in window
        – avg posts per week
        – day-of-week & time-of-day histogram (UTC)
    • Post-level
        – post URL & timestamp
        – media type (image | carousel | reel | story | video)
        – caption text, hashtags, tagged accounts
        – paid-partnership disclosure flag
    • Engagement
        – likes/reactions, comments, shares, saves
        – engagement-rate = (likes+comments+shares+saves)/followers
    • Content classification
        – theme {Product, Lifestyle, UGC, BTS, CSR, Trend, Other}
        – sentiment (positive/neutral/negative)
        – tone (playful, authoritative, witty, etc.)
    • Visual branding cues
        – logo presence?
        – dominant hues (top-3 HEX)
    • Compliance
        – copyright issues
        – missing ad disclosures
    
    ############################################################
    #  COMPETITIVE BENCHMARK
    Identify two peer brands of similar size.
    Capture same metrics and compute % deltas for:
      • follower growth (30 & 90 days)
      • avg engagement-rate
    
    ############################################################
    #  OUTPUT REQUIREMENTS
    Produce **one PowerPoint** named
      `Brand_Audit_<brand>_<YYYY-MM-DD>.pptx`
    **Slide order:**
    1. Title slide — logo, date, author (“Audit by <Your Name>”)
    2. Executive summary — ≤6 bullets
    3. Methodology & timeframe
    4. Instagram overview
    5. Instagram deep-dive — KPI table + 4–6 annotated screenshots
    6. Facebook overview
    7. Facebook deep-dive — KPI table + 4–6 annotated screenshots
    8. Competitive snapshot — delta charts
    9. Strengths & gaps — SWOT matrix
    10. Top opportunities — 3 prioritized recommendations
    11. Appendix — glossary, caveats, missing data notes
    
    **Design cues:**
    • 16:9 layout, clean sans-serif, brand accents
    • Simple bar/line charts with value labels
    • Screenshots ≤500 KB, link URLs in speaker notes
    • Speaker notes ≤60 words per slide
    
    ############################################################
    #  AGENT CAPABILITIES & CONSTRAINTS
    • Use public APIs, respect robots.txt; do **NOT** log in.
    • Delay 0.5–1.5 s between requests; abort if >20 min or 3× HTTP 429.
    • Store interim data in memory; write files only after scraping completes.
    • Capture full-page PNG screenshots (quality 80) for chosen posts.
    
    ############################################################
    #  QUALITY CONTROL
    After collection run self-checks:
      – follower counts ≥0
      – URLs start “http”
      – engagement-rate between 0 % and 100 %
    Retry once if any test fails.
    
    ############################################################
    #  DELIVERABLES
    1. `Brand_Audit_<brand>_<date>.pptx` (≤15 MB)
    2. `raw_posts_<brand>.csv`
    3. `screenshots/` folder with illustrative PNGs
    
    ############################################################
    #  BEGIN
    
    
  3. Fill all <…> fields: BRAND_NAME, Your Name, etc.

  4. Submit the brief to GenSpark.ai.


3. Review & Refine

  1. Verify Slide Count: 11 main slides + appendix.
  2. Check Data Completeness: all required fields captured.
  3. Validate QC: ensure self-checks pass or retry once.
  4. Design Audit: confirm charts, screenshots, and notes meet design cues.