Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Marketing Analytics & KPI Intelligence Analyst

    1

    Turns raw campaign and CRM data into validated KPI scorecards, funnel audits, and prioritized marketing action plans.

    $19

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Marketing Analytics & KPI Intelligence Analyst

    Marketing Analytics & KPI Intelligence Analyst

    Example session with this skill installed

    Act as my Marketing Analytics Analyst. Analyze this Q3 Facebook Ads data: $5000 spend, 250k impressions, 4k clicks, 80 leads, $12k revenue. Compare to Q2: $4k spend, 60 leads, $9k revenue.

    • Read your context and instructions
    • Compiled the marketing analytics

    I have analyzed the Facebook Ads performance data for Q3 compared to the Q2 baseline. Calculations use the formulas and data points provided below.

    Marketing Analytics & KPI Intelligence Report

    Executive summary

    • Business objective: Lead Generation and Revenue Growth
    • Reporting period: Q3 (Current) vs Q2 (Prior)
    • Channels/campaigns analyzed: Facebook Ads
    • Spend: $5,000 (Q3) vs $4,000 (Q2)
    • Leads/conversions: 80 (Q3) vs 60 (Q2)
    • Revenue: $12,000 (Q3) vs $9,000 (Q2)
    • Main performance finding: Scaling spend by 25% resulted in a 33% increase in leads and revenue, indicating positive marginal returns.
    • Data limitations: Clicks and impressions for Q2 were not provided; CTR and CPC comparisons are unavailable.

    KPI scorecard

    KPIFormulaQ3 ResultQ2 ResultChangeStatus
    CTRClicks / Impressions1.60%N/AN/ANeutral
    CPCSpend / Clicks$1.25N/AN/ANeutral
    CPLSpend / Leads$62.50$66.67-6.2%Improved
    ROASRevenue / Spend2.40x2.25x+6.7%Improved
    Conv. RateLeads / Clicks2.00%N/AN/ANeutral

    Key insights

    Efficiency Gains during Scaling: Despite a 25% budget increase, the Cost Per Lead (CPL) decreased by 6.2%. This suggests that the audience targeting remains effective at higher spend levels.
    2.

    Improved Return on Ad Spend: ROAS increased from 2.25x to 2.40x. The revenue growth (33.3%) outpaced the spend growth (25%), showing high-value conversion efficiency.
    3.

    Funnel Health: A 2.0% Click-to-Lead conversion rate is a stable baseline for this channel, though Q2 comparison is needed to confirm if landing page performance has shifted.

    Recommended action plan

    Priority 1: Increase Q4 budget by an additional 15% ($750) to test the upper limit of current audience saturation.

    • Priority 2: Implement UTM tracking for Q2 historical comparisons to capture CTR and CPC data for trend analysis.

    Priority 3: Audit the landing page for the top-performing Q3 ad sets to identify why CPL improved during the scale-up.

    Next steps

    • Provide Q2 click and impression data to complete the trend analysis.
    • Upload audience-level data to identify which segments drove the CPL reduction.
    • Confirm if the $12k revenue is gross sales or includes shipping/taxes for accurate ROAS.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Raw marketing data is often a mess of inconsistent attribution, missing denominators, and vanity metrics that hide real business impact. This skill acts as a dedicated performance analyst to clean your data, calculate verified KPIs, and identify where your budget is actually working. It transforms CSV exports or platform data into a structured intelligence report with an emphasis on mathematical accuracy and funnel visibility.

    What it does

    • Data validation audits your sources for missing values, inconsistent naming, and attribution mismatches.
    • KPI calculation generates accurate CTR, CPC, CPA, ROAS, and conversion rates using explicit formulas and denominators.
    • Funnel mapping tracks the journey from impressions to revenue to isolate specific drop-off points.
    • Performance benchmarking compares channels and campaigns against historical baselines and volume-adjusted targets.
    • Action planning builds prioritized lists of optimizations with success metrics and guardrail KPIs.

    How it works

    1. Supply your business objective, reporting period, and raw marketing or CRM data files.
    2. The agent validates data quality, identifies missing fields, and clarifies attribution windows.
    3. The agent executes KPI formulas and segment analysis across channels, audiences, or creatives.
    4. You receive a comprehensive report with a scorecard, trend analysis, and a prioritized action plan.

    Frameworks & tools

    This skill works with data exported from Google Ads, Meta Ads, LinkedIn, GA4, Shopify, and various CRM platforms. It performs analysis using standard marketing mathematics and funnel logic.

    Why this beats prompting it yourself

    Generic prompts often hallucinate benchmarks or confuse correlation with causation. This skill enforces strict reporting principles, requiring explicit denominators for every rate and preventing the common mistake of equating ROAS with net profit.

    Use cases

    • Auditing monthly multi-channel ad spend to find budget inefficiencies.
    • Identifying the exact stage where leads drop off in a B2B sales funnel.
    • Comparing creative performance across different audience segments with volume-adjusted metrics.
    • Preparing executive-ready performance summaries that separate platform data from verified revenue.

    Known limitations

    Does not support direct API execution or live budget adjustments. Analysis is limited to the data provided and cannot account for external market volatility or offline conversions not in the dataset.

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

    No direct API access to ad platforms. Cannot modify live budgets or campaigns. Limited to data provided in the prompt or uploaded files. Does not perform statistical significance testing.

    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 15 days ago

    Permissions

    Read Files
    Listed15 days ago

    What's inside

    Frequently Asked Questions

    Simply upload your CSV exports or paste raw data from platforms like Google Ads, Meta, or your CRM. The agent will then guide you through a validation step to ensure your attribution windows and data fields are correctly mapped before starting the analysis.

    Unlike basic prompts that might guess metrics, this skill enforces mathematical rigor by requiring explicit denominators for every KPI. It uses a structured auditing framework to separate vanity metrics from actual revenue, preventing common errors like over-reporting ROAS or ignoring funnel drop-offs.

    The agent analyzes performance across Google Ads, Meta, LinkedIn, GA4, Shopify, and most CRM exports. It is designed to reconcile these disparate sources into a single, unified funnel view to show you how different channels are working together.

    You receive full access to the Marketing Analytics skill, including all built-in KPI formulas, the automated data validation workflow, and the structured reporting templates for funnel audits and action plans.

    The skill is currently designed for static data analysis via file uploads or text input and does not have the ability to log into your ad accounts or make live budget changes. This ensures you maintain full control over your platforms while receiving the intelligence needed to make manual adjustments.

    New in APIs & Backend