{"slug":"kantan-analytics","name":"Kantan Analytics","description":"Lightweight, self-hosted analytics with click tracking, scroll depth, and user journey visualization. No cookies, no external services.","author":"Try Kantan","active_installs":0,"version":"2.20.1","wp_org_url":"https://wordpress.org/plugins/kantan-analytics/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"conversions_archive","full_table_name":"wp_conversions_archive","description":"Stores conversions archive data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INTEGER","nullable":true,"primary_key":true},{"name":"mysql_id","type":"INTEGER","nullable":true,"primary_key":false},{"name":"session_id","type":"TEXT","nullable":true,"primary_key":false},{"name":"visitor_id","type":"TEXT","nullable":true,"primary_key":false},{"name":"conversion_type","type":"TEXT","nullable":true,"primary_key":false},{"name":"conversion_label","type":"TEXT","nullable":true,"primary_key":false},{"name":"conversion_value","type":"TEXT","nullable":true,"primary_key":false},{"name":"page_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"converted_at","type":"TEXT","nullable":false,"primary_key":false},{"name":"archived_at","type":"TEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS conversions_archive ( id INTEGER PRIMARY KEY AUTOINCREMENT, mysql_id INTEGER UNIQUE, session_id TEXT, visitor_id TEXT, conversion_type TEXT, conversion_label TEXT, conversion_value TEXT, page_url TEXT, converted_at TEXT NOT NULL, archived_at TEXT NOT NULL )\");"},{"table_name":"daily_aggregates","full_table_name":"wp_daily_aggregates","description":"Stores daily aggregates data created by this plugin.","detection_method":"static","confidence":"high","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}],"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 )\");"},{"table_name":"kantan_analytics","full_table_name":"wp_kantan_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"kantan_clicks","full_table_name":"wp_kantan_clicks","description":"Stores kantan clicks data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"kantan_conversions","full_table_name":"wp_kantan_conversions","description":"Stores kantan conversions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"kantan_pageviews","full_table_name":"wp_kantan_pageviews","description":"Stores kantan pageviews data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"kantan_utm","full_table_name":"wp_kantan_utm","description":"Stores kantan utm data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"meta","full_table_name":"wp_meta","description":"Stores meta data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"value","type":"TEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS meta ( key TEXT PRIMARY KEY, value TEXT )\");"},{"table_name":"visitors","full_table_name":"wp_visitors","description":"Stores visitors data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"visitor_id","type":"TEXT","nullable":true,"primary_key":true},{"name":"first_seen","type":"TEXT","nullable":false,"primary_key":false},{"name":"last_seen","type":"TEXT","nullable":false,"primary_key":false},{"name":"session_count","type":"INTEGER","nullable":true,"primary_key":false},{"name":"pageview_count","type":"INTEGER","nullable":true,"primary_key":false},{"name":"conversion_count","type":"INTEGER","nullable":true,"primary_key":false},{"name":"first_source","type":"TEXT","nullable":true,"primary_key":false},{"name":"first_referrer","type":"TEXT","nullable":true,"primary_key":false},{"name":"first_landing_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"last_source","type":"TEXT","nullable":true,"primary_key":false},{"name":"device_category","type":"TEXT","nullable":true,"primary_key":false},{"name":"updated_at","type":"TEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS visitors ( visitor_id TEXT PRIMARY KEY, first_seen TEXT NOT NULL, last_seen TEXT NOT NULL, session_count INTEGER DEFAULT 0, pageview_count INTEGER DEFAULT 0, conversion_count INTEGER DEFAULT 0, first_source TEXT, first_referrer TEXT, first_landing_url TEXT, last_source TEXT, device_category TEXT, updated_at TEXT NOT NULL )\");"}],"table_count":9}