- Home
- Skills
- Marketing & SEO
- Customer Analytics & RFM Segmentation
Works with the AI Agents you already use
Customer Analytics & RFM Segmentation
Analyze customer transactions, identify valuable customer segments using RFM, calculate revenue KPIs, and generate actionable marketing and retention recommendations.
Free
Customer Analytics & RFM Segmentation
Example session with this skill installed
Analyze my customer transactions CSV. Calculate total revenue, average order value, customer RFM scores, and customer segments. Identify high-value customers and recommend targeted marketing and retention actions.
- Read your context and instructions
- Compiled the customer analytics
- Generated the data export
Customer Analytics Report — Synthetic Demo
Executive Summary
Analyzed 12 transactions from 9 customers, covering August 17 to November 5, 2026. Total observed revenue was 885 currency units, with an average order value of 73.75.
RFM Segments
| Segment | Customers | Customer Share | Revenue Share |
|---|---|---|---|
| Champions | 3 | 33.33% | 54.24% |
| New / Promising | 1 | 11.11% | 22.60% |
| Other | 5 | 55.56% | 23.16% |
Key Findings
- Three Champions account for more than half of total observed revenue.
- One New / Promising customer contributes 22.60% of observed revenue.
- Other customers represent most of the customer base but generate less than a quarter of revenue.
Recommendations
- Champions: Test loyalty rewards and referral campaigns. Track repeat purchase rate and incremental revenue against a randomized control group.
- New / Promising: Test onboarding and second-purchase messages to encourage repeat transactions.
- Other: Review order history and customer context before choosing a retention strategy.
Files Produced
- summary.json
- customer_segments.csv
- segment_summary.csv
- report.md
Methodological Notes
RFM scores are descriptive percentile-based measures. Segments follow predefined rules. The demo does not establish causal effects, future purchase probability, or campaign ROI. All observations are synthetic.
customer_segments.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
Customer Analytics & RFM Segmentation
Turn raw customer transaction data into actionable business intelligence.
This skill helps marketing teams, business analysts, entrepreneurs, and data professionals understand customer purchasing behavior and identify opportunities to improve retention and customer engagement.
What it does
- Customer segmentation: Classifies customers using Recency, Frequency, and Monetary (RFM) analysis.
- Revenue analytics: Calculates total revenue, average order value, purchasing frequency, and revenue contribution by segment.
- Customer behavior: Identifies high-value, loyal, at-risk, and promising customer groups.
- Marketing recommendations: Suggests targeted retention, loyalty, onboarding, and customer reactivation strategies.
- Reproducible reporting: Generates structured summaries and customer segmentation outputs using Python.
How it works
Provide a CSV dataset containing customer IDs, transaction IDs, dates, and transaction values. The skill validates the input, calculates RFM scores, segments customers, and creates a report with practical recommendations.
Ideal for
E-commerce businesses, marketing analysts, CRM teams, data analysts, and small businesses looking to understand customer value.
Important
This version uses interpretable RFM scoring rather than K-means clustering. It runs locally on user-provided data without requiring external APIs. Its recommendations are descriptive and should be validated through controlled experiments before being treated as proven marketing outcomes.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Marketing & SEO.
Requires Python 3.10+ and pandas. Uses rule-based heuristics rather than machine learning clustering. Cannot predict future churn or calculate ROI without cost 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 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
- Software
Pythonpandas
This skill reads user-provided CSV transaction data, runs a local Python analysis, and writes customer segmentation reports. No external network services or API credentials are required.