New User Retention Path

I. Calculator Introduction

The New User Retention Path Calculator is a specialized tool for tracking new users' behavior completion within key time windows, forming a retention conversion ladder. By analyzing user behavior completion rates at different time points after registration (next day, 3 days, 7 days, 15 days, 30 days, 60 days), this tool helps you gain deep insights into new users' retention conversion paths, identify key churn points, and provide data support for developing new user activation and retention strategies.

Core Features

• Retention Conversion Ladder Analysis: Tracks new users' behavior completion within key time windows after registration (next day, 3 days, 7 days, 15 days, 30 days, 60 days), forming a retention conversion ladder that visually displays key churn points
• Registration Day Activity Statistics: Statistics on the proportion of users with order behavior on the registration day, evaluating the conversion effectiveness of new users on registration day
• Monthly Retention Path Details: Groups by registration month, statistics on retention within each time window, facilitating observation of new user retention performance across different periods
• Overall Retention Rate Calculation: Calculates key metrics such as overall 7-day retention rate to evaluate new user retention effectiveness

Application Scenarios

• Identify key time points of new user churn and develop targeted activation strategies
• Evaluate the effectiveness of new user activation and retention strategies, optimizing operation plans
• Observe new user retention performance across different periods, identifying signals of business growth or decline
• Analyze new user retention conversion paths, optimizing product experience and user onboarding processes
• Develop new user activation and retention strategies to improve new user retention rates

Applicable Customers

This calculator is suitable for all industries and scenarios that need to analyze new user retention conversion paths, particularly suitable for the following types of customers:

• Food & Beverage Industry: Restaurants, fast food stores, coffee shops, bubble tea shops, etc., analyzing consumption conversion paths of new users after registration, identifying key churn points, and developing new user activation and retention strategies
• E-commerce Platforms: B2C e-commerce, C2C platforms, vertical e-commerce, etc., tracking purchase conversion paths of new users after registration, optimizing new user onboarding processes and product recommendation strategies
• Retail Industry: Supermarkets, convenience stores, specialty stores, brand retail, etc., understanding consumption conversion paths of new users after registration, developing member marketing and promotion strategies
• Life Services: Beauty salons, fitness clubs, car wash services, home services, etc., analyzing service usage conversion paths of new users after registration, evaluating the impact of service quality on user retention
• Online Education: Online course platforms, training institutions, etc., tracking course purchase and learning conversion paths of new students after registration, optimizing course content and learning experience
• Subscription Services: Video platforms, music platforms, reading platforms, etc., analyzing subscription conversion paths of new users after registration, evaluating service quality and user satisfaction
• Other B2C Businesses: Any business targeting individual consumers, as long as it involves new user acquisition and retention conversion analysis, can use this tool for analysis

Prerequisites: Your business needs to be able to provide data on user ID, event date (order date or behavior date), and registration date, and the data should contain historical behavior records of new users.

---

II. Algorithm Introduction

2.1 Core Concepts

Retention Definition

Retention: Users have order or behavior records within a specified time window.

For example:

• User A registered on 2024-01-01 and placed an order on 2024-01-02 → Next Day Retention
• User B registered on 2024-01-01, placed an order on 2024-01-01, and placed an order on 2024-01-03 → Registration Day Active, and 3-Day Retention
• User C registered on 2024-01-01, placed an order on 2024-01-01, but had no orders within 60 days thereafter → Registration Day Active, but No Subsequent Retention

Time Window Definition

The system defines the following key time windows (milestones):

• Registration Day Active: Order or behavior records on the registration date
• Next Day Retention: Order or behavior records on the 2nd day after registration (registration + 1 day)
• 3-Day Retention: Order or behavior records within days 2-3 after registration (registration + 1 day to registration + 3 days)
• 7-Day Retention: Order or behavior records within days 2-7 after registration (registration + 1 day to registration + 7 days)
• 15-Day Retention: Order or behavior records within days 2-15 after registration (registration + 1 day to registration + 15 days)
• 30-Day Retention: Order or behavior records within days 2-30 after registration (registration + 1 day to registration + 30 days)
• 60-Day Retention: Order or behavior records within days 2-60 after registration (registration + 1 day to registration + 60 days)

Note: All time windows are calculated starting from the 2nd day after registration, excluding the registration day. Behavior on the registration day is separately counted as "Registration Day Active".

Retention Rate Definition

Retention Rate: The proportion of users with order or behavior records within a specified time window to the total number of new users.

Retention Rate = Number of users with behavior in the time window / Total number of new users

For example:

• 7-Day Retention Rate = Number of users with orders within days 2-7 after registration / Total number of new users
• 30-Day Retention Rate = Number of users with orders within days 2-30 after registration / Total number of new users

2.2 Calculation Logic

Step 1: Data Preprocessing

The system performs the following processing on the data:

1. Parse Dates: Parse registration date and event date strings into date objects
2. Filter Invalid Data: Exclude records with missing user ID, registration date, or event date
3. User Grouping: Group by user ID, collecting registration date and all event dates for each user

