Why aren't keywords used for searching showing up in the keyword_searches table?
Environment:
Phrase Searching, Customer Portal, Analytics
Issue:
A custom report based on the "keyword_searches" table doesn't show all keywords that were used for search on Customer Portal pages.
Resolution:
When a search is performed on Customer Portal pages, the end-used activity or sessions are being saved in a the clickstreams table in a form of actions. Search actions may also get recorded in the keyword_searches table by the dqa utility; however, certain conditions should be met in order for data to be populated into keyword_searches.
Following actions should be present within the same end-user session:
1. "/Search" action type
2. "/ResultList" action type
Those actions are present and being executed by default on a standard Customer Portal pages but can be accidentally removed or renamed on some pages during CP development process. You will want to check any customized code if you encounter the scenario above.