On our chatbot app, users can do the following for each query/response set:
1. Add Comments
2. Give Thumbs up
3. Give Thumbs down
4. Give Thumbs up with comments
5. Give Thumbs down with comments
The app is triggering the following separate events in Amplitude. These are the event properties:
Comments
name: comment
value.comments: TRUE
value.correct: NULL
value.EventId: “unique identifier assigned to the chat interaction”
Thumbs up
name: feedback
value.comments: FALSE
value.correct: YES
value.EventId: “unique identifier assigned to the chat interaction”
Thumbs down
name: feedback
value.comments: FALSE
value.correct: NO
value.EventId: “unique identifier assigned to the chat interaction”
There are no unique events for thumbs up/down with a comment, and we cannot change that right now.
In other words, when a user provides Thumbs down with a comment, the events come through separately (A Comments event and a Feedback event with value.correct=No). This is tied to the user interface, which we cannot modify at the moment.
In order to report on the 5 distinct categories mentioned above, we are also sending in an Event ID to Amplitude, to tie the Thumbs + Comment information together. The event ID is a unique identifier given to each chat interaction, and it gets captured under property “value.EventId”. Each query/response set gets its own unique Event ID.
Our question is: How can we use the Event ID to tie together thumbs up/down and comment actions in Amplitude?
Is it possible to join separate events with a common/shared property? If yes, please share the steps.
The goal is to be able to count the number of comments and thumbs by Event ID. IOW, if the event ID is the same, we want to club together the comment and feedback events and count them as 1.
Looking for the best way to accomplish this. Please note that I am unable to create derived properties.
Thank you very much!