- Home
- Skills
- Research & Analysis
- Social Campaign ROI Calculator & Analyst
Works with the AI Agents you already use
Social Campaign ROI Calculator & Analyst
Calculate and audit social media campaign ROI, CAC, and engagement metrics with transparent formulas.
$19.99
Social Campaign ROI Calculator & Analyst
Example session with this skill installed
Analyze this Meta campaign data: Spend $5,000, Revenue $12,500, Purchases 100, Impressions 250,000, Clicks 3,500. Calculate ROAS, CAC, and CTR. Provide a brief insight.
- Read your context and instructions
- Compiled the social campaign roi
I have analyzed the Meta campaign data provided. Calculations are based on the reported $5,000 spend and $12,500 attributed revenue.
Campaign Performance Audit
| Metric | Formula | Calculation | Result |
|---|---|---|---|
| ROAS | Revenue / Ad Spend | $12,500 / $5,000 | 2.50x |
| CAC | Spend / New Customers | $5,000 / 100 | $50.00 |
| CTR | (Clicks / Impressions) x 100 | (3,500 / 250,000) x 100 | 1.40% |
| CPC | Spend / Clicks | $5,000 / 3,500 | $1.43 |
| Conv. Rate | (Purchases / Clicks) x 100 | (100 / 3,500) x 100 | 2.86% |
Data Quality and Assumptions
- Attribution: Assumed 7-day click / 1-day view based on standard Meta defaults unless specified otherwise.
- Costs: Calculations only include ad spend; creative production or agency fees are not factored into this ROI.
- Currency: USD.
Key Findings
Healthy Top-of-Funnel: A 1.40% CTR is generally strong for social feeds, suggesting the creative is effectively capturing attention.
Efficiency Gap: While the ROAS is 2.5x, the $50 CAC must be measured against your Product Margin to determine true profitability.
Conversion Opportunity: The 2.86% click-to-purchase rate is stable, but a small lift here would significantly move the ROAS toward a 3.0x+ target.
Next steps
- Provide your product margin or AOV to calculate true profit-based ROI.
- Share landing page session data to see if drop-off is happening between the click and the site load.
- Compare this to a previous period to check for creative fatigue.
Connects securely to your tools. The creator never sees your data.
About this skill
Stop guessing if your social ads are actually profitable. This skill acts as a dedicated marketing analytics specialist, transforming raw campaign exports into transparent ROI calculations and performance audits. It eliminates the ambiguity of "platform-reported" success by applying rigorous formulas to your specific spend and revenue data.
What it does
- Transparent ROI/ROAS: Calculates return on investment and ad spend using your specific attribution windows and profit margins.
- Unit Economics: Breaks down Customer Acquisition Cost (CAC) and Cost Per Acquisition (CPA) by campaign or platform.
- Engagement Audits: Analyzes Cost Per Engagement (CPE) and engagement rates using reach, impressions, or followers as denominators.
- Funnel Performance: Tracks CTR and conversion rates from click-to-lead or session-to-purchase to identify friction points.
- Platform Comparisons: Builds normalized tables to compare performance across different ad networks despite varying metrics.
How it works
- Data Intake: Provide campaign names, spend, revenue, impressions, clicks, and conversion counts.
- Validation: The skill flags missing fields, inconsistent currencies, or incompatible attribution models.
- Calculation: It generates a KPI dashboard showing the exact formulas used for every metric.
- Analysis: It identifies high-spend/low-return outliers and creative fatigue based on your data.
Frameworks & tools
This skill is platform-agnostic and works with data exported from Meta Ads Manager, TikTok Ads, LinkedIn Campaign Manager, Google Analytics, and custom CSV/Excel tracking sheets.
Why this beats prompting it yourself
Standard LLMs often hallucinate ROI math or confuse ROAS with profit-based ROI. This skill enforces strict mathematical rules, prevents division-by-zero errors, and refuses to "fill in" missing data with fake benchmarks, ensuring your business decisions are based on reality.
Use cases
- Compare Meta vs. TikTok performance to reallocate monthly budget.
- Calculate true profit ROI by factoring in agency fees and production costs.
- Identify why high-CTR campaigns are failing to convert on the landing page.
- Audit creator/influencer campaign efficiency using standardized CPE metrics.
Known limitations
Does not have direct API access to live ad accounts. Requires manual data input or pasted exports. Cannot verify the accuracy of the attribution data supplied by the user.
No live API access to ad platforms. Relies entirely on user-provided exports. Cannot validate the accuracy of third-party attribution data.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 17 days ago
Permissions
No special permissions declared or detected