🗄️What WP Table Is This?
Home / FreshRank – Instant Feedback for Better Content / wp_freshrank_analytics

wp_freshrank_analytics

Static

Stores analytics or statistics data.

CREATE TABLE Statement

CREATE TABLE `wp_freshrank_analytics` (\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n  `post_id` bigint unsigned NOT NULL,\n  `update_date` datetime NOT NULL,\n  `snapshot_date` datetime NOT NULL,\n  `snapshot_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `clicks` int DEFAULT '0',\n  `impressions` int DEFAULT '0',\n  `ctr` decimal(5,4) DEFAULT '0.0000',\n  `position` decimal(5,2) DEFAULT '0.00',\n  `top_queries` longtext COLLATE utf8mb4_unicode_520_ci,\n  `measurement_period_start` datetime DEFAULT NULL,\n  `measurement_period_end` datetime DEFAULT NULL,\n  `days_since_update` int DEFAULT '0',\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\n  PRIMARY KEY (`id`),\n  KEY `post_id` (`post_id`),\n  KEY `update_date` (`update_date`),\n  KEY `snapshot_type` (`snapshot_type`),\n  KEY `snapshot_date` (`snapshot_date`),\n  KEY `composite_lookup` (`post_id`,`snapshot_type`,`snapshot_date`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

Safe to delete?

If you have uninstalled FreshRank – Instant Feedback for Better Content, 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_freshrank_analytics`;

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

Other tables from FreshRank – Instant Feedback for Better Content