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
| Frequency | Type | Retention |
|---|---|---|
| Daily | Automated full database | Keep 7-14 days |
| Weekly | Full site (files + database) | Keep 4-8 weeks |
| Monthly | Archived offsite backup | Keep 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!