You have a table of experiments with user_id, variant (A or B), and converted (boolean). Write a query that returns, for each variant, the number of users, the number who converted, and the conversion rate, plus the absolute lift of variant B over variant A.

Question

Answer

Stay specific. One example, told well, beats three told fast. Make your decisions visible — what you chose between. End on what changed, for whom.

You have a table of experiments with user_id, variant (A or B), and converted (boolean). Write a query that returns, for each variant, the number of users, the number who converted, and the conversion rate, plus the absolute lift of variant B over variant A.

Practice more