meta-roi-framework
CommunityShow ROI of social media ads in one model.
Authorpeterbamuhigire
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Calculates and presents the ROI of a client’s social media and digital marketing investment using the Bodnar and Cohen (2012) formula: ROI = (TLV − COCA) ÷ COCA. Produces TLV calculations, COCA by channel, TLV:COCA ratio, attribution guidance, break-even analysis, a 12-month projection table, and consultant talking points for retainer justification.
Core Features & Use Cases
- TLV calculation using inputs such as average transaction value, transactions per year, and customer relationship length.
- COCA by channel: compute cost per new customer per channel with separate channel view and a blended estimate when attribution is unavailable.
- TLV:COCA ratio interpretation with actionable guidance per ratio tier.
- Bottom-Up Revenue Modelling: reverse-engineer required inquiries and opportunities from a revenue target.
- Attribution methodology: directional tracking plan using enquiry logs and UTM tracking to attribute sources.
- Break-even analysis: determine minimum new customers per month to cover the investment.
- 12-month ROI projection: monthly ROI and cumulative ROI based on conservative new-customer estimates.
Quick Start
Provide client data and financial inputs to generate a TLV, COCA, and 12-month ROI projection.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: meta-roi-framework Download link: https://github.com/peterbamuhigire/social-media-skills/archive/main.zip#meta-roi-framework Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.