I have a long list (80-100) of various product IDs that I want to add to various events. The IDs don’t have a common category, so usually I have to add them manually.
I’ve read posts about various matching (I’m new to using query and regex), so I hope Amplitude has some way for me to add all IDs to the property, by a simple copy-paste.
Usually when adding manually, it’ll look like the following image.
I’ve tried adding the IDs as a single string, but no matter which sort of matching I’m using, I’m getting 0 event hits.
Is there a smart way to do this?
NB: ‘contains’ is dangerous to use as we have IDs (e.g. 1234) on the list, that also matches IDs (e.g. 12345 or 12346) outside the list.
Best answer by Jacenda Davis
Hello! Thanks for your question.
It is the case that by selecting the property values as a comma-separated list in the drop-down menu that you are filtering the chart for nav_link_click events that have a combination of the property values present (e.g. the event would have to include property values 11, 33, 6, and 14 simultaneously). This is likely why your chart is showing "0" results when you select this option.
I would recommend you use the "=" operator and then input a comma-separated list of property values in the search bar. This should produce a list of each of the separate property values in the drop-down menu, then you can use the "Select All" option to select all of the property values individually at once as depicted below: You could use a spreadsheet (e.g. Excel, Google Sheets, etc.) to create a comma-separated list of the property values, which you can then simply copy and paste into the search bar.
It is the case that by selecting the property values as a comma-separated list in the drop-down menu that you are filtering the chart for nav_link_click events that have a combination of the property values present (e.g. the event would have to include property values 11, 33, 6, and 14 simultaneously). This is likely why your chart is showing "0" results when you select this option.
I would recommend you use the "=" operator and then input a comma-separated list of property values in the search bar. This should produce a list of each of the separate property values in the drop-down menu, then you can use the "Select All" option to select all of the property values individually at once as depicted below: You could use a spreadsheet (e.g. Excel, Google Sheets, etc.) to create a comma-separated list of the property values, which you can then simply copy and paste into the search bar.
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.
You could use a spreadsheet (e.g. Excel, Google Sheets, etc.) to create a comma-separated list of the property values, which you can then simply copy and paste into the search bar.
