I heard about the term "backfilling" in Funnels, but I'm not quite sure what it does or what it means. Can you clarify on "backfilling", and if possible, provide examples of what would be the best types of properties to set in my events with "backfilling" in mind?
Best answer by spark
Sarah here from Mixpanel Support. Happy to clarify on backfilling.
Backfilling is when an event property "fills in the blanks" from a later event (step) to an earlier event.
For example, say we were tracking a Funnel that had three steps. Imagine a scenario where in steps 1, and 2, the user completes the steps with their 'Browser' property having the value of 'Chrome'. However, that same user completes steps 3 with the 'Browser' property having the value of 'Safari'. In this case, there's a product question- do we put them in the table as a converted 'Chrome' user or a converted 'Safari' user? If we put them as both, that will create two conversions for a single user.
The product decision our team made was that we would keep the last converting value and backfill it to the previous steps. Thus, in our previous example, the last converting value was 'Safari', so steps 1, 2, and 3 will all be considered 'Safari' values, despite the fact that they did 'Chrome' in steps 1, and 2.
Does this make sense,