Hiya, I’m having trouble getting GrowthBook to read metrics from BigQuery? Or else I misunderstand the metric charts? I have fabricated data in BigQuery and it’s in the events_intraday_ table for today; I can see there are plenty of events but my metric isn’t reading them. I’m sure I am missing something obvious but I just can’t see it… These are my queries: Metric query ------

SELECT

user_id,

user_pseudo_id as anonymous_id,

TIMESTAMP_MICROS(event_timestamp) as timestamp

FROM

``analytics_xxx.events_intraday_*``

WHERE

event_name = 'Main CTA'

AND _TABLE_SUFFIX BETWEEN '20230328' AND '20230401'

Logged-in users query ----------------

SELECT

user_id as user_id,

TIMESTAMP_MICROS(event_timestamp) as timestamp,

experiment_id_param.value.string_value AS experiment_id,

<http://variation_id_param.value.int|variation_id_param.value.int>_value AS variation_id,

geo.country as country,

traffic_source.source as source,

traffic_source.medium as medium,

device.category as device,

device.web_info.browser as browser,

device.operating_system as os

FROM

``analytics_xxx.events_intraday_*`,`

UNNEST(event_params) AS experiment_id_param,

UNNEST(event_params) AS variation_id_param

WHERE

_TABLE_SUFFIX BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'

AND event_name = 'experiment_viewed'

AND experiment_id_param.key = 'experiment_id'

AND variation_id_param.key = 'variation_id'

AND user_id is not null

And here’s a screenshot of the preview of the BigQuery table events_intraday_20230330 where I can see plenty of “Main CTA” events. However all my metric chart shows when I refresh the data, is two events from several days ago. An experiment based on that metric is showing the sort of results I expect however, so maybe I just don’t understand the metric chart?

Hi All, I was helping someone try to debug their GrowthBook set up and had a basic setup question that I wasn't real sure about that I was hoping someone could answer. I've attached a copy of an experiment they are running showing the Configure Experiment Analysis screen and called out a couple of areas of interest for me. 1. I've confirmed that this database exists and that the connection is working correctly 2. Where is this table supposed to be coming from? Is that our responsibility to manually set up? 3. What happens if this column is not there will it fail silently and just say no rows returned or will it give a more detailed error. Right now I don't have direct access to that DB to confirm manually but I suspect that entire table doesn't exist and I am not sure where it is even supposed to come from yet.

I’m running GrowthBook locally; will the new version be automatically available when I run

docker-compose up -d

? Or do I need to pull an update from GitHub? I’m wondering how to see the new features 🙂

Is there a way to randomly, but consistently, divide users into segments, say by id, which can then be used to ensure that different experiments are applied to different groups of users? As a trivial example, to divide users into two groups. Group 1 would then be used for an A/A experiment, and Group 2 would have a new feature rolled out at 50% and be used for an A/B experiment. Looking through the docs I haven’t seen anything that does exactly this?

Hey Hi all is it possible to trigger withTrackingcallback every time we run a feature? And not the experiment?

https://growthbook.github.io/growthbook-golang/github.com/growthbook/growthbook-golang/ could not see the hook in Golang sdk

Good afternoon everyone! We are planning on having a central self-hosted growthbook instance with multiple kubernetes clusters connecting to it. Is it possible to have multiple proxy servers? E.g. one in each of the clusters? According to the documentation it looks like you can only have one because you need to set the env variable

PROXY_HOST_PUBLIC=<proxy_url>

on the main growthbook instance.

Hey all! I am new to GrowthBook, and I have a couple of questions. I had successfully installed and used GrowthBook feature toggles in our frontend app (ReactJS), but I am having trouble doing the same in our backend app (KoaJS). I tried following the JavaScript SDK but without any luck. Does anyone have any insights? More specifically: • Where should I install the Growthbook package? In our main

app.js

? And if so, is there any guide that I can follow? • How can I use GrowthBook features inside a service? Consider that some services we use are used directly from other services and are not attached to any route. I want to access the GrowthBook instance on those services. I tried exhausting all possible solutions before deferring to you folks. Any help would be much appreciated. Thanks in advance!

Hello, I am currently using GrowthBook, absolutely newbie . I followed the https://docs.growthbook.io/lib/react guide to setup with my react project. Got it up and running for first feature flag, i can see the feature in the Features and Experiment list. But when i am trying to add the 2nd feature named

