https://www.growthbook.io/ logo
e

eager-camera-84109

02/24/2022, 2:51 PM
Hello guys! 1) Can I add old experiments to platform? We didn't started testing yet: i'm gonna check results of our old experiments firstly. 2) what period platform use? i want control it
f

future-teacher-7046

02/24/2022, 2:53 PM
Yep! When you connect a data source, you can import old experiments and look at the results
I'm not sure what you mean by your second question
e

eager-camera-84109

02/24/2022, 2:57 PM
For example: I made specific Experiments SQL and Pageviews SQL (I have to make changes every time for every new experiment, isn't it?). And my old experiment was, for example, in July. How do I explain to the platform that I need these date?
may be I don't understand correct something from docs, sorry. I also have same question for Metric.
I see this. I also now have another problem: I can't select anything from my table if there is no condition with event_date from this table
f

future-teacher-7046

02/24/2022, 3:22 PM
The queries you write in GrowthBook should select all rows for all users and experiments. We filter down the results for you so you don't need to include that in your query
1
e

eager-camera-84109

02/24/2022, 3:32 PM
okay, what if we talk about Pageviews SQL? I have different metrics, and for every metric "page view" event is different
f

future-teacher-7046

02/24/2022, 3:34 PM
For page view you should use a common event that all of your users will fire at some point. Like a "app load" or "page view". It shouldn't be specific to a single metric.
e

eager-camera-84109

02/24/2022, 3:39 PM
well, what if my table have time condition for selecting? It means that someone (or something) can't select anything w/o this condition. It's a precaution not to write a request for a thousand bucks
f

future-teacher-7046

02/24/2022, 3:45 PM
If you need a date filter in your queries we do support template variables - https://docs.growthbook.io/app/datasources#sql-template-variables
e

eager-camera-84109

02/24/2022, 4:46 PM
>The queries you write in GrowthBook should select all rows for all users and experiments.
what if we use events with labels to separate users?how I can dynamically write the Experiments SQL?
I'm talking about
Copy code
experiment_id
f

future-teacher-7046

02/24/2022, 4:50 PM
Depends on what your schema looks like. Are you using a standard schema like Snowplow or Segment uses, or something custom?
e

eager-camera-84109

02/24/2022, 4:53 PM
the problem also is that sometimes we use events for separating, and sometimes we send UserFeature to separate. It depends on part of our app
i'm not sure about our schema, it's managing by Google
f

future-teacher-7046

02/24/2022, 5:03 PM
Are you using Google Analytics and syncing that to BigQuery?
e

eager-camera-84109

02/24/2022, 5:04 PM
No, only BQ
we're on Firebase. We didn't like it's AB platform and now we're trying yours btw :)
f

fresh-football-47124

02/24/2022, 11:26 PM
Do you need more help with this?
e

eager-camera-84109

02/25/2022, 10:31 AM
yep, problem is actual
i'm not sure how i'm gonna write universal experiment SQL
may be I can make scheduled queries for right format, but it's sad