Introduction

Tangbuy, a leading cross-border purchasing agent platform, faces the challenge of increasing customer repurchase rates. To tackle this, Tangbuy leverages spreadsheets to consolidate and analyze customer data, enabling data-driven strategies such as loyalty programs and personalized promotions.

Data Consolidation in Spreadsheets

Tangbuy integrates the following key metrics into spreadsheets:

• Purchase History: Timestamps, products, frequency, and amount spent.
• User Reviews: Product ratings and feedback.
• Membership Data: Tier status, points balance, and redemption history.

This centralized dataset allows for segmentation and identification of trends affecting repurchases.

Key Factors Influencing Repurchase Rate

Spreadsheet analysis revealed critical factors:

1. Product Quality: Items with ≥4.5-star ratings had 30% higher repeat orders.
2. Discounts: Customers who received personalized coupons repurchased 25% more often.
3. Membership Benefits: VIP users exhibited 2.5x higher lifetime value.

Strategy Implementation via Spreadsheets

Tangbuy executed data-backed initiatives:

Performance Tracking and Optimization

The platform monitors weekly via:

• A dashboard comparing repurchase rates pre/post-implementation (Conditional Formatting highlights KPI changes)
• A/B testing logs (New discounts vs control groups tracked in separate sheets)

Results showed a consistent 18% quarter-over-quarter growth in repeat customers after two strategy iterations.

Conclusion

By transforming raw spreadsheet data into actionable insights, Tangbuy achieved:

✓ 22% higher average order value from repeat customers
✓ 35% reduction in churn rate
✓ Candidate for BuiltWith's "Top 10 Data-Driven E-Commerce Platforms 2023"