Search Unity

Question Optimal raw data to spreadsheets workflow?

Discussion in 'Unity Analytics' started by SolidJuhoMek, Jan 12, 2022.

  1. SolidJuhoMek

    SolidJuhoMek

    Joined:
    Jun 4, 2021
    Posts:
    1
    Hello,
    Is there proper workflow for getting rawdata to spreadsheets/excel?

    Current workflow requires multiple steps. Heres how I currently do it.
    1. Right now I first need to download all dates one by one. (DownloadThemAll addon helps to automate it.)
    2. Extract files and then rename them with correct extension. Lets say I do this once a month, thats 30 files to be renamed.
    3. Self made script that combines those files to single file.
    4. Import that single file to excel/spreadsheet.
    Please tell me theres hidden button somewhere so I can just download single csv file that already combines data.
     
    SolidJuhoMek, Jan 12, 2022
    #1

  2. JeffDUnity3D

    JeffDUnity3D

    Joined:
    May 2, 2017
    Posts:
    14,446
    @SolidJuhoMek You would use the Raw Data Export REST API and not the dashboard, and combine the files automatically in a Python script (for example).

    https://docs.unity3d.com/Manual/UnityAnalyticsRawDataExport.html (scroll down a bit for the REST API)

    There is also this:

    https://support.unity.com/hc/en-us/...ced-Queries-with-Unity-Analytics-Part-2-Excel

    We are working on a much improved data connector for the Unity Analytics Beta product that should be available later this Q1. There is more information on the beta here:

    https://support.unity.com/hc/en-us/articles/4408915768724-General-FAQ
     
    JeffDUnity3D, Jan 12, 2022
    #2