Search stats and clickstream actions

Summary

Joining the search stats/keyword searches to clickstream action ids

Content

We have a requirement to breakdown the searches summary (id 208) and keyword searches (id 15) to identify from which portal page that search was performed. We have multiple portals (different app folder for each process) in same interface and they all have their own home and search pages from where the search can be performed. (refer attachment req-1 for sample layout)

The other requirement is to provide drilldown on # of Results column in the Searches Summary report (refer attachment drilldown-result) similar to Answers Viewed to view the answers returned by search. The stats data seems to be just taking count. the answer ids are there in the clickstream table but no way to access them from stats table. The keyword search report shows that by running the search knowledgebase report using linked report. But that is going against current data and not what the user might have seen so again not really useful.