休閑游戲投放數(shù)據(jù)模型表格

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,1.0,游戲名,三國(guó)志,,,渠道,iOS,,投放媒體,今日頭條,,,,,,,,游戲名,三國(guó)志,,,渠道,iOS,,開(kāi)始投放,2019/9/25,

,,,,,,,,,,,,,,,,,,,,,,投放地區(qū),中國(guó),,,投放媒體,今日頭條,,投放天數(shù),30,

,參數(shù),日期,,參數(shù),投放,自然,,分成比例,,,參數(shù),投放,自然,匯總,,,,,,,,,,,,渠道分成,30%,,CP分成,20%,流水

,開(kāi)始日期,2019/9/25,,新增,"60,000","10,000",,名稱(chēng),金額/比例,,新增,"60,000","10,000","70,000",,,,,,,,,,,,,,,,,

,投放天數(shù),30,,eCPM,220,200,,版權(quán)金,0,,廣告流水,"220,869","19,123","239,991",,,,,,,,,,,,,,,,,

,截止日期,2019/10/24,,人均觀(guān)次,3.5,2,,MG,0,,內(nèi)購(gòu)流水,"286,832","7,171","294,003",,,,,,,,,,,,,,,,,

,投放預(yù)算,"300,000",,ARPPU,50,15,,廣告分成,0%,,總流水,"507,701","26,294","533,995",,,,,,,,,,,,,,,,,

,CPA,5.0,,付費(fèi)率,2.0%,1.0%,,渠道分成,30%,,廣告ARPU,0.77,0.4,-,,,,,,,,,,,,,,,,,

,,,,1,35.0%,35.0%,,CP分成,20%,,內(nèi)購(gòu)ARPU,1.00,0.2,-,,,,,,,,,,,,,,,,,

,,,,3,20.0%,20.0%,,分成系數(shù),流水,,總流水ARPU,1.77,0.6,-,,,,,,,,,,,,,,,,,

,,,,7,13.0%,13.0%,,,,,投放預(yù)算,"300,000",0,"300,000",,,,,,,,,,,,,,,,,

,,,,14,8.0%,8.0%,,,,,流水ROI,5077%,0%,178%,,,,,,,,,,,,,,,,,

,,,,30,4.0%,4.0%,,,,,毛利,"320,111",-,"338,995",,,,,,,,,,,,,,,,,

,,,,60,0.5%,0.5%,,,,,毛利ROI,107%,-,113%,,,,,,,,,,,,,,,,,

,,,,,,,,,,,凈利,"20,111",-,"38,995",,,,,,,,,,,,,,,,,

,,,,,,,,,,,MG抵扣,無(wú),無(wú),回收,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,日投放新增計(jì)劃,,,,日投放成本,,,,LTV計(jì)算,,,,,,,,,,,,,,,,,,,,,

,序號(hào),日,投放,自然,,日,CPA,成本,,日,LTV,流水,流水ROI,毛利ROI,,,,,,,,,,,,,,,,,

,1,9/25,"2,000",333,,9/25,5.0,"10,000",,9/25,1.8,"3,540",35%,,,,,,,,,,,,,,,,,,

,2,9/26,"2,000",333,,9/26,5.0,"10,000",,9/26,2.4,"4,779",42%,,,,,,,,,,,,,,,,,,

,3,9/27,"2,000",333,,9/27,5.0,"10,000",,9/27,2.7,"5,487",46%,,,,,,,,,,,,,,,,,,

,4,9/28,"2,000",333,,9/28,5.0,"10,000",,9/28,3.1,"6,112",50%,,,,,,,,,,,,,,,,,,

,5,9/29,"2,000",333,,9/29,5.0,"10,000",,9/29,3.3,"6,683",53%,,,,,,,,,,,,,,,,,,

,6,9/30,"2,000",333,,9/30,5.0,"10,000",,9/30,3.6,"7,216",56%,,,,,,,,,,,,,,,,,,

,7,10/1,"2,000",333,,10/1,5.0,"10,000",,10/1,3.8,"7,677",59%,,,,,,,,,,,,,,,,,,

,8,10/2,"2,000",333,,10/2,5.0,"10,000",,10/2,4.1,"8,111",62%,,,,,,,,,,,,,,,,,,

,9,10/3,"2,000",333,,10/3,5.0,"10,000",,10/3,4.3,"8,525",65%,,,,,,,,,,,,,,,,,,

,10,10/4,"2,000",333,,10/4,5.0,"10,000",,10/4,4.5,"8,919",67%,,,,,,,,,,,,,,,,,,

,11,10/5,"2,000",333,,10/5,5.0,"10,000",,10/5,4.6,"9,298",69%,,,,,,,,,,,,,,,,,,

,12,10/6,"2,000",333,,10/6,5.0,"10,000",,10/6,4.8,"9,663",72%,,,,,,,,,,,,,,,,,,

,13,10/7,"2,000",333,,10/7,5.0,"10,000",,10/7,5.0,"10,017",74%,,,,,,,,,,,,,,,,,,

,14,10/8,"2,000",333,,10/8,5.0,"10,000",,10/8,5.2,"10,360",76%,,,,,,,,,,,,,,,,,,

,15,10/9,"2,000",333,,10/9,5.0,"10,000",,10/9,5.3,"10,643",78%,,,,,,,,,,,,,,,,,,

,16,10/10,"2,000",333,,10/10,5.0,"10,000",,10/10,5.5,"10,916",80%,,,,,,,,,,,,,,,,,,

,17,10/11,"2,000",333,,10/11,5.0,"10,000",,10/11,5.6,"11,180",82%,,,,,,,,,,,,,,,,,,

,18,10/12,"2,000",333,,10/12,5.0,"10,000",,10/12,5.7,"11,435",84%,,,,,,,,,,,,,,,,,,

,19,10/13,"2,000",333,,10/13,5.0,"10,000",,10/13,5.8,"11,682",85%,,,,,,,,,,,,,,,,,,

,20,10/14,"2,000",333,,10/14,5.0,"10,000",,10/14,6.0,"11,921",87%,,,,,,,,,,,,,,,,,,

,21,10/15,"2,000",333,,10/15,5.0,"10,000",,10/15,6.1,"12,154",89%,,,,,,,,,,,,,,,,,,

,22,10/16,"2,000",333,,10/16,5.0,"10,000",,10/16,6.2,"12,379",90%,,,,,,,,,,,,,,,,,,

,23,10/17,"2,000",333,,10/17,5.0,"10,000",,10/17,6.3,"12,599",92%,,,,,,,,,,,,,,,,,,

,24,10/18,"2,000",333,,10/18,5.0,"10,000",,10/18,6.4,"12,814",93%,,,,,,,,,,,,,,,,,,

,25,10/19,"2,000",333,,10/19,5.0,"10,000",,10/19,6.5,"13,023",95%,,,,,,,,,,,,,,,,,,

,26,10/20,"2,000",333,,10/20,5.0,"10,000",,10/20,6.6,"13,227",96%,,,,,,,,,,,,,,,,,,

,27,10/21,"2,000",333,,10/21,5.0,"10,000",,10/21,6.7,"13,427",98%,,,,,,,,,,,,,,,,,,

,28,10/22,"2,000",333,,10/22,5.0,"10,000",,10/22,6.8,"13,622",99%,,,,,,,,,,,,,,,,,,

,29,10/23,"2,000",333,,10/23,5.0,"10,000",,10/23,6.9,"13,814",100%,,,,,,,,,,,,,,,,,,

,30,10/24,"2,000"