We would like to submit an idea for a new reporting functionality in Coremetrics Digital Analytics - based on information from IBM this functionality currently does not exist.

1) Showing search queries (keywords) and product clicks from the search results (products shown on search results page)
It could be something like this:

query1 | ProductID_1 | number of clicks
query1 | ProductID_2 | number of clicks
etc

2) Showing search queries (keywords) and products added to cart from the search results
It could be something like this:
query1 | ProductID_1 | number of times this product was added to cart from search results (or, in other words, product items added to cart)
query1 | ProductID_2 | number of times this product was added to cart from search results (or, in other words, product items added to cart)
etc

3) Showing search queries (keywords) and products purchased (ordered) from the search results
It could be something like this:
query1 | ProductID_1 | number of orders
query1 | ProductID_2 | number of orders

We tried to build these reports but once we select "On Site Search Term" field from Content, product related fields from Merchandising/Products disappear from "Available Display Columns."

It would be useful to see this on site search query and related products data to show a relationship between search terms and products added to cart and purchased after these searches.