{"table_name":"freshrank_analytics","full_table_name":"wp_freshrank_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","create_sql":"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","columns":[],"plugin":{"slug":"freshrank-ai","name":"FreshRank – Instant Feedback for Better Content","active_installs":10,"version":"1.0.3","wp_org_url":"https://wordpress.org/plugins/freshrank-ai/"}}