Case Study
How Tilt moves at internet speed with ContextFlo
Tilt's marketplace team turned week-long investigations into real-time answers without adding headcount.
About Tilt
Tilt is a livestream shopping platform where sellers auction products live to buyers. With thousands of sellers, thousands of daily transactions, and real-time decisions driving GMV, speed of insight is competitive advantage.
Data stack
Amplitude, Snowflake, dbt, Dagster
How ContextFlo Helped
- •Ops, PM, and finance leaders investigate issues end-to-end without analyst queues.
- •ContextFlo blends product, marketing, and payments data so answers live in one session.
- •Alert-driven workflows catch performance swings and trigger SQL automation instantly.
The Challenge
Fast-moving business meets slow data access.
Tilt operates at internet speed:
- •Sellers go live multiple times per day
- •Conversion rates shift by the hour
- •Payment issues need immediate investigation
- •Fraud patterns emerge in real-time
But their data team couldn't keep up:
- •3-5 people could write production SQL
- •Everyone else waited days for analysis
- •Simple questions became backlog items
- •Critical decisions delayed while waiting for data
The breaking point:
When business metrics shift unexpectedly, the team needs to investigate across dozens of dimensions to find root cause. Traditional approaches would take weeks. They need answers in minutes.
The Solution
Self-service analytics powered by ContextFlo.
Tilt connected ContextFlo to their Snowflake warehouse and GitLab repos. Within Snowflake, they have both business data and data from external tools (Linear, Stripe, FB ads, TikTok ads). Within days, team members across product, operations, and leadership were running complex analyses independently.
Key capabilities they use:
- •Funnel analysis (install → signup → purchase)
- •Seller performance tracking
- •Fraud detection
- •Supply/demand matching
- •Real-time anomaly investigation
Usage in Practice
Sample queries the team runs every week.
"Determine if we have a break in our payments funnel"
"Match daily signups' brand interests to brands actually auctioned that day"
"Show GMV minute-by-minute compared to average for this day of week"
"Determine if a user is abusing referral coupons"
Results
Usage metrics and real business impact.
Volume:
- ~4k SQL queries executed
- 2k unique analytical sessions
- ~100 queries per day average
Adoption:
- 27 active users (50% of team)
- Used every day in past month
- Peak: 357 queries in a single day
Speed:
Questions that previously took 2-5 days now get answered in 2-5 minutes.
Real Business Impact
Rapid Investigation:
When key business metrics shift unexpectedly, Tilt uses ContextFlo to identify changes within hours, segment by multiple dimensions, test hypotheses in parallel, and implement fixes based on data-driven insights.
Traditional approach: Days or weeks of backlog, decision paralysis, delayed response.
Fraud Detection:
Team member noticed unusual referral patterns, ran 16 queries investigating a specific user, identified systematic coupon abuse, prevented further losses within same day.
Seller Operations:
Operations team runs daily performance checks on sellers, identifying tier transitions, schedule optimization opportunities, and at-risk performers. All self-service.
Key Metrics
| Active Users | 27 (50% of team) |
| Daily Usage | 30/30 days |
| Queries/Day | 125 average |
| Time to Insight | Minutes vs days |
| Data Team Reduction | 75% fewer routine requests |
What Tilt's Team Says
Hedi Ketari, Lead Data Scientist at Tilt:
"ContextFlo transformed how our team works with data. Instead of waiting days for answers, anyone can investigate complex questions independently. The speed and accuracy mean we can respond to business changes in real-time rather than after the fact."
The Bottom Line
Before ContextFlo
- ×3-5 people could analyze data
- ×2-5 day turnaround for simple questions
- ×Critical decisions delayed
- ×Data team = bottleneck
After ContextFlo
- ✓27 people analyze data independently
- ✓2-5 minute turnaround for complex analysis
- ✓Real-time decision making
- ✓Data team = strategic
Ready to move at internet speed?
See how ContextFlo can transform your team's data access and decision-making velocity.