各个站点的数据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
