手游投放預(yù)估工具

,LTV-ROI,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,項目數(shù)據(jù)表,,,,分成比例,,,,,,,,,,,,,,,,,,,,,,,,

,參數(shù),iOS,安卓,,名稱,金額/比例,,,,,,,,,,,,,,,,,,,,,,,

?,DNU,"30,000","60,000",?,版權(quán)金,0,,,,,,,,,,,,,,,,,,,,,,,

?,N-ARPPU,40,30,?,MG,0,,,,,,,,,,,,,,,,,,,,,,,

?,N-PUR,1.8%,1.8%,?,AppStore分成,30%,,,匯總,,,,,,,,,,,ROI,,,,,,,,,

?,O-ARPPU,100,60,?,安卓分成,0%,,,日期,新增,流水,投放成本,渠道分成,CP分成,財收,毛利,服務(wù)器費用,凈利,,,,,,,,,,,

?,O-PUR,3.0%,3.0%,?,CP分成,25%,,,1月,"90,000","255,357","1,980,000","35,369","54,997","219,988","-1,815,009",0,"-1,815,009",,,,,,,,,,,

?,1,30%,26%,,分成系數(shù),流水,,,2月,0,"119,832",0,"16,650","25,796","103,182","77,387",0,"77,387",,,,,,,,,,,

?,3,21%,18%,,,,,,3月,0,"90,756",0,"12,460","19,574","78,296","58,722",0,"58,722",,,,,,,,,,,

?,7,10%,9%,,投放用戶比例,,,,4月,0,"80,661",0,"11,060","17,400","69,600","52,200",0,"52,200",,,,,,,,,,,

?,14,6%,5%,?,月份,iOS投放比,安卓投放比,,5月,0,"75,945",0,"10,398","16,387","65,547","49,160",0,"49,160",,,,,,,,,,,

?,30,2%,2%,?,1,100%,100%,,6月,0,"66,330",0,"9,065","14,316","57,265","42,949",0,"42,949",,,,,,,,,,,

?,60,1%,1%,?,2,0%,0%,,7月,0,"30,835",0,"4,208","6,657","26,627","19,971",0,"19,971",,,,,,,,,,,

?,180,1%,1%,?,3,0%,0%,,8月,0,0,0,0,0,0,0,0,0,,,,,,,,,,,

,DAU/MAU,10%,10%,?,4,0%,0%,,9月,0,0,0,0,0,0,0,0,0,,,,,,,,,,,

,ARPU,1.64,0.98,?,5,0%,0%,,10月,0,0,0,0,0,0,0,0,0,,,,,,,,,,,

,30LTV,4.53,2.65,?,6,0%,0%,,11月,0,0,0,0,0,0,0,0,0,,,,,,,,,,,

,60LTV,7.02,4.08,?,7,0%,0%,,12月,0,0,0,0,0,0,0,0,0,,,,,,,,,,,

,90LTV,8.73,5.07,?,8,0%,0%,,匯總,"90,000","719,716","1,980,000","99,210","155,126","620,506","-1,514,621",0,"-1,514,621",,,,,,,,,,,

,180LTV,12.39,7.23,?,9,0%,0%,,,,,,,,,,,,,,,,,,,,,,

,留存至少填寫1%，否則會影響衰減指數(shù)運算,,,?,10,0%,0%,,iOS,,,,,,,,,,,安卓,,,,,,,,,

,,,,?,11,0%,0%,,日期,新增,流水,投放成本,渠道分成,CP分成,財收,毛利,服務(wù)器費用,凈利,,日期,新增,流水,投放成本,渠道分成,CP分成,財收,毛利,服務(wù)器費用,凈利

,新增系數(shù),,,?,12,0%,0%,,1月,"30,000","117,897","900,000","35,369","20,632","82,528","-838,104",0,"-838,104",,1月,"60,000","137,460","1,080,000",0,"34,365","137,460","-976,905",0,"-976,905"

