CPG FB — Linear Model [Sample Data]

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE
1

2		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16
3		WEEK 1	WEEK 2	WEEK 3	WEEK 4	WEEK 5	WEEK 6	WEEK 7	WEEK 8	WEEK 9	WEEK 10	WEEK 11	WEEK 12	WEEK 13	WEEK 14	WEEK 15	WEEK 16
4	Cost	$50.00	$500.00	$650.00	$800.00	$1,000.00	$1,200.00	$1,450.00	$1,500.00	$1,650.00	$1,700.00	$1,850.00	$2,000.00	$2,200.00	$2,379.05	$3,220.14	$3,598.50
5	Revenue	$0.00	$150.00	$900.00	$1,500.00	$2,000.00	$1,800.00	$2,000.00	$1,300.00	$2,200.00	$3,000.00	$3,850.00	$4,305.60	$4,083.55	$5,123.00	$6,180.40	$6,735.05
6	CPA	$0.00	$250.00	$43.33	$40.00	$40.00	$44.44	$48.33	$60.00	$41.25	$36.96	$37.00	$36.36	$36.67	$72.09	$82.57	$79.97
7	Purchases	0	2	15	20	25	27	30	25	40	46	50	55	60	33	39	45
8	ROAS	0.00	0.30	1.38	1.88	2.00	1.50	1.38	0.87	1.33	1.76	2.08	2.15	1.86	2.15	1.92	1.87
9
10
11			*For privacy reasons, all data is representational; not a reflection of what was actually spent or earned, during this period of time.																Goals	Revenue	Spend	ROAS
12																			Target	$125,895.00	$50,358.00	250%
13																			Projected (Linear)	$70,596.00	$50,358.00	140.19%
14
15																		Trending		17	18	19	20	21	22	23	24	25	26	27	28
16																		Linear Formula — Revenue	250(x) +258	$4,508.00	$4,758.00	$5,008.00	$5,258.00	$5,508.00	$5,758.00	$6,008.00	$6,258.00	$6,508.00	$6,758.00	$7,008.00	$7,258.00
17																		Linear Formula — (Cost)	175(x)+259	$3,234.00	$3,409.00	$3,584.00	$3,759.00	$3,934.00	$4,109.00	$4,284.00	$4,459.00	$4,634.00	$4,809.00	$4,984.00	$5,159.00
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
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