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.
  2. We have updated the language to the Editor Terms based on feedback from our employees and community. Learn more.
    Dismiss Notice

Resolved How to get unbounded retention?

Discussion in 'Unity Analytics' started by mech_alina, Oct 13, 2022.

  1. mech_alina

    mech_alina

    Joined:
    Nov 3, 2020
    Posts:
    26
    Hello, we want to calculate unbounded retention D1, D7, D30. How can we set it up to get these numbers?
     
    SmoothD likes this.
  2. RandolfKlemola

    RandolfKlemola

    Unity Technologies

    Joined:
    May 1, 2020
    Posts:
    127
    Hey mech_alina,

    Thank you for reaching out to the support team!

    Using the Data Explorer: There is a Retention section in the Dashboard menu (Suites > Analytics > Dashboards > Retention) that will have 2 pre-built charts for retention.

    These 2 charts both display percentages based on D1, D7, D14, and D30. You can read more about this in the Retention section of our Dashboards documentation.

    Using the SQL Data Explorer: We have a pre-built SQL Query in the SQL Cookbook that gives you a New Player Retention Matrix.

    This Matrix includes days 1-14, 21, and 30, but with the query itself, you can manipulate it to meet your needs. Additionally, feel free to explore the rest of the UGS SQL Cookbook as there is a lot of handy information in there.

    Best,
    Randy
     
  3. mech_alina

    mech_alina

    Joined:
    Nov 3, 2020
    Posts:
    26
    Thanks for the response! I am checking out the SQL Data Explorer