{"slug":"unipixel","name":"UniPixel: Meta, Pinterest, TikTok, Google & Microsoft Server-Side Tracking for WooCommerce","description":"Send conversion events from your WordPress server to Meta, Pinterest, TikTok, Google and Microsoft. No cloud, no GTM. WooCommerce and custom events.","author":"Buildio","active_installs":200,"version":"2.6.9","wp_org_url":"https://wordpress.org/plugins/unipixel/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"unipixel_conversion_groups","full_table_name":"wp_unipixel_conversion_groups","description":"Stores unipixel conversion groups data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"conceptual_event","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"event_trigger","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"trigger_target","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_unipixel_conversion_groups ( id INT NOT NULL AUTO_INCREMENT, conceptual_event VARCHAR(255) NOT NULL, description TEXT, event_trigger VARCHAR(255) NOT NULL, trigger_target VARCHAR(255) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) );"},{"table_name":"unipixel_event_log","full_table_name":"wp_unipixel_event_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"platform_id","type":"INT","nullable":true,"primary_key":false},{"name":"platform_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"element_ref","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"event_trigger","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"event_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"response_message","type":"TEXT","nullable":true,"primary_key":false},{"name":"sent_data","type":"TEXT","nullable":true,"primary_key":false},{"name":"method","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"party","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"event_order","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"log_time","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_unipixel_event_log ( id INT AUTO_INCREMENT, platform_id INT, platform_name VARCHAR(255), element_ref VARCHAR(255), event_trigger VARCHAR(255), event_name VARCHAR(255), response_message TEXT, sent_data TEXT, method VARCHAR(10), party VARCHAR(10), event_order VARCHAR(20), log_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY log_time (log_time) );"},{"table_name":"unipixel_events_settings","full_table_name":"wp_unipixel_events_settings","description":"Stores unipixel events settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"platform_id","type":"INT","nullable":true,"primary_key":false},{"name":"element_ref","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"event_trigger","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"event_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"event_description","type":"TEXT","nullable":true,"primary_key":false},{"name":"send_client","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"send_server","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"conversion_group_id","type":"INT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_unipixel_events_settings ( id INT AUTO_INCREMENT, platform_id INT, element_ref VARCHAR(255), event_trigger VARCHAR(255), event_name VARCHAR(255), event_description TEXT, send_client TINYINT(1) NOT NULL DEFAULT 1, send_server TINYINT(1) NOT NULL DEFAULT 0, conversion_group_id INT NULL DEFAULT NULL, PRIMARY KEY (id), KEY idx_conversion_group (conversion_group_id) );"},{"table_name":"unipixel_log_count","full_table_name":"wp_unipixel_log_count","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"count","type":"INT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_unipixel_log_count ( id INT AUTO_INCREMENT, count INT DEFAULT 0, PRIMARY KEY (id) );"},{"table_name":"unipixel_platform_settings","full_table_name":"wp_unipixel_platform_settings","description":"Stores unipixel platform settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":false},{"name":"platform_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"pixel_id","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"access_token","type":"VARCHAR(512)","nullable":true,"primary_key":false},{"name":"platform_enabled","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"additional_id","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"pixel_setting","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"pageview_send_serverside","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"pageview_send_clientside","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"serverside_global_enabled","type":"TINYINT(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_unipixel_platform_settings ( id INT NOT NULL, platform_name VARCHAR(255), pixel_id VARCHAR(255), access_token VARCHAR(512), platform_enabled TINYINT(1) DEFAULT 1, additional_id VARCHAR(255) DEFAULT '', pixel_setting VARCHAR(255) DEFAULT 'include', pageview_send_serverside TINYINT(1) DEFAULT 1, pageview_send_clientside TINYINT(1) DEFAULT 1, serverside_global_enabled TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (id) );"},{"table_name":"unipixel_woocomm_event_settings","full_table_name":"wp_unipixel_woocomm_event_settings","description":"Stores unipixel woocomm event settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"platform_id","type":"INT(11)","nullable":false,"primary_key":false},{"name":"event_local_ref","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"event_platform_ref","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"event_description","type":"TEXT","nullable":true,"primary_key":false},{"name":"event_enabled","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"send_server_log_response","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"send_client","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"send_server","type":"TINYINT(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_unipixel_woocomm_event_settings ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, platform_id INT(11) NOT NULL, event_local_ref VARCHAR(255) NOT NULL, event_platform_ref VARCHAR(255) NOT NULL, event_description TEXT DEFAULT NULL, event_enabled TINYINT(1) NOT NULL DEFAULT 0, send_server_log_response TINYINT(1) NOT NULL DEFAULT 0, send_client TINYINT(1) NOT NULL DEFAULT 1, send_server TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (id) );"}],"table_count":6}