{"table_name":"daily_aggregates","full_table_name":"wp_daily_aggregates","description":"Stores daily aggregates data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"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 )\");","columns":[{"name":"date","type":"TEXT","nullable":true,"primary_key":true},{"name":"sessions","type":"INTEGER","nullable":true,"primary_key":false},{"name":"new_visitors","type":"INTEGER","nullable":true,"primary_key":false},{"name":"returning_visitors","type":"INTEGER","nullable":true,"primary_key":false},{"name":"pageviews","type":"INTEGER","nullable":true,"primary_key":false},{"name":"bounces","type":"INTEGER","nullable":true,"primary_key":false},{"name":"total_duration","type":"INTEGER","nullable":true,"primary_key":false},{"name":"total_scroll_depth","type":"INTEGER","nullable":true,"primary_key":false},{"name":"conversions","type":"INTEGER","nullable":true,"primary_key":false},{"name":"source_direct","type":"INTEGER","nullable":true,"primary_key":false},{"name":"source_organic","type":"INTEGER","nullable":true,"primary_key":false},{"name":"source_social","type":"INTEGER","nullable":true,"primary_key":false},{"name":"source_referral","type":"INTEGER","nullable":true,"primary_key":false},{"name":"source_ai","type":"INTEGER","nullable":true,"primary_key":false},{"name":"device_mobile","type":"INTEGER","nullable":true,"primary_key":false},{"name":"device_tablet","type":"INTEGER","nullable":true,"primary_key":false},{"name":"device_laptop","type":"INTEGER","nullable":true,"primary_key":false},{"name":"device_desktop","type":"INTEGER","nullable":true,"primary_key":false},{"name":"created_at","type":"TEXT","nullable":false,"primary_key":false},{"name":"updated_at","type":"TEXT","nullable":false,"primary_key":false}],"plugin":{"slug":"kantan-analytics","name":"Kantan Analytics","active_installs":0,"version":"2.20.1","wp_org_url":"https://wordpress.org/plugins/kantan-analytics/"}}