画啦啦
select event,user_id,distinct_id,date,time,sp_mkt_page,sp_mkt_type,sp_mkt_name,channel from events where event in ('sp_mkt_expose') and distinct_id='1894388156' and date='2021-01-21' order by time desc

点击
select event,user_id,distinct_id,date,time,sp_mkt_page,sp_mkt_type,sp_mkt_name,channel from events where event in ('sp_mkt_click') and distinct_id='1894388156' and date='2021-01-21' order by time desc

下拉弹窗曝光
select event,user_id,distinct_id,date,time,allclass_type,menu_category,menu_page,menu_type,menu_name,item_id from events where event in ('item_detail_PopupMenu_expose') and distinct_id='1894388156' and date='2021-01-21' order by time desc

点击
select event,user_id,distinct_id,date,time,allclass_type,menu_category,menu_page,menu_type,menu_name,item_id from events where event in ('item_detail_PopupMenu_click') and distinct_id='1894388156' and date='2021-01-21' order by time desc

资源位关闭
select event,user_id,distinct_id,date,time,sp_mkt_page,sp_mkt_type,sp_mkt_name,content_name from events where event in ('sp_button_close')  and date='2021-01-21' order by time desc





浏览页-详情页
select event,user_id,distinct_id,date,time,platform_type,ip_category,page_type,discount_single_price,purchase,group_identity,poster_user_id,group_people,rest_people,rest_time,group_type
from events where event in ('item_detail') and date='2020-12-28' order by time desc
年龄下拉弹窗点击
select event,user_id,distinct_id,date,time,allclass_type,menu_category,menu_page,menu_type,menu_name,item_id,ip_category
from events where event in ('item_detail_PopupMenu_click') and distinct_id='1894388156' and date='2020-12-25' order by time desc


下拉弹窗曝光

select event,user_id,distinct_id,date,time,ip_category
from events where event in ('item_detail_PopupMenu_expose') and distinct_id='1894388156' and date='2020-12-28' order by time desc




点击购买

select event,user_id,distinct_id,date,time,ip_category,page_type
from events where event in ('item_detail_buy_now') and distinct_id='1894388156' and date='2020-12-28' order by time desc

支付订单结果

select event,user_id,distinct_id,date,time,ip_category_category,page_type
from events where event in ('pay_order_result') and distinct_id='1894388156' and date='2020-12-25' order by time desc

订单最终结果

select event,user_id,distinct_id,date,time,ip_category,page_type
from events where event in ('order_final_result') and distinct_id='1894388156' and date='2020-12-25' order by time desc

提交订单
select event,user_id,distinct_id,date,time,ip_category,page_type
from events where event in ('submit_order') and distinct_id='1894388156' and date='2020-12-28' order by time desc





o
商品列表坑位曝光
select event,user_id,distinct_id,date,time,items_list_page,items_list_type,items_list_name,usertype,is_exchange,is_new_user,user_group
from events where event in ('items_list_mkt_expose') and  date='2021-01-29' order by time desc

o
商品列表坑位点击
select event,user_id,distinct_id,date,time,items_list_page,items_list_type,items_list_name,usertype,is_exchange,is_new_user
from events where event in ('items_list_mkt_click') and date='2021-01-29' order by time desc

o
课程页-浏览课程详情页/拼团详情页
select event,user_id,distinct_id,date,time,mkt_category,mkt_page,mkt_type,mkt_name,usertype,is_exchange,is_new_user
from events where event in ('item_detail') and date='2021-01-29' order by time desc

购买
select event,user_id,distinct_id,date,time,mkt_category,mkt_page,mkt_type,mkt_name,usertype,is_exchange,	
from events where event in ('item_detail_buy_now') and date='2021-01-29' order by time desc


无需查
提交订单
select event,user_id,distinct_id,date,time,mkt_category,mkt_page,mkt_type,mkt_name,usertype,is_exchange,is_new_user
from events where event in ('submit_order') and date='2021-01-29' order by time desc


o
订单结果
select event,user_id,distinct_id,date,time,mkt_category,mkt_page,mkt_type,mkt_name,usertype,is_exchange,is_new_user
from events where event in ('pay_order_result') and date='2021-01-29' order by time desc


is_new_user新老用户 没有上传
支付订单最终结果
select event,user_id,distinct_id,date,time,mkt_category,mkt_page,mkt_type,mkt_name,usertype,is_exchange,is_new_user
from events where event in ('order_final_result') and date='2021-01-29' order by time desc


美术课导流
曝光
select event,user_id,distinct_id,date,time,sp_mkt_page,sp_mkt_type,sp_mkt_name,channel,content_location,content_type,content_id,content_name,item_id from events where event in ('sp_mkt_expose') and distinct_id='1894423088' and date='2021-02-23' order by time desc
点击
select event,user_id,distinct_id,date,time,sp_mkt_page,sp_mkt_type,sp_mkt_name,channel,content_location,content_type,content_id,content_name,item_id from events where event in ('sp_mkt_click') and distinct_id='1894423088' and date='2021-02-23' order by time desc

弹窗
select event,user_id,distinct_id,date,time,sp_button_page,sp_button_type,sp_button_name,item_id from events where event in ('sp_button_close') and distinct_id='1894423088' and date='2021-02-23' order by time desc
课程页
select event,user_id,distinct_id,date,time,mkt_page,mkt_type,mkt_name,mkt_location,channel,page_type,item_id from events where event in ('item_detail') and distinct_id='1894423088' and date='2021-02-23' order by time desc

点击购买
select event,user_id,distinct_id,date,time,mkt_page,mkt_type,mkt_name,mkt_location,channel,page_type,item_id from events where event in ('item_detail') and distinct_id='1894423088' and date='2021-02-23' order by time desc

提交订单（mkt都没传）
select event,user_id,distinct_id,date,time,mkt_page,mkt_type,mkt_name,mkt_location,channel,page_type,item_id from events where event in ('submit_order') and distinct_id='1894423088' and date='2021-02-23' order by time desc

select event,user_id,distinct_id,date,time,mkt_page,mkt_type,mkt_name,mkt_location,channel,page_type,item_id from events where event in ('pay_order_result') and distinct_id='1894423088' and date='2021-02-23' order by time desc

最终生成订单结果
select event,user_id,distinct_id,date,time,mkt_page,mkt_type,mkt_name,mkt_location,channel,page_type,item_id from events where event in ('order_final_result') and distinct_id='1894423088' and date='2021-02-23' order by time desc

select event,user_id,distinct_id,date,time,course_id,section_id,content_type,stage_id,status from events where event in ('ai_course_play') and date='2021-03-29'and distinct_id='1894388156'order by time desc