,月份,iOS,安卓,,CPA,30,18,,2月,0,"55,499",0,"16,650","9,712","38,849","29,137",0,"29,137",,2月,0,"64,333",0,0,"16,083","64,333","48,250",0,"48,250"

?,1,100,100,,,,,,3月,0,"41,534",0,"12,460","7,268","29,074","21,805",0,"21,805",,3月,0,"49,222",0,0,"12,306","49,222","36,917",0,"36,917"

?,2,0,0,,,,,,4月,0,"36,867",0,"11,060","6,452","25,807","19,355",0,"19,355",,4月,0,"43,793",0,0,"10,948","43,793","32,845",0,"32,845"

?,3,0,0,,其它支出,,,,5月,0,"34,660",0,"10,398","6,065","24,262","18,196",0,"18,196",,5月,0,"41,285",0,0,"10,321","41,285","30,964",0,"30,964"

?,4,0,0,?,月份,服務(wù)器費用,,,6月,0,"30,216",0,"9,065","5,288","21,152","15,864",0,"15,864",,6月,0,"36,114",0,0,"9,028","36,114","27,085",0,"27,085"

?,5,0,0,?,1,0,,,7月,0,"14,027",0,"4,208","2,455","9,819","7,364",0,"7,364",,7月,0,"16,808",0,0,"4,202","16,808","12,606",0,"12,606"

?,6,0,0,?,2,0,,,8月,0,0,0,0,0,0,0,0,0,,8月,0,0,0,0,0,0,0,0,0

?,7,0,0,?,3,0,,,9月,0,0,0,0,0,0,0,0,0,,9月,0,0,0,0,0,0,0,0,0

?,8,0,0,?,4,0,,,10月,0,0,0,0,0,0,0,0,0,,10月,0,0,0,0,0,0,0,0,0

?,9,0,0,?,5,0,,,11月,0,0,0,0,0,0,0,0,0,,11月,0,0,0,0,0,0,0,0,0

?,10,0,0,?,6,0,,,12月,0,0,0,0,0,0,0,0,0,,12月,0,0,0,0,0,0,0,0,0

?,11,0,0,?,7,0,,,匯總,"30,000","330,700","900,000","99,210","57,873","231,490","-726,382",0,"-726,382",,匯總,"60,000","389,016","1,080,000",0,"97,254","389,016","-788,238",0,"-788,238"

,12,0,0,?,8,0,,,,,,,,,,,,,,,,,,,,,,,

,Total,100,100,?,9,0,,,,,,,,,,,,,,,,,,,,,,,

,,,,?,10,0,,,,,,,,,,,,,,,,,,,,,,,

,日,LN日期,LN留存,?,11,0,,,,,,,,,,,,,,,,,,,,,,,

,iOS,,,,12,0,,,,,,,,,,,,,,,,,,,,,,,

,1,0.00,-1.20,,Total,0.00,,,,,,,,,,,,,,,,,,,,,,,

,3,1.10,-1.56,,,,,,,,,,,,,,,,,,,,,,,,,,

,7,1.95,-2.30,,iOS-ROI-100%,未回收,,,,,,,,,,,,,,,,,,,,,,,

,14,2.64,-2.81,,安卓-ROI-100%,未回收,,,,,,,,,,,,,,,,,,,,,,,

,30,3.40,-3.91,,累計-ROI-100%,未回收,,,,,,,,,,,,,,,,,,,,,,,

,60,4.09,-4.61,,,,,,,,,,,,,,,,,,,,,,,,,,

,衰減指數(shù),-0.86,,,新增,"90,000",,,,,,,,,,,,,,,,,,,,,,,

,R2值,0.95,,,流水,"719,716",,,,,,,,,,,,,,,,,,,,,,,

,安卓,,,,投放成本,"1,980,000",,,,,,,,,,,,,,,,,,,,,,,

,1,0.00,-1.35,,財收,"620,506",,,,,,,,,,,,,,,,,,,,,,,

,3,1.10,-1.71,,毛利,"-1,514,621",,,,,,,,,,,,,,,,,,,,,,,

,7,1.95,-2.41,,ROI,2