Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Social Campaign ROI Calculator & Analyst

    1

    Calculate and audit social media campaign ROI, CAC, and engagement metrics with transparent formulas.

    $19.99

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Social Campaign ROI Calculator & Analyst

    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

    MetricFormulaCalculationResult
    ROASRevenue / Ad Spend$12,500 / $5,0002.50x
    CACSpend / New Customers$5,000 / 100$50.00
    CTR(Clicks / Impressions) x 100(3,500 / 250,000) x 1001.40%
    CPCSpend / Clicks$5,000 / 3,500$1.43
    Conv. Rate(Purchases / Clicks) x 100(100 / 3,500) x 1002.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

    1. Provide your product margin or AOV to calculate true profit-based ROI.
    2. Share landing page session data to see if drop-off is happening between the click and the site load.
    3. 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

    1. Data Intake: Provide campaign names, spend, revenue, impressions, clicks, and conversion counts.
    2. Validation: The skill flags missing fields, inconsistent currencies, or incompatible attribution models.
    3. Calculation: It generates a KPI dashboard showing the exact formulas used for every metric.
    4. 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.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Research & Analysis.

    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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    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

    Listed17 days ago

    What's inside

    Frequently Asked Questions

    This skill acts as a dedicated marketing analyst that calculates true ROI and CAC using rigorous formulas, preventing the common mathematical hallucinations and "vanity metric" bias often found in standard AI outputs.

    The skill is platform-agnostic; it works with any campaign data you can copy and paste or upload, including exports from Meta Ads, TikTok, LinkedIn, and Google Analytics.

    Yes, you can include overhead like agency fees, content production costs, and software subscriptions to move beyond simple ROAS and calculate your actual bottom-line profitability.

    No complex setup is required; once the skill is added to your workspace, you simply provide your raw campaign metrics, and it will guide you through the validation and analysis process.

    The skill provides a breakdown of every formula used in its calculations, ensuring you can audit the results and understand exactly how metrics like engagement rate or unit economics were derived.

    You receive lifetime access to the current version of the ROI Analyst, including any future performance tuning and logic updates released by the developer.

    New in Research & Analysis