Step 2: Group New Users by Registration Date

The system groups all new users by registration date:

1. Collect each user's registration date (recorded only once per user)
2. Collect all event dates (order date or behavior date) for each user
3. Group by registration date, forming different cohorts

Step 3: Calculate Registration Day Activity

For each user:

1. Check if the user has an event date equal to the registration date
2. If yes, the user belongs to "Registration Day Active" users

Step 4: Calculate Retention Users for Each Milestone

For each user and each milestone (1 day, 3 days, 7 days, 15 days, 30 days, 60 days):

1. Calculate time window: from the 2nd day after registration (registration + 1 day) to the Nth day after registration (registration + N days)
2. Check if the user has an event date falling within this time window
3. If yes, the user belongs to the retention users of this milestone

Example:

• User A registered on 2024-01-01 and placed an order on 2024-01-03 → Belongs to 3-day retention users (because 2024-01-03 falls within registration + 1 day to registration + 3 days)
• User B registered on 2024-01-01 and placed an order on 2024-01-05 → Belongs to 7-day retention users (because 2024-01-05 falls within registration + 1 day to registration + 7 days)

Step 5: Monotonicity Verification and Correction

The system ensures monotonicity of retention numbers:

• 60-day retention users ≥ 30-day retention users ≥ 15-day retention users ≥ 7-day retention users ≥ 3-day retention users ≥ next day retention users
• If the retention number of a milestone is greater than the next milestone, the system automatically corrects it to the value of the next milestone
• This ensures the rationality of the retention conversion ladder (longer time windows should have more or equal retention numbers)

Step 6: Aggregate Data by Month

The system aggregates daily grouped data into monthly grouped data:

1. Group all registration dates by month (YYYY-MM format)
2. For each month, summarize data for all users registered in that month
3. Calculate retention numbers and retention rates for each milestone
4. Keep only the most recent 12 calendar months of data

Step 7: Calculate Overall Retention Rates

The system calculates overall retention rates:

• Overall Registration Day Activity Rate = Total number of registration day active users / Total number of new users
• Overall 7-Day Retention Rate = Total number of 7-day retention users / Total number of new users
• Other milestones' retention rates are calculated in the same way

Step 8: Result Display

1. Overall Metrics:
   • Overall 7-Day Retention Rate: Proportion of 7-day retention users among all new users
2. Retention Path Details Table:
   • Grouped by registration month, displaying retention numbers and retention rates within each time window
   • Includes columns such as Registration Day Active, Next Day, 1-3 Days, 1-7 Days, 1-15 Days, 1-30 Days, 1-60 Days
   • Displays only the most recent 12 months of data
3. Retention Conversion Ladder Chart:
   • Displays the conversion path from Registration Day Active to 60-Day Retention in a ladder format
   • Each stage shows retention numbers and retention rates
   • Facilitates observation of key churn points

2.3 Data Filtering Rules

• Data Integrity: Records with missing key fields (user ID, registration date, event date) are automatically excluded
• Date Parsing: The system automatically recognizes common date formats, and dates that cannot be parsed are excluded
• Time Range: The monthly details table displays only the most recent 12 calendar months of data, but overall retention rate calculation is based on all data
• User Deduplication: Each user is counted only once in the same milestone, even if multiple event dates fall within that time window

---

III. Usage Instructions and Notes

3.1 Data Preparation

Required Fields

Before importing data, please ensure your data file contains the following three fields:

1. User ID (user_id)
   • Description: Field that uniquely identifies users (user ID or phone number are both acceptable)
   • Format Requirements: Text or numbers are both acceptable
   • Examples: U001, 12345, 13800138000
2. Event Date (event_date)
   • Description: Date when user behavior occurred (order date or behavior date)
   • Format Requirements: Supports multiple date formats (such as YYYY-MM-DD, YYYY/MM/DD, MM/DD/YYYY, etc.)
   • Notes: The system automatically recognizes common date formats. It is recommended to use standard date formats to ensure accurate parsing
3. Registration Date (register_date)
   • Description: Date when user registered (used to define cohort starting point), format such as 2025-01-01 or 2025/1/1
   • Format Requirements: Supports multiple date formats (such as YYYY-MM-DD, YYYY/MM/DD, MM/DD/YYYY, etc.)
   • Notes: The system automatically recognizes common date formats. It is recommended to use standard date formats to ensure accurate parsing

Data Format Requirements

• File Format: Supports CSV and Excel (.xlsx) formats
• Encoding: UTF-8 encoding is recommended
• Data Volume: It is recommended that the data volume for a single analysis does not exceed 1 million records to ensure calculation efficiency
• Data Range: It is recommended to include sufficient historical data to accurately calculate new user retention paths. At least the most recent 12 months of data should be included to observe monthly retention trends

3.2 Field Mapping

After uploading data, the system will ask you to map columns in your data file to the following fields:

