wp_cintel_customer_clv
StaticStores cintel customer clv data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| customer_id | BIGINT UNSIGNED | NO |
| VARCHAR(255) | YES | |
| first_order_date | DATE | YES |
| last_order_date | DATE | YES |
| total_orders | INT UNSIGNED | YES |
| total_spent | DECIMAL(15,4) | YES |
| avg_order_value | DECIMAL(15,4) | YES |
| avg_days_between_orders | DECIMAL(10,2) | YES |
| predicted_clv | DECIMAL(15,4) | YES |
| recency_score | TINYINT UNSIGNED | YES |
| frequency_score | TINYINT UNSIGNED | YES |
| monetary_score | TINYINT UNSIGNED | YES |
| rfm_segment | VARCHAR(50) | YES |
| churn_risk | VARCHAR(10) | YES |
| days_since_last_order | INT UNSIGNED | YES |
| expected_next_order_date | DATE | YES |
| acquisition_source | VARCHAR(255) | YES |
| last_calculated | DATETIME | YES |
| month_number | INT UNSIGNED | NO |
| active_customers | INT UNSIGNED | YES |
| total_revenue | DECIMAL(15,4) | YES |
| retained_pct | DECIMAL(8,4) | YES |
CREATE TABLE Statement
CREATE TABLE wp_cintel_customer_clv ( customer_id BIGINT UNSIGNED NOT NULL, email VARCHAR(255) DEFAULT '', first_order_date DATE DEFAULT NULL, last_order_date DATE DEFAULT NULL, total_orders INT UNSIGNED DEFAULT 0, total_spent DECIMAL(15,4) DEFAULT 0, avg_order_value DECIMAL(15,4) DEFAULT 0, avg_days_between_orders DECIMAL(10,2) DEFAULT 0, predicted_clv DECIMAL(15,4) DEFAULT 0, recency_score TINYINT UNSIGNED DEFAULT 0, frequency_score TINYINT UNSIGNED DEFAULT 0, monetary_score TINYINT UNSIGNED DEFAULT 0, rfm_segment VARCHAR(50) DEFAULT '', churn_risk VARCHAR(10) DEFAULT 'low', days_since_last_order INT UNSIGNED DEFAULT 0, expected_next_order_date DATE DEFAULT NULL, acquisition_source VARCHAR(255) DEFAULT '', last_calculated DATETIME DEFAULT NULL, PRIMARY KEY (customer_id), KEY idx_segment (rfm_segment), KEY idx_churn (churn_risk), KEY idx_clv (predicted_clv) ) $charset_collate; CREATE TABLE wp_cintel_customer_cohorts ( cohort_month VARCHAR(7) NOT NULL, month_number INT UNSIGNED NOT NULL, active_customers INT UNSIGNED DEFAULT 0, total_revenue DECIMAL(15,4) DEFAULT 0, retained_pct DECIMAL(8,4) DEFAULT 0, PRIMARY KEY (cohort_month, month_number) ) $charset_collate;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );
Safe to delete?
If you have uninstalled Customer Intelligence for WooCommerce, 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_cintel_customer_clv`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Customer Intelligence for WooCommerce