new-preview-clip-test

. It is showing up on the Feature list but not in the Experiment list in the GrowthBook browser plugin. and also the

useFeatureIsOn("new-preview-clip-test");

is always returning false, but in the browser plugin it is showing true. Any help will be really helpful 🙌

Team, If we have couple of experiments inside another experiment, the GTM is tracking the child exp, not the parent exp. Can anyone help? TIA

I am sure this is my lack of experience with reading statistical charts, but I’m just not understanding the metric charts? For example I have a ‘count’ metric. I’m using a script to simulate user logins and clicks on a localhost React website, and there are several hundred users on some days (the ones where I ran the script!) who each click the button around 10 times. My experiment data matches this so I think it’s working. But I can’t match this with the metric chart. What is this chart showing? It might be the number of users, but what is ‘n’ and why is it always 2? (I do know that mu and sigma are mean and standard deviation, but why is mu not something like 10, the average number of clicks per user?) Why are the lines always straight? I’d be really grateful for some basic information on how to read these charts.

Hello, I am working on integrating our Android app with the Java SDK. Our Debug app allows users to switch between Production and Staging environments for testing purposes. Setting it up went smoothly for the debug app, but our Release app (only containing production environment) continues to return null "default values" from the GrowthBook sdk instance. After debugging, I see the featuresJson String correctly being returned from the web and applied to the GrowthBook sdk context, but feature flags continue to return null. Anybody have any ideas why the SDK would be returning default values of null for flags that hold a value according the features json string?

Hi all, I'm working on getting GrowthBook integrated into a React Js application to get rid of our current solution. I've got the initialisation working in the

App.js

file but I have a redux reducer where I'm attempting to setAttributes on a user any time an update happens to the user within our application. I have a few questions... • Is this possible? The reason I'm doing this is we have some features which are enabled for certain groups of people. ie. internal features only enabled for users with certain emails/company information on their client data. • When i set the attributes they dont get updated on the attributes screen here https://app.growthbook.io/attributes is there something I'm doing wrong? • The Chrome plugin for Growthbook doesn't seem to be working, do I need any setup in order to get this going? • Is there somewhere that I can have a development SDK key and a production SDK key, reason being for testing tickets in a development environment with flags and then passing them through or duplicating them into prod. • I'd love to move to a paid plan but can I trial this first? Appreciate the help in advance! Here's the code I'm using in the reducer in order to try and set the client attributes.

reducers: {
    setClientData: (state, action) => {
      console.log("Updating growthbook data with", action.payload)
      growthbook.setAttributes({
        "id": fire.auth().currentUser.uid,
        ...action.payload,
      });
      state.data = action.payload;
    },
  } ...

Hey all I need to setup SMTP server options. Not sure where I should enable below options • EMAIL_ENABLED ("true" or "false") • EMAIL_HOST • EMAIL_PORT • EMAIL_HOST_USER • EMAIL_HOST_PASSWORD • EMAIL_FROM

I set up an experiment in the Visual Editor but it’s seeing no data. I have an SDK/feature experiment that tracks the same metric, and it sees data. The data are coming from BigQuery and I see the id of the visual experiment in the results. I originally set the Visual experiment to track in draft, but I wouldn’t expect that to be the problem now it’s gone live? I’d be grateful for any ideas why the visual experiment isn’t tracking?

Hi! I’m writing a JS email-sending script where I’m iterating over a group of users, and want to check whether or not they have the feature to get the email. Using @growthbook/growthbook. Is there a better way than instantiating a new GrowthBook instance for each user and loading their features? Is there a way to load all features at once and hash people’s ids for feature state client-side?

Hi. I need a clarification on feature data retrieval. I am running growthbook locally using docker. Will the data be retrieved everytime from cloud? Any example available to use CACHE_EXPIRES_TTL in Java SDK?

Hi! We are moving from google optimize to growthbook (free version) and have setup the javascript sdk via GTM, ga4 metrics and a handful of attributes. Similar to google optimize are we able to add code snippets (JS,CSS) for the variation through the growth book platform Or do we need to implement experiment code inline via GTM using features/experiments?

