wp_attentiq_daily_stats

Static

Stores analytics or statistics data.

Column Definitions

Column	Type	Nullable
post_id	BIGINT(20)	NO
views	INT	YES
time_header	FLOAT	YES
time_mid	FLOAT	YES
time_footer	FLOAT	YES
scroll_avg	FLOAT	YES
zone_times	LONGTEXT	YES
slot_view_times	LONGTEXT	YES
paragraph_times	LONGTEXT	YES
skim_times	LONGTEXT	YES
paragraph_times_mobile	LONGTEXT	YES
paragraph_times_desktop	LONGTEXT	YES
skim_times_mobile	LONGTEXT	YES
paragraph_count	SMALLINT UNSIGNED	YES
views_mobile	INT	YES
views_desktop	INT	YES
updated_at	DATETIME	YES
created_at	DATETIME	YES
post_id	BIGINT UNSIGNED	NO
stat_date	DATE	NO
device	VARCHAR(10)	NO
bounces	INT UNSIGNED	YES
header_time	FLOAT	YES
mid_time	FLOAT	YES
footer_time	FLOAT	YES
avg_scroll_depth	FLOAT	YES
slot_view_in_content	FLOAT	YES
slot_view_footer	FLOAT	YES
post_id	BIGINT UNSIGNED	NO
stat_date	DATE	NO
stat_hour	TINYINT UNSIGNED	NO
device	VARCHAR(10)	NO
views	INT UNSIGNED	YES
total_time	FLOAT	YES
avg_scroll	FLOAT	YES

CREATE TABLE Statement

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 );

Safe to delete?

If you have uninstalled AttentIQ, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_attentiq_daily_stats`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from AttentIQ

wp_attentiq_attention wp_attentiq_hourly_stats