When looking at MAUs, do you find raw numbers or rolling averages to be more useful?

The rolling averages definitely make for cleaner charts, and it's helpful that they remove spikiness that isn't particularly insightful. But, it also seems like it paints such a clean picture that I wonder if it causes you to miss important data.

So, just curious how people who use Mixpanel/Amplitude/Heap/etc. think about this.

#Mixpanel #Amplitude Analytics #Heap #Marketing #Analytics
gruen's avatar
3 years ago
Do both

Rolling averages are useful for directionality, daily spikes are useful for telling you what's going on. (Forest vs trees.) Good charts help you ask (and then answer) questions, and provide good context for those questions.

Rolling averages provide the context, granular charts provide the why.

Do both. Hell, you do both on the same chart.

9 points
awwstn's avatar
@awwstn (replying to @gruen )
3 years ago

I agree with this. I tend to use both, and use them for different things:

  • week to week, looking at the raw numbers is useful to answer questions like "did we do better this week than last week"

  • On a more zoomed out view across a year or so, it's helpful to look at rolling averages to get a clear picture of the trends.

3 points
What are the best platforms for community management?

We have 15k newsletter subscribers, and have around ~2k of them in a Slack group. We're starting to encounter issues in terms of community management - specifically, it's hard to pin content like c...

Any suggestions for a workaround to an Outlook calendar not syncing with Google Calendars?

Google lets you subscribe to a calendar using a URL - although when using an Outlook 365 Calendar link, events are copied over once, and then the syncing stops. This seems to be a relatively new is...

What's the best video conferencing app for internal discussions?

Three major considerations I have been using to evaluate the plethora of options available: 1. Effortless/non-intrusive: It shouldn't feel like a video call 2. Price: As this app would be complime...

The community for power users.