SleekView Charts for Relevanssi
Relevanssi writes every indexed term into wp_relevanssi and every front-end query into wp_relevanssi_log. SleekView Charts pivots both into one dashboard with KPIs, distributions, and time-series cards.
♾️ Lifetime License available
Search briefs, stop-word candidates, and daily volume on one canvas
Relevanssi writes every indexed term into wp_relevanssi with post ID and term frequency, and every front-end query into wp_relevanssi_log with the search string and result count. The settings page summarises totals but the actual rows live in tables you can only inspect with phpMyAdmin or hand-rolled queries.
SleekView Charts reads both tables and renders a reporting canvas. A Number card counts zero-result queries from the last 30 days. A Pie card splits queries between hits and misses. A Bar card ranks the highest-frequency indexed terms. An Area card plots total queries per day.
Relevanssi keeps indexing and serving the search; Charts becomes the place where content teams find the next brief and admins find stop-word candidates.
Workflow
Build a Relevanssi charts dashboard in four steps
Connect Relevanssi tables
Open a new Charts view
Add four cards
Pin and share
Sample dashboard
Charts you can build from Relevanssi data
Zero-result queries (30 days)
Count
Queries with hits vs zero results
Count
group by hits
Top indexed terms by frequency
Sum(freq)
group by term
Queries per day
Count
group by time
Comparison
Default Relevanssi reporting vs SleekView Charts
Relevanssi settings page
- Settings page shows totals but no per-day trends
- No native KPI for zero-result queries in a chosen window
- Indexed terms reachable only via phpMyAdmin or SQL
- Hit vs miss ratio isn't visualised
- No saved per-team dashboards for content briefs
SleekView Charts
- Zero-result KPI surfaces briefs immediately
- Hit vs miss donut shows search effectiveness
- Top indexed terms ranked by frequency on a bar card
- Daily query volume as an area chart
- All four cards saved in one Charts view
Features
What SleekView Charts gives you for Relevanssi
Reads index and log together
wp_relevanssi and wp_relevanssi_log both feed the same Charts canvas. Index hygiene and query analytics live side by side.
Missing-match alerts
A dedicated KPI card surfaces zero-result queries so content gaps stop hiding inside the log table.
Cached aggregates
Each card caches its aggregate at a configurable interval, so even a busy query log renders fast.
Audience
Who builds Relevanssi charts dashboards with SleekView
Content opportunities
Surface popular queries with zero matches and turn them into the next editorial brief. The dashboard replaces the spreadsheet.
Stop-word tuning
Inspect terms by frequency to find candidates for the stop word list. The TF-100 noise terms stop dominating relevance signals.
Editorial handoff
Export query data so writers can act on it without admin access to the database.
The bigger picture
Why Relevanssi needs a Charts layer
Relevanssi's logging captures exactly what users want to find on the site, but the settings page only summarises and the underlying tables are reachable through database tools, not WP Admin. Content teams can't act on data they can't see, and admins can't tune stop words from a totals widget. SleekView Charts reads both tables and renders four cards that put zero-result counts, hit ratios, top terms, and daily volume on one canvas.
The dashboard updates as new queries come in, so the editorial brief queue stays current.
Questions
Common questions about SleekView Charts for Relevanssi
No. Charts is read-only. Relevanssi keeps full ownership of indexing and logging.
 No. Each card caches its aggregate at a configurable interval, so even big logs render fast.
 Yes. Joining wp_relevanssi with wp_posts on doc ID lets cards report which posts get hit most.
 Yes. Premium uses the same wp_relevanssi and wp_relevanssi_log tables, plus extra fields that SleekView can include in cards.
 Yes. Cards accept where-clauses, so scoping by post category or taxonomy term works directly.
 Yes. Cards refresh on a configurable interval. The view header also offers a manual refresh.
 Yes. Every card exposes a CSV export of its current dataset.
 Yes. SleekView views have role-based access, so editorial roles can see the dashboard without admin rights.
 Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkout