https://www.growthbook.io/ logo
Join Slack
Powered by
Hello guys! 1) Can I add old experiments to platfo...
# announcements
e
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
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
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
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
okay, what if we talk about Pageviews SQL? I have different metrics, and for every metric "page view" event is different
f
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
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
If you need a date filter in your queries we do support template variables - https://docs.growthbook.io/app/datasources#sql-template-variables
e
>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
Depends on what your schema looks like. Are you using a standard schema like Snowplow or Segment uses, or something custom?
e
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
Are you using Google Analytics and syncing that to BigQuery?
e
No, only BQ
we're on Firebase. We didn't like it's AB platform and now we're trying yours btw :)
f
Do you need more help with this?
e
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
27 Views
Open in Slack
PreviousNext
Powered by