Scribd
Upload
13 views3 pages

Alt Mobility Data Analysis Insights

The Alt Mobility Data Analyst Assessment reveals strong potential for customer lifetime value through improved retention, with a majority of repeat customers. It highlights issues with payment failures and infrequent reorder cycles, suggesting the need for engagement strategies and loyalty programs. Recommendations include addressing payment issues, targeting high-value segments, refining demand forecasting, and enhancing data monitoring to boost revenue and customer satisfaction.

Uploaded by

Suhani Life
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views3 pages

Alt Mobility Data Analysis Insights

The Alt Mobility Data Analyst Assessment reveals strong potential for customer lifetime value through improved retention, with a majority of repeat customers. It highlights issues with payment failures and infrequent reorder cycles, suggesting the need for engagement strategies and loyalty programs. Recommendations include addressing payment issues, targeting high-value segments, refining demand forecasting, and enhancing data monitoring to boost revenue and customer satisfaction.

Uploaded by

Suhani Life
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Alt Mobility Data Analyst Assessment

Key Insights from SQL Analysis


1. Customer Segmentation
- One-time customers: 2,932
- Repeat customers: 4,402
- Repeat customers form a majority, indicating strong potential for
customer lifetime value if retention is improved.
2. Revenue and Sales Patterns
- Average order value: ₹254
- Max order value: ₹500
- Highest revenue months: January and February
- Most active days for orders: Tuesday and Thursday
3. Order Frequency and Engagement
- Average time between orders: 480 days
- Indicates infrequent repeat ordering; suggests need for
engagement strategies to shorten reorder cycles.
4. Payment Behavior*
- Average payment attempts per order: 1.5, a moderate level of
friction in the payment process.
- Payment success and failure rates: Roughly equal, highlighting
potential issues in the payment funnel.
- High-value customers prefer PayPal, which also shows a higher
success rate.
- 2025 shows a spike in failed payments, suggesting recent
operational or technical issues.
Observations from Customer Retention Analysis
- Based on the cohort retention matrix:
- Initial acquisition is strong, especially in early 2020 cohorts.
- However, monthly retention significantly drops after the 1st or
2nd month.
- Long-term retention (after 6 months) is minimal across cohorts.
- Only a few cohorts (e.g., Jan & Feb 2020) maintain some degree
of customer engagement over time.
Interpretation:
- Initial onboarding and customer acquisition are effective.
- Lack of long-term incentives or communication may be causing
customer churn.
- Seasonal trends may also influence retention, especially around
the beginning of the year.
Recommendations for Alt Mobility
1. Improve Customer Retention
- Introduce loyalty programs or subscription models to
encourage reorders.
- Implement automated reminders or re-engagement campaigns
to reduce the 480-day gap between orders.
2. Address Payment Failures
- Investigate technical issues causing high failure rates in 2025.
- Promote PayPal as a preferred payment method, especially for
high-value customers.
- Optimize and simplify the payment interface to reduce retries
and drop-offs.
3. Target High-Value Segments
- Focus marketing and service upgrades on repeat and PayPal-
using customers, who likely represent a high lifetime value.
- Analyze these users’ order history to build personalized
upselling or cross-selling strategies.
4. Refine Demand Forecasting
- Given that Tuesday and Thursday drive higher orders, consider
ad campaigns or fleet availability increases during these
periods.
- Prioritize operations and support during Q1 (Jan–Feb) to match
peak demand.
5. Enhance Data Monitoring
- Build real-time dashboards to continuously track metrics such
as payment failures, cohort performance, and order volume
spikes.

This summary outlines actionable insights to help Alt Mobility


enhance revenue, customer satisfaction, and operational efficiency.

You might also like