{"slug":"layersync-conversion-tracking","name":"LayerSync – Conversion Tracking, Pixel Manager, and Server-Side API","description":"Conversion tracking for online stores. Pixel injection plus server-side Conversion API delivery, built for WooCommerce.","author":"Layersync Conversion Tracking","active_installs":0,"version":"1.37.4","wp_org_url":"https://wordpress.org/plugins/layersync-conversion-tracking/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"layersync_queue","full_table_name":"wp_layersync_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"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":"medium","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) );"},{"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":"medium","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":"medium","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":"medium","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":"medium","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":7}