Hey, @fresh-football-47124 or anyone else, I hope this message finds you well. I'm currently facing an issue with CORS policy while using your visual editor on my website (https://www.hurb.com). Here's the error message I'm encountering:

Access to fetch at '<https://cdn.growthbook.io/api/v1/visual-changesets/vcs_19g61mlgcpfhuq?includeExperiment=1>' from origin '<https://www.hurb.com>' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. If an opaque response serves your needs, set the request's mode to 'no-cors' to fetch the resource with CORS disabled.

Could you please assist me in resolving this issue? I've checked my configurations on the GrowthBook dashboard, but I'm still unable to get the visual editor to work properly due to this CORS issue. Any guidance or support would be greatly appreciated. Thanks in advance!

How i can reset admin password without smtp? docker compose installation

Hey, https://docs.growthbook.io/self-host/env All the changes of the environment variables has to be done on which file?

Hey 👋 Could someone help me with the error I get when applying dimensions to my experiment results? So I’m using Amazon Redshift and apparently it encounters error with concat function, which is used in Growthbook’s query.

REGEXP_REPLACE(
  MIN(
    CONCAT(
      cast(e.timestamp as varchar),
      '____',
      coalesce(cast(e.dimension as varchar), '__NULL_DIMENSION')
    )
  ),
  '.*____',
  ''
) as dimension,

Is it possible to create custom roles? Like I want to have a user who can create feature but can't review and publish. One reviewer role to review the features.

Hey you all. After using Visual Editor, I noticed that it currently doesn't support injecting JavaScript scripts directly into the experiments. (Am I right?) I wanted to ask if there are any plans to include this feature in the future. The ability to inject custom JavaScript scripts would benefit more complex use cases. Looking forward to hearing your thoughts on this matter and any possible roadmap for this feature.

Hey! I am trying to make a simple GrowthBook metrics analysis but I get some errors. We are using Amplitude as our product analysis platform so I had to export our data to AWS Athena (I am not even sure if we did this right but GrowthBook seems to think it is?). Anyway, I just create a metric, "Doctor List", which is supposed to get all the "Doctor List" events that already exist, but when I try to analyse this metric by clicking on "Run analysis" I get the following error: line 1411 mismatched input '$'. Expecting: '*', <expression>. The SQL query that GrowthBook is generating is:

-- Last 90 days - Doctor List Metric
WITH
  __metric as ( -- Metric (Doctor List)
    SELECT
      anonymous_id as anonymous_id,
      1 as value,
      m.timestamp as timestamp,
      m.timestamp as conversion_start,
      m.timestamp as conversion_end
    FROM
      (
        SELECT
          user_id,
          $ amplitude_id as anonymous_id,
          event_time as timestamp
        FROM
          $ events
        WHERE
          event_type = 'Doctor List'
      ) m
    WHERE
      m.timestamp >= from_iso8601_timestamp('2023-01-12T23:11:24.843Z')
      AND m.timestamp <= from_iso8601_timestamp('2023-04-16T23:11:24.843Z')
  ),
 .......

Line 14 (where the error is) is basically this:

$ amplitude_id as anonymous_id,

Can I set conditions on a feature flag based on environment? E.g. feature A can only be enabled in production if it is also enabled in staging?

Hi. How to differentiate between feature updated and feature published in event webhook?

Hey Hi All!Please help me I am trying to setup the email server and even with creadentials I am getting the error

Failed to send email to

I have infact generated the credentials from https://ethereal.email/create and used the same package you guys have used that is nodemailer and I am able to. But when I deploy with same credentials then no luck. I am stuck here for 2 weeks and its pretty urgent for me

Hello, Somebody had a problem with the metric when you added

purchase

with GA4 as the data source? I added SQL below, and I got an error and I don't know how to fix. What I'm doing wrong?

SELECT
  user_id,
  user_pseudo_id as anonymous_id,
  TIMESTAMP_MICROS(event_timestamp) as timestamp,
  event_value_in_usd as value
FROM
  `azos-data`.`analytics_262365471`.`events_*`
WHERE
  event_name = 'purchase'  
  AND value_param.key = 'value'
  AND _TABLE_SUFFIX BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'

hi all! I am new to ts. I was making some tweeks in the code to see how the output is reflected. I have few questions. I have changed a text in ts file. But I did not see any output reflected. Also I did not see any js compiled. How to compile the code so that I can see the changes?