# Converting page paths to row owners **URL:** \ **Category:** Ask for Help\ **Created:** [December 15, 2022, 2:53pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767 "2022-12-15T14:53:39Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [December 15, 2022, 2:53pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/1 "2022-12-15T14:53:39Z")
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: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e02fe6286ce058f6fc1d0d96f6d7eb1545e14198.jpeg) This is how we were tracking the data before it broke with new Gilde release (from the page titles on GA): ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b686aa48fe9e87907be3d2acf212689cd6dd768.jpeg) 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): ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/cee781e361a892038d49d6ad27575dc97e460c1e.png) 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 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/d/9d6a6c68f170ceb63fde60cb0fd24c1321672af1.jpeg) 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 šŸ«  ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 15, 2022, 3:41pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/2 "2022-12-15T15:41:54Z")
To extract just the RowIDs from the GA page path, you can use the [Extract Matching Text](https://www.glideapps.com/plugins/regex) plugin with the following regular expression: ```auto ([^\/]+)$ ``` With that, you should be able to build the relations that you need, yes? ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [December 15, 2022, 6:32pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/3 "2022-12-15T18:32:00Z")
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? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/4607ee8e9f4b4ade685a7cea5f274af144abfd50.png) ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [December 15, 2022, 8:14pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/4 "2022-12-15T20:14:22Z")
ok iā€™m not going to say iā€™m a genius but i figured out how to extract the page paths from Glide lol So the page paths donā€™t have a full URL: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/eac341e175bb12557151fb0fc4de1c0fe30d1377.jpeg) 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? THANKS! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 16, 2022, 1:11am UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/5 "2022-12-16T01:11:02Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0f2291f59096a7a860e16f9157359efa92f0f38c.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1a24e7daea47467a80fc21b489a3ac5e1ce6916f.png) Thereā€™s this plugin, you donā€™t need to use experimental code. ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [December 16, 2022, 3:59pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/6 "2022-12-16T15:59:42Z")
@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. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4a8aa24470bf3521e142210010b0ddb3dcd74357.jpeg) 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ā€¦ ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/2/4217432635297d445ad8561217827dace27cca35.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 16, 2022, 4:05pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/7 "2022-12-16T16:05:56Z")
> [@Katelyn\_Alberts](#): > > 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? 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? ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [December 16, 2022, 4:11pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/8 "2022-12-16T16:11:09Z")
ah, got it! thanks! ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [December 17, 2022, 4:23pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/9 "2022-12-17T16:23:13Z")
@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. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4a1312886cbed6f2157a0ccb15dc394c3feaa9f1.jpeg) This weird path name converted to the correct path once I plugged in the URL ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/0/309c98b0df17e864bff75fde4d7b228cd2ca604e.jpeg) Any ideas why this is happening? Or how to work around it? Iā€™m losing a ton of data capture because of this. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 18, 2022, 2:59am UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/10 "2022-12-18T02:59:59Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/a/fa511fda7cbb2cdfb0f1d3aaed1d34db29e3e045.png) That is how the deep link was constructed before the new computation model, I believe. It corresponds to: ```auto {"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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2022, 3:29am UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/11 "2022-12-18T03:29:14Z")
We can use a couple of pluginsā€¦ First the [Decode Text](https://www.glideapps.com/plugins/decode) plugin (it does Base64 by default): ![Screen Shot 2022-12-18 at 11.25.36 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/361189c561a2c99be7700efe2d9da9eab992ddb0.png) And then the [Transform JSON](https://www.glideapps.com/plugins/jq) plugin: ![Screen Shot 2022-12-18 at 11.25.49 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d512cccab26fc5117541f0921baa4f40b612c222.png) Which gives us: ![Screen Shot 2022-12-18 at 11.25.22 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5e8db264319f3699a6988a3b1438d8ed653323bd.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 18, 2022, 8:49am UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/12 "2022-12-18T08:49:20Z")
That decode column would have been useful back in the days šŸ˜… Thank you! ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [December 18, 2022, 1:38pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/13 "2022-12-18T13:38:04Z")
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? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/57494613b2af340bf5a6c76163416014828972ea.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f293d669a96f53c86c6b857924757e911c00fcd4.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2022, 2:00pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/14 "2022-12-18T14:00:40Z")
> [@Katelyn\_Alberts](#): > > 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? It looks like youā€™re feeding the wrong column into the Decode Text column. Try it with the first column - ā€œPage Pathā€ ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [December 18, 2022, 2:04pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/15 "2022-12-18T14:04:41Z")
i did that too, same thing? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/be3e1412a207cf849262bfa781a811c95b00a550.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2022, 2:09pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/16 "2022-12-18T14:09:41Z")
You might have to strip some of it out. Can you paste the Page Path value from row 16 please, so I can try it? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2022, 2:10pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/17 "2022-12-18T14:10:53Z")
Just for giggles, hereā€™s a one line JavaScript solution šŸ˜‰ ```auto return (JSON.parse(atob(p1)).r) ``` ![Screen Shot 2022-12-18 at 10.08.08 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/0/305d795faf641d95f58aed7647cc31808f74a059.jpeg) ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [December 18, 2022, 2:11pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/18 "2022-12-18T14:11:08Z")
absolutely. Thank you so much! /dl/ewAiAHQAIgA6ADIALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0AbgBhAHQAaQB2AGUALQB0AGEAYgBsAGUALQA3AFAAVgBqAHkANgBzAFkASABGAEIAaQBDAEMAUgBkAGQAVQBKAHkAIgAsACIAcgAiADoAIgBhAC4AdgA5AGkAQwAtAEMASABUADcASwBJAEgALgBYAEUANQBVAHQAZAAzAFEAIgAsACIAbgAiADoAIgBUAG8AbgB5ACAARgBvAHgAIAAiAH0A ---
**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Post date:** [December 18, 2022, 2:17pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/19 "2022-12-18T14:17:36Z")
> [@ThinhDinh](#): > > That is how the deep link was constructed before the new computation model, I believe. They must still be using these paths now even with the NCM because this is all the activity from yesterday on my GA ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/c/bcc7e9c9b98b4724a8ae8577b3c8de205df62367.png) 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 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2022, 2:23pm UTC](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767/20 "2022-12-18T14:23:20Z")
> [@Katelyn\_Alberts](#): > > absolutely. Thank you so much! > > /dl/ewAiAHQAIgA6ADIALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0AbgBhAHQAaQB2AGUALQB0AGEAYgBsAGUALQA3AFAAVgBqAHkANgBzAFkASABGAEIAaQBDAEMAUgBkAGQAVQBKAHkAIgAsACIAcgAiADoAIgBhAC4AdgA5AGkAQwAtAEMASABUADcASwBJAEgALgBYAEUANQBVAHQAZAAzAFEAIgAsACIAbgAiADoAIgBUAG8AbgB5ACAARgBvAHgAIAAiAH0A hmm, decoding that (even after stripping off the `/dl/`) doesnā€™t result in valid JSON. Iā€™ll need to fiddle with it a bitā€¦ [Next page](https://community.glideapps.com/t/converting-page-paths-to-row-owners/55767.md?page=2)