{"slug":"freshrank-ai","name":"FreshRank – Instant Feedback for Better Content","description":"AI-powered content analysis for SEO & GEO optimization. Analyze your content for search engines AND AI platforms like ChatGPT and Claude.","author":"Themeisle","active_installs":10,"version":"1.0.3","wp_org_url":"https://wordpress.org/plugins/freshrank-ai/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"actionscheduler_actions","full_table_name":"wp_actionscheduler_actions","description":"Stores actionscheduler actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_actions` (\\n  `action_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `hook` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `scheduled_date_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  `scheduled_date_local` datetime DEFAULT '0000-00-00 00:00:00',\\n  `priority` tinyint unsigned NOT NULL DEFAULT '10',\\n  `args` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `schedule` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `group_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `attempts` int NOT NULL DEFAULT '0',\\n  `last_attempt_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  `last_attempt_local` datetime DEFAULT '0000-00-00 00:00:00',\\n  `claim_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `extended_args` varchar(8000) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  PRIMARY KEY (`action_id`),\\n  KEY `hook_status_scheduled_date_gmt` (`hook`(163),`status`,`scheduled_date_gmt`),\\n  KEY `status_scheduled_date_gmt` (`status`,`scheduled_date_gmt`),\\n  KEY `scheduled_date_gmt` (`scheduled_date_gmt`),\\n  KEY `args` (`args`),\\n  KEY `group_id` (`group_id`),\\n  KEY `last_attempt_gmt` (`last_attempt_gmt`),\\n  KEY `claim_id_status_priority_scheduled_date_gmt` (`claim_id`,`status`,`priority`,`scheduled_date_gmt`),\\n  KEY `status_last_attempt_gmt` (`status`,`last_attempt_gmt`),\\n  KEY `status_claim_id` (`status`,`claim_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actionscheduler_claims","full_table_name":"wp_actionscheduler_claims","description":"Stores actionscheduler claims data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_claims` (\\n  `claim_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `date_created_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  PRIMARY KEY (`claim_id`),\\n  KEY `date_created_gmt` (`date_created_gmt`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actionscheduler_groups","full_table_name":"wp_actionscheduler_groups","description":"Stores actionscheduler groups data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_groups` (\\n  `group_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `slug` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`group_id`),\\n  KEY `slug` (`slug`(191))\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actionscheduler_logs","full_table_name":"wp_actionscheduler_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_logs` (\\n  `log_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `action_id` bigint unsigned NOT NULL,\\n  `message` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `log_date_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  `log_date_local` datetime DEFAULT '0000-00-00 00:00:00',\\n  PRIMARY KEY (`log_id`),\\n  KEY `action_id` (`action_id`),\\n  KEY `log_date_gmt` (`log_date_gmt`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"freshrank_analysis","full_table_name":"wp_freshrank_analysis","description":"Stores freshrank analysis data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_freshrank_analysis` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `post_id` bigint unsigned NOT NULL,\\n  `analysis_data` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `issues_count` int DEFAULT '0',\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending',\\n  `error_message` text COLLATE utf8mb4_unicode_520_ci,\\n  `processing_time` decimal(8,2) DEFAULT NULL,\\n  `tokens_used` int DEFAULT '0',\\n  `prompt_tokens` int DEFAULT '0',\\n  `completion_tokens` int DEFAULT '0',\\n  `model_used` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `dismissed_items` text COLLATE utf8mb4_unicode_520_ci COMMENT 'JSON array of dismissed issue identifiers',\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  KEY `post_id` (`post_id`),\\n  KEY `status` (`status`),\\n  KEY `created_at` (`created_at`),\\n  KEY `post_status_date` (`post_id`,`status`,`created_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"freshrank_analytics","full_table_name":"wp_freshrank_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"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"},{"table_name":"freshrank_articles","full_table_name":"wp_freshrank_articles","description":"Stores freshrank articles data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_freshrank_articles` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `post_id` bigint unsigned NOT NULL,\\n  `priority_score` decimal(10,2) DEFAULT '0.00',\\n  `display_order` int DEFAULT '0',\\n  `ctr_current` decimal(5,4) DEFAULT '0.0000',\\n  `ctr_previous` decimal(5,4) DEFAULT '0.0000',\\n  `ctr_decline` decimal(5,4) DEFAULT '0.0000',\\n  `position_current` decimal(5,2) DEFAULT '0.00',\\n  `position_previous` decimal(5,2) DEFAULT '0.00',\\n  `position_drop` decimal(5,2) DEFAULT '0.00',\\n  `impressions_current` bigint DEFAULT '0',\\n  `impressions_previous` bigint DEFAULT '0',\\n  `clicks_current` bigint DEFAULT '0',\\n  `clicks_previous` bigint DEFAULT '0',\\n  `traffic_potential` decimal(10,2) DEFAULT '0.00',\\n  `content_age_score` decimal(5,2) DEFAULT '0.00',\\n  `last_gsc_update` datetime DEFAULT NULL,\\n  `analysis_status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending',\\n  `draft_status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending',\\n  `custom_order` int DEFAULT '0',\\n  `excluded` tinyint(1) DEFAULT '0',\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `post_id` (`post_id`),\\n  KEY `priority_score` (`priority_score`),\\n  KEY `display_order` (`display_order`),\\n  KEY `analysis_status` (`analysis_status`),\\n  KEY `draft_status` (`draft_status`),\\n  KEY `custom_order` (`custom_order`),\\n  KEY `status_priority` (`analysis_status`,`priority_score`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"freshrank_drafts","full_table_name":"wp_freshrank_drafts","description":"Stores freshrank drafts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_freshrank_drafts` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `original_post_id` bigint unsigned NOT NULL,\\n  `draft_post_id` bigint unsigned NOT NULL,\\n  `analysis_id` bigint unsigned DEFAULT NULL,\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending',\\n  `tokens_used` int DEFAULT '0',\\n  `prompt_tokens` int DEFAULT '0',\\n  `completion_tokens` int DEFAULT '0',\\n  `model_used` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `draft_post_id` (`draft_post_id`),\\n  KEY `original_post_id` (`original_post_id`),\\n  KEY `status` (`status`),\\n  KEY `analysis_id` (`analysis_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":8}