Understand user behavior in my app

Hi,

I’m exploring the best way to track user behavior in my app.

Currently, I use “set column values” occasionally (for example, when a user presses a button, I update the date and time and increase the count of button presses), which helps.

However, I’m searching for a more scalable and efficient solution to capture all events in the app for later analysis.

What are your thoughts?

Thanks,
Yan

Have you tried the Google Analytics integration?
That would be the best option, if you’ve used google tags or google analytics it works just as it should.

Hi Micheal,

thanks, Yes. it can help - let me check it out.

any idea how much Glide will charging for using it ? how much it consume form my monthly updates buckets ?

thanks
Yan

1 Like

Free. 0.

A good trick is to fill in names for the ‘slugs’ under options. That will clue you in as to which screen the user is viewing

5 Likes

Hi Eric,

Thanks,

Yes, I did it and used the slug, thanks!
I can now see the different pages the user is on.
However, is it possible to continue and further narrow it down to each specific object the user clicks on, and the different screens within each page?

thanks,

Yan

Screenshot 2024-10-08 at 14.38.00

1 Like

The value after /r/ is the RowID.

r=RowID

You can cross reference that RowID from GA to the RowID in your tables. Still not straight forward, but there is a pattern to the urls, which contain specific things like tab, row, and screen IDs.

3 Likes

Thanks, Jeff!

Where can I find the row ID in Glide tables?, or is it hidden somewhere? How can I query to locate it?

Yan

Do you have a RowID column in your tables? If you don’t see it, you just need to add a new column and select RowID for the type.

1 Like

Thanks, Jeff!

I’ve added the Row ID column to my tables. How can I manually search for the Row ID in Glide (&it could be in any table…)

Also, my next question is about automatically matching it with analytics—have you done that before?

Thanks.
Yaniv

I don’t use GA, so I don’t have any suggestions.

Like I said, if you study the url, you can start to figure out how its structured.

d/ usually refers to a tab.
s/ usually refers to a screen
r/ usually refers to a row

If you search for posts by @Katelyn_Alberts, she has done quite a bit of work to extract data from GA, add it to a table in her app and build relations to and from it using those IDs. She could provide more insight, but I don’t think it was an easy setup.

As for manually searching for a RowID…I think you can just go into each table and do a CTRL+F or CMD+F to find data. For something a little more streamlined, you could create a table with a column to hold a manually entered Row ID, and then build relations to all of your other tables.

5 Likes