Social Media Reporter
by herdiansah
Create comprehensive social media analytics reports with insights and recommendations. Use when the user needs to analyze social data, track brand health, or understand audience sentiment.
Skill Details
Repository Files
1 file in this skill directory
name: social-media-reporter description: Create comprehensive social media analytics reports with insights and recommendations. Use when the user needs to analyze social data, track brand health, or understand audience sentiment.
Social Media Reporter
When to Use This Skill
Use this skill when you need to:
- Improve business operations and strategy through data
- Make data-driven business decisions
- Optimize processes and outcomes based on performance
Not Recommended For
- Tasks requiring creative design work
- Technical coding
Quick Reference
| Action | Command/Trigger |
|---|---|
| Create social media reporter | social media report |
| Review and optimize | review social media reporter |
| Get best practices | social media reporter best practices |
Core Workflows
Workflow 1: Initial Social Media Reporter Creation
Goal: Create a high-quality social media report from scratch.
- Discovery: Understand reporting requirements, KPIs, and audience.
- Planning: Develop strategy and approach (data sources, format).
- Execution: Implement the plan (gather data, visualize).
- Review: Evaluate results and iterate.
- Optimization: Refine based on feedback.
Workflow 2: Advanced Social Media Reporter Optimization
Goal: Refine and optimize existing social media reporting.
- Research: Gather relevant information on new metrics/tools.
- Analysis: Evaluate options and approaches.
- Decision: Choose the best path forward.
- Implementation: Execute with precision.
- Measurement: Track success metrics.
Best Practices
- Start with Clear Objectives: Define what success looks like (e.g., actionable insights) before beginning work.
- Follow Industry Standards: Leverage proven frameworks and best practices in business reporting.
- Iterate Based on Feedback: Continuously improve based on results and stakeholder input.
- Document Your Process: Keep track of decisions and formulas.
- Focus on Quality: Prioritize excellence and accuracy over speed.
Checklist
Before considering your work complete:
- Objectives clearly defined and understood
- Research and discovery phase completed
- Strategy or plan documented
- Implementation matches requirements
- Quality standards met
- Stakeholders informed and aligned
- Results measured against goals
- Documentation updated
- Feedback collected
- Next steps identified
Common Mistakes
| Mistake | Why It's Bad | Better Approach |
|---|---|---|
| Skipping research | Misaligned solutions | Invest time in understanding context |
| Ignoring best practices | Reinventing the wheel | Study successful examples first |
| No clear metrics | Can't measure success | Define KPIs upfront |
Integration Points
- Tools: Integration with common business platforms (Tableau, Looker, Excel).
- Workflows: Fits into existing operations workflows.
- Team: Collaborates with leadership and operations stakeholders.
Success Metrics
- Quality of output
- Time to completion
- Stakeholder satisfaction
- Impact on business goals
- Reusability of approach
Related Skills
Xlsx
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
Clickhouse Io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Clickhouse Io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Analyzing Financial Statements
This skill calculates key financial ratios and metrics from financial statement data for investment analysis
Data Storytelling
Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.
Kpi Dashboard Design
Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.
Dbt Transformation Patterns
Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.
Sql Optimization Patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
Anndata
This skill should be used when working with annotated data matrices in Python, particularly for single-cell genomics analysis, managing experimental measurements with metadata, or handling large-scale biological datasets. Use when tasks involve AnnData objects, h5ad files, single-cell RNA-seq data, or integration with scanpy/scverse tools.
Xlsx
Spreadsheet toolkit (.xlsx/.csv). Create/edit with formulas/formatting, analyze data, visualization, recalculate formulas, for spreadsheet processing and analysis.