{"slug":"attentiq","name":"AttentIQ","description":"See where attention goes. Monetize what matters.","author":"Mus Code","active_installs":0,"version":"1.2.3","wp_org_url":"https://wordpress.org/plugins/attentiq/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"attentiq_attention","full_table_name":"wp_attentiq_attention","description":"Stores attentiq attention data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"attentiq_daily_stats","full_table_name":"wp_attentiq_daily_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"post_id","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"views","type":"INT","nullable":true,"primary_key":false},{"name":"time_header","type":"FLOAT","nullable":true,"primary_key":false},{"name":"time_mid","type":"FLOAT","nullable":true,"primary_key":false},{"name":"time_footer","type":"FLOAT","nullable":true,"primary_key":false},{"name":"scroll_avg","type":"FLOAT","nullable":true,"primary_key":false},{"name":"zone_times","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"slot_view_times","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"paragraph_times","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"skim_times","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"paragraph_times_mobile","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"paragraph_times_desktop","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"skim_times_mobile","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"paragraph_count","type":"SMALLINT UNSIGNED","nullable":true,"primary_key":false},{"name":"views_mobile","type":"INT","nullable":true,"primary_key":false},{"name":"views_desktop","type":"INT","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"stat_date","type":"DATE","nullable":false,"primary_key":false},{"name":"device","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"bounces","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"header_time","type":"FLOAT","nullable":true,"primary_key":false},{"name":"mid_time","type":"FLOAT","nullable":true,"primary_key":false},{"name":"footer_time","type":"FLOAT","nullable":true,"primary_key":false},{"name":"avg_scroll_depth","type":"FLOAT","nullable":true,"primary_key":false},{"name":"slot_view_in_content","type":"FLOAT","nullable":true,"primary_key":false},{"name":"slot_view_footer","type":"FLOAT","nullable":true,"primary_key":false},{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"stat_date","type":"DATE","nullable":false,"primary_key":false},{"name":"stat_hour","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"device","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"views","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"total_time","type":"FLOAT","nullable":true,"primary_key":false},{"name":"avg_scroll","type":"FLOAT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE $table ( post_id BIGINT(20) NOT NULL, views INT DEFAULT 0, time_header FLOAT DEFAULT 0, time_mid FLOAT DEFAULT 0, time_footer FLOAT DEFAULT 0, scroll_avg FLOAT DEFAULT 0, zone_times LONGTEXT DEFAULT NULL, slot_view_times LONGTEXT DEFAULT NULL, paragraph_times LONGTEXT DEFAULT NULL, skim_times LONGTEXT DEFAULT NULL, paragraph_times_mobile LONGTEXT DEFAULT NULL, paragraph_times_desktop LONGTEXT DEFAULT NULL, skim_times_mobile LONGTEXT DEFAULT NULL, paragraph_count SMALLINT UNSIGNED DEFAULT 0, views_mobile INT DEFAULT 0, views_desktop INT DEFAULT 0, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP, created_at DATETIME DEFAULT NULL, PRIMARY KEY (post_id) ) $charset_collate;\"; $sql2 = \"CREATE TABLE IF NOT EXISTS wp_attentiq_daily_stats ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, post_id BIGINT UNSIGNED NOT NULL, stat_date DATE NOT NULL, device VARCHAR(10) NOT NULL DEFAULT 'all', -- Views & engagement views INT UNSIGNED DEFAULT 0, bounces INT UNSIGNED DEFAULT 0, -- Time total_time FLOAT DEFAULT 0, header_time FLOAT DEFAULT 0, mid_time FLOAT DEFAULT 0, footer_time FLOAT DEFAULT 0, avg_scroll_depth FLOAT DEFAULT 0, -- Ad slot viewability slot_view_header FLOAT DEFAULT 0, slot_view_in_content FLOAT DEFAULT 0, slot_view_footer FLOAT DEFAULT 0, -- Paragraph hotspot top_paragraph INT UNSIGNED DEFAULT 0, -- Skim vs read total_skim_time FLOAT DEFAULT 0, UNIQUE KEY post_date_device (post_id, stat_date, device), KEY idx_post_id (post_id), KEY idx_stat_date (stat_date), KEY idx_device (device) ) $charset;\"; $sql3 = \"CREATE TABLE IF NOT EXISTS wp_attentiq_hourly_stats ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, post_id BIGINT UNSIGNED NOT NULL, stat_date DATE NOT NULL, stat_hour TINYINT UNSIGNED NOT NULL, device VARCHAR(10) NOT NULL DEFAULT 'all', views INT UNSIGNED DEFAULT 0, unique_views INT UNSIGNED DEFAULT 0, total_time FLOAT DEFAULT 0, avg_scroll FLOAT DEFAULT 0, UNIQUE KEY post_date_hour_device (post_id, stat_date, stat_hour, device), KEY idx_stat_date (stat_date) ) $charset\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql1 );"},{"table_name":"attentiq_hourly_stats","full_table_name":"wp_attentiq_hourly_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":true},{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"stat_date","type":"DATE","nullable":false,"primary_key":false},{"name":"stat_hour","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"device","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"views","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"total_time","type":"FLOAT","nullable":true,"primary_key":false},{"name":"avg_scroll","type":"FLOAT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_attentiq_hourly_stats` ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, post_id BIGINT UNSIGNED NOT NULL, stat_date DATE NOT NULL, stat_hour TINYINT UNSIGNED NOT NULL, device VARCHAR(10) NOT NULL DEFAULT 'all', views INT UNSIGNED DEFAULT 0, unique_views INT UNSIGNED DEFAULT 0, total_time FLOAT DEFAULT 0, avg_scroll FLOAT DEFAULT 0, UNIQUE KEY post_date_hour_device (post_id, stat_date, stat_hour, device), KEY idx_stat_date (stat_date) ) {$charset}\" );"}],"table_count":3}