Hi Been running a couple of experiments now and loving the p

Question

Hi Been running a couple of experiments now and loving the product so far However I ve had to create new segments for each of the experiment where I only want to include the user s that have signed up after the experiment has gone live I m wondering if there s a better way for me to filter the users based on the experiment start date instead of adding a new segment manually each time thinking face

billions-xylophone-11752 · Answer

Hey Axel GrowthBook does support SQL Template Variables so you can build a query with placeholder variables that will be replaced with strings before being run based on the experiment <https docs growthbook io app datasources sql template variables>

billions-xylophone-11752 · Answer

So your where clause could look something like ```WHERE merchants shop creation date gt = startDate ```

prehistoric-oxygen-56976 · Answer

awesome had missed that thanks for your help

fresh-football-47124 · Answer

the experiment assignment query will automatically use the date range for the experiment