Untitled

Cumulative Average(10, Orders):
10: This is the lookback window or time period. It specifies the number of data points (e.g., days, weeks, or months) to include in the cumulative calculation.
Orders: This is the metric being averaged cumulatively.
Interpretation:
The metric calculates the average Orders over the last 10 periods (e.g., days if your report is daily). It smooths out fluctuations by showing the running average for the last 10 periods instead of including all periods from the start.

Cumulative Average(10, Visits):
10: Again, this specifies the lookback period of 10 data points.
Visits: This is the metric being averaged cumulatively.
Interpretation:
The metric calculates the average Visits over the last 10 periods.

Cumulative Total: It is the running total of the revenue from Day 1 to the current day.
Example:
Day 1: $100
Day 2: $100 (Day 1) + $150 (Day 2) = $250
Day 3: $250 (Day 1 & 2) + $200 (Day 3) = $450
Cumulative Average: It is calculated as the cumulative total divided by the number of days.
Formula:
Cumulative Average = Cumulative Total ÷ Number of Days
Example:
Day 1: $100 ÷ 1 = $100
Day 2: $250 ÷ 2 = $125
Day 3: $450 ÷ 3 = $150


For Cumulative Total: Use the built-in "Cumulative" function in Adobe Analytics.
For Cumulative Average: Use the formula:
Cumulative Total ÷ Row Count

Scenario:
Metric: Orders (Number of orders per day).
Lookback Window: 10 (only the last 10 days are included in the calculation of the cumulative average).
Data: Orders data for 15 days.
Day	Orders	Cumulative Average (10, Orders)
Day 1	100	100
Day 2	150	(100 + 150) / 2 = 125
Day 3	200	(100 + 150 + 200) / 3 = 150
Day 4	50	(100 + 150 + 200 + 50) / 4 = 125
Day 5	300	(100 + 150 + 200 + 50 + 300) / 5 = 160
Day 6	250	(100 + 150 + 200 + 50 + 300 + 250) / 6 = 175
Day 7	400	(100 + 150 + 200 + 50 + 300 + 250 + 400) / 7 = 207
Day 8	350	(100 + 150 + 200 + 50 + 300 + 250 + 400 + 350) / 8 = 225
Day 9	500	(100 + 150 + 200 + 50 + 300 + 250 + 400 + 350 + 500) / 9 = 255
Day 10	450	(100 + 150 + 200 + 50 + 300 + 250 + 400 + 350 + 500 + 450) / 10 = 275
Day 11	600	(150 + 200 + 50 + 300 + 250 + 400 + 350 + 500 + 450 + 600) / 10 = 325
Day 12	550	(200 + 50 + 300 + 250 + 400 + 350 + 500 + 450 + 600 + 550) / 10 = 365
Day 13	700	(50 + 300 + 250 + 400 + 350 + 500 + 450 + 600 + 550 + 700) / 10 = 415
Day 14	800	(300 + 250 + 400 + 350 + 500 + 450 + 600 + 550 + 700 + 800) / 10 = 490
Day 15	900	(250 + 400 + 350 + 500 + 450 + 600 + 550 + 700 + 800 + 900) / 10 = 550
Explanation:
First 10 Days:

Until Day 10, the cumulative average includes all available data points up to that day (starting from Day 1).
Example for Day 10:
𝐶
𝑢
𝑚
𝑢
𝑙
𝑎
𝑡
𝑖
𝑣
𝑒
 
𝐴
𝑣
𝑒
𝑟
𝑎
𝑔
𝑒
=
(
100
+
150
+
200
+
50
+
300
+
250
+
400
+
350
+
500
+
450
)
10
=
275
CumulativeAverage= 
10
(100+150+200+50+300+250+400+350+500+450)

 =275
After Day 10:

From Day 11 onward, only the last 10 days' data are included in the calculation.

Example for Day 11:

𝐶
𝑢
𝑚
𝑢
𝑙
𝑎
𝑡
𝑖
𝑣
𝑒
 
𝐴
𝑣
𝑒
𝑟
𝑎
𝑔
𝑒
=
(
150
+
200
+
50
+
300
+
250
+
400
+
350
+
500
+
450
+
600
)
10
=
325
CumulativeAverage= 
10
(150+200+50+300+250+400+350+500+450+600)

 =325
Day 1's value (100) is excluded from the calculation.

Rolling Window:

As each new day is added, the earliest day's data is dropped, and the calculation only includes the latest 10 days.