Hi, In case I have two different tables in BigQuery that I would like to use as sources. Would it be possible to add an experiment that works for both sources? Or will I have to create two copies of the same experiment?

different tables or different databases?

Different tables!

yes, the queries are quite customizable and can handle joining across tables- basically anything you can query yourself, you can make it work with GrowthBook

I guess I could union the two tables while following the experiment_id and variation_id format - however each time I query it, it would have to scan a lot more data. As opposed to one bigquery experiment working for two different bigquery sources

We would be happy to jump on a call to help you figure out the queries if you like

I'm just curious, what are the two tables? Is it one for dev, one for production? Or split by a dimension like country? Or something else?

One is standard AB-test experiment viewed, and the other contains data from marketing campaigns. So if I’m running a campaign with two different ads, I want to be able to compare important company metrics between the two attributed groups