
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.
@brandname)YYYY-MM-DD formatCreate a New Brief in GenSpark.
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
Fill all <…> fields: BRAND_NAME, Your Name, etc.
Submit the brief to GenSpark.ai.