Analytics - Mixpanel + Segment

Here is what I found for Segment: https://segment.com/docs/connections/sources/catalog/libraries/server/http-api/
I hope this helps you out. If not, it's probably best to ask the guys at Xano

Hi Alex , I managed to set up some kind of analytics with Xano. It’s not super convenient but here is what I did : 

 I created a « visit » table in my db with those field : User/Created at/Product. 

Then for all my get detail endpoint I added one step creating a record in this visit table. 

This way I can follow which Product has more visits, the mean age of the users visiting a particular product and more generally how many visitors I have through my application on a daily/weekly/monthly basis etc… 

Not perfect at all but it seems to be the best I can do..

If you need help let me know !

This is a really cool solution! Depending on the detail of statistics you want to gather I would recommend this over Segment or Mixpanel.

Thanks super helpful. I follow everything except, "Then for all my get detail endpoint I added one step creating a record in this visit table. "

How do you do the "create a record in the visit table" step? Is this something you're doing in Xano, like embeded in your get endpoint?

Or are you doing the remote triggers for UI navigation? I saw some recommend removed any prototype transitions, and instead do them with remote:action triggers and watch those? I tried this but the lag is noticable.

Oh so do you mean, taking a get-detail request like this...

And adding this "add record" in step 3?

exactly ! 
Depending on what info you want, you can add an extra step to be more precise : 
Get Record -> User (if your app use Xano’s authentification) 
Add a « user » field matching the user table
Bind user.id to that field in the analytics_Visits_1

This allow you to get more info from a simple visit

Oh true! that's perfect thanks. If you have a screenshot of that it'd be great! but I can probably figure it out if not

Got it. for the record incase anyone needs it:

FYI because i've been asked a few timies, connecting mixpanel analytics is possible!

There are some details here, but maybe I can do a video tutorial later if interest and time:
https://community.xano.com/discussion/comment/12131863#Comment\_12131863