custom metric permitted events and other related things
@jennru
Are we not allowed to refer to Cohorts we’ve created as part of custom metrics?
For our situation, I’m trying to create a custom metric for the third column in second image below.
The first column is just users to a page.
The second column is users to that page who were part of a cohort. That custom cohort is users who viewed a thank-you page, which is for us our final conversion step.
Third column is intended to be second column divided by first column, as percentage.
Within first image below is the available events, and the event is viewed page filtered to that cohort. Trying to work out some combination that makes that work in some fashion.
Thank you!
Page 1 / 1
Hi @Herb Lau thank you for reaching out. Great callout, you cannot reference a cohort in a data tables chart metric at this time. Thinking out loud ...
create a second segment in your data tables chart that references the cohort
this will then enable you to collapse column 2 “Viewed Loan TV Page” since the 2nd segment will split up column 1 into 2 for the All Users segment vs Cohort segment
^^This will enable you to see the uniques for all users vs uniques of cohort users (which I recognize is the exact same view you already have now)
I was going to then suggest to add a second column with a custom metric formula for %:UNIQUES(A1)/UNIQUES(A2) (or A2/A1 contingent on the ordering of the segments) but I tested this out and it looks like we don’t support referencing a segment in a formula in data tables at this time :(
I’ve surfaced this to the product team and will get back to you when I learn if this is a known limitation that will be worked on this year or if there’s a technical limitation preventing product from enabling this in data tables.
A final thought for now - contingent on the complexity of your cohort (and if you can remove any time interval dependencies), you could recreate the event+property filters in the selected events when building your custom metric. I recognize this will not be an exact match at the cohort though.
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.
