Skip to main content

Hi, I’m trying to create a data table that shows the breakdown of 4 different segments in a cohort of 1,000 users. I’m grouping it by `initial_utm_medium`, but the first event (SMS sent) is returning (None) for all users, regardless of whether they later visited the site and got assigned a utm_medium or not.

Is it possible to group by something that was set later in the user journey? It would be helpful to be able to filter in this way.

Hello Max,

I hope you're having a good day!

Amplitude is an event-based Analytics product, and we query based on the value at the time of the event. While it's not possible to backfill property values on already ingested events, are you looking to see `initial_utm_medium` during the same session as the SMS sent event? Is there another event that consistently occurs in the same session as the SMS sent event and has `initial_utm_medium` values? Perhaps you could group your charts by that event instead?

Would that work for you?

Best,
Sydney


P.S. Checkout upcoming events and user meetups on our events page.

Reply


Terms & ConditionsCookie settings