“组件化”的版本间的差异
来自qingwei personal wiki
（创建页面，内容为“== 首页经营数据店铺指标概览 == === SQL === <source lang="sql"> select stat_date as statDate, fb_uv_1d_013 as fbUv, suc_ord_amt_1d as orderAmo…”） |
（没有差异）
|
2018年12月19日 (三) 03:28的版本
首页经营数据店铺指标概览
SQL
select
stat_date as statDate,
fb_uv_1d_013 as fbUv,
suc_ord_amt_1d as orderAmount,
pv_1d_01 as shopPv,
suc_ord_cnt_1d as orderCount,
clk_cnt_1d_092 as searchClicks,
uv_1d_063 as shopUv,
fb_uv_1d_014 as tmUv,
imps_cnt_1d_027 as searchImps,
fb_cnt_1d_013 as fbPv
from
dwp_en_dm_vip_comp_term_eff_d
where
admin_mbr_seq = '200042360'
and terminal_type = 'TOTAL'
and (stat_date = '2018-12-17' or stat_date = '2018-12-16')
and statistic_type = 'all'
