Openpanel-dev / openpanel

All the goodies from both Mixpanel and Plausible combined into one tool.
https://openpanel.dev
GNU Affero General Public License v3.0
3.14k stars 112 forks source link

Stitching #77

Open lourcourt opened 1 month ago

lourcourt commented 1 month ago

Hi!

First of all congrats, great project 🙌🏼 Is there a way of stitching events sent before user_id or account_id creation via a session_id/device_id?

Thanks!

lindesvard commented 1 month ago

Hey and thanks!

Short answer: Not today

Long answer: Today we does this in a sense. If you look into a profile you will see the events both before and after you have identified a user.

We do this with the common device id, but the user id is still not set on those events before the identify call.


But this is something I want to support, its quite simple task but afraid of the consequences it might give to Clickhouse since they do not promote updating/deleting rows. Then it should have a different table engine (don't want to change it for the events table).