Matching data from one table to many tables?

I’m pulling in Google analytics data to one table in a base via a 3rd party extension, it includes a column with a pageview number and another with the corresponding URL. On my other tables on this base I have the URL already in a column. I’m looking to pull in the pageviews by matching URL in my other tables and cannot figure out how to do this.

Any help would be appreciated.


Let’s call the table with the Google Analytics data the Data table, and the other tables that contian the URLs already in a column Table 1, Table 2 and so forth

If you can change the column layouts of Table 1 etc, make the URL column the primary column for those tables. From there, you can create link fields from the Data table to Table 1, Table 2, etc and paste the URL into it, and then use lookups / rollups to see the fields from the Data table that you need

Screenshot 2022-07-11 at 3.40.03 PM

If modifying the layout isn’t possible, you can make an automation that would look for a record in Table 1 that had the same URL value, and then link the records together, allowing you to use lookups and rollups, same as above.

Screenshot 2022-07-11 at 3.42.47 PM

Both of the above setups can be found here

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.