-- Step1: 验证"低vov高曝光"现象是否存在
-- 查询头部视频（曝光rank < 50）的 vov 分布

SELECT  dt
        ,视频id AS vid
        ,曝光rank
        ,当日分发曝光pv AS exp
        ,ROUND(当日分发拉回曝光pv / NULLIF(当日分发曝光pv, 0), 4) AS vov0
        ,ROUND(当日分发分享pv / NULLIF(当日分发曝光pv, 0), 4) AS str_t0
        ,ROUND(当日分发回流uv / NULLIF(当日分发分享pv, 0), 4) AS ros_t0
        ,ROUND(当日分发拉回曝光pv / NULLIF(当日分发回流uv, 0), 4) AS vor_t0
        ,标题
FROM    loghubods.video_dimension_detail_add_column
WHERE   dt BETWEEN '${start}' AND '${end}'
AND     曝光rank < 50
ORDER BY dt DESC, 曝光rank ASC
;
