Hi, using Data Tables for the first time and would love to get some extra pairs of eyes on my work.
Use case:
Every time we send an email, we fire an event called notifications:send with event properties of notificationId and notificationType
When a user clicks an email, we fire an event called notifications:clicked with event properties of notificationId and notificationType
I am trying to get email clickthrough rate, defined as “for each email that is sent, is it clicked within 7 days”?
I set up a conversion metric to calculate this.
Does it look like I’ve set this up correctly?
Best answer by Manabu Takeya
Hi Anita,
Thank you for reaching out to Amplitude Support. Happy to help!
Based on your use case, you seem to be on the right track. However, whether to use 'Total' or 'Unique' depends on the specific question you're trying to answer.
If you're interested in the total number of times an email was clicked, regardless of who clicked it, then 'Total' would be the appropriate measure. This counts every event instance, even if the same notification is sent multiple times to the same users or if the same user is clicking the email multiple times.
On the other hand, if you're interested in the number of unique users who clicked the email, then 'Unique' would be the appropriate measure. This counts a user only once, no matter how many times they clicked the email. However, in your case, as the hold property constant option is enabled, the same user may appear multiple times with a different notification ID. (e.g., Sent/Click - User A x notification ID=1, User A x notification ID=2)
In the context of calculating clickthrough rate, you might want to consider using 'Unique' to get a sense of how many individual users are engaging with your emails. However, 'Total' could also provide valuable insights, such as if certain users are clicking your emails multiple times.
I hope this helps! Please let me know if you have any questions.
Best regards, Manabu
P.S. Checkout upcoming events and user meetups on our events page.
Thank you for reaching out to Amplitude Support. Happy to help!
Based on your use case, you seem to be on the right track. However, whether to use 'Total' or 'Unique' depends on the specific question you're trying to answer.
If you're interested in the total number of times an email was clicked, regardless of who clicked it, then 'Total' would be the appropriate measure. This counts every event instance, even if the same notification is sent multiple times to the same users or if the same user is clicking the email multiple times.
On the other hand, if you're interested in the number of unique users who clicked the email, then 'Unique' would be the appropriate measure. This counts a user only once, no matter how many times they clicked the email. However, in your case, as the hold property constant option is enabled, the same user may appear multiple times with a different notification ID. (e.g., Sent/Click - User A x notification ID=1, User A x notification ID=2)
In the context of calculating clickthrough rate, you might want to consider using 'Unique' to get a sense of how many individual users are engaging with your emails. However, 'Total' could also provide valuable insights, such as if certain users are clicking your emails multiple times.
I hope this helps! Please let me know if you have any questions.
Best regards, Manabu
P.S. Checkout upcoming events and user meetups on our events page.
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.
