-- Step8: 拉取特定月份的详细数据，分析问题原因
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
        ,当日分发分享pv AS share_pv
        ,当日分发回流uv AS return_uv
        ,当日分发拉回曝光pv AS return_exp
        ,标题
FROM    loghubods.video_dimension_detail_add_column
WHERE   dt BETWEEN '${start}' AND '${end}'
AND     曝光rank <= 10
ORDER BY dt, 曝光rank
;
