I have 2 custom events called asset_download_started and asset_download_completed, they both share a property between them called assetId, asset_download_started has a property called entryName that the other event does not have and asset_download_completed has a property called downloadTime that the other event does not have.
So, just to recap, both events share assetId one of them has entryName and the other one has downloadTime. Now what I want to do is to join this events, just like you would on traditional SQL, on assetId so that I can make a chart where I can display the average downloadTime grouped by entryName.
Can I do this in amplitude? If so how? All of the things i’ve tried so far have not worked.
Best answer by dangrainger
Hey @Zisis Tsatsas . Assuming you’re passing entryName as an event property, I think the answer is no….event properties don’t persist, they’re only captured and associated at a point in time with the event they’re passed with. User properties do persist...but I wouldn’t go down that route, it doesn’t sound like you entryName variable is “user” level so that would merely be a (bad) hack.
I think the solution here is for you to pass entryName as an event property with the asset_download_completed event; I’m not aware of anything in the Amplitude UI that would allow for transposition of event properties between events on the fly (though if there is something like that I’m sure someone from Amplitude will chime in!).
Hey @Zisis Tsatsas . Assuming you’re passing entryName as an event property, I think the answer is no….event properties don’t persist, they’re only captured and associated at a point in time with the event they’re passed with. User properties do persist...but I wouldn’t go down that route, it doesn’t sound like you entryName variable is “user” level so that would merely be a (bad) hack.
I think the solution here is for you to pass entryName as an event property with the asset_download_completed event; I’m not aware of anything in the Amplitude UI that would allow for transposition of event properties between events on the fly (though if there is something like that I’m sure someone from Amplitude will chime in!).
Hey @Zisis Tsatsas . Assuming you’re passing entryName as an event property, I think the answer is no….event properties don’t persist, they’re only captured and associated at a point in time with the event they’re passed with. User properties do persist...but I wouldn’t go down that route, it doesn’t sound like you entryName variable is “user” level so that would merely be a (bad) hack.
I think the solution here is for you to pass entryName as an event property with the asset_download_completed event; I’m not aware of anything in the Amplitude UI that would allow for transposition of event properties between events on the fly (though if there is something like that I’m sure someone from Amplitude will chime in!).
Dan.
Hey Dan,
Thanks for the reply. You are right entryName is passed as an event property, I am sending data through the API and not using the SDKs, and yeah passing it in user properties would be hacky you are right. This i unfortunate, hopefuly they add a feature like this in the future. I just want to join my data 😅
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you're a current customer, select the domain you use to sign in with Amplitude.
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
If you're a current customer, select the domain you use to sign in with Amplitude.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
