Data AnalysisTableAdvancedhard
漏斗 SQL 设计
测试模型能否把业务漏斗转成可查询逻辑。
Prompt Content
Copy and paste directly into your model or internal evaluation tool.
事件表 events(user_id, event_name, event_time)。请写 SQL 统计 7 天内从 signup 到 activation 再到 purchase 的用户漏斗转化，要求同一用户事件按时间顺序发生。
Use Cases
数据工程评测
Reference Output
应按用户聚合各步骤首次发生时间，并保证 signup <= activation <= purchase 且 purchase 在 signup 后7天内。
Scoring Rubric
看时间顺序、窗口约束和去重处理。
Try & save
Fill variables and copy, or save as a personal template.
This template has no variables and is ready to copy.
User Rating
0 ratings-
Your rating
Log in to rate
Comments
0Log in to comment
Related Prompts
TextData Analysis
Senior Analytics Engineer Prompt
This prompt defines the role, skills, process, and best practices of a senior analytics engineer building scalable, maintainable data pipelines and analytical systems in production.