増分CPA計算シート

	B	C	D	E	F	G	H	J	K	L	M	N
1	日	配信金額	ln(配信金額)	CV				日予算	想定CV	増分CV数	想定CPA	増分CPA
2	12/1	¥911,263	13.72258683	48.73		slope（傾き）	40.53027506	¥900,000	55.6	-	¥16,192	-
3	12/2	¥964,997	13.77988027	45.97		intercept（切片）	-500.0934013	¥950,000	57.8	2.191	¥16,443	¥22,817
4	12/3	¥1,475,287	14.20436311	73.41				¥1,000,000	59.9	2.079	¥16,708	¥24,051
5	12/4	¥1,217,867	14.01261153	77.82				¥1,050,000	61.8	1.977	¥16,982	¥25,285
6	12/5	¥1,047,608	13.86202003	49.42				¥1,100,000	63.7	1.885	¥17,264	¥26,519
7	12/6	¥1,134,417	13.94162942	55.74				¥1,150,000	65.5	1.802	¥17,553	¥27,752
8	12/7	¥1,099,717	13.91056343	67.71				¥1,200,000	67.2	1.725	¥17,846	¥28,986
9	12/8	¥1,010,943	13.82639412	65.88				¥1,250,000	68.9	1.655	¥18,143	¥30,220
10	12/9	¥796,827	13.58839287	46.4				¥1,300,000	70.5	1.590	¥18,443	¥31,454
11	12/10	¥1,028,345	13.84346127	60				¥1,350,000	72.0	1.530	¥18,746	¥32,688
12	12/11	¥1,017,354	13.8327157	64.76				¥1,400,000	73.5	1.474	¥19,050	¥33,922
13	12/12	¥974,183	13.78935445	54.21				¥1,450,000	74.9	1.422	¥19,356	¥35,155
14	12/13	¥810,316	13.60517957	54.79				¥1,500,000	76.3	1.374	¥19,663	¥36,389
15	12/14	¥689,512	13.44373938	50.21				¥1,550,000	77.6	1.329	¥19,970	¥37,623
16	12/15	¥805,447	13.59915268	63.23	※R2値は0.7〜0.8位が理想とされています。1に近いほど相関が強い。			¥1,600,000	78.9	1.287	¥20,278	¥38,857
17	12/16	¥715,581	13.48085008	48.32				¥1,650,000	80.1	1.247	¥20,587	¥40,090
18	12/17	¥797,363	13.58906531	57.31				¥1,700,000	81.4	1.210	¥20,895	¥41,324
19	12/18	¥790,242	13.58009451	62.82				¥1,750,000	82.5	1.175	¥21,203	¥42,558
20	12/19	¥936,203	13.74958761	53.15				¥1,800,000	83.7	1.142	¥21,511	¥43,792
21	12/20	¥1,059,620	13.87342091	61.24				¥1,850,000	84.8	1.110	¥21,819	¥45,025
22	12/21	¥1,192,288	13.99138471	80.27				¥1,900,000	85.9	1.081	¥22,127	¥46,259
23	12/22	¥783,324	13.57130168	48.05				¥1,950,000	86.9	1.053	¥22,434	¥47,493
24	12/23	¥910,166	13.72138228	51.39				¥2,000,000	87.9	1.026	¥22,741	¥48,726
25	12/24	¥742,631	13.51795457	38.36				¥2,050,000	88.9	1.001	¥23,047	¥49,960
26	12/25	¥785,751	13.57439523	53.58				¥2,100,000	89.9	0.977	¥23,353	¥51,194
27	12/26	¥752,648	13.53135293	52.4				¥2,150,000	90.9	0.954	¥23,658	¥52,428
28	12/27	¥632,370	13.35722994	33.83				¥2,200,000	91.8	0.932	¥23,963	¥53,661
29	12/28	¥420,294	12.94870975	23.14				¥2,250,000	92.7	0.911	¥24,267	¥54,895
30	12/29	¥910,166	13.72138228	51.39				¥2,300,000	93.6	0.891	¥24,570	¥56,129
31	12/30	¥689,512	13.44373938	50.21				¥2,350,000	94.5	0.872	¥24,872	¥57,362
32	12/31	¥796,827	13.58839287	46.4				¥2,400,000	95.3	0.853	¥25,174	¥58,596
33								¥2,450,000	96.2	0.836	¥25,475	¥59,830
34								¥2,500,000	97.0	0.819	¥25,776	¥61,063
35								¥2,550,000	97.8	0.803	¥26,075	¥62,297
36								¥2,600,000	98.6	0.787	¥26,374	¥63,531
37								¥2,650,000	99.4	0.772	¥26,673	¥64,764
38								¥2,700,000	100.1	0.758	¥26,970	¥65,998
39								¥2,750,000	100.9	0.744	¥27,267	¥67,232
40								¥2,800,000	101.6	0.730	¥27,563	¥68,465
41								¥2,850,000	102.3	0.717	¥27,859	¥69,699
42								¥2,900,000	103.0	0.705	¥28,154	¥70,933
43								¥2,950,000	103.7	0.693	¥28,448	¥72,167
44								¥3,000,000	104.4	0.681	¥28,741	¥73,400
45								¥3,050,000	105.1	0.670	¥29,034	¥74,634
46								¥3,100,000	105.7	0.659	¥29,326	¥75,868
47								¥3,150,000	106.4	0.648	¥29,617	¥77,101
48								¥3,200,000	107.0	0.638	¥29,908	¥78,335
49								¥3,250,000	107.6	0.628	¥30,198	¥79,569
50								¥3,300,000	108.2	0.619	¥30,487	¥80,802
51								¥3,350,000	108.9	0.609	¥30,776	¥82,036
52								¥3,400,000	109.5	0.600	¥31,064	¥83,270
53								¥3,450,000	110.0	0.592	¥31,351	¥84,503
54								¥3,500,000	110.6	0.583	¥31,638	¥85,737
55								¥3,550,000	111.2	0.575	¥31,924	¥86,971
56								¥3,600,000	111.8	0.567	¥32,209	¥88,204
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100