Average 1-day retention rate

In the metrics monitor I can see the average 7-day retention rate.

If I click on it, I can see 1-day and 30-day retention rates too, but just for a single day, as well as in the data explorer. Is there any way to see the average of 1-day and 30-day retention rates? If not for when is this feature planned round about?

While averages aren’t current worked out that way, there’s a simple way to get there from the available data.

  • Go to Metric Monitoring. Click on ‘Retention’
  • Click the magnifying glass at the right of the "Daily Retention’ chart.
  • This takes you to Data Explorer with the correct graph.
  • Click the CSV download button to get the data as a CSV file.
  • Open in your favorite spreadsheet program and formulate an average from the relevant cells. (In Excel, Right-click > Insert Function… > Average)

Just now there is no existing plan to add this feature directly into the dashboard, but asking goes a long way! We’ll add it to our requested feature list. If enough people want it, we’ll build it. :slight_smile:

There is only one cell, date and the daily retention rate is in it… I would have to parse that myself in the current state, you might want to write that into 2 different cells if you want users to access that info that way.

I’m not sure I understand. If you follow the instructions I gave above, you should get a CSV file with a column of values. Looking at your app’s CSV output, I see a column with Day-1 values, Day-7 values and Day-30 values. In each case the values are from 2/5-2/17. Calculating an average from that is simple…but it sounds as if the CSV file you’re downloading shows something different from what I’m describing?