https://www.growthbook.io/ logo
#ask-questions
Title
# ask-questions
s

salmon-toddler-21259

09/21/2023, 9:49 PM
Hi - I’m new to growthbook. I need to customize the default “purchase” metric that growthbook generated. So I duplicated it, and even without editing the sql at all I get this error “Missing the following required columns: “user_id” when I try to save. But how come purchase metric is able to be generated with user_id mentioned in the SQL? Anyways to move around this error, do I just remove user_id from identifiers supported? I am using GA4 / Big Query.
p

prehistoric-beard-84272

09/22/2023, 10:54 AM
Hi, have you tried adding
user_id
to your query? like
Copy code
SELECT
user_id,
user_pseudo_id as anonymous_id,
.
.
.
Alternatively removing user_id from supported identifier types should also resolve this.
s

salmon-toddler-21259

09/23/2023, 1:42 AM
I did remove user_id and that worked fine. Does growthbook care if user_id is included or not? I’m just using anonymous_id for now, people are not logged in.
14 Views