• User ID Column → Select the column containing unique user identifiers
• Event Date Column → Select the column containing user behavior dates (order dates)
• Registration Date Column → Select the column containing user registration dates

3.3 Data Filtering (Optional)

The system supports filtering by event date:

• Date Range Filtering: You can specify the time range for analysis, analyzing only data within the specified time period
• Usage Recommendation: If the data volume is large, it is recommended to filter to the most recent 1-2 years of data first to improve calculation speed

3.4 Result Interpretation

Metric Description

• Overall 7-Day Retention Rate: Reflects the overall retention effectiveness of new user groups, an important metric for measuring the effectiveness of new user activation and retention strategies. Higher 7-day retention rates indicate higher satisfaction with products or services and more effective user activation strategies
• Registration Day Activity Rate: Reflects the conversion effectiveness of new users on registration day, an important metric for evaluating new user onboarding processes and registration day conversion strategies. Higher registration day activity rates indicate more effective new user onboarding processes
• Retention Conversion Ladder: Displays the conversion path from Registration Day Active to 60-Day Retention, helping identify key churn points. Gentler ladder decline indicates better user retention effectiveness

Retention Path Analysis

• Registration Day Active: This is the starting point of retention conversion. If the registration day activity rate is low, it is necessary to optimize new user onboarding processes and registration day conversion strategies
• Next Day Retention: Reflects the activity of new users on the second day after registration. If the next day retention rate drops significantly, it may indicate problems with the new user onboarding process
• 3-Day and 7-Day Retention: These are key windows for new user retention. If retention rates at these stages are low, it is necessary to strengthen new user activation strategies
• 15-Day, 30-Day, 60-Day Retention: Reflect long-term retention effectiveness of new users. If retention rates at these stages continue to decline, it is necessary to optimize product experience and service quality

Monthly Trend Analysis

• Upward Trend: Retention rates show an upward trend, indicating that new user activation and retention strategies are effective and business is developing healthily
• Downward Trend: Retention rates show a downward trend, requiring attention to new user onboarding processes, product experience, or operation strategies, and timely adjustments
• High Volatility: There may be seasonal factors, marketing activity impacts, or external environment changes, requiring analysis combined with business conditions

3.5 Notes

⚠️ Important Notes

💡 Usage Recommendations

3.6 Frequently Asked Questions

Q1: Why are some users in my data not counted?

A: Possible reasons include:

• Users are missing user ID fields
• Users are missing registration date fields
• Users are missing event date fields
• User registration dates or event dates cannot be parsed

Q2: How are retention time windows calculated?

A: All retention time windows are calculated starting from the 2nd day after registration, excluding the registration day. For example:

• User A registered on 2024-01-01, next day retention means placing an order on 2024-01-02
• User B registered on 2024-01-01, 3-day retention means placing orders between 2024-01-02 and 2024-01-03
• User C registered on 2024-01-01, 7-day retention means placing orders between 2024-01-02 and 2024-01-07

Behavior on the registration day is separately counted as "Registration Day Active".

Q3: If a user places an order on the registration day, does it count as next day retention?

A: No. Next day retention means placing an order on the 2nd day after registration (registration + 1 day). Behavior on the registration day is separately counted as "Registration Day Active".

Q4: How is retention rate calculated?

A: Retention Rate = Number of users with behavior in the time window / Total number of new users. For example:

• 7-Day Retention Rate = Number of users with orders within days 2-7 after registration / Total number of new users
• 30-Day Retention Rate = Number of users with orders within days 2-30 after registration / Total number of new users

Q5: Why might 60-day retention users equal 30-day retention users in the retention conversion ladder?

A: This is normal. If a user placed an order within days 2-30 after registration, that user belongs to both 30-day retention users and 60-day retention users (because the 30-day window is contained within the 60-day window). The system ensures monotonicity of retention numbers: 60-day retention users ≥ 30-day retention users ≥ ... ≥ next day retention users.

Q6: How to improve new user retention rates?

A: It is recommended to start from the following aspects:

• Optimize new user onboarding processes to improve registration day activity rates
• Strengthen new user activation strategies, pushing coupons or activity information within key time windows after registration
• Improve product experience and service quality to increase user satisfaction
• Establish membership tier systems and point reward mechanisms to incentivize users to continue using
• Analyze retention conversion ladders to identify key churn points and develop targeted activation strategies
• Adjust new user activation and retention strategies in a timely manner based on monthly retention trends

---

IV. Summary

The New User Retention Path Calculator helps you fully understand new users' retention conversion paths through scientific algorithms and intuitive visualizations. Proper use of this tool can:

• Quickly identify key time points of new user churn and develop targeted activation strategies
• Evaluate the effectiveness of new user activation and retention strategies, optimizing operation plans
• Observe new user retention performance across different periods and adjust operation strategies in a timely manner
• Analyze new user retention conversion paths, optimizing product experience and user onboarding processes
• Provide data support for developing new user activation and retention strategies

If you have any questions or need technical support, please contact the system administrator.