pure_coral_4158

From event_data, return event_id and JSON_EXTRACT_SCALAR(payload, '$.currency') AS currency for even

From event_data, count events per utm_source using JSON_EXTRACT_SCALAR(properties, '$.utm_source')

From event_data, return event_id and JSON_EXTRACT_SCALAR(properties, '$.utm_source') AS utm_source f

Use a CTE to extract the first and second tags from the tags array

Extract the SKU and quantity of the first item from each purchase event's payload using JSON_EXTRACT

Group events by the 'source' field extracted from payload using JSON_EXTRACT_SCALAR

Find button click events and extract the button_id from the payload JSON column.

Find all events that have a 'country' property defined

For each event, list the names of all its properties as prop_names and count how many properties it

For each event, return event_id and its tags sorted alphabetically with duplicates removed.