Ok friends, so Google Analytics has not been able to track individual page activity on Glide for several months now and while the Glide team is working on a fix, I need to provide tracking data to my paid users ASAP, so I found a new way to capture the data on GA and I need help making the appropriate relations on Glide!
Users have featured business profiles where they are supposed to be able to what kind of activity they have on their pages. Example of dashboard:
Google analytics canât track âpage namesâ anymore so my data has been stunted BUT I figured out it can still track âpage pathsâ (and this last section is the rowID):
I need help converting the GA page path into a rowID and then creating a relation to which user owns that rowID (or multiple rowIDs) and making it so that the user can view the data for what happens on their business profiles. We previously did this with the page titles (names) but now i have to figure it out with the paths and row IDs.
Pictures of tables. Paid âusersâ create their own âprofessionalâ profiles and/or âsalonâ profiles
I know this is complicated, but can anyone help me with this? Iâm already so frustrated that I need to find a workaround after setting this whole thing up
Oh so interesting! Lots of new stuff! OK before i can test that I need to figure out how to get the new GA information on my Google Sheet. I didnât do the original syncing myself, is this something you happen to know how to do?
This is the original one with the page names. Do I need to DL something or add in some code in order to connect my GA to a new sheet with the page paths?
So do i have to make a template first? To add the whole URL to the beginning of it, and then use this experiemental code shown in the picture? Did i pick the right one?
@Darren_Murphy@ThinhDinh ohhh I see! I couldnât find âextract matching textâ option because I didnât type it in the text box. Funny i found a wild workaround by slicing the array and working backwards from the last /. This was so much easier than that
So I was able to create relations from the RowID to the salons or proâs that they are associated with.
But now If I want my paid users to only see the data for the salon or professional profiles that they own, what kind of relationship do I need to add on the database side to create my visibility conditions? Users can own multiple featured profilesâŚ
You have a relation from your GA data table to your Salons, yes?
Iâm guessing you could probably use a lookup through that relation to fetch the SalonID (or name), and then use that as a filter?
@ThinhDinh@Darren_Murphy I ran into another snag with the page paths Some of the paths arenât finishing with the RowID and therefore are not relating back to the business profile. Hereâs an example of a path (which is a salon with a ton of views and engagement on it) and itâs not connecting to the business bc of this weird path name.
That is how the deep link was constructed before the new computation model, I believe.
It corresponds to:
{"t":0,"s":"class-Sheet1","r":"yptsU4r2S6iNNonGtXIuyw","n":"Fringe Hair Studio "}
Now the problem is I donât know how you can do a decode like this inside Glide, I tried many times in the past but was not successful. Theoretically, if you can decode that, the ârâ value is the thing you need.
omg I love you guys! @Darren_Murphy I donât think mine decoded right? It doesnât look like yours and then nothing computed onto the Transform column. What did I miss?
Unless any profile that was created before a certain date is stuck with that and therefore causing the low data return even with current activity. Iâll have to dig around and see if any profiles created from Sept onward have an old return