I’ve extracted the list of Amplitude IDs from a Funnel, copied and pasted them on a csv, and .txt files with nothing more than the numbers (no commas, nada). Just line by line, and the platform rejects it.
Great workaround proposal, I would just recommend to use the = logic rather than set contains. If there’s a case that a user’s ID = 123 and another user’s ID = 123456, but you only want to include user 123 in your cohort, the = would be the most strict condition to yield the exact list of IDs that are in your list.
For your original CSV file attempt,
Was there a row header in the CSV file? Make sure to remove any headers from the file
Were the Amplitude IDs shown in scientific notation in the CSV file? If yes, convert these values to a custom number with no decimals.
Then the CSV import should work.
As an additional suggestion, you can build a dynamic cohort directly from a funnel analysis chart. And if you want to restrict the cohort to a specific date range, you can edit the dates in the cohort to an exact interval, rather than a rolling interval.
Either way, your workaround proposal works just as well (just modifying set contains to =
But let me know if this helps if you ever retry CSV imported cohorts.
Great workaround proposal, I would just recommend to use the = logic rather than set contains. If there’s a case that a user’s ID = 123 and another user’s ID = 123456, but you only want to include user 123 in your cohort, the = would be the most strict condition to yield the exact list of IDs that are in your list.
For your original CSV file attempt,
Was there a row header in the CSV file? Make sure to remove any headers from the file
Were the Amplitude IDs shown in scientific notation in the CSV file? If yes, convert these values to a custom number with no decimals.
Then the CSV import should work.
As an additional suggestion, you can build a dynamic cohort directly from a funnel analysis chart. And if you want to restrict the cohort to a specific date range, you can edit the dates in the cohort to an exact interval, rather than a rolling interval.
Either way, your workaround proposal works just as well (just modifying set contains to =
But let me know if this helps if you ever retry CSV imported cohorts.
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.