Social Media Analytics Dashboard and Reporting Framework
Build a comprehensive analytics dashboard that tracks the metrics that actually matter across all social platforms.
Create a social media reporting system that goes beyond vanity metrics to track engagement quality, audience growth, and business impact.
At a glance
Access
Free prompt
Open to copy — no account or payment needed.
Prompt objective
Create a social media reporting system that goes beyond vanity metrics to track engagement quality, audience growth, and business impact.
Real use case
A marketing agency manages social media for 12 clients but only reports on followers and likes. Clients want to see how social media impacts their business goals, not just vanity metrics.
Customize these fields first
Replace the placeholders with your own context before you run the prompt. That usually improves the first output more than adding more instructions later.
Prompt
Create a social media analytics dashboard and reporting framework for [COMPANY/AGENCY NAME] managing [NUMBER] accounts across [PLATFORMS]. **1) KPI Hierarchy by Platform:** **Instagram:** - Reach vs. impressions (and why the difference matters) - Engagement rate (by reach, not followers) - Saves and shares (quality engagement indicators) - Profile visits and website clicks - Follower growth rate (not total count) **TikTok:** - Average watch time and completion rate - Shares (most important TikTok metric) - Profile views from video - Follower growth from viral videos **LinkedIn:** - Impressions vs. unique viewers - Engagement rate (comments weigh more than likes) - Profile views and connection requests - Lead generation from content **Twitter/X:** - Impressions and engagement rate - Profile visits and follows from tweets - Link clicks (traffic generation) - Reply quality (not just quantity) **YouTube:** - Watch time (most important metric) - Average view duration and percentage - Click-through rate (CTR) from impressions - Subscriber conversion rate - Session time **2) Dashboard Structure:** - Executive summary (big numbers) - Platform-by-platform breakdown - Content performance (top and bottom posts) - Audience growth trends - Business impact metrics (leads, sales, traffic) **3) Reporting Cadence:** - Weekly: quick performance snapshot - Monthly: comprehensive report with insights - Quarterly: strategic review and adjustments **4) Tools and Setup:** - Native analytics vs. third-party tools - Recommended tools by budget - Automated reporting setup - Data visualization best practices **5) Insight Generation:** - How to turn data into actionable insights - Pattern recognition framework - When to double down vs. when to pivot - Client-facing report template Include a monthly report template and a KPI tracking spreadsheet.
Open directly in an AI — the text is pre-filled:
How to use this prompt
- 1Replace the key placeholders first: COMPANY/AGENCY NAME, NUMBER, PLATFORMS.
- 2Replace any bracketed placeholders like [this] with your own context.
- 3Add extra background information when you want more tailored results.
- 4Combine multiple prompts in one conversation when you need a richer output.
- 5Save your best-performing prompts so they are easy to reuse later.
Next best step
Open the guide first, then branch only if you still need more.
A practical guide for marketers who want campaigns, prompts, and automations that shorten execution time.
If this prompt is close but not quite right, generate variants next. If the job is recurring, move into the course library after the guide.
Related prompts
View allB2B Reels Strategy to Generate Qualified Leads
Framework for B2B companies to use Reels on Instagram to attract decision-makers, build authority, and convert into sales meetings.
Best for
Adapt the Reels format — typically B2C — for Brazilian B2B brands, creating content that educates decision-makers and generates measurable commercial pipeline.
TikTok for Brazilian Businesses — Organic Growth Strategy
Complete plan for Brazilian brands and entrepreneurs to grow on TikTok with authentic content that converts into sales.
Best for
Build a strategic presence on TikTok for Brazilian businesses, leveraging the interest-based algorithm (not follower-based) to reach new audiences and convert into customers.
WhatsApp Community for Brands — Engagement and Recurring Sales
Strategy to create and monetize an active WhatsApp community that builds customer loyalty and generates systematic repeat purchases.
Best for
Structure a WhatsApp Community (native feature) for brands that converts customers into fans, generates organic repeat purchases, and reduces CAC through relationship marketing.
Social Media Competitor Analysis — Competitive Intelligence Framework
Complete methodology to monitor, analyze, and outperform competitors on social media with actionable data and insights.
Best for
Create a social media competitive intelligence system that identifies what competitors are doing right, unexplored content gaps, and differentiation opportunities.
Explore other prompt categories
Move sideways into adjacent libraries when the current category is not the full answer.
Every prompt here is free. The course teaches the thinking behind them.
Copy as many prompts as you like. When you want to move from single prompts to a repeatable AI workflow, Learn AI in 30 Days walks through it, one day at a time.
Buy the course once ($15/$20 by length), or go all-access for $10/mo with a verifiable certificate.