Google Tag Manager

snowflake data sharing

2 Topics

First_did_event
Hi all, I'm working with a white label solution so 95% of my events (and attribute overwrites) are being ingested in to Segment and forwarded to braze via webhooks and largely it's working fine. However, I have a first_did_action_event that is super key but not available via the webhook the only place that see's it is snowflake via updated tables every 5 minutes (not Ideal but soon enough to remove clients from nudging canvas and in to others) I plan to build tables for details that help us group activity based on the first and ongoing did_action_event but wondering the following: CDI will allow me to update attributes But how can I send an event with these systems alone if i want to trigger an event (rather than use audience exclusions to remove someone) - We might want to trigger comms on this action_event in future potentially. I've been reading up about external_functions in snowflake and think we can use Segment Source Function to accept the Above external_function and send on to Braze. Could anyone confirm or offer up some alternative options. Thanks.
David_M
8 hours ago Place Data
21Views
0likes
2Comments
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_SHARED table, which includes event "name" and "properties" (according to the documentation --- Custom properties of the event stored as a JSON encoded string). I managed to output the total event occurrences but got stuck when it came to filtering by event property and pretty sure it's a syntax issue... Query - Total Voucher Redemptions: This looks at total "Voucher Redeem" events from users who entered the specified canvas. WITH canvas_users AS ( SELECT DISTINCT user_id FROM USERS_CANVAS_ENTRY_SHARED WHERE canvas_api_id = 'XXXXXXXXXXXXXXXXXXXXXXXX' ), voucher_redeems AS ( SELECT DISTINCT user_id FROM USERS_BEHAVIORS_CUSTOMEVENT_SHARED WHERE name = 'Voucher Redeem' ) SELECT COUNT(DISTINCT cr.user_id) AS users_redeemed_voucher FROM canvas_users cr JOIN voucher_redeems vr ON cr.user_id = vr.user_id; Query - Filter by specific property: I need to basically filter above to only include event occurrences where the "Voucher Redeem" property "campaign_name" matches a specific string. Just can't figure out how to do it. Chat GPT advised me the following, but I get zero results. WITH canvas_users AS ( SELECT DISTINCT user_id FROM USERS_CANVAS_ENTRY_SHARED WHERE canvas_api_id = 'XXXXXXXXXXXXXXXXXXXXXXXX' ), voucher_redeems AS ( SELECT DISTINCT user_id FROM USERS_BEHAVIORS_CUSTOMEVENT_SHARED WHERE name = 'Voucher Redeem' AND REGEXP_LIKE( PARSE_JSON(properties):campaign_name::STRING, '[XXXX]' ) ) SELECT COUNT(DISTINCT cr.user_id) AS users_redeemed_voucher FROM canvas_users cr JOIN voucher_redeems vr ON cr.user_id = vr.user_id; Has anyone successfully queried event properties and can shed some light on the solution here? Much appreciated!
inespais
9 months ago Place Data
186Views
1like
3Comments