Update: I was able to do this using SQL instead of a fact table, but curious to know if that is the right approach
f
fresh-football-47124
12/20/2024, 3:28 AM
either will work
fresh-football-47124
12/20/2024, 3:28 AM
fact tables are more efficient as one query can return multiple metrics - but if you don't have much data, there wont be much difference.
fresh-football-47124
12/20/2024, 3:28 AM
did you click on 'discover metrics'?
fresh-football-47124
12/20/2024, 3:29 AM
it will create two fact table queries for you
fresh-football-47124
12/20/2024, 3:29 AM
and add metrics for page views and some other events
l
limited-kilobyte-98712
12/20/2024, 1:36 PM
Thanks Graham!
Is that the same as the recommended metrics? That got me about 95% of the way there! I just had to use SQL for the events that used event parameters to distinguish them.