题解 | #2021年10月退货率不大于0.5商品各项指标#

selectproduct_id,ctr,cart_rate,payment_rate,refund_rate

from

(select product_id,event_time,

if(count(event_time)=0,0,round(sum(if_click)/count(*),3)) ctr,

if(sum(if_click)=0,0,round(sum(if_cart)/sum(if_click),3)) cart_rate,

if(sum(if_cart)=0,0,round(sum(if_payment)/sum(if_cart),3)) payment_rate,

if(sum(if_payment)=0,0,round(sum(if_refund)/sum(if_payment),3)) refund_rate

from

tb_user_event

group by product_id) a

where event_time like '2021-10%' and refund_rate <=0.5

order by product_id;