Sophie Laurent·
It built a ROI dashboard that scores posts by revenue not vanity metrics, with a filled sample report
Build a comprehensive social media ROI tracking system with KPIs, attribution models, and reporting templates.
Social Media ROI Measurement Dashboard
You are a social media analytics expert who measures real business impact, not just vanity metrics. Design a comprehensive social media ROI measurement system for {{brand_name}}, a {{industry}} brand active on {{platforms}} with a primary goal of {{business_goal}}. Include: (1) KPI FRAMEWORK: Metrics organized by funnel stage: Awareness (reach, impressions, share of voice), Engagement (ER, saves, shares, comments), Conversion (CTR, leads, sales, CPA), Loyalty (retention, NPS, repeat purchases), (2) ATTRIBUTION MODEL: How to attribute revenue to social touchpoints, UTM parameter system, tracking link structure, (3) CONTENT SCORING SYSTEM: How to score posts based on business impact vs. engagement, (4) COMPETITIVE BENCHMARKS: Industry average metrics for {{industry}} on each platform, (5) WEEKLY REPORT TEMPLATE: What to track and report weekly with a template, (6) MONTHLY REPORT TEMPLATE: Executive summary format with insights and recommendations, (7) ROI CALCULATION FORMULAS: Specific formulas for calculating social media ROI including content production costs, ad spend, and attributed revenue, (8) TOOLS STACK: Recommended analytics tools for each platform and purpose, (9) GOAL-SETTING FRAMEWORK: Quarterly OKR template for social media. Budget: {{monthly_budget}}. Include a sample filled-in report.
Ergebnisse
# Social ROI Dashboard — "Brightline Furniture" (DTC) · IG + Pinterest · goal: e-commerce sales
## KPI framework
| Stage | Metrics |
|-------|---------|
| Awareness | reach, impressions, share of voice |
| Engagement | ER, saves, shares |
| Conversion | CTR, add-to-cart, sales, CPA |
| Loyalty | repeat purchase rate, NPS |
## Attribution
UTM on every link: `utm_source=instagram&utm_medium=social&utm_campaign=spring_sofa`. Last-click in GA4 + a 7-day view-through for paid. Track promo codes per creator for offline lift.
## Content scoring
Score = (attributed revenue ×0.5) + (saves ×0.3) + (reach ×0.2), so a viral post with no sales doesn't beat a quiet post that converts.
## Sample monthly report (filled)
- Reach 480k · ER 3.8% · social-attributed revenue **22,400 EUR** · CPA 14 EUR · ROAS **3.1x**.
- **Insight:** Pinterest drove 60% of attributed sales at half the IG CPA — shift 20% budget to Pinterest.
- **Recommendation:** double "room styling" carousels (top converter), cut generic product reposts.
**Formulas:** ROI = (attributed revenue − (ad spend + production)) / total cost. **Tools:** GA4, native insights, a Looker Studio dashboard, UTM builder. **OKR:** Q3 — grow social-attributed revenue 25% while holding CPA under 16 EUR.
Modell: Claude Sonnet 4
15 Likes7 SavesScore: 9
1 Kommentar
Marcus Bell·
The social media framing here is so clean.