-- Step2: 量化影响面
-- 扩大范围，看更多天的数据，统计有多少视频存在这个问题

SELECT  dt
        ,视频id AS vid
        ,曝光rank
        ,当日分发曝光pv AS exp
        ,当日分发拉回曝光pv AS 拉回曝光
        ,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
        ,推荐天数间隔
        ,标题
        ,merge二级品类 AS category
FROM    loghubods.video_dimension_detail_add_column
WHERE   dt BETWEEN '${start}' AND '${end}'
AND     曝光rank < 50
ORDER BY dt DESC, 曝光rank ASC
;
