customer marketing analytics

    1

    Turn raw customer transaction data into KPI reports and segmented marketing insights.

    Free

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    customer marketing analytics

    Example session with this skill installed

    I've uploaded my Q3 transaction CSV. Can you analyze the customer segments and give me the key KPIs?

    • Read your context and instructions
    • Compiled the customer marketing analytics

    I have processed the Q3 transaction dataset containing 1,240 rows spanning from July 1 to September 30.

    Q3 Marketing Analytics Report

    Data Summary

    • Total Records: 1,240 transactions
    • Date Range: 2023-07-01 to 2023-09-30
    • Key Columns Found: CustomerID, OrderValue, OrderDate, CampaignID

    KPI Results

    MetricValue
    Total Revenue$84,250.00
    Average Order Value (AOV)$67.94
    Total Unique Customers812
    Repeat Purchase Rate28.5%
    Est. Customer Lifetime Value$103.75

    Customer Segments

    • High Value (122 customers / 15%): Contributed 42% of total revenue. Multiple purchases over $150.
    • Medium Value (340 customers / 42%): Consistent moderate spenders.
    • Low Value / One-time (250 customers / 31%): Single purchase users.
    • At Risk (100 customers / 12%): No activity in the last 45 days of the quarter.

    Key Insights

    • High-value customers are driving a disproportionate amount of revenue, suggesting a need for a dedicated loyalty program.
    • The Repeat Purchase Rate is healthy at 28.5%, but there is a significant drop-off after the first purchase for 31% of the base.
    • Customers acquired in July show a 15% higher LTV than those acquired in September.

    Recommendations

    1. Launch a Win-Back Campaign: Target the 100 "At Risk" customers with a time-limited discount code.

    Upsell Medium Spenders: Implement a "Frequently Bought Together" recommendation engine to increase AOV for the largest segment.
    3. VIP Early Access: Offer high-value customers early access to Q4 product launches to maintain retention.

    Next steps

    • Provide campaign spend data to calculate specific ROI per channel.
    • Upload Q2 data to perform a quarter-over-quarter growth comparison.

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

    About this skill

    Stop guessing which customers drive your revenue. This skill transforms raw transaction exports into actionable marketing intelligence by identifying high-value segments and calculating core growth metrics.

    What it does

    • Metric calculation tracks total revenue, AOV, and customer lifetime value from raw data.
    • Automated segmentation categorizes users into high-value, medium-value, at-risk, and new customer groups.
    • Retention tracking calculates repeat purchase rates to measure brand loyalty.
    • Campaign analysis evaluates response and conversion rates when marketing data is provided.
    • Data sanitization handles missing values and validates key columns before processing.

    How it works

    1. Provide a CSV or Excel export containing customer transactions or marketing logs.
    2. The skill audits the dataset for required columns like spend, date, and customer ID.
    3. It executes segmentation logic and KPI calculations based on your specific date range.
    4. You receive a structured report including a data summary, KPI table, and strategic recommendations.

    Frameworks & tools

    This skill is designed for standard data exports including CSV, Excel, and JSON formats containing transactional or campaign records.

    Why this beats prompting it yourself

    Generic prompts often overlook "At Risk" segments or fail to normalize AOV calculations across different time periods. This skill applies consistent segmentation logic and ensures that missing data points are flagged rather than ignored or hallucinated.

    Use cases

    • Analyze monthly Shopify or Stripe exports to find top-tier customers.
    • Identify "At Risk" users for a targeted win-back email campaign.
    • Evaluate the ROI of recent marketing spend by calculating campaign response rates.
    • Generate a high-level KPI report for a stakeholder or client presentation.

    Known limitations

    Requires specific columns like spend, dates, or customer IDs to calculate metrics. Cannot fetch data directly from live APIs.

    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.

    Requires manual upload of CSV/Excel data. Cannot calculate specific KPIs if relevant columns like transaction dates or campaign tags are missing from the source file.

    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

    Free to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed today

    • Free with an Agensi account

    Permissions

    No special permissions declared or detected

    Listedtoday

    What's inside

    Frequently Asked Questions

    Turn raw customer transaction data into KPI reports and segmented marketing insights.

    This skill uses the open SKILL.md standard. Use it through an MCP-compatible agent connected to Agensi, and check the compatibility information on this page for confirmed agents and required capabilities.

    Connect your AI agent to Agensi through MCP, then ask it to use customer marketing analytics on your task. Your agent loads the latest approved version each time. Paid skills require a purchase or active subscription. Skill files are not available for download; your licence does not allow you to save, copy or export any part of a skill.

    New in Research & Analysis

    Free