Which Platform Converts Best
Which Platform Converts Best
QUERY is comparing platforms before reconstructing Kotomarket’s old funnel. For each platform, calculate the share of paid events among all events: count paid rows using the is_paid condition and divide them by the total with a single safe-division function — it returns NULL on a zero denominator instead of raising an error.
Output platform and the share as cr. Sort the result by platform.
Any row order
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid