I want to export data explorer reports to amazon s3 on daily basis. Is there any way to automate this process?
If the automation is not possible, can i use RDE api with python to export raw data to s3? i will calculate DAU,MAU, new installs and etc on my own in AWS.
For any new project, you would want to avoid legacy Analytics. For Raw Data Export, you would need a Pro license and use the RDE API as you mention from Python. You would need to calculate your own values for DAU, MAU etc and would be a LOT of work. There is no automation for the Data Explorer reports in legacy Analytics. Instead, you might consider waiting for the Analytics beta data connector, hopefully available by Q2. https://docs.unity3d.com/Manual/UnityAnalyticsRawDataExport.html