✨ 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 WordPress Importer: WXR import audit

The official WordPress Importer ingests WXR exports and stamps imported rows with _wxr_import_user_* postmeta plus original_post_id markers. SleekView reads those keys and charts what was imported, who got mapped and which attachments failed.

♾️ Lifetime License available

SleekView Charts dashboard for WordPress Importer

WXR imports vanish into wp_posts with almost no breadcrumb

WordPress Importer is the canonical free tool from the wordpress.org team for ingesting WXR exports between sites. It walks the XML, creates posts, terms and attachments, and attempts to remap authors. The footprint it leaves is sparse: _wxr_import_user_* postmeta on remapped users, _wxr_imported_post_id on legacy IDs and an admin-side progress log that does not persist. The native UI confirms success and disappears.

SleekView Charts reads the residual postmeta and joins it back to wp_posts to recover an audit trail. A Number card counts posts imported in the last 30 days using the _wxr_imported_post_id marker. A donut breaks imported rows down by post_type so the team sees the mix of pages, posts and attachments. A bar lists author mappings by remapped user. An area chart tracks imports over time, which is useful when you ingest content from several legacy sources.

Attachments are the usual failure point. The chart layer flags attachment rows where _wp_attached_file is missing or where the source URL did not download, so cleanup is targeted instead of guesswork.

Workflow

From _wxr_imported_post_id postmeta to an import audit

1

Connect SleekView to wp_postmeta

Point the view at wp_postmeta filtered to _wxr_import_user_* and _wxr_imported_post_id keys, then join to wp_posts on post_id for full row context.
2

Pivot import markers into columns

SleekView surfaces post_id, post_type, post_status, post_date, original_post_id and remapped_author so each imported row becomes a chartable record.
3

Add the four chart cards

A Number for posts imported in the last 30 days, a donut for imports by post_type, a bar for author remapping and an area for import volume per day.
4

Flag attachment failures

Add a filtered view of attachment rows missing _wp_attached_file so broken media imports are visible as a queue instead of being scattered across the media library.

Sample dashboard

Charts you can build from WordPress Importer data

Four cards that turn _wxr_imported_post_id postmeta into a WXR-import audit covering counts, post types, authors and cadence.
Number · Default

Posts imported, last 30 days

Single big-number KPI counting rows in wp_postmeta with meta_key equal to _wxr_imported_post_id whose joined wp_posts.post_date is within the last 30 days.
Count
Pie · Donut

Imports by post type

Donut over imported rows joined to wp_posts.post_type so the page, post, attachment, nav_menu_item and custom post type mix is visible at a glance.
Count group by post_type
Bar · Horizontal

Author remapping counts

Horizontal bar of posts grouped by remapped_author from _wxr_import_user_* postmeta, showing how many imported posts landed under each existing WordPress user.
Count group by remapped_author
Area · Gradient

Import volume per day

Gradient area chart of imported posts per day using wp_posts.post_date, useful for distinguishing one large WXR run from several smaller incremental imports.
Count group by post_date

Comparison

Default WordPress Importer log vs SleekView Charts

Default WordPress Importer log

  • Import progress log only lives on screen during the run.
  • No persistent audit of which post types were imported in which run.
  • Author remapping outcomes vanish once the importer closes.
  • Attachment failures appear as inline errors, then disappear.
  • Cross-import cadence over time is not surfaced anywhere.

SleekView Charts

  • Posts-imported KPI counted from _wxr_imported_post_id postmeta.
  • Post-type donut so the page, post and attachment mix is visible.
  • Author-remap bar built from _wxr_import_user_* postmeta.
  • Import cadence area chart from wp_posts.post_date.
  • Attachment-failure queue from missing _wp_attached_file rows.

Features

What SleekView Charts gives you for WordPress Importer

Recover the import history

WordPress Importer does not persist a log, but the postmeta breadcrumbs are enough for SleekView to reconstruct a per-run audit of every imported post and attachment.

Author mapping clarity

Bar of remapped authors exposes content that ended up under the default importer user, which is the usual symptom of an incomplete user mapping step.

Attachment failure queue

Filtered view of imported attachment rows missing _wp_attached_file surfaces broken media uploads that the native importer reports inline and then forgets.

Audience

Who builds WordPress Importer audit dashboards with SleekView

Site migration teams

Audit dashboard during incremental WXR ingests, with imports per day, post-type mix and remapped-author counts visible alongside the live import.

Content migration leads

Per-source visibility when consolidating several legacy blogs into one WordPress site through staged WXR imports across days or weeks.

Editorial compliance

Evidence that imported content has correct authorship attribution before the new site flips to public, with remap counts as the artifact.

The bigger picture

The official importer is reliable; the audit is missing

WordPress Importer is rock-solid at the technical job of moving WXR content from site to site. The gap is that it leaves almost no readable history once the run completes, which is awkward for any migration that imports from several sources or runs in passes. The _wxr_imported_post_id and _wxr_import_user_* postmeta are usually treated as internals, but they are exactly the breadcrumbs needed to reconstruct an audit.

Charting them turns a one-off dialog into a saved view, which is what serious editorial migrations need.

Questions

Common questions about SleekView Charts for WordPress Importer

Yes. WordPress Importer writes _wxr_imported_post_id and _wxr_import_user_* postmeta during every WXR ingest. SleekView reads those keys directly and joins them to wp_posts for chart cards.

 

Yes, as long as the importer left its postmeta on the imported posts. That metadata persists indefinitely, so historical imports remain chartable after the fact.

 

Yes, provided they were ingested via the WordPress Importer plugin. The chart layer keys off the importer's postmeta, not the WXR file format, so any importer-run shows up.

 

Attachments fail loudly during the run and then disappear. SleekView builds a queue of imported attachment rows missing _wp_attached_file so a follow-up media re-import is targeted.

 

If the WXR file embeds a source URL or you set a custom meta during ingest, SleekView can group by it. Out of the box the importer does not record a stable source identifier.

 

No. SleekView is read-only against wp_postmeta and wp_posts, and chart queries run on demand. A live importer run is unaffected by whether the dashboard is open.

 

Yes. SleekView views are capability-gated, so the import audit can be limited to editors-in-chief or a custom migration_lead role and hidden from contributors.

 

Each site renders its own audit dashboard out of the box. Cross-site aggregation requires a SleekView data source that joins postmeta from each site into one table.

 

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