WhoKnew Views™ | Backup & Archive Your Analytics Data

Skip to main content
Table of Contents
Print

Protect years of valuable view data with proper database backups

All your WhoKnew Views™ data—every view timestamp, lifetime counter, conversion record, and AI learning data—lives in your WordPress MySQL database. Unlike cloud-based analytics that store data on external servers, your view data stays on your hosting. That’s great for privacy and ownership, but it means you’re responsible for backups. 🛡️


🗄️ Where Your Data Lives

WhoKnew Views™ stores all analytics in your WordPress wp_postmeta table, attached to each product:

📊 Critical Meta Keys

product_views→ Real view timestamps (last 90 days)

_wkv_daily_view_aggregates→ Historical daily counts (91 days – 5 years)

_wkv_total_real_views_ever→ Lifetime counter (permanent, never decreases)

product_views_baseline_padding→ Permanent baseline floor (Pro)

product_padded_views→ Variation timestamps (Pro)

_wkv_conversions→ Conversion tracking data (Pro)

🚨 If You Lose Your Database: All historical view data, lifetime achievement counts, AI learning patterns, and conversion records are gone. No cloud backup exists—this data lives only on your server.


💾 The Only Real Backup: Your Database

The single most important thing you can do is regularly back up your WordPress database. This protects everything—not just WhoKnew Views™ data, but your entire store.

✅ Recommended Backup Solutions

🏢

Hosting Provider Backups

Most quality hosts (SiteGround, Kinsta, WP Engine, Cloudways) include automatic daily backups. Verify yours are enabled and test restoration periodically.

🔌

Backup Plugins

UpdraftPlus, BackupBuddy, BlogVault, or Jetpack Backup. Schedule automatic backups to cloud storage (Google Drive, Dropbox, S3).

🖥️

Manual MySQL Exports

Use phpMyAdmin, MySQL Workbench, or mysqldump for periodic manual database exports. Store offsite.


📅 Recommended Backup Schedule

FrequencyTypeRetention
DailyAutomated full databaseKeep 7-14 days
WeeklyFull site (files + database)Keep 4-8 weeks
MonthlyArchived offsite backupKeep 6-12 months

📤 Supplemental: Point-in-Time Snapshots

While database backups protect your raw data, WhoKnew Views™ Pro also provides export tools for human-readable snapshots:

📸

PNG Chart Exports

Visual snapshots for reporting

📊

CSV Data Exports

Raw numbers for spreadsheets

📧

Weekly Summaries

Automatic email archives

💡 Pro Tip: These exports are supplements, not replacements for database backups. They capture a moment in time but don’t include the granular timestamp data needed for AI forecasting or detailed historical analysis.


⚠️ What Happens Without Backups

Without proper database backups, you risk losing:

  • 📈 Years of historical view data — The raw timestamps that power trend analysis
  • 🏆 Lifetime achievement counters — Permanent records that never decrease
  • 🤖 AI learning patterns — Months of conversion optimization intelligence
  • 💰 Conversion tracking records — Purchase attribution and ROI data
  • 🔮 Forecasting accuracy — Prophet AI needs historical data; more history = better predictions

✅ Bottom Line: Set up automated database backups today. It takes 10 minutes to configure and protects years of irreplaceable analytics data. Your hosting provider likely offers this for free—just make sure it’s enabled!

Share