广告宽表流程图

各个站点的数据union合并

广告宽表（datacube.dwa_ad_aditemid） 

广告数据

连表从广告库取数

订单(datacube.dwa_orders)

fb广告数据和gg广告数据union合并

banggoodsem.sem_aditem a left join banggoodsem.sem_ad_quene b on a.aditemid = b.adid left join banggoodsem.sem_account c on b.accountid = c.id left join banggoodsem.sem_adset_quene as d on d.adsetId = b.adsetIdleft join banggoodsem.sem_campaign_quene as e on a.campaign_id = e.campaignid

每个ad_id对应的订单指标和毛利润指标

gg广告数据

毛利润( st.bgnc_order_SKU_profit)

fb广告数据

广告数据 as a left join 每个ad_id的订单毛利润指标 as b on a.ad_id=b.ad_id and a.domain=b.domain