I. Calculator Introduction
The User Repurchase Frequency Distribution Calculator is a specialized tool for analyzing user consumption frequency distribution and repurchase behavior. By counting the number of distinct order dates (distinct(order_date)) for each user, this tool helps you gain deep insights into user consumption habits, activity levels, and repurchase behavior characteristics, providing data support for developing user operation strategies and precision marketing.
Core Features
- Consumption Frequency Distribution Analysis: Statistics on user distribution across different consumption frequencies (number of distinct order dates), helping identify high-frequency and low-frequency user groups
- Overall Repurchase Rate Calculation: Calculates the proportion of users with repurchase behavior (
distinct(order_date) > 1) among all users
- Monthly Repurchase Rate Trends: Provides monthly repurchase rate trend charts to observe temporal patterns in user repurchase behavior
- User Activity Assessment: Evaluates overall user activity levels and consumption habits through frequency distribution data
Application Scenarios
- Identify high-frequency and low-frequency user groups to develop differentiated operation strategies
- Evaluate overall user activity levels and repurchase potential
- Observe repurchase rate trends over time to identify signals of business growth or decline
- Develop user activation and retention strategies to improve repurchase rates
- Analyze the impact of marketing activities on user repurchase behavior
Target Customers
This calculator is suitable for all industries and scenarios that need to analyze user consumption frequency and repurchase behavior, especially the following types of customers:
- Food & Beverage Industry: Restaurants, fast food chains, coffee shops, bubble tea shops, etc. Analyze user consumption frequency distribution, identify high-frequency and low-frequency customers, develop membership marketing and promotion strategies
- E-commerce Platforms: B2C e-commerce, C2C platforms, vertical e-commerce, etc. Analyze user purchase frequency distribution, optimize product recommendation strategies and user operation plans
- Retail Industry: Supermarkets, convenience stores, specialty stores, brand retail, etc. Understand user consumption frequency habits, develop membership tier systems and point reward mechanisms
- Life Services: Beauty salons, fitness clubs, car wash services, home services, etc. Analyze user service frequency distribution, evaluate how service quality promotes user repurchase
- Online Education: Online course platforms, training institutions, etc. Analyze student course purchase frequency, optimize course content and learning experience
- Subscription Services: Video platforms, music platforms, reading platforms, etc. Analyze user subscription renewal frequency, evaluate service quality and user satisfaction
- Other B2C Businesses: Any business targeting individual consumers, as long as it involves user consumption frequency analysis and repurchase behavior research, can use this tool for analysis
Prerequisites: Your business needs to be able to provide data with user ID and order date, and the data should include users' historical order records.
II. Algorithm Introduction
2.1 Core Concepts
Consumption Frequency Definition
Consumption Frequency: The number of distinct order dates (count(distinct order_date)) in a user's historical orders, not the total number of orders.
For example:
- User A placed 3 orders on 2024-01-01 and 2 orders on 2024-01-05 → Consumption frequency is 2 (2 distinct order dates)
- User B placed 1 order on 2024-01-01, 1 order on 2024-01-03, and 1 order on 2024-01-10 → Consumption frequency is 3 (3 distinct order dates)
- User C placed multiple orders on 2024-01-01, but only has 1 order date → Consumption frequency is 1 (no repurchase)
Repurchase Definition
Repurchase: User's consumption frequency is greater than 1, i.e., count(distinct order_date) > 1.
For example:
- User A has 2 distinct order dates → Has repurchase
- User B has only 1 order date (even if multiple orders on the same day) → No repurchase
Monthly Repurchase Rate Definition
Monthly Repurchase Rate: The proportion of users with repurchase behavior among all users in a specified month.
Monthly Repurchase Rate = Number of repurchase users in that month / Total number of users in that month
Where repurchase users are those with multiple distinct order dates in that month (distinct(order_date) > 1).
2.2 Calculation Logic
Step 1: Data Preprocessing
The system processes data as follows:
- Parse Order Dates: Parse order date strings into date objects
- Filter Invalid Data: Exclude records with missing user ID or order date
- Date Deduplication: Maintain an order date set (Set) for each user, automatically removing duplicate orders on the same date
Step 2: Calculate User Consumption Frequency
For each user:
- Collect all order dates for that user (using Set for automatic deduplication)
- Calculate the number of distinct order dates:
distinct_order_dates = Set.size
- Use the number of distinct order dates as the user's consumption frequency
Step 3: Build Frequency Distribution Table
The system counts the number of users for each consumption frequency:
- Frequency Grouping: Group users by consumption frequency (1, 2, 3, 4, 5, 6 and above)
- Frequency Display Rules:
- Frequencies 1-5: Display separately, one row per frequency
- Frequency 6 and above: Combined and displayed as "6+"
- Calculate Proportions: The proportion of users in each frequency group relative to total users
Step 4: Calculate Overall Repurchase Rate
Overall Repurchase Rate:
Overall Repurchase Rate = Number of users with consumption frequency > 1 / Total number of users
Step 5: Calculate Monthly Repurchase Rate Trends
The system calculates repurchase rates grouped by month:
- Group by Month: Group all orders by month (YYYY-MM format)
- Calculate Monthly Repurchase Rate: For each month
- Count all users with orders in that month
- Identify users with multiple distinct order dates in that month (repurchase users)
- Calculate repurchase rate = Number of repurchase users / Total number of users in that month
- Time Sorting: Sort by month chronologically to generate trend data
Step 6: Result Display
- Overall Metrics:
- Overall Repurchase Rate: The proportion of users with repurchase behavior among all users
- Frequency Distribution Table:
- Displays user counts and proportions for different consumption frequencies (1, 2, 3, 4, 5, 6+)
- Includes a total row showing total user count and total proportion (100%)
- Monthly Repurchase Rate Trend Chart:
- Displays repurchase rate trends by month
- Facilitates observation of temporal patterns and trends in repurchase rates
2.3 Data Filtering Rules
- Data Completeness: Records missing key fields (user ID, order date) are automatically excluded
- Date Parsing: The system automatically recognizes common date formats; dates that cannot be parsed are excluded
- Time Range: Monthly trend charts display all months with data, with no time range restrictions
III. Usage Instructions and Notes
3.1 Data Preparation
Required Fields
Before importing data, please ensure your data file contains the following two fields:
- User ID (
user_id)
- Description: Field that uniquely identifies users (user ID or phone number)
- Format requirements: Text or numbers are acceptable
- Examples:
U001, 12345, 13800138000
- Order Date (
order_date)
- Description: Date when the user placed the order
- 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 order data to accurately calculate user consumption frequency and monthly repurchase rate 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
- Order Date Column → Select the column containing order dates
3.3 Data Filtering (Optional)
The system supports filtering order dates:
- 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 last 1-2 years of data first to improve calculation speed
3.4 Result Interpretation
Metric Description
- Overall Repurchase Rate: Reflects the overall repurchase activity of the user base, an important metric for measuring user loyalty and business health. Higher repurchase rates indicate higher user satisfaction with products or services and healthier business
- Consumption Frequency Distribution: Shows the distribution of users across different consumption frequencies, helping identify high-frequency and low-frequency user groups. The more concentrated the distribution is in high frequencies, the higher the user activity level
- Monthly Repurchase Rate Trends: Reflects temporal patterns in user repurchase behavior, an important metric for observing business growth trends and marketing activity effectiveness
Frequency Distribution Analysis
- High-Frequency Users (Frequency 6+): These users are core customers and need key maintenance. You can enhance their loyalty through VIP services, exclusive offers, etc.
- Medium-Frequency Users (Frequency 2-5): These users have repurchase potential. You can increase their consumption frequency through precision marketing, personalized recommendations, etc.
- Low-Frequency Users (Frequency 1): These users may be one-time customers. You need to analyze churn reasons and develop activation strategies
Trend Analysis
- Upward Trend: Repurchase rate shows an upward trend, indicating effective user operation strategies and healthy business development
- Downward Trend: Repurchase rate shows a downward trend, requiring attention to product quality, service quality, or operation strategies, and timely adjustments
- High Volatility: May be affected by seasonal factors, marketing activities, or external environmental changes, requiring analysis combined with business conditions
3.5 Notes
⚠️ Important Notes
- Frequency Calculation Based on Distinct Order Dates:
- Consumption frequency is calculated based on
distinct(order_date), i.e., the number of distinct order dates
- Multiple orders on the same day count as only 1 frequency and do not increase the user's consumption frequency
- Example: A user placing 3 orders on the same day still has a consumption frequency of 1; a user placing orders on 3 different days has a consumption frequency of 3
- Repurchase Definition:
- Repurchase means a user has multiple distinct order dates (
distinct(order_date) > 1)
- Multiple orders on the same day do not count as repurchase; only orders on different dates count as repurchase
- Recommendation: Understanding this logic helps correctly interpret analysis results
- Monthly Repurchase Rate Calculation:
- Monthly repurchase rate is calculated by month, with each month's repurchase rate calculated independently
- Users with multiple distinct order dates in a month are counted as repurchase users for that month
- If a month has only a small amount of data, the repurchase rate may not be accurate enough; it is recommended to analyze in combination with data volume
- Data Completeness:
- Records missing user ID or order date are automatically excluded
- Order dates that cannot be parsed are excluded, which may affect the accuracy of frequency calculations
- Recommendation: During data preparation, ensure key fields are complete and formatted correctly
💡 Usage Recommendations
- Data Quality Check:
- Check data completeness before uploading, ensure user ID and order date fields are not missing
- Verify date formats are correct to avoid date parsing errors
- Check for abnormal data (such as future dates, obviously incorrect dates)
- Analysis Time Range:
- It is recommended to include sufficient historical data (at least 3-6 months) to accurately calculate user consumption frequency
- If the data volume is large, you can first analyze the last 1-2 years of data to observe short-term trends
- Then extend to longer historical data to observe long-term trends and seasonal patterns
- Result Validation:
- Compare frequency distributions across different periods to identify abnormal changes
- Combine with business activity times to analyze reasons for repurchase rate changes
- Verify that frequency distribution meets business expectations; if abnormal, further investigation is needed
- Strategy Optimization:
- If overall repurchase rate is low, it is recommended to strengthen user outreach, push coupons or activity information to improve user repurchase willingness
- If low-frequency users (frequency 1) account for too high a proportion, it is recommended to analyze churn reasons and develop user activation strategies
- If high-frequency users (frequency 6+) account for too low a proportion, it is recommended to optimize product and service quality to improve user satisfaction
- Adjust marketing activity rhythm and strategies based on monthly repurchase rate trends
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 order date fields
- User order dates cannot be parsed
Q2: How is consumption frequency calculated?
A: Consumption frequency is calculated based on the number of distinct order dates, i.e., count(distinct order_date). For example, a user placing orders on 3 different days has a consumption frequency of 3; a user placing multiple orders on the same day still has a consumption frequency of 1.
Q3: If a user places multiple orders on the same day, does it count as repurchase?
A: No. The definition of repurchase is that a user has multiple distinct order dates (distinct(order_date) > 1). Multiple orders on the same day count as only 1 order date, so it does not count as repurchase.
Q4: How is monthly repurchase rate calculated?
A: Monthly repurchase rate is calculated by month. For each month, the system counts all users with orders in that month, then identifies users with multiple distinct order dates in that month (repurchase users), and finally calculates repurchase rate = Number of repurchase users / Total number of users in that month.
Q5: What does "6+" mean in the frequency distribution table?
A: "6+" represents users with consumption frequency of 6 or more. The system combines all users with frequency ≥ 6 and displays them as "6+" to simplify table presentation. If you need to view more detailed frequency distribution, you can check the raw data.
Q6: How to improve user repurchase rate?
A: It is recommended to start from the following aspects:
- Improve product quality and service experience to increase user satisfaction
- Strengthen user outreach, regularly push coupons or activity information to remind users to repurchase
- Establish membership tier systems and point reward mechanisms to incentivize repurchase
- Analyze characteristics of high-frequency users, optimize products and services to improve user loyalty
- Develop activation strategies for low-frequency users, improve their consumption frequency through personalized recommendations and precision marketing
IV. Summary
The User Repurchase Frequency Distribution Calculator helps you fully understand user consumption frequency distribution and repurchase behavior through scientific algorithms and intuitive visualizations. Proper use of this tool can:
- Quickly identify high-frequency and low-frequency user groups to develop differentiated operation strategies
- Evaluate overall user activity levels and repurchase potential
- Observe repurchase rate trends over time and adjust operation strategies in time
- Analyze the impact of marketing activities on user repurchase behavior to optimize marketing effectiveness
- Provide data support for developing user activation and retention strategies
If you have any questions or need technical support, please contact the system administrator.