Forum Discussion
Help with Query around custom event properties
Hey all! Trying to run a query to output volume of a specific custom event (with a specific property) performed by users who entered a specific canvas. I'm using the USERS_BEHAVIORS_CUSTOMEVENT_SHAR...
Hello inespais could you please try this :
voucher_redeems AS (
SELECT DISTINCT user_id
FROM USERS_BEHAVIORS_CUSTOMEVENT_SHARED
WHERE name = 'Voucher Redeem'
AND PARSE_JSON(properties):campaign_name::STRING = 'XYZ_CAMPAIGN'
)
This directly extracts the campaign_name property as a string.
Hope this works :)
