Hi, I am trying to analyze a "funnel" in amplitude related to searches in our app.
The funnel is made of events like "Search Completed", "Item Clicked", "Added to cart".
I would like to be able to group by both the "search_term" (in the Search Completed event), and by the "item_id" contained in the "Item Clicked" and "Added to cart".Ideally,
I would like to get a table like:
search_term, item_id, n, add_to_cart_rate.
Right now I can group the first event of the funnel by “search term” in the Search Completed event, but there’s no way I can know the conversion rate of the individual items returned as search results.
It would be great if one could group by other fields in subsequent events of the funnel to get a better understanding of what items are good for which queries.
