Query Events in the Sitecore Analytics Database

In this article
Legacy feature

This article pertains to achieving relevance with the Coveo Hive framework. Coveo Hive is now in maintenance mode.

See Achieve relevance for guidance on leveraging Coveo relevance features with the Coveo Atomic library.

Knowing how to query page events directly in the Analytics database can be useful to validate that events coming from a Coveo Search Interface are correctly logged.

Querying xDB Page Events

  1. Download and install Robomongo.

  2. Open Robomongo and connect to localhost.

  3. Look for the Interactions collection in the analytics database. Double-click it and you should get a list of documents.

  4. By default, the documents are ordered by ascending date of insertion. Expand one of the latest documents; you should see a number of properties there. Expand the Pages array.

  5. Expand one of the Pages element. You should get an array of PageEvents. Expand this array to see the page events that have been logged.