{"slug":"formvela-form-abandonment-analytics","name":"FormVela – Form Abandonment Analytics","description":"Find where visitors leave your forms. Track views, starts, submissions, field drop-off, errors and time without saving entered values.","author":"tahmir","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/formvela-form-abandonment-analytics/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"faan_fields","full_table_name":"wp_faan_fields","description":"Stores faan fields data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"session_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"field_key","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"label","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"field_type","type":"varchar(24)","nullable":false,"primary_key":false},{"name":"position","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"step","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"reached","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"completed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"errors","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"focus_count","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"time_ms","type":"int(10) unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_faan_fields ( session_id varchar(32) NOT NULL, field_key varchar(40) NOT NULL, label varchar(100) NOT NULL, field_type varchar(24) NOT NULL, position smallint(5) unsigned NOT NULL DEFAULT 0, step smallint(5) unsigned NOT NULL DEFAULT 1, reached tinyint(1) NOT NULL DEFAULT 0, completed tinyint(1) NOT NULL DEFAULT 0, errors smallint(5) unsigned NOT NULL DEFAULT 0, focus_count smallint(5) unsigned NOT NULL DEFAULT 0, time_ms int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (session_id,field_key) ) $charset;\" );"},{"table_name":"faan_forms","full_table_name":"wp_faan_forms","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"form_key","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"page_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"builder","type":"varchar(24)","nullable":false,"primary_key":false},{"name":"title","type":"varchar(160)","nullable":false,"primary_key":false},{"name":"last_seen","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_faan_forms ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, form_key varchar(64) NOT NULL, page_id bigint(20) unsigned NOT NULL DEFAULT 0, builder varchar(24) NOT NULL, title varchar(160) NOT NULL, last_seen datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY form_key (form_key) ) $charset;\" );"},{"table_name":"faan_sessions","full_table_name":"wp_faan_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"form_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"device","type":"varchar(8)","nullable":false,"primary_key":false},{"name":"started","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"attempted","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"submitted","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"last_field","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"steps","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"duration","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"sequence","type":"int(10) unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_faan_sessions ( id varchar(32) NOT NULL, form_id bigint(20) unsigned NOT NULL, created_at datetime NOT NULL, updated_at datetime NOT NULL, device varchar(8) NOT NULL, started tinyint(1) NOT NULL DEFAULT 0, attempted tinyint(1) NOT NULL DEFAULT 0, submitted tinyint(1) NOT NULL DEFAULT 0, last_field varchar(40) NOT NULL DEFAULT '', steps smallint(5) unsigned NOT NULL DEFAULT 0, duration int(10) unsigned NOT NULL DEFAULT 0, sequence int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY form_date (form_id,created_at), KEY created_at (created_at), KEY updated_at (updated_at) ) $charset;\" );"}],"table_count":3}