I wanted to integrate the analytical system into my application so the admin can view all the analytics on the admin portal of my application. I tried lots of web analytics tools including Google Analytics and Facebook Analytics. And they are storing custom analytics very well but the problem is I am not able to find any way to retrieve this data so I can display it on my admin portal. I searched a lot but I am not sure if they provide any endpoint to retrieve data.
I Stucked into this for so long and need some proper solution for it, any other analytical tool will also work, thanks in advance.
Have you looked into the Google Analytics Reporting API?
Another possible solution is to create a data dump with BigQuery. I think you must upgrade from universal analytics to Google Analytics 4(GA4) because BigQuery was previously only available for Google Analytics 360 (enterprise) accounts.
Real-time gathering of data is not possible because GA aggregates the data first before it is available. So it would be wise if you thought of exporting the data once a day.
I think Facebook also grants the option to export data, but I'm not really familiar with it.