@fresh-football-47124 thank you so much for your time today, and the engineer whose name I sadly didn’t write down. I’ve updated my local instance of GrowthBook to Build: 18664dd (2023-05-03) but my visual experiment still isn’t showing results. This is the experiment query:

-- Counter button clicks (count)

WITH

__rawExperiment as (

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

(

SELECT

*

FROM

``analytics_xxx.events_*``

WHERE

_TABLE_SUFFIX BETWEEN '20230403' AND '20230505'

UNION ALL

SELECT

*

FROM

``analytics_xxx.events_intraday_*``

WHERE

_TABLE_SUFFIX BETWEEN '20230403' AND '20230505'

),

UNNEST (event_params) AS experiment_id_param,

UNNEST (event_params) AS variation_id_param

WHERE

event_name = 'experiment_viewed'

AND experiment_id_param.key = 'experiment_id'

AND variation_id_param.key = 'variation_id'

AND user_id is not null

),

__experiment as ( -- Viewed Experiment

SELECT

e.user_id as user_id,

cast(e.variation_id as string) as variation,

CAST(e.timestamp as DATETIME) as timestamp,

CAST(e.timestamp as DATETIME) as conversion_start,

DATETIME_ADD(CAST(e.timestamp as DATETIME), INTERVAL 72 HOUR) as conversion_end

FROM

__rawExperiment e

WHERE

e.experiment_id = 'new-secondary-panel-title'

AND CAST(e.timestamp as DATETIME) >= DATETIME("2023-04-03 17:53:00")

),

__metric as ( -- Metric (Counter button clicks)

SELECT

user_id as user_id,

m.value as value,

CAST(m.timestamp as DATETIME) as timestamp,

CAST(m.timestamp as DATETIME) as conversion_start,

CAST(m.timestamp as DATETIME) as conversion_end

FROM

(

SELECT

user_id,

user_pseudo_id as anonymous_id,

TIMESTAMP_MICROS(event_timestamp) as timestamp,

1 as value

FROM

``analytics_356435236.events_intraday_*``

WHERE

event_name = 'Click counter button'

AND _TABLE_SUFFIX BETWEEN '20230328' AND '20231231'

UNION ALL

SELECT

user_id,

user_pseudo_id as anonymous_id,

TIMESTAMP_MICROS(event_timestamp) as timestamp,

1 as value

FROM

``analytics_356435236.events_*``

WHERE

event_name = 'Click counter button'

AND _TABLE_SUFFIX BETWEEN '20230328' AND '20231231'

) m

WHERE

CAST(m.timestamp as DATETIME) >= DATETIME("2023-04-03 17:53:00")

),

__distinctUsers as (

-- One row per user

SELECT

e.user_id as user_id,

cast('All' as string) as dimension,

(

CASE

WHEN count(distinct e.variation) > 1 THEN '__multiple__'

ELSE max(e.variation)

END

) as variation,

MIN(e.conversion_start) as conversion_start,

MIN(e.conversion_end) as conversion_end

FROM

__experiment e

GROUP BY

e.user_id

),

__userMetric as (

-- Add in the aggregate metric value for each user

SELECT

d.variation,

d.dimension,

d.user_id,

SUM(m.value) as value

FROM

__distinctUsers d

JOIN __metric m ON (m.user_id = d.user_id)

WHERE

m.timestamp >= d.conversion_start

AND m.timestamp <= d.conversion_end

GROUP BY

d.variation,

d.dimension,

d.user_id

),

__stats AS (

-- One row per variation/dimension with aggregations

SELECT

m.variation,

m.dimension,

COUNT(*) AS count,

SUM(COALESCE(m.value, 0)) AS main_sum,

SUM(POWER(COALESCE(m.value, 0), 2)) AS main_sum_squares

FROM

__userMetric m

GROUP BY

m.variation,

m.dimension

),

__overallUsers as (

-- Number of users in each variation/dimension

SELECT

variation,

dimension,

COUNT(*) as users

FROM

__distinctUsers

GROUP BY

variation,

dimension

)

SELECT

u.variation,

u.dimension,

u.users AS users,

'mean' as statistic_type,

'count' as main_metric_type,

COALESCE(s.main_sum, 0) AS main_sum,

COALESCE(s.main_sum_squares, 0) AS main_sum_squares

FROM

__overallUsers u

LEFT JOIN __stats s ON (

u.variation = s.variation

AND u.dimension = s.dimension

)

Here’s a screenshot of the SELECT in BigQuery, and a screenshot of the experiment in GrowthBook. Is there anything else you can suggest for me to try?