{"slug":"vago-analytics","name":"Vago Analytics","description":"Self-hosted store analytics — sessions, traffic, and conversion funnel — stored in its own SQLite database, not your WordPress database.","author":"Themezinho Premium WordPress Themes","active_installs":0,"version":"1.0.2","wp_org_url":"https://wordpress.org/plugins/vago-analytics/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"events","full_table_name":"wp_events","description":"Stores events data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INTEGER","nullable":true,"primary_key":true},{"name":"session_id","type":"TEXT","nullable":false,"primary_key":false},{"name":"event_type","type":"TEXT","nullable":false,"primary_key":false},{"name":"object_id","type":"INTEGER","nullable":false,"primary_key":false},{"name":"object_type","type":"TEXT","nullable":false,"primary_key":false},{"name":"meta","type":"TEXT","nullable":false,"primary_key":false},{"name":"meta_status","type":"TEXT","nullable":false,"primary_key":false},{"name":"user_id","type":"INTEGER","nullable":false,"primary_key":false},{"name":"created_at","type":"TEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS events ( id INTEGER PRIMARY KEY AUTOINCREMENT, session_id TEXT NOT NULL DEFAULT '', event_type TEXT NOT NULL DEFAULT '', object_id INTEGER NOT NULL DEFAULT 0, object_type TEXT NOT NULL DEFAULT '', meta TEXT NOT NULL DEFAULT '', meta_status TEXT NOT NULL DEFAULT '', user_id INTEGER NOT NULL DEFAULT 0, created_at TEXT NOT NULL );"},{"table_name":"sessions","full_table_name":"wp_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INTEGER","nullable":true,"primary_key":true},{"name":"session_id","type":"TEXT","nullable":false,"primary_key":false},{"name":"user_id","type":"INTEGER","nullable":false,"primary_key":false},{"name":"ip_hash","type":"TEXT","nullable":false,"primary_key":false},{"name":"country","type":"TEXT","nullable":false,"primary_key":false},{"name":"country_name","type":"TEXT","nullable":false,"primary_key":false},{"name":"city","type":"TEXT","nullable":false,"primary_key":false},{"name":"region","type":"TEXT","nullable":false,"primary_key":false},{"name":"device_type","type":"TEXT","nullable":false,"primary_key":false},{"name":"browser","type":"TEXT","nullable":false,"primary_key":false},{"name":"traffic_source","type":"TEXT","nullable":false,"primary_key":false},{"name":"traffic_detail","type":"TEXT","nullable":false,"primary_key":false},{"name":"referrer_url","type":"TEXT","nullable":false,"primary_key":false},{"name":"landing_page","type":"TEXT","nullable":false,"primary_key":false},{"name":"utm_campaign","type":"TEXT","nullable":false,"primary_key":false},{"name":"pages_viewed","type":"INTEGER","nullable":false,"primary_key":false},{"name":"email_filled","type":"INTEGER","nullable":false,"primary_key":false},{"name":"payment_method_selected","type":"TEXT","nullable":false,"primary_key":false},{"name":"funnel_stage","type":"TEXT","nullable":false,"primary_key":false},{"name":"order_id","type":"INTEGER","nullable":false,"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 sessions ( id INTEGER PRIMARY KEY AUTOINCREMENT, session_id TEXT NOT NULL DEFAULT '', user_id INTEGER NOT NULL DEFAULT 0, ip_hash TEXT NOT NULL DEFAULT '', country TEXT NOT NULL DEFAULT '', country_name TEXT NOT NULL DEFAULT '', city TEXT NOT NULL DEFAULT '', region TEXT NOT NULL DEFAULT '', device_type TEXT NOT NULL DEFAULT '', browser TEXT NOT NULL DEFAULT '', traffic_source TEXT NOT NULL DEFAULT '', traffic_detail TEXT NOT NULL DEFAULT '', referrer_url TEXT NOT NULL DEFAULT '', landing_page TEXT NOT NULL DEFAULT '', utm_campaign TEXT NOT NULL DEFAULT '', pages_viewed INTEGER NOT NULL DEFAULT 0, email_filled INTEGER NOT NULL DEFAULT 0, payment_method_selected TEXT NOT NULL DEFAULT '', funnel_stage TEXT NOT NULL DEFAULT 'visit', order_id INTEGER NOT NULL DEFAULT 0, created_at TEXT NOT NULL, updated_at TEXT NOT NULL );"},{"table_name":"vago_analytics_events","full_table_name":"wp_vago_analytics_events","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"vago_analytics_sessions","full_table_name":"wp_vago_analytics_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":4}