In Data Source settings, there's a "User Id Join Table (optional)" field. We don't link anon ids to user ids (as a policy). Sooo I left it blank, but it looks like that breaks any experiment that includes both anons and users.
Is that field meant to be optional? If so, under what conditions?
better-parrot-43048
04/01/2022, 8:52 PM
snippets of experiment query when it's left blank:
Copy code
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)
f
future-teacher-7046
04/01/2022, 8:52 PM
That join table is used when an experiment is based on