Deep Social Media Analytics Report from Excel Data
Generates a comprehensive social media analytics report from pasted Excel data, covering all key performance dimensions. Ideal for marketers and analysts who want structured, actionable insights without manual interpretation.
Ready to use
This prompt has no variables — just copy and paste.
Your prompt
# Role You are a senior social media analytics strategist with deep expertise in interpreting platform performance data and translating raw metrics into actionable business insights. # Task Analyze the social media data I provide below and produce a thorough, structured analytics report covering every relevant dimension from a social media performance perspective. # Constraints - Cover all core analytics pillars: reach and impressions, engagement (rate, volume, type), follower growth trends, content performance (top and bottom performers), posting frequency and timing patterns, audience behavior, and conversion or click-through signals if present. - Identify significant trends, anomalies, and patterns in the data — do not just restate numbers. - Provide a prioritized list of actionable recommendations based on the findings. - If a metric is missing or cannot be calculated from the data provided, note it clearly and explain what it would reveal. - Keep language precise and professional, suitable for a marketing report. # Output format Structure the report with clearly labeled sections using headers: Executive Summary, Reach & Impressions Analysis, Engagement Analysis, Content Performance, Audience & Growth Trends, Timing & Frequency Insights, Anomalies & Observations, and Strategic Recommendations. Use bullet points within sections for clarity, and include a brief narrative paragraph at the start of each section. — via PromptShop: https://promptshop.munirabbasi.me/prompts/deep-social-media-analytics-report-from-excel-data
How to use it
Paste this prompt into ChatGPT, then immediately follow it with your Excel data — either copy-paste the rows and columns directly into the chat or describe the columns and paste the data as plain text. The more complete your data (dates, post types, metrics columns), the richer the analysis will be. If your spreadsheet is large, paste the most recent 30–90 days for best results. Review the Strategic Recommendations section first for quick wins, then use the detailed sections to support deeper decisions.
Tags
Related prompts
Brutal Business Reality Check and Pivot Strategy
Delivers uncompromising analysis of your business idea from a veteran investor perspective, identifying critical blind spots, failure modes, and competitive vulnerabilities with actionable pivot recommendations.
Comprehensive GTM Strategy Builder
Transform your product launch into a strategic success with this comprehensive go-to-market framework. This prompt generates detailed, actionable GTM strategies covering market analysis, positioning, pricing, distribution, and launch execution plans tailored to your specific product and market conditions.
30 Day Social Media Content Planner
Create a comprehensive 30-day social media content calendar with post ideas and strategy
The Profitable Niche Selector
Identify and rank up to 3 profitable micro-niches using real market signals and user fit.
Digital Workspace Organization System
Design an efficient digital file structure and tool ecosystem that minimizes search time and decision fatigue for remote and hybrid workers.
Professional Contract Review & Risk Analysis
Upload any contract and get a comprehensive legal review from an experienced attorney perspective. Identifies key terms, flags potential risks, and provides actionable negotiation recommendations with priority-based risk assessment to protect your business interests.