Exclusive dashboard is not showing reports in Sitecore when register local search using DMS

1.6k views Asked by At

I am working on register local search terms in Sitecore DMS. I took help from the following blog. First of all I registered a Search page Event with named "Search".

protected void RegisterSearchPageEvent(string searchQuery)
{
    if (!Tracker.IsActive || Tracker.Visitor == null || Tracker.Visitor.CurrentVisit == null)
        return;

    var page = Tracker.Visitor.CurrentVisit.CurrentPage;
    if (Tracker.Visitor.CurrentVisit.PreviousPage != null)
        page = Tracker.Visitor.CurrentVisit.PreviousPage;

    page.Register(new PageEventData("Search")
    {
        Data = searchQuery,
        DataKey = searchQuery.ToLowerInvariant(),
        Text = searchQuery
    });
}

I also defined the page event “Search” in Sitecore. Now to display the Report in Executive Dashboard I went under the "Site Search" but it does not display anything. I configured the .config file located here:

\sitecore\shell\Applications\Reports\Dashboard\Configuration.config

Here there is a setting called “MinimumVisitsFilter“. I set it from 50 to 5 and also entered the search keywords - more than 50 times. The main point is here is that the above code is inserting the keyword into the Analytics database. Is there any SQL Query problem for Executive Dashboard?

2

There are 2 answers

0
Mahendra Shekhawat On BEST ANSWER

The above problem is due to browser cache. Sitecore DMS Search event stores the single value for one word if we don't close the browser or need to search from the different browser to store the value. If this kind of problem occurs, then search for different keywords by closing the browser and then clearing the cache. This works for me.

1
Mark Cassidy On

Even with the MinimumVisitsFilter set to 5, you still need to generate 5 unique visits to start seeing any data. On your local dev environment you could probably set this one as low as 1 or even 0 - but I would not recommend you did this on the live environment.

Also make sure all the basics are in place; Analytics is active (Sitecore.Analytics.config), the database is set up and so on.

I followed the same post when registering local search, and the procedure Brian describes here does work.