Graybeard
Well-Known Member
I wrote a script with the help of ChatGPT's Financial Wizard AI `bot` 20 years in the webcam business 14 of them active I do have a lot of historical data to work out a PPC performa projection ---now can I get my clicks at =<$2.00 not at Google probably but at Bing and others ...
after an hour and 10 tries and 9 fails ...
This includes a 18% +- variable for the revenue returned each week but it is still a lineal projection
after an hour and 10 tries and 9 fails ...
This includes a 18% +- variable for the revenue returned each week but it is still a lineal projection
Week | Total Spend | Total Returns | Cumulative ROAS | ||
1 | 400 | 20.58 | 0.051 | ||
2 | 800 | 59.90 | 0.075 | ||
3 | 1200 | 127.23 | 0.106 | ||
4 | 1600 | 218.51 | 0.137 | ||
5 | 2000 | 326.24 | 0.163 | ||
6 | 2400 | 426.58 | 0.178 | ||
7 | 2800 | 543.70 | 0.194 | ||
8 | 3200 | 711.97 | 0.222 | ||
9 | 3600 | 882.64 | 0.245 | ||
10 | 4000 | 1085.62 | 0.271 | ||
11 | 4400 | 1314.10 | 0.299 | ||
12 | 4800 | 1566.38 | 0.326 | ||
13 | 5200 | 1867.53 | 0.359 | ||
14 | 5600 | 2157.66 | 0.385 | ||
15 | 6000 | 2441.42 | 0.407 | ||
16 | 6400 | 2779.30 | 0.434 | ||
17 | 6800 | 3168.20 | 0.466 | ||
18 | 7200 | 3513.10 | 0.488 | ||
19 | 7600 | 3827.56 | 0.504 | ||
20 | 8000 | 4163.59 | 0.520 | ||
21 | 8400 | 4534.05 | 0.540 | ||
22 | 8800 | 4918.78 | 0.559 | ||
23 | 9200 | 5309.26 | 0.577 | ||
24 | 9600 | 5803.77 | 0.605 | ||
25 | 10000 | 6335.94 | 0.634 | ||
26 | 10400 | 6837.58 | 0.657 | ||
27 | 10800 | 7431.21 | 0.688 | ||
28 | 11200 | 7939.84 | 0.709 | ||
29 | 11600 | 8480.38 | 0.731 | ||
30 | 12000 | 9154.49 | 0.763 | ||
31 | 12400 | 9857.16 | 0.795 | ||
32 | 12800 | 10480.35 | 0.819 | ||
33 | 13200 | 11068.71 | 0.839 | ||
34 | 13600 | 11786.75 | 0.867 | ||
35 | 14000 | 12392.27 | 0.885 | ||
36 | 14400 | 12921.44 | 0.897 | ||
37 | 14800 | 13473.40 | 0.910 | ||
38 | 15200 | 14087.83 | 0.927 | ||
39 | 15600 | 14904.68 | 0.955 | ||
40 | 16000 | 15582.75 | 0.974 | ||
41 | 16400 | 16331.03 | 0.996 | ||
42 | 16800 | 17113.72 | 1.019 | ||
43 | 17200 | 17802.76 | 1.035 | ||
44 | 17600 | 18393.01 | 1.045 | ||
45 | 18000 | 18905.63 | 1.050 | ||
46 | 18400 | 19744.58 | 1.073 | ||
47 | 18800 | 20533.82 | 1.092 | ||
48 | 19200 | 21216.74 | 1.105 | ||
49 | 19600 | 21739.17 | 1.109 | ||
50 | 20000 | 22374.24 | 1.119 | ||
51 | 20400 | 23176.80 | 1.136 | ||
52 | 20800 | 23804.55 | 1.144 | ||
53 | 21200 | 24558.10 | 1.158 | ||
54 | 21600 | 25222.67 | 1.168 | ||
55 | 22000 | 25996.26 | 1.182 | ||
56 | 22400 | 26769.82 | 1.195 | ||
57 | 22800 | 27617.20 | 1.211 | ||
58 | 23200 | 28490.81 | 1.228 | ||
59 | 23600 | 29262.23 | 1.240 | ||
60 | 24000 | 30121.48 | 1.255 | ||
61 | 24400 | 30805.76 | 1.263 | ||
62 | 24800 | 31507.71 | 1.270 | ||
63 | 25200 | 32313.54 | 1.282 | ||
64 | 25600 | 33118.99 | 1.294 | ||
65 | 26000 | 33894.68 | 1.304 | ||
66 | 26400 | 34755.29 | 1.316 | ||
67 | 26800 | 35702.46 | 1.332 | ||
68 | 27200 | 36511.96 | 1.342 | ||
69 | 27600 | 37469.88 | 1.358 | ||
70 | 28000 | 38454.47 | 1.373 | ||
71 | 28400 | 39444.86 | 1.389 | ||
72 | 28800 | 40372.77 | 1.402 | ||
73 | 29200 | 41307.54 | 1.415 | ||
74 | 29600 | 42257.99 | 1.428 | ||
75 | 30000 | 43054.52 | 1.435 | ||
76 | 30400 | 44197.70 | 1.454 | ||
77 | 30800 | 45478.43 | 1.477 | ||
78 | 31200 | 46584.60 | 1.493 | ||
79 | 31600 | 47778.39 | 1.512 | ||
80 | 32000 | 48734.53 | 1.523 | ||
81 | 32400 | 49923.65 | 1.541 | ||
82 | 32800 | 51481.40 | 1.570 | ||
83 | 33200 | 52547.99 | 1.583 | ||
84 | 33600 | 54164.59 | 1.612 | ||
85 | 34000 | 55156.49 | 1.622 | ||
86 | 34400 | 56324.88 | 1.637 | ||
87 | 34800 | 57810.58 | 1.661 | ||
88 | 35200 | 59424.08 | 1.688 | ||
89 | 35600 | 60473.36 | 1.699 | ||
90 | 36000 | 61896.53 | 1.719 | ||
91 | 36400 | 63363.59 | 1.741 | ||
92 | 36800 | 64740.20 | 1.759 | ||
93 | 37200 | 66049.51 | 1.776 | ||
94 | 37600 | 67663.27 | 1.800 | ||
95 | 38000 | 69238.79 | 1.822 | ||
96 | 38400 | 70851.54 | 1.845 | ||
97 | 38800 | 72183.82 | 1.860 | ||
98 | 39200 | 73850.27 | 1.884 | ||
99 | 39600 | 75195.58 | 1.899 | ||
100 | 40000 | 76961.61 | 1.924 | ||
101 | 40400 | 78498.43 | 1.943 | ||
102 | 40800 | 79636.33 | 1.952 | ||
103 | 41200 | 81420.45 | 1.976 | ||
104 | 41600 | 83278.07 | 2.002 | ||
105 | 42000 | 84599.96 | 2.014 | ||
106 | 42400 | 86291.27 | 2.035 | ||
107 | 42800 | 88018.83 | 2.057 | ||
108 | 43200 | 89745.86 | 2.077 | ||
109 | 43600 | 90858.60 | 2.084 | ||
110 | 44000 | 92233.25 | 2.096 | ||
111 | 44400 | 93753.67 | 2.112 | ||
112 | 44800 | 95282.23 | 2.127 | ||
113 | 45200 | 96863.88 | 2.143 | ||
114 | 45600 | 98007.51 | 2.149 | ||
115 | 46000 | 99799.95 | 2.170 | ||
116 | 46400 | 101412.52 | 2.186 | ||
117 | 46800 | 103617.15 | 2.214 | ||
118 | 47200 | 105246.46 | 2.230 | ||
119 | 47600 | 106508.35 | 2.238 | ||
120 | 48000 | 108306.44 | 2.256 | ||
121 | 48400 | 110470.18 | 2.282 | ||
122 | 48800 | 112510.00 | 2.306 | ||
123 | 49200 | 113766.91 | 2.312 | ||
124 | 49600 | 115894.74 | 2.337 | ||
125 | 50000 | 118110.74 | 2.362 | ||
126 | 50400 | 119511.05 | 2.371 | ||
127 | 50800 | 121269.26 | 2.387 | ||
128 | 51200 | 123160.24 | 2.405 | ||
129 | 51600 | 124869.97 | 2.420 | ||
130 | 52000 | 127049.88 | 2.443 | ||
131 | 52400 | 128806.95 | 2.458 | ||
132 | 52800 | 130082.20 | 2.464 | ||
133 | 53200 | 132401.51 | 2.489 | ||
134 | 53600 | 134685.95 | 2.513 | ||
135 | 54000 | 136824.96 | 2.534 | ||
136 | 54400 | 138558.64 | 2.547 | ||
137 | 54800 | 140851.39 | 2.570 | ||
138 | 55200 | 142893.57 | 2.589 | ||
139 | 55600 | 145061.68 | 2.609 | ||
140 | 56000 | 147194.18 | 2.628 | ||
141 | 56400 | 149189.57 | 2.645 | ||
142 | 56800 | 151636.07 | 2.670 | ||
143 | 57200 | 154358.24 | 2.699 | ||
144 | 57600 | 156232.01 | 2.712 | ||
145 | 58000 | 158175.66 | 2.727 | ||
146 | 58400 | 160761.40 | 2.753 | ||
147 | 58800 | 163288.97 | 2.777 | ||
148 | 59200 | 165316.14 | 2.793 | ||
149 | 59600 | 167701.15 | 2.814 | ||
150 | 60000 | 169612.07 | 2.827 | ||
151 | 60400 | 172080.06 | 2.849 | ||
152 | 60800 | 173928.25 | 2.861 | ||
153 | 61200 | 176312.87 | 2.881 | ||
154 | 61600 | 178402.36 | 2.896 | ||
155 | 62000 | 181648.82 | 2.930 | ||
156 | 62400 | 184295.02 | 2.953 |