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

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid