- Home
- Skills
- Research & Analysis
- customer marketing analytics
customer marketing analytics
Turn raw customer transaction data into KPI reports and segmented marketing insights.
Free
Works with the AI Agents you already use
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
| Metric | Value |
|---|---|
| Total Revenue | $84,250.00 |
| Average Order Value (AOV) | $67.94 |
| Total Unique Customers | 812 |
| Repeat Purchase Rate | 28.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
- 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
- Provide a CSV or Excel export containing customer transactions or marketing logs.
- The skill audits the dataset for required columns like spend, date, and customer ID.
- It executes segmentation logic and KPI calculations based on your specific date range.
- 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
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
Permissions
No special permissions declared or detected