{"table_name":"fct_retention_snapshots","full_table_name":"wp_fct_retention_snapshots","description":"Stores fct retention snapshots data created by this plugin.","detection_method":"live","confidence":"high","create_sql":"CREATE TABLE `wp_fct_retention_snapshots` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `cohort` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'YYYY-MM format, when customer first subscribed',\\n  `period` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'YYYY-MM format, the month being measured',\\n  `product_id` bigint unsigned DEFAULT NULL COMMENT 'NULL means all products combined',\\n  `cohort_customers` int unsigned NOT NULL DEFAULT '0',\\n  `cohort_mrr` bigint unsigned NOT NULL DEFAULT '0',\\n  `retained_customers` int unsigned NOT NULL DEFAULT '0',\\n  `retained_mrr` bigint unsigned NOT NULL DEFAULT '0',\\n  `new_customers` int unsigned NOT NULL DEFAULT '0' COMMENT 'Recyclers who came back this period',\\n  `churned_customers` int unsigned NOT NULL DEFAULT '0' COMMENT 'Left this period',\\n  `retention_rate_customers` decimal(5,2) DEFAULT NULL,\\n  `retention_rate_mrr` decimal(5,2) DEFAULT NULL,\\n  `period_offset` int unsigned NOT NULL DEFAULT '0',\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `wp_fct_rs_cohort_period_product_idx` (`cohort`,`period`,`product_id`),\\n  KEY `wp_fct_rs_cohort_idx` (`cohort`),\\n  KEY `wp_fct_rs_period_idx` (`period`),\\n  KEY `wp_fct_rs_product_idx` (`product_id`),\\n  KEY `wp_fct_rs_offset_idx` (`period_offset`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci","columns":[{"name":"when","type":"customer","nullable":true,"primary_key":false},{"name":"the","type":"month","nullable":true,"primary_key":false}],"plugin":{"slug":"fluent-cart","name":"FluentCart A New Era of eCommerce – Faster, Lighter, and Simpler","active_installs":5000,"version":"1.3.18","wp_org_url":"https://wordpress.org/plugins/fluent-cart/"}}