7-Day Rolling Average Calculator
Smooth a noisy daily series into a 7-day rolling average so the real trend in your traffic, sales or spend shows through.
Daily values
Rolling series
Rolling averages reveal the trend inside the noise
Daily marketing data is noisy. Saturday traffic looks nothing like Tuesday traffic. A 7-day rolling average smooths out weekly seasonality and shows the trend underneath. Use it on daily revenue, sessions, conversions and ad spend, and never trust a single-day spike or drop on its own.
How the calculation works
For each day, the calculator adds that day and the six days before it, then divides by seven. The first six days use a shorter window and are marked as partial, so you can see where the full window starts.
Frequently asked questions
Should I use a 7-day or a 28-day average?
Use 7 days for short-term operational decisions and 28 days for strategic trend analysis. They answer different questions, so many teams watch both side by side.
Why does my rolling average lag behind the real numbers?
Every rolling average looks backward, so it reacts a few days after a real change. That delay is the price of removing noise. A shorter window reacts faster but stays noisier.