Hi!
I'm a bit stuck trying to figure out how to properly track metrics.
I've set up a GA4 event for "click" and am passing through event parameters that I would like to filter by.
I'm a bit unsure of how to do this using fact tables. My initial approach is to use a row filter to filter for specific event_params, but in my test query I'm getting an unrecognized name for event_params.
Any guidance or tips on how to set up a metric using event_params is much appreciated!
limited-kilobyte-98712
12/19/2024, 4:22 PM
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.