Open source platform for stress free deployments, measured impact, and smarter decisions.

GrowthBook Users

Hi. Is there a way to join the experiment assignment query to metrics using 2 keys? Currently, it's merging using _user_id_, but I would like to join on an additional key. Thank you.

Trying to think- If you are ANDing the ids you can select both and concatenate them and alias the results as some new id 

Thanks <@U01T6HCHD0A>. What if I have metrics pulling from various sources? For example, there's one metric I want to merge using two keys, but for the other metrics I only need to merge using one key.

We will allow that - as long as you can describe a way in SQL to join between the identifiers. Each metric defines what identifier they apply to

so if you have a metric by user id, and randomize by IP or something else, we will use the join query between those two ids in the eventual query. You will see a place to add a join query on the data sources page once you add more than one identifier types