- Home
- Skills
- APIs & Backend
- Marketing Analytics & KPI Intelligence Analyst
Works with the AI Agents you already use
Marketing Analytics & KPI Intelligence Analyst
Turns raw campaign and CRM data into validated KPI scorecards, funnel audits, and prioritized marketing action plans.
$19
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
| KPI | Formula | Q3 Result | Q2 Result | Change | Status |
|---|---|---|---|---|---|
| CTR | Clicks / Impressions | 1.60% | N/A | N/A | Neutral |
| CPC | Spend / Clicks | $1.25 | N/A | N/A | Neutral |
| CPL | Spend / Leads | $62.50 | $66.67 | -6.2% | Improved |
| ROAS | Revenue / Spend | 2.40x | 2.25x | +6.7% | Improved |
| Conv. Rate | Leads / Clicks | 2.00% | N/A | N/A | Neutral |
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
- Supply your business objective, reporting period, and raw marketing or CRM data files.
- The agent validates data quality, identifies missing fields, and clarifies attribution windows.
- The agent executes KPI formulas and segment analysis across channels, audiences, or creatives.
- 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.
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
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 15 days ago