Edit Report:Top 50 Search Terms Online
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Top 50 Search Terms Online
select
keyword 'SEARCH' ,
count(keyword) as 'COUNT'
from
cscleve.oc_customer_search
group by
keyword
order by
count(keyword) desc
limit
50;