This message was deleted.

snippets of experiment query when it's left blank:

WITH __identities as (
  -- ERROR: Missing User Id Join Table!
  SELECT
    '' as anonymous_id,
    '' as user_id
),
...
(then, in the __metric CTE):
    JOIN __identities i ON (i.user_id = m.user_id)

That join table is used when an experiment is based on

anonymous_id

and you have a metric that only has a

user_id

column.

Oooh I get it. Thank u!