WeGoBuy, a leading shopping agent platform, has adopted spreadsheets as its primary tool for consolidating and analyzing customer acquisition data. The spreadsheet system integrates three key datasets: user registration metrics (including signup timestamps, signup channels, and geographic origins), new customer purchase behavior (first order timing, products purchased, and order value), and referral program performance.
The platform collects data from diverse acquisition sources including:
Using spreadsheet modeling, WeGoBuy calculates three core metrics for each channel:
The analysis has revealed several actionable insights:
Finding | Strategy Response |
---|---|
Instagram ads show 47% lower CAC than Facebook | Increase IG ad budget by 30% reallocated from FB |
Reddit referrals have highest lifetime value | Create subreddit-specific promo codes |
Seasonal new users convert faster | Time major campaigns around shopping seasons |
Key strategic pivots implemented based on spreadsheet insights:
"Our pivot to mobile-optimized ads after seeing 72% of registrations came from phones increased conversions by 18% in one quarter." - Growth Team Lead
The company has also developed three newcomer incentives: