{"slug":"linesw-search-rank-monitor","name":"LineSW Search Rank Monitor","description":"SEO dashboard for WordPress with keyword suggestions, Site Crawl, Search Console CSV import, reports and optional API-based rank tracking.","author":"Linesw","active_installs":0,"version":"0.22.10","wp_org_url":"https://wordpress.org/plugins/linesw-search-rank-monitor/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"cirm_alerts","full_table_name":"wp_cirm_alerts","description":"Stores cirm alerts data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"engine","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"alert_type","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"message","type":"TEXT","nullable":false,"primary_key":false},{"name":"old_position","type":"INT","nullable":true,"primary_key":false},{"name":"new_position","type":"INT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_alerts ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, keyword_id BIGINT UNSIGNED NULL, engine VARCHAR(30) NOT NULL DEFAULT '', alert_type VARCHAR(40) NOT NULL DEFAULT '', message TEXT NOT NULL, old_position INT NULL, new_position INT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY created_at (created_at) ) {$charset};\");"},{"table_name":"cirm_competitors","full_table_name":"wp_cirm_competitors","description":"Stores cirm competitors data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"engine","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"device","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"domain","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"title","type":"TEXT","nullable":true,"primary_key":false},{"name":"url","type":"TEXT","nullable":true,"primary_key":false},{"name":"position","type":"INT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_competitors ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, keyword_id BIGINT UNSIGNED NOT NULL, engine VARCHAR(30) NOT NULL, device VARCHAR(20) NOT NULL DEFAULT 'desktop', domain VARCHAR(255) NOT NULL, title TEXT NULL, url TEXT NULL, position INT NOT NULL DEFAULT 0, checked_at DATETIME NOT NULL, PRIMARY KEY (id), KEY keyword_engine_date (keyword_id, engine, device, checked_at) ) {$charset};\");"},{"table_name":"cirm_diary","full_table_name":"wp_cirm_diary","description":"Stores cirm diary data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"entry_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"title","type":"TEXT","nullable":false,"primary_key":false},{"name":"note","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"target_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"entry_type","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"impact","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_diary ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, entry_date DATETIME NOT NULL, title TEXT NOT NULL, note LONGTEXT NULL, target_url TEXT NULL, entry_type VARCHAR(40) NOT NULL DEFAULT 'note', impact VARCHAR(20) NOT NULL DEFAULT 'neutral', created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY entry_date (entry_date), KEY entry_type (entry_type) ) {$charset};\");"},{"table_name":"cirm_gsc","full_table_name":"wp_cirm_gsc","description":"Stores cirm gsc data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"query_text","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"page_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"clicks","type":"INT","nullable":false,"primary_key":false},{"name":"impressions","type":"INT","nullable":false,"primary_key":false},{"name":"ctr","type":"FLOAT","nullable":false,"primary_key":false},{"name":"position_avg","type":"FLOAT","nullable":false,"primary_key":false},{"name":"data_date","type":"DATE","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_gsc ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, query_text VARCHAR(255) NOT NULL, page_url TEXT NULL, clicks INT NOT NULL DEFAULT 0, impressions INT NOT NULL DEFAULT 0, ctr FLOAT NOT NULL DEFAULT 0, position_avg FLOAT NOT NULL DEFAULT 0, data_date DATE NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY query_text (query_text), KEY data_date (data_date) ) {$charset};\");"},{"table_name":"cirm_keywords","full_table_name":"wp_cirm_keywords","description":"Stores cirm keywords data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"target_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"group_name","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"tags","type":"TEXT","nullable":true,"primary_key":false},{"name":"priority","type":"INT","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(60)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_keywords ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, keyword VARCHAR(255) NOT NULL, target_url TEXT NULL, group_name VARCHAR(120) NOT NULL DEFAULT '', tags TEXT NULL, priority INT NOT NULL DEFAULT 50, source VARCHAR(60) NOT NULL DEFAULT 'manual', status VARCHAR(20) NOT NULL DEFAULT 'active', created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY keyword (keyword) ) {$charset};\");"},{"table_name":"cirm_link_checks","full_table_name":"wp_cirm_link_checks","description":"Stores cirm link checks data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"source_url","type":"TEXT","nullable":false,"primary_key":false},{"name":"target_url","type":"TEXT","nullable":false,"primary_key":false},{"name":"anchor_text","type":"TEXT","nullable":true,"primary_key":false},{"name":"http_status","type":"INT","nullable":true,"primary_key":false},{"name":"link_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_link_checks ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, source_url TEXT NOT NULL, target_url TEXT NOT NULL, anchor_text TEXT NULL, http_status INT NULL, link_type VARCHAR(20) NOT NULL DEFAULT 'internal', status VARCHAR(20) NOT NULL DEFAULT 'open', checked_at DATETIME NOT NULL, PRIMARY KEY (id), KEY http_status (http_status), KEY status (status) ) {$charset};\");"},{"table_name":"cirm_pagespeed","full_table_name":"wp_cirm_pagespeed","description":"Stores cirm pagespeed data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"url","type":"TEXT","nullable":false,"primary_key":false},{"name":"strategy","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"performance_score","type":"INT","nullable":true,"primary_key":false},{"name":"lcp","type":"FLOAT","nullable":true,"primary_key":false},{"name":"cls","type":"FLOAT","nullable":true,"primary_key":false},{"name":"inp","type":"FLOAT","nullable":true,"primary_key":false},{"name":"fcp","type":"FLOAT","nullable":true,"primary_key":false},{"name":"ttfb","type":"FLOAT","nullable":true,"primary_key":false},{"name":"opportunities","type":"LONGTEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_pagespeed ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, url TEXT NOT NULL, strategy VARCHAR(20) NOT NULL DEFAULT 'mobile', performance_score INT NULL, lcp FLOAT NULL, cls FLOAT NULL, inp FLOAT NULL, fcp FLOAT NULL, ttfb FLOAT NULL, opportunities LONGTEXT NULL, checked_at DATETIME NOT NULL, PRIMARY KEY (id), KEY strategy (strategy), KEY checked_at (checked_at) ) {$charset};\");"},{"table_name":"cirm_rankings","full_table_name":"wp_cirm_rankings","description":"Stores cirm rankings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"engine","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"device","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"position","type":"INT","nullable":true,"primary_key":false},{"name":"found_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"result_title","type":"TEXT","nullable":true,"primary_key":false},{"name":"serp_features","type":"LONGTEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_rankings ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, keyword_id BIGINT UNSIGNED NOT NULL, engine VARCHAR(30) NOT NULL, device VARCHAR(20) NOT NULL DEFAULT 'desktop', position INT NULL, found_url TEXT NULL, result_title TEXT NULL, serp_features LONGTEXT NULL, checked_at DATETIME NOT NULL, PRIMARY KEY (id), KEY keyword_engine_date (keyword_id, engine, device, checked_at) ) {$charset};\");"},{"table_name":"cirm_seo_audits","full_table_name":"wp_cirm_seo_audits","description":"Stores cirm seo audits data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"post_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"url","type":"TEXT","nullable":false,"primary_key":false},{"name":"title_text","type":"TEXT","nullable":true,"primary_key":false},{"name":"meta_description","type":"TEXT","nullable":true,"primary_key":false},{"name":"h1_count","type":"INT","nullable":false,"primary_key":false},{"name":"word_count","type":"INT","nullable":false,"primary_key":false},{"name":"image_missing_alt","type":"INT","nullable":false,"primary_key":false},{"name":"internal_links","type":"INT","nullable":false,"primary_key":false},{"name":"external_links","type":"INT","nullable":false,"primary_key":false},{"name":"schema_found","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"score","type":"INT","nullable":false,"primary_key":false},{"name":"findings","type":"LONGTEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_seo_audits ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, post_id BIGINT UNSIGNED NULL, url TEXT NOT NULL, title_text TEXT NULL, meta_description TEXT NULL, h1_count INT NOT NULL DEFAULT 0, word_count INT NOT NULL DEFAULT 0, image_missing_alt INT NOT NULL DEFAULT 0, internal_links INT NOT NULL DEFAULT 0, external_links INT NOT NULL DEFAULT 0, schema_found TINYINT(1) NOT NULL DEFAULT 0, score INT NOT NULL DEFAULT 0, findings LONGTEXT NULL, checked_at DATETIME NOT NULL, PRIMARY KEY (id), KEY post_id (post_id), KEY checked_at (checked_at) ) {$charset};\");"},{"table_name":"cirm_seo_tasks","full_table_name":"wp_cirm_seo_tasks","description":"Stores cirm seo tasks data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"task_type","type":"VARCHAR(60)","nullable":false,"primary_key":false},{"name":"title","type":"TEXT","nullable":false,"primary_key":false},{"name":"description","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"target_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"intent","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"priority_score","type":"INT","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_seo_tasks ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, keyword_id BIGINT UNSIGNED NULL, task_type VARCHAR(60) NOT NULL, title TEXT NOT NULL, description LONGTEXT NULL, target_url TEXT NULL, intent VARCHAR(40) NOT NULL DEFAULT 'general', priority_score INT NOT NULL DEFAULT 50, status VARCHAR(20) NOT NULL DEFAULT 'open', created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), KEY status (status), KEY task_type (task_type) ) {$charset};\");"},{"table_name":"cirm_shared_reports","full_table_name":"wp_cirm_shared_reports","description":"Stores cirm shared reports data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"token","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(190)","nullable":false,"primary_key":false},{"name":"is_active","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_shared_reports ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, token VARCHAR(80) NOT NULL, title VARCHAR(190) NOT NULL DEFAULT '', is_active TINYINT(1) NOT NULL DEFAULT 1, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY token (token), KEY is_active (is_active) ) {$charset};\");"},{"table_name":"cirm_site_crawl","full_table_name":"wp_cirm_site_crawl","description":"Stores cirm site crawl data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"crawl_id","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"url","type":"TEXT","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"http_status","type":"INT","nullable":true,"primary_key":false},{"name":"final_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"redirect_count","type":"INT","nullable":false,"primary_key":false},{"name":"title_text","type":"TEXT","nullable":true,"primary_key":false},{"name":"title_length","type":"INT","nullable":false,"primary_key":false},{"name":"meta_description","type":"TEXT","nullable":true,"primary_key":false},{"name":"meta_description_length","type":"INT","nullable":false,"primary_key":false},{"name":"h1_count","type":"INT","nullable":false,"primary_key":false},{"name":"h1_text","type":"TEXT","nullable":true,"primary_key":false},{"name":"canonical_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"noindex","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"word_count","type":"INT","nullable":false,"primary_key":false},{"name":"image_count","type":"INT","nullable":false,"primary_key":false},{"name":"image_missing_alt","type":"INT","nullable":false,"primary_key":false},{"name":"internal_links","type":"INT","nullable":false,"primary_key":false},{"name":"external_links","type":"INT","nullable":false,"primary_key":false},{"name":"issue_count","type":"INT","nullable":false,"primary_key":false},{"name":"issues","type":"LONGTEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_site_crawl ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, crawl_id VARCHAR(40) NOT NULL DEFAULT '', url TEXT NOT NULL, source VARCHAR(40) NOT NULL DEFAULT 'manual', http_status INT NULL, final_url TEXT NULL, redirect_count INT NOT NULL DEFAULT 0, title_text TEXT NULL, title_length INT NOT NULL DEFAULT 0, meta_description TEXT NULL, meta_description_length INT NOT NULL DEFAULT 0, h1_count INT NOT NULL DEFAULT 0, h1_text TEXT NULL, canonical_url TEXT NULL, noindex TINYINT(1) NOT NULL DEFAULT 0, word_count INT NOT NULL DEFAULT 0, image_count INT NOT NULL DEFAULT 0, image_missing_alt INT NOT NULL DEFAULT 0, internal_links INT NOT NULL DEFAULT 0, external_links INT NOT NULL DEFAULT 0, issue_count INT NOT NULL DEFAULT 0, issues LONGTEXT NULL, checked_at DATETIME NOT NULL, PRIMARY KEY (id), KEY crawl_id (crawl_id), KEY http_status (http_status), KEY issue_count (issue_count), KEY checked_at (checked_at) ) {$charset};\");"},{"table_name":"cirm_suggestions","full_table_name":"wp_cirm_suggestions","description":"Stores cirm suggestions data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"target_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"score","type":"INT","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_suggestions ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, keyword VARCHAR(255) NOT NULL, target_url TEXT NULL, score INT NOT NULL DEFAULT 0, source VARCHAR(80) NOT NULL DEFAULT '', status VARCHAR(20) NOT NULL DEFAULT 'new', created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), KEY status (status) ) {$charset};\");"},{"table_name":"cirm_technical_checks","full_table_name":"wp_cirm_technical_checks","description":"Stores cirm technical checks data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"url","type":"TEXT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"details","type":"LONGTEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_technical_checks ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, check_type VARCHAR(60) NOT NULL, url TEXT NULL, status VARCHAR(30) NOT NULL DEFAULT 'info', details LONGTEXT NULL, checked_at DATETIME NOT NULL, PRIMARY KEY (id), KEY check_type (check_type), KEY status (status), KEY checked_at (checked_at) ) {$charset};\");"},{"table_name":"cirm_traffic_daily","full_table_name":"wp_cirm_traffic_daily","description":"Stores cirm traffic daily data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"data_date","type":"DATE","nullable":false,"primary_key":false},{"name":"landing_path","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"referrer_host","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"views","type":"INT","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cirm_traffic_daily ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, data_date DATE NOT NULL, landing_path VARCHAR(255) NOT NULL DEFAULT '', referrer_host VARCHAR(255) NOT NULL DEFAULT '', source VARCHAR(40) NOT NULL DEFAULT 'direct', views INT NOT NULL DEFAULT 0, updated_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY rollup (data_date, landing_path(120), referrer_host(120), source), KEY data_date (data_date), KEY source (source) ) {$charset};\");"}],"table_count":15}