{"slug":"azexo-advertising-analytics","name":"AZEXO Advertising Analytics","description":"This plugin collects data from CRM-system, advertising platforms and your website. With this data it generate reports on key business indexes.","author":"azexo","active_installs":10,"version":"1.27.3","wp_org_url":"https://wordpress.org/plugins/azexo-advertising-analytics/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"aza_calltracking","full_table_name":"wp_aza_calltracking","description":"Stores aza calltracking data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"promo_code","type":"bigint(10) unsigned","nullable":false,"primary_key":false},{"name":"phone","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"caller_phone","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"call_timestamp","type":"int(11) unsigned","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_aza_calltracking ( promo_code bigint(10) unsigned NOT NULL, phone varchar(100), caller_phone varchar(100), call_timestamp int(11) unsigned, UNIQUE KEY promo_code (promo_code), KEY caller_phone (caller_phone), KEY phone (phone) ) $collate;\");"},{"table_name":"aza_calltracking_phones","full_table_name":"wp_aza_calltracking_phones","description":"Stores aza calltracking phones data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"phone","type":"varchar(100)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_aza_calltracking_phones ( user_id bigint(20) unsigned NOT NULL, phone varchar(100), UNIQUE KEY phone (user_id, phone) ) $collate;\");"},{"table_name":"aza_leads","full_table_name":"wp_aza_leads","description":"Stores aza leads data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"promo_code","type":"bigint(10) unsigned","nullable":false,"primary_key":false},{"name":"visitor_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"lead_timestamp","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"lead_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"lead_page_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"lead_page_author","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"type","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"first_cost","type":"decimal(10,2) unsigned","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(10,2) unsigned","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_aza_leads ( promo_code bigint(10) unsigned NOT NULL, visitor_id varchar(32) NOT NULL, lead_timestamp int(11) unsigned NOT NULL, lead_id bigint(20) unsigned NOT NULL, lead_page_id bigint(20) unsigned, lead_page_author bigint(20) unsigned NOT NULL, type varchar(20), status varchar(50), first_cost decimal(10,2) unsigned, amount decimal(10,2) unsigned, KEY promo_code (promo_code), UNIQUE KEY lead (lead_id, type) ) $collate;\");"},{"table_name":"aza_offline_marketing_costs","full_table_name":"wp_aza_offline_marketing_costs","description":"Stores aza offline marketing costs data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"channel","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"from_date","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"to_date","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"cost","type":"decimal(10,2) unsigned","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_aza_offline_marketing_costs ( user_id bigint(20) unsigned NOT NULL, channel varchar(100), from_date int(11) unsigned NOT NULL, to_date int(11) unsigned NOT NULL, cost decimal(10,2) unsigned, UNIQUE KEY cost (user_id, channel, from_date, to_date) ) $collate;\");"},{"table_name":"aza_targets","full_table_name":"wp_aza_targets","description":"Stores aza targets data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"promo_code","type":"bigint(10) unsigned","nullable":false,"primary_key":false},{"name":"visitor_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"target_timestamp","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"target_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"target_page_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"target_page_author","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"type","type":"varchar(20)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_aza_targets ( promo_code bigint(10) unsigned NOT NULL, visitor_id varchar(32) NOT NULL, target_timestamp int(11) unsigned NOT NULL, target_id bigint(20) unsigned NOT NULL, target_page_id bigint(20) unsigned, target_page_author bigint(20) unsigned NOT NULL, type varchar(20), KEY promo_code (promo_code), UNIQUE KEY target (target_id, type) ) $collate;\");"},{"table_name":"aza_visits_","full_table_name":"wp_aza_visits_","description":"Stores aza visits  data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":6}