{"slug":"kantan-analytics","name":"Kantan Analytics – Cookieless Self-Hosted Analytics & Heatmaps","description":"Cookieless, self-hosted WordPress analytics with heatmaps, scroll depth, user journeys and conversions. A private Google Analytics alternative.","author":"Try Kantan","active_installs":20,"version":"2.36.0","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":"source_email","type":"INTEGER","nullable":true,"primary_key":false},{"name":"source_paid","type":"INTEGER","nullable":true,"primary_key":false},{"name":"source_campaign","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, source_email INTEGER DEFAULT 0, source_paid INTEGER DEFAULT 0, source_campaign 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_404s","full_table_name":"wp_kantan_404s","description":"Stores kantan 404s data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"kantan_aeo_results","full_table_name":"wp_kantan_aeo_results","description":"Stores kantan aeo results data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"kantan_analytics","full_table_name":"wp_kantan_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","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_crawler_hits","full_table_name":"wp_kantan_crawler_hits","description":"Stores kantan crawler hits 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":"kantan_video_engagement","full_table_name":"wp_kantan_video_engagement","description":"Stores kantan video engagement data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"kantan_video_events","full_table_name":"wp_kantan_video_events","description":"Stores kantan video events data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"kantan_videos","full_table_name":"wp_kantan_videos","description":"Stores kantan videos 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":15}