Verified by DataSimHQ

Analyst

Sumaya Mateen

Lead Analyst

Project

What the holdout did

Kilele Mobile · SQL · Advanced

The brief

From: Wanjiru Kamau, Chief Commercial Officer

Daniel's Rudi Nyumbani win-back has run twice and both times he reported 8.5 percent reactivation. He wants budget for a third wave. I asked what the holdout did and got a long pause. I am not against Daniel; I am against spending money on a number nobody has checked.

From the kilele database: 1. For every campaign in the campaigns table, the number of subscribers and the conversion rate in the target group and in the holdout group, with the lift (target minus holdout) in percentage points. 2. The two win-back waves (campaigns 4 and 5) against the Weekly 2GB Upsell (campaign 2), side by side. 3. For win-back converters, how many had any customer-money revenue event more than 30 days after converting. I want to know whether they came back or j…

Independent grading

97/100

Achieved 11 Nov 2026

Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.

What is DataSimHQ?

A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more