Sitecore 9 update 1, I'm trying to get the top trending search keywords by users for my website.
I discovered that the local search keywords are stored at table
DimensionKeys in the Reporting database, and its count in table
It seems the keywords are stored after 25 minutes. Not all keywords are stored it seems. I have been unable to find any documentation for this in the xConnect Documentation.
How can I access this data to extract trending search keywords?