✨ 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 for Snowplow WP: schema and self-describing event tables

Snowplow WP stores schema-to-event mapping in wp_options and writes self-describing event metadata into wp_postmeta. SleekView surfaces both as grids so schema audits stop requiring Iglu lookups.

♾️ Lifetime License available

SleekView table view for Snowplow WP

Audit Snowplow schema configuration inside WP Admin

Snowplow is one of the few CDPs where schema is a first-class citizen. Every event is self-describing against an Iglu schema, every entity context is versioned, and the Snowplow WP integration stores its schema-to-event mapping in wp_options under snowplow_schema_map. WooCommerce orders, form submissions, and content interactions each get an _snowplow_event_id and _snowplow_schema row in wp_postmeta after relay.

The integration's settings page lists each schema mapping one at a time. To audit which schemas are pinned to which version, which events fired against a deprecated schema, or which orders never got a Snowplow event, operators end up running SQL against the Snowplow enriched events table.

SleekView reads the wp_options schema mapping and the per-row wp_postmeta as two coordinated grids. Mapping rows expose source hook, Iglu schema URI, version, and last-fired timestamp. Event rows expose the parent post or order, Snowplow event ID, schema, and version. Inline edits route through the Snowplow WP settings API so version pins stay validated.

Workflow

From wp_options schemas to a working schema audit

1

Register the Snowplow sources

SleekView reads snowplow_schema_map from wp_options and per-post _snowplow_event_id plus _snowplow_schema from wp_postmeta.
2

Compose audit columns

Schema mapping grid: source hook, Iglu URI, version pin, events 30d, last fired. Event grid: parent post, event ID, schema, version.
3

Save audit views

Build Deprecated schemas, Stale mappings, and Orders missing Snowplow event. Scope per role so data engineering, analytics, and compliance audit the same data.
4

Edit inline

Update version pins or schema URIs. Writes route through the Snowplow WP settings API so Iglu validation continues to apply.

Sample columns

A typical Snowplow WP schema-mapping view

Schema-to-event mappings with the Iglu URI, version, and last-fired timestamp from wp_options.
Source: wp_options (snowplow_schema_map) + wp_postmeta (_snowplow_event_id, _snowplow_schema)
Source hook Schema Version Events 30d Last fired Status
woocommerce_order_status_completed iglu:com.acme/order_completed 1-0-3 12,481 8s ago Active
user_register iglu:com.acme/signup 1-0-1 3,210 3m ago Active
wpforms_process_complete iglu:com.acme/form_submit 1-0-0 84 1d ago Stale
comment_post iglu:com.acme/comment_posted 0-9-1 0 Deprecated

Comparison

Default Snowplow WP admin vs SleekView

Default Snowplow WP admin

  • Settings page lists schema mappings one at a time
  • Iglu schema versions require manual lookup to verify
  • Cross-source audits (events vs orders) need SQL against the enriched events table
  • Deprecated schemas surface as debug.log warnings, not a queryable list
  • Cannot share a curated schema view with a non-admin role

SleekView

  • Every schema mapping from wp_options in one grid
  • Self-describing event metadata from wp_postmeta alongside
  • Filter Deprecated schemas or Stale mappings in one query
  • Inline edits route through the Snowplow WP settings API
  • Per-role scoped views so data engineering and product analysts share an audit surface

Features

What SleekView gives you for Snowplow WP

Schema mapping grid

Each row is a WordPress hook plus its Iglu schema URI, version, last-fired timestamp, and events sent in the last 30 days. Deprecated and stale mappings surface immediately.

Self-describing event audit

Filter wp_postmeta for _snowplow_event_id rows missing on parent shop_order posts. The audit becomes a saved view instead of a JOIN against the enriched events table.

Version pin enforcement

Edit schema version pins inline. Writes go through the Snowplow WP settings API so validation against the configured Iglu registry continues to apply.

Audience

Who uses SleekView for Snowplow WP

Data engineering

Audit every schema mapping and version pin in one grid. Deprecated schemas, broken Iglu references, and stale mappings surface as filterable rows.

Product analysts

Confirm the schemas powering a Snowplow data product are still active. Filter to a specific Iglu prefix and verify last-fired timestamps against expectations.

Compliance leads

Verify that self-describing events meet schema contract obligations. The per-event audit confirms each WooCommerce order produced a valid schema-pinned event.

The bigger picture

Why schema-first CDPs need a local schema audit

Snowplow's defining feature is that schema is enforced at collection time: every event carries a self-describing Iglu URI, every entity context is versioned, and downstream consumers can trust the shape of the data they receive. That contract is only as strong as the schema configuration on the WordPress side, which lives in wp_options as a mapping between hooks and Iglu schema URIs plus version pins. Right now that configuration is opaque to anyone who is not a data engineer.

The settings page lists schemas one at a time, deprecated versions surface as debug.log warnings, and a per-order audit requires SQL against the Snowplow enriched events table. SleekView treats the wp_options schema mapping and the wp_postmeta event metadata as coordinated, queryable grids inside WP Admin. The schema audit, deprecated, stale, missing events, becomes a saved view.

Version pins stay validated by the plugin's own Iglu helper. The schema contract becomes legible to product analysts and compliance leads, not just to the engineer who deployed it.

Questions

Common questions about SleekView for Snowplow WP

No. Snowplow remains the collector, enrichment, and warehouse pipeline. SleekView covers the WordPress-side schema audit: mapping in wp_options and event metadata in wp_postmeta.

 

When Snowplow WP exposes a validation helper, yes. Inline edits trigger the plugin's own Iglu validation, so version pins are checked against the configured registry before save.

 

Yes. The schema mapping grid surfaces deprecated and active statuses, and a saved view of Deprecated schemas highlights mappings that need an upgrade plan.

 

No. Queries paginate against existing indexes on wp_options and wp_postmeta. There is no background sync.

 

Yes. WooCommerce hooks appear as first-class source hooks. The schema mapping grid lists each Woo event with its Iglu URI and version pin.

 

Yes. The event grid joins wp_postmeta rows to wp_posts (post_type=shop_order) or HPOS wp_wc_orders. Orders missing a Snowplow event surface as filterable rows.

 

Yes. Both grids export with active filters and visible columns. Data engineers use the export to file schema deprecation tickets and version upgrade plans.

 

Yes. Event IDs and schema URIs stored in wp_postmeta stay on your server. WordPress's privacy erase tools clear those rows alongside the parent post.

 

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