wp_daily_aggregates
StaticStores daily aggregates data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑date | TEXT | YES |
| sessions | INTEGER | YES |
| new_visitors | INTEGER | YES |
| returning_visitors | INTEGER | YES |
| pageviews | INTEGER | YES |
| bounces | INTEGER | YES |
| total_duration | INTEGER | YES |
| total_scroll_depth | INTEGER | YES |
| conversions | INTEGER | YES |
| source_direct | INTEGER | YES |
| source_organic | INTEGER | YES |
| source_social | INTEGER | YES |
| source_referral | INTEGER | YES |
| source_ai | INTEGER | YES |
| device_mobile | INTEGER | YES |
| device_tablet | INTEGER | YES |
| device_laptop | INTEGER | YES |
| device_desktop | INTEGER | YES |
| created_at | TEXT | NO |
| updated_at | TEXT | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS daily_aggregates ( date TEXT PRIMARY KEY, sessions INTEGER DEFAULT 0, unique_visitors INTEGER DEFAULT 0, new_visitors INTEGER DEFAULT 0, returning_visitors INTEGER DEFAULT 0, pageviews INTEGER DEFAULT 0, bounces INTEGER DEFAULT 0, total_duration INTEGER DEFAULT 0, total_scroll_depth INTEGER DEFAULT 0, conversions INTEGER DEFAULT 0, source_direct INTEGER DEFAULT 0, source_organic INTEGER DEFAULT 0, source_social INTEGER DEFAULT 0, source_referral INTEGER DEFAULT 0, source_ai INTEGER DEFAULT 0, device_mobile INTEGER DEFAULT 0, device_tablet INTEGER DEFAULT 0, device_laptop INTEGER DEFAULT 0, device_desktop INTEGER DEFAULT 0, created_at TEXT NOT NULL, updated_at TEXT NOT NULL )");
Safe to delete?
If you have uninstalled Kantan Analytics, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_daily_aggregates`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Kantan Analytics