✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

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

SleekView Charts dashboard for Relevanssi

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

1

Connect Relevanssi tables

Add wp_relevanssi and wp_relevanssi_log as SleekView data sources. The agent UI auto-discovers term, doc, freq, query, hits, and time columns.
2

Open a new Charts view

Toggle the view type to Charts. The empty canvas waits for cards configured against the Relevanssi datasets.
3

Add four cards

Drop a Number for zero-result queries. Add a Pie for hit vs miss queries. Add a Bar for the top indexed terms by frequency. Add an Area for queries per day.
4

Pin and share

Save the view, assign roles, and pin to the admin sidebar. Editors and admins open the same live dashboard.

Sample dashboard

Charts you can build from Relevanssi data

All four cards read Relevanssi's own tables. The index and the log are already populated.
Number · Default

Zero-result queries (30 days)

KPI for content gaps. Counts queries in wp_relevanssi_log where hits is 0 over the trailing 30 days.
Count
Pie · Donut text

Queries with hits vs zero results

Donut split of queries that returned matches against zero-result queries. The miss rate becomes visible at a glance.
Count group by hits
Bar · Horizontal

Top indexed terms by frequency

Horizontal bar of the highest-frequency terms in wp_relevanssi. Stop-word candidates and long-tail terms become visible in one sorted view.
Sum(freq) group by term
Area · Gradient

Queries per day

Gradient area of total queries per day. Campaign spikes and quiet weeks share one chart.
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.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

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