{"slug":"poptics","name":"Poptics – Popup Builder, Email Opt-ins, Exit-Intent & WooCommerce Popups Sales","description":"Create high-converting popups, email opt-ins, exit-intent popups & WooCommerce popups to boost leads, subscribers and sales.","author":"Aethonic","active_installs":2000,"version":"1.0.22","wp_org_url":"https://wordpress.org/plugins/poptics/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"campaign_visited_from_ip","full_table_name":"wp_campaign_visited_from_ip","description":"Stores campaign visited from ip data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"campaign_id","type":"bigint(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"ip_address","type":"varchar(150)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_campaign_visited_from_ip` ( `id` int(11) NOT NULL AUTO_INCREMENT, `campaign_id` bigint(20) UNSIGNED DEFAULT NULL, `ip_address` varchar(150) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"poptics_analytics","full_table_name":"wp_poptics_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"campaign_id","type":"bigint(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"views","type":"int(11)","nullable":true,"primary_key":false},{"name":"visitors","type":"int(11)","nullable":true,"primary_key":false},{"name":"conversions","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_poptics_analytics` ( `id` int(11) NOT NULL AUTO_INCREMENT, `campaign_id` bigint(20) UNSIGNED DEFAULT NULL, `date` date DEFAULT NULL, `views` int(11) DEFAULT 0, `visitors` int(11) DEFAULT 0, `conversions` int(11) DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"poptics_analytics_meta","full_table_name":"wp_poptics_analytics_meta","description":"Stores additional metadata (key-value pairs) for poptics analytics records.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"analytics_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"campaign_id","type":"bigint(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"meta_key","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"meta_value","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_poptics_analytics_meta` ( `id` int(11) NOT NULL AUTO_INCREMENT, `analytics_id` int(11) DEFAULT NULL, `campaign_id` bigint(20) UNSIGNED DEFAULT NULL, `date` date DEFAULT NULL, `meta_key` varchar(150) DEFAULT NULL, `meta_value` text DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK_wp_poptics_analytics_with_meta` (`analytics_id`), KEY `campaign_id` (`campaign_id`), KEY `date` (`date`), KEY `meta_key` (`meta_key`) ) ENGINE"},{"table_name":"poptics_submissions","full_table_name":"wp_poptics_submissions","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"campaign_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"browser","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"device","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"location","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"date","type":"timestamp","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_poptics_submissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `campaign_id` bigint(20) DEFAULT NULL, `email` varchar(150) DEFAULT NULL, `browser` varchar(150) DEFAULT NULL, `device` varchar(150) DEFAULT NULL, `location` varchar(150) DEFAULT NULL, `status` varchar(150) DEFAULT 'active', `date` timestamp NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"poptics_submissions_meta","full_table_name":"wp_poptics_submissions_meta","description":"Stores additional metadata (key-value pairs) for poptics submissions records.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"submission_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"meta_key","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_poptics_submissions_meta` ( `id` int(11) NOT NULL AUTO_INCREMENT, `submission_id` int(11) DEFAULT NULL, `meta_key` varchar(150) DEFAULT NULL, `meta_value` longtext DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK_wp_poptics_submissions_with_meta` (`submission_id`) ) ENGINE"}],"table_count":5}