Search Unity

  1. Welcome to the Unity Forums! Please take the time to read our Code of Conduct to familiarize yourself with the forum rules and how to post constructively.

Average 1-day retention rate

Discussion in 'Unity Analytics' started by ocean_maps, Feb 17, 2015.

  1. ocean_maps

    ocean_maps

    Joined:
    Feb 5, 2015
    Posts:
    4
    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?
     
    ocean_maps, Feb 17, 2015
    #1

  2. marc_tanenbaum

    marc_tanenbaum

    Unity Technologies

    Joined:
    Oct 22, 2014
    Posts:
    630
    While averages aren't current worked out that way, there's a simple way to get there from the available data.
    1. Go to Metric Monitoring. Click on 'Retention'
    2. Click the magnifying glass at the right of the "Daily Retention' chart.
    3. This takes you to Data Explorer with the correct graph.
    4. Click the CSV download button to get the data as a CSV file.
    5. 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. :)
     
    marc_tanenbaum, Feb 17, 2015
    #2

  3. ocean_maps

    ocean_maps

    Joined:
    Feb 5, 2015
    Posts:
    4
    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.
     
    ocean_maps, Feb 18, 2015
    #3

  4. marc_tanenbaum

    marc_tanenbaum

    Unity Technologies

    Joined:
    Oct 22, 2014
    Posts:
    630
    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?
     
    marc_tanenbaum, Feb 18, 2015
    #4