Start date:2017-06-25
Total inserted:1
array(2) { ["total"]=> int(12) ["data"]=> array(12) { [0]=> array(17) { ["id"]=> string(10) "55ac67d197" ["web_id"]=> int(71045) ["name"]=> string(6) "Alumni" ["date_created"]=> string(19) "2012-04-22 02:38:07" ["email_type_option"]=> bool(false) ["use_awesomebar"]=> bool(true) ["default_from_name"]=> string(21) "Mississippi Institute" ["default_from_email"]=> string(22) "reggie@msinstitute.com" ["default_subject"]=> string(55) "Congratulations from your Mississippi Institute family!" ["default_language"]=> string(2) "en" ["list_rating"]=> float(0) ["subscribe_url_short"]=> string(23) "http://eepurl.com/lAKsb" ["subscribe_url_long"]=> string(91) "http://msinstitute.us4.list-manage1.com/subscribe?u=c7ec50064341e70914d6794c4&id=55ac67d197" ["beamer_address"]=> string(47) "us4-36a80d1fea-1914416fb5@inbound.mailchimp.com" ["visibility"]=> string(3) "pub" ["stats"]=> array(15) { ["member_count"]=> float(2) ["unsubscribe_count"]=> float(0) ["cleaned_count"]=> float(0) ["member_count_since_send"]=> float(2) ["unsubscribe_count_since_send"]=> float(0) ["cleaned_count_since_send"]=> float(0) ["campaign_count"]=> float(23) ["grouping_count"]=> float(0) ["group_count"]=> float(0) ["merge_var_count"]=> float(2) ["avg_sub_rate"]=> float(0) ["avg_unsub_rate"]=> float(0) ["target_sub_rate"]=> float(0) ["open_rate"]=> float(0) ["click_rate"]=> float(0) } ["modules"]=> array(0) { } } [1]=> array(17) { ["id"]=> string(10) "936cd85197" ["web_id"]=> int(71041) ["name"]=> string(9) "Withdrawn" ["date_created"]=> string(19) "2012-04-22 02:23:46" ["email_type_option"]=> bool(false) ["use_awesomebar"]=> bool(false) ["default_from_name"]=> string(21) "Mississippi Institute" ["default_from_email"]=> string(22) "reggie@msinstitute.com" ["default_subject"]=> string(5) "hello" ["default_language"]=> string(2) "en" ["list_rating"]=> float(0) ["subscribe_url_short"]=> string(23) "http://eepurl.com/lAKsn" ["subscribe_url_long"]=> string(90) "http://msinstitute.us4.list-manage.com/subscribe?u=c7ec50064341e70914d6794c4&id=936cd85197" ["beamer_address"]=> string(47) "us4-36a80d1fea-62fc06a0ea@inbound.mailchimp.com" ["visibility"]=> string(3) "pub" ["stats"]=> array(15) { ["member_count"]=> float(0) ["unsubscribe_count"]=> float(0) ["cleaned_count"]=> float(0) ["member_count_since_send"]=> float(0) ["unsubscribe_count_since_send"]=> float(0) ["cleaned_count_since_send"]=> float(0) ["campaign_count"]=> float(0) ["grouping_count"]=> float(0) ["group_count"]=> float(0) ["merge_var_count"]=> float(2) ["avg_sub_rate"]=> float(0) ["avg_unsub_rate"]=> float(0) ["target_sub_rate"]=> float(0) ["open_rate"]=> float(0) ["click_rate"]=> float(0) } ["modules"]=> array(0) { } } [2]=> array(17) { ["id"]=> string(10) "1dbbcd8b49" ["web_id"]=> int(71009) ["name"]=> string(23) "Registered But No Start" ["date_created"]=> string(19) "2012-04-21 21:55:51" ["email_type_option"]=> bool(false) ["use_awesomebar"]=> bool(false) ["default_from_name"]=> string(21) "Mississippi Institute" ["default_from_email"]=> string(22) "reggie@msinstitute.com" ["default_subject"]=> string(5) "hello" ["default_language"]=> string(2) "en" ["list_rating"]=> float(0) ["subscribe_url_short"]=> string(23) "http://eepurl.com/lAKsr" ["subscribe_url_long"]=> string(90) "http://msinstitute.us4.list-manage.com/subscribe?u=c7ec50064341e70914d6794c4&id=1dbbcd8b49" ["beamer_address"]=> string(47) "us4-36a80d1fea-f2557258dc@inbound.mailchimp.com" ["visibility"]=> string(3) "pub" ["stats"]=> array(15) { ["member_count"]=> float(0) ["unsubscribe_count"]=> float(0) ["cleaned_count"]=> float(0) ["member_count_since_send"]=> float(0) ["unsubscribe_count_since_send"]=> float(0) ["cleaned_count_since_send"]=> float(0) ["campaign_count"]=> float(0) ["grouping_count"]=> float(0) ["group_count"]=> float(0) ["merge_var_count"]=> float(2) ["avg_sub_rate"]=> float(0) ["avg_unsub_rate"]=> float(0) ["target_sub_rate"]=> float(0) ["open_rate"]=> float(0) ["click_rate"]=> float(0) } ["modules"]=> array(0) { } } [3]=> array(17) { ["id"]=> string(10) "ea1949e45b" ["web_id"]=> int(70989) ["name"]=> string(19) "Currently Attending" ["date_created"]=> string(19) "2012-04-21 20:23:51" ["email_type_option"]=> bool(false) ["use_awesomebar"]=> bool(false) ["default_from_name"]=> string(21) "Mississippi Institute" ["default_from_email"]=> string(22) "reggie@msinstitute.com" ["default_subject"]=> string(35) "Current Student News - MS Institute" ["default_language"]=> string(2) "en" ["list_rating"]=> float(0) ["subscribe_url_short"]=> string(23) "http://eepurl.com/lAKsv" ["subscribe_url_long"]=> string(90) "http://msinstitute.us4.list-manage.com/subscribe?u=c7ec50064341e70914d6794c4&id=ea1949e45b" ["beamer_address"]=> string(47) "us4-36a80d1fea-b9b8ab2ea2@inbound.mailchimp.com" ["visibility"]=> string(3) "pub" ["stats"]=> array(15) { ["member_count"]=> float(0) ["unsubscribe_count"]=> float(0) ["cleaned_count"]=> float(0) ["member_count_since_send"]=> float(0) ["unsubscribe_count_since_send"]=> float(0) ["cleaned_count_since_send"]=> float(0) ["campaign_count"]=> float(0) ["grouping_count"]=> float(0) ["group_count"]=> float(0) ["merge_var_count"]=> float(2) ["avg_sub_rate"]=> float(0) ["avg_unsub_rate"]=> float(0) ["target_sub_rate"]=> float(0) ["open_rate"]=> float(0) ["click_rate"]=> float(0) } ["modules"]=> array(0) { } } [4]=> array(17) { ["id"]=> string(10) "aa4767e5b8" ["web_id"]=> int(70985) ["name"]=> string(10) "Start Date" ["date_created"]=> string(19) "2012-04-21 20:17:25" ["email_type_option"]=> bool(false) ["use_awesomebar"]=> bool(true) ["default_from_name"]=> string(21) "Mississippi Institute" ["default_from_email"]=> string(22) "reggie@msinstitute.com" ["default_subject"]=> string(20) "Orientation Reminder" ["default_language"]=> string(2) "en" ["list_rating"]=> float(0) ["subscribe_url_short"]=> string(23) "http://eepurl.com/lAKsz" ["subscribe_url_long"]=> string(91) "http://msinstitute.us4.list-manage2.com/subscribe?u=c7ec50064341e70914d6794c4&id=aa4767e5b8" ["beamer_address"]=> string(47) "us4-36a80d1fea-ad1ad2e272@inbound.mailchimp.com" ["visibility"]=> string(3) "pub" ["stats"]=> array(15) { ["member_count"]=> float(0) ["unsubscribe_count"]=> float(0) ["cleaned_count"]=> float(0) ["member_count_since_send"]=> float(0) ["unsubscribe_count_since_send"]=> float(0) ["cleaned_count_since_send"]=> float(0) ["campaign_count"]=> float(0) ["grouping_count"]=> float(0) ["group_count"]=> float(0) ["merge_var_count"]=> float(2) ["avg_sub_rate"]=> float(0) ["avg_unsub_rate"]=> float(0) ["target_sub_rate"]=> float(0) ["open_rate"]=> float(0) ["click_rate"]=> float(0) } ["modules"]=> array(0) { } } [5]=> array(17) { ["id"]=> string(10) "4e65458dad" ["web_id"]=> int(70981) ["name"]=> string(10) "Registered" ["date_created"]=> string(19) "2012-04-21 20:11:22" ["email_type_option"]=> bool(false) ["use_awesomebar"]=> bool(true) ["default_from_name"]=> string(21) "Mississippi Institute" ["default_from_email"]=> string(22) "reggie@msinstitute.com" ["default_subject"]=> string(5) "hello" ["default_language"]=> string(2) "en" ["list_rating"]=> float(0) ["subscribe_url_short"]=> string(23) "http://eepurl.com/lAKsD" ["subscribe_url_long"]=> string(91) "http://msinstitute.us4.list-manage1.com/subscribe?u=c7ec50064341e70914d6794c4&id=4e65458dad" ["beamer_address"]=> string(47) "us4-36a80d1fea-7fbca8e393@inbound.mailchimp.com" ["visibility"]=> string(3) "pub" ["stats"]=> array(15) { ["member_count"]=> float(0) ["unsubscribe_count"]=> float(0) ["cleaned_count"]=> float(0) ["member_count_since_send"]=> float(0) ["unsubscribe_count_since_send"]=> float(0) ["cleaned_count_since_send"]=> float(0) ["campaign_count"]=> float(0) ["grouping_count"]=> float(0) ["group_count"]=> float(0) ["merge_var_count"]=> float(2) ["avg_sub_rate"]=> float(0) ["avg_unsub_rate"]=> float(0) ["target_sub_rate"]=> float(0) ["open_rate"]=> float(0) ["click_rate"]=> float(0) } ["modules"]=> array(0) { } } [6]=> array(17) { ["id"]=> string(10) "37f83a6cd0" ["web_id"]=> int(70977) ["name"]=> string(25) "Visited and Toured School" ["date_created"]=> string(19) "2012-04-21 19:41:08" ["email_type_option"]=> bool(false) ["use_awesomebar"]=> bool(true) ["default_from_name"]=> string(21) "Mississippi Institute" ["default_from_email"]=> string(22) "reggie@msinstitute.com" ["default_subject"]=> string(5) "hello" ["default_language"]=> string(2) "en" ["list_rating"]=> float(0) ["subscribe_url_short"]=> string(23) "http://eepurl.com/lAKsH" ["subscribe_url_long"]=> string(90) "http://msinstitute.us4.list-manage.com/subscribe?u=c7ec50064341e70914d6794c4&id=37f83a6cd0" ["beamer_address"]=> string(47) "us4-36a80d1fea-6a31a3005e@inbound.mailchimp.com" ["visibility"]=> string(3) "pub" ["stats"]=> array(15) { ["member_count"]=> float(0) ["unsubscribe_count"]=> float(0) ["cleaned_count"]=> float(0) ["member_count_since_send"]=> float(0) ["unsubscribe_count_since_send"]=> float(0) ["cleaned_count_since_send"]=> float(0) ["campaign_count"]=> float(0) ["grouping_count"]=> float(0) ["group_count"]=> float(0) ["merge_var_count"]=> float(2) ["avg_sub_rate"]=> float(0) ["avg_unsub_rate"]=> float(0) ["target_sub_rate"]=> float(0) ["open_rate"]=> float(0) ["click_rate"]=> float(0) } ["modules"]=> array(0) { } } [7]=> array(17) { ["id"]=> string(10) "12a3113072" ["web_id"]=> int(70973) ["name"]=> string(27) "Contacted Scheduled a Visit" ["date_created"]=> string(19) "2012-04-21 19:13:54" ["email_type_option"]=> bool(false) ["use_awesomebar"]=> bool(true) ["default_from_name"]=> string(21) "Mississippi Institute" ["default_from_email"]=> string(22) "reggie@msinstitute.com" ["default_subject"]=> string(5) "hello" ["default_language"]=> string(2) "en" ["list_rating"]=> float(0) ["subscribe_url_short"]=> string(23) "http://eepurl.com/lAKsL" ["subscribe_url_long"]=> string(90) "http://msinstitute.us4.list-manage.com/subscribe?u=c7ec50064341e70914d6794c4&id=12a3113072" ["beamer_address"]=> string(47) "us4-36a80d1fea-ee1be27da6@inbound.mailchimp.com" ["visibility"]=> string(3) "pub" ["stats"]=> array(15) { ["member_count"]=> float(0) ["unsubscribe_count"]=> float(0) ["cleaned_count"]=> float(0) ["member_count_since_send"]=> float(0) ["unsubscribe_count_since_send"]=> float(0) ["cleaned_count_since_send"]=> float(0) ["campaign_count"]=> float(0) ["grouping_count"]=> float(0) ["group_count"]=> float(0) ["merge_var_count"]=> float(2) ["avg_sub_rate"]=> float(0) ["avg_unsub_rate"]=> float(0) ["target_sub_rate"]=> float(0) ["open_rate"]=> float(0) ["click_rate"]=> float(0) } ["modules"]=> array(0) { } } [8]=> array(17) { ["id"]=> string(10) "93d0672296" ["web_id"]=> int(70969) ["name"]=> string(24) "Contacted Not Interested" ["date_created"]=> string(19) "2012-04-21 18:52:17" ["email_type_option"]=> bool(false) ["use_awesomebar"]=> bool(true) ["default_from_name"]=> string(21) "Mississippi Institute" ["default_from_email"]=> string(22) "reggie@msinstitute.com" ["default_subject"]=> string(5) "hello" ["default_language"]=> string(2) "en" ["list_rating"]=> float(0) ["subscribe_url_short"]=> string(23) "http://eepurl.com/lAKsP" ["subscribe_url_long"]=> string(90) "http://msinstitute.us4.list-manage.com/subscribe?u=c7ec50064341e70914d6794c4&id=93d0672296" ["beamer_address"]=> string(47) "us4-36a80d1fea-d0c4e93e26@inbound.mailchimp.com" ["visibility"]=> string(3) "pub" ["stats"]=> array(15) { ["member_count"]=> float(0) ["unsubscribe_count"]=> float(0) ["cleaned_count"]=> float(0) ["member_count_since_send"]=> float(0) ["unsubscribe_count_since_send"]=> float(0) ["cleaned_count_since_send"]=> float(0) ["campaign_count"]=> float(0) ["grouping_count"]=> float(0) ["group_count"]=> float(0) ["merge_var_count"]=> float(2) ["avg_sub_rate"]=> float(0) ["avg_unsub_rate"]=> float(0) ["target_sub_rate"]=> float(0) ["open_rate"]=> float(0) ["click_rate"]=> float(0) } ["modules"]=> array(0) { } } [9]=> array(17) { ["id"]=> string(10) "39778a2eb0" ["web_id"]=> int(70917) ["name"]=> string(9) "Contacted" ["date_created"]=> string(19) "2012-04-21 01:49:51" ["email_type_option"]=> bool(false) ["use_awesomebar"]=> bool(true) ["default_from_name"]=> string(21) "Mississippi Institute" ["default_from_email"]=> string(22) "reggie@msinstitute.com" ["default_subject"]=> string(5) "hello" ["default_language"]=> string(2) "en" ["list_rating"]=> float(0) ["subscribe_url_short"]=> string(23) "http://eepurl.com/lAKsX" ["subscribe_url_long"]=> string(90) "http://msinstitute.us4.list-manage.com/subscribe?u=c7ec50064341e70914d6794c4&id=39778a2eb0" ["beamer_address"]=> string(47) "us4-36a80d1fea-7cfdf98f54@inbound.mailchimp.com" ["visibility"]=> string(3) "pub" ["stats"]=> array(15) { ["member_count"]=> float(0) ["unsubscribe_count"]=> float(0) ["cleaned_count"]=> float(0) ["member_count_since_send"]=> float(0) ["unsubscribe_count_since_send"]=> float(0) ["cleaned_count_since_send"]=> float(0) ["campaign_count"]=> float(0) ["grouping_count"]=> float(0) ["group_count"]=> float(0) ["merge_var_count"]=> float(2) ["avg_sub_rate"]=> float(0) ["avg_unsub_rate"]=> float(0) ["target_sub_rate"]=> float(0) ["open_rate"]=> float(0) ["click_rate"]=> float(0) } ["modules"]=> array(0) { } } [10]=> array(17) { ["id"]=> string(10) "05a156a467" ["web_id"]=> int(70293) ["name"]=> string(7) "Initial" ["date_created"]=> string(19) "2012-04-19 04:14:51" ["email_type_option"]=> bool(false) ["use_awesomebar"]=> bool(true) ["default_from_name"]=> string(21) "Mississippi Institute" ["default_from_email"]=> string(22) "reggie@msinstitute.com" ["default_subject"]=> string(57) "Mississippi Institute of Aesthetics, Nails, & Cosmetology" ["default_language"]=> string(2) "en" ["list_rating"]=> float(0) ["subscribe_url_short"]=> string(23) "http://eepurl.com/k9JtT" ["subscribe_url_long"]=> string(91) "http://msinstitute.us4.list-manage2.com/subscribe?u=c7ec50064341e70914d6794c4&id=05a156a467" ["beamer_address"]=> string(47) "us4-36a80d1fea-bdadb1e156@inbound.mailchimp.com" ["visibility"]=> string(3) "pub" ["stats"]=> array(15) { ["member_count"]=> float(0) ["unsubscribe_count"]=> float(0) ["cleaned_count"]=> float(0) ["member_count_since_send"]=> float(0) ["unsubscribe_count_since_send"]=> float(0) ["cleaned_count_since_send"]=> float(0) ["campaign_count"]=> float(0) ["grouping_count"]=> float(0) ["group_count"]=> float(0) ["merge_var_count"]=> float(2) ["avg_sub_rate"]=> float(0) ["avg_unsub_rate"]=> float(0) ["target_sub_rate"]=> float(0) ["open_rate"]=> float(0) ["click_rate"]=> float(0) } ["modules"]=> array(0) { } } [11]=> array(17) { ["id"]=> string(10) "f936035632" ["web_id"]=> int(42633) ["name"]=> string(5) "leads" ["date_created"]=> string(19) "2012-02-25 12:28:39" ["email_type_option"]=> bool(false) ["use_awesomebar"]=> bool(false) ["default_from_name"]=> string(19) "ymail2000@gmail.com" ["default_from_email"]=> string(19) "ymail2000@gmail.com" ["default_subject"]=> string(32) "Newsletters from msinstitute.com" ["default_language"]=> string(2) "en" ["list_rating"]=> float(3.5) ["subscribe_url_short"]=> string(23) "http://eepurl.com/jE6oD" ["subscribe_url_long"]=> string(90) "http://msinstitute.us4.list-manage.com/subscribe?u=c7ec50064341e70914d6794c4&id=f936035632" ["beamer_address"]=> string(47) "us4-36a80d1fea-921de7a68c@inbound.mailchimp.com" ["visibility"]=> string(3) "pub" ["stats"]=> array(15) { ["member_count"]=> float(2262) ["unsubscribe_count"]=> float(9) ["cleaned_count"]=> float(62) ["member_count_since_send"]=> float(297) ["unsubscribe_count_since_send"]=> float(0) ["cleaned_count_since_send"]=> float(0) ["campaign_count"]=> float(0) ["grouping_count"]=> float(0) ["group_count"]=> float(0) ["merge_var_count"]=> float(5) ["avg_sub_rate"]=> float(0) ["avg_unsub_rate"]=> float(0) ["target_sub_rate"]=> float(1) ["open_rate"]=> float(31.896193771626) ["click_rate"]=> float(3.282001254268) } ["modules"]=> array(0) { } } } } List ID:f936035632
1 to subscribe or update...
array(1) { [0]=> array(6) { ["EMAIL"]=> string(26) "Cherrellejones46@yahoo.com" ["FNAME"]=> string(10) "Cherrelle " ["LNAME"]=> string(5) "Jones" ["STATUS"]=> string(7) "Initial" ["STATUSDATE"]=> string(10) "2017-06-25" ["STARTDATE"]=> string(11) "-0001-11-30" } } string(10) "f936035632" array(4) { ["add_count"]=> int(1) ["update_count"]=> int(0) ["error_count"]=> int(0) ["errors"]=> array(0) { } } Added:1,Updated:0,Error:0
array(2) { ["total"]=> int(9) ["data"]=> array(9) { [0]=> array(4) { ["email"]=> string(25) "mcneil_ashley89@ymail.com" ["timestamp"]=> string(19) "2016-04-25 21:28:56" ["reason"]=> string(6) "NORMAL" ["reason_text"]=> string(0) "" } [1]=> array(4) { ["email"]=> string(20) "samandradc@yahoo.com" ["timestamp"]=> string(19) "2016-05-23 16:13:39" ["reason"]=> string(6) "NORMAL" ["reason_text"]=> string(0) "" } [2]=> array(4) { ["email"]=> string(25) "maryallisonsaul@gmail.com" ["timestamp"]=> string(19) "2016-06-09 17:07:02" ["reason"]=> string(6) "NORMAL" ["reason_text"]=> string(0) "" } [3]=> array(4) { ["email"]=> string(25) "THATS1SINGINGAL@YAHOO.COM" ["timestamp"]=> string(19) "2016-06-10 05:35:52" ["reason"]=> string(6) "NORMAL" ["reason_text"]=> string(0) "" } [4]=> array(4) { ["email"]=> string(24) "christoforos@outlook.com" ["timestamp"]=> string(19) "2016-07-13 16:21:45" ["reason"]=> string(8) "NOSIGNUP" ["reason_text"]=> string(0) "" } [5]=> array(4) { ["email"]=> string(26) "leslie_hankins08@yahoo.com" ["timestamp"]=> string(19) "2016-07-16 10:29:08" ["reason"]=> NULL ["reason_text"]=> NULL } [6]=> array(4) { ["email"]=> string(21) "BCIrons0418@YAHOO.COM" ["timestamp"]=> string(19) "2016-07-20 03:34:12" ["reason"]=> NULL ["reason_text"]=> NULL } [7]=> array(4) { ["email"]=> string(22) "Uniqlee.sped@gmail.com" ["timestamp"]=> string(19) "2016-08-05 10:11:19" ["reason"]=> NULL ["reason_text"]=> NULL } [8]=> array(4) { ["email"]=> string(20) "aafoster1999@att.net" ["timestamp"]=> string(19) "2016-08-07 15:16:05" ["reason"]=> NULL ["reason_text"]=> NULL } } } Get 9 unsubscribed records.
update lm_leads set sync='delete' where email in ('mcneil_ashley89@ymail.com','samandradc@yahoo.com','maryallisonsaul@gmail.com','THATS1SINGINGAL@YAHOO.COM','christoforos@outlook.com','leslie_hankins08@yahoo.com','BCIrons0418@YAHOO.COM','Uniqlee.sped@gmail.com','aafoster1999@att.net')
0 to unsubscribe...




MS Institute of Aesthetics, Nails, & Cosmetology | 507 Springridge Road, Ste G | Clinton, MS 39056 | Tel: (601) 925-1344 | Fax: (601) 925-1345


SiteLock