Our platform allows users to create posts and other users to comment on them. We would like to know, on a continuous basis, what % of posts are being commented on within a week of the post being created.
Post Created event tracked against user User1 with property
Post Commented event tracked against user User2 with property
As you can see, it’s the correlation of the postId property that’s important in our use case. We’re not particularly interested in the specific user (except, potentially, to be able to state the condition Post Created.distinctId != Post Commented.distinctId to eliminate users self-commenting from the data).
What would be the best way of performing this analysis in Mixpanel?
Thanks in advance,