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 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 2, etc and paste the URL into it, and then use lookups / rollups to see the fields from the
Data table that you need
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.
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.