Enhancing User Repurchase Rate: Tangbuy's Data-Driven Strategy Using Spreadsheets

In the competitive world of e-commerce, fostering customer loyalty is essential for sustained growth. Tangbuy, a prominent cross-border shopping platform, has leveraged the power of spreadsheets to analyze and enhance user repurchase rates through a systematic, data-driven approach.

1. Data Integration: Building A 360-Degree Customer View

Tangbuy consolidates diverse datasets into structured spreadsheets to identify repurchase patterns:

  • Transaction History: Purchase timestamps, product categories, order frequency, and spending amounts
  • User Feedback: Product ratings, service reviews, and complaint records
  • Membership Data: Tier status, point balances, and benefit utilization
"Our spreadsheets transformed raw data into actionable trends - we discovered 68% of repeat purchases came from users who bought at least 2 beauty products in their first order," noted Tangbuy's CRM analyst.

2. Key Repurchase Drivers Identified

Factor Impact Level Actionable Insight
Product Quality High Highlight lab-test results for top repurchased items
Loyalty Benefits Very High Accelerate point accumulation for repeat purchases
Personalized Promotions Moderate-High Time discounts based on individual repurchase cycles

3. Strategy Implementation Framework

The platform executed four spreadsheet-managed initiatives:

  1. Tiered Membership Program
    Spreadsheet columns track: (A) Current tier (B) Next-tier progress (C) Personalized milestone alerts
  2. Automated Recommendation System
    "If TPurchases>3 then Suggest Complementary_Items" rules applied in purchase history sheets
  3. Win-Back Campaign Triggers
    Conditional formatting flags users when "LastPurchaseDate > AVG(RepurchaseCycle)+10days"
Repurchase Rate +22% YoY

4. Performance Measurement & Iteration

The team established a dedicated Repurchase_Dashboard.xlsx with:

  • Weekly cohort analysis tabs by user segment
  • Pivot tables comparing strategy variants' effectiveness
  • ROI calculations per intervention type

Initial results showed: 

Quarter 1: 
- 19% increase in 60-day repurchase rate
- 2.3x more points redeemed than previous quarter 
- Customer service inquiries related to returns ↓14%
5. Continuous Improvement Process

Monthly spreadsheet audits drive optimizations:

Iteration Example: When "Exclusive Discounts" showed diminishing returns in Column AF of the strategy tracker, the team pivoted to bundle offers which increased conversion by 11pp.

By transforming spreadsheets into a centralized command center for repurchase analytics, Tangbuy achieved sustainable growth while maintaining the flexibility to adapt to ever-changing consumer behaviors.

```
Copyright © Cn Trusted