MediumCodingData

Find Conversion Rates

1Give yourself 5 minutes

2Answer out loud, not in your head

3Then compare with the answer below

Reference answer

This SQL query calculates the conversion rate for each marketing channel. It joins the attribution and user_sessions tables on sessionid. The conversion_rate is computed by dividing the count of sessions with a purchasevalue greater than zero by the total count of sessions for each marketing_channel, then multiplying by 100. The results are grouped by marketing_channel and ordered by conversion_rate in descending order to show the best-performing channels first. The query also calculates the average purchase value per channel.

Hiring now

Get the interview, not just the prep

landed applies to roles like these for you, on each company’s own site, with answers written for the role.

Get 5x interviews10 free auto-applies. No card.

Or practice this question first

Next question

Calculate the trapped rainwater between bars in a given array.
Find a triplet in an array with a given sum.
Print all combinations of numbers from 1 to n that sum to n.
Find the number of rotations in a circularly sorted array.
Coin Change
Find all permutations of a given string.