Nexters interview questions

Tech interview was medium but home assessment was huge. Task 1: Campaign Effectiveness Analysis Determine the effectiveness of advertising campaigns A-H based on Cost Per Payer (CPP) metric, where campaigns with CPP ≤ $50 are considered effective. Task 2: Funnel Analysis & User Journey Optimization ### Objective Analyze the complete user acquisition and product funnel to identify success factors and optimization opportunities. Task 3: Statistical Hypothesis Testing Do users acquired by campaigns E and H exhibit identical payment behavior? Task 4: A/B Test Design UA Manager wants to launch a new campaign similar to Campaign E and test for a 20% improvement in Day 3 payer conversion rate. Task 5: Cohort Analysis with SQL Create a cumulative revenue analysis for users registered between May 10-20 who completed tutorial within 7 days, tracking revenue over 100 days post-registration.

SQL and Python questions, A/B testing, most interesting or difficult projects, and what inspired me the most