INSERT INTO hp_sms_broadcast_campaign (`broadId`,`teamId`,`added_by`,`permission`,`groupId`,`tags`,`skip_lead_tags`,`campagin_name`,`templateId`,`from_number`,`sms_body`,`sms_type`,`type`,`schedule_date`,`schedule_time`,`server_date`,`server_time`,`throttle_per_hour`,`throttle_duration`,`time_constraint`,`dated`,`is_processed`,`total_sent`,`bulk_activities_status`) VALUES
("976","3826","3826","","566016","","","SMS 6-49","0","+15874107130","Hi, it\'s John from Capital Jeep. Here\'s the link to play Auto 6/49:  www.CapitalJeepAuto6-49.com  $1,000,000 will be shared by people in the area! Call me if you have questions. Reply STOP to unsubscribe. Have a GREAT day! Good Luck!","Schedule","sms","2016-10-19","03:30 PM","2016-10-19","14:30:00","400","15","yes","2016-10-19 11:23:08","yes","2389","start"),
("4338","3826","3826","","592089","","","Black Friday SMS","0","+15873242261","Register for our Black Friday event and get a chance to play to win a $50,000 cash prize, a 5-day cruise for 2, and an instant $500 Business Office Bonus Cash: www.CapitalJeepWin50000Cash.com   Call me with any questions. Reply STOP to unsubscribe. Good luck! :)","Schedule","sms","2017-11-14","11:30 AM","2017-11-14","10:30:00","200","15","yes","2017-11-14 10:41:57","yes","4707","start"),
("5422","3826","3826","","605478","","","March 2018  FCA 699 SMS","0","+15873242261","Hi {first_name}, Josh Davis, the Dealer Partner at Capital Jeep, asked me to reach out because
\nwe think we found a way to help you lower the interest rate on your payments. It could be as
\nlow as 0% or make lease payments as little as $45 a week oac. I’m sure that would make you
\nhappy? Give us a quick call at 587 200-4787, and we’ll explain how. Just reply STOP if you want
\nto unsubscribe. Talk soon!","Immediate","sms","2018-03-16","11:01:51","2018-03-16","10:01:51","25","15","yes","2018-03-16 11:01:51","yes","67","start"),
("5593","3826","3826","","606613","","","SMS for Lease/Finance/Warranty Expiry","0","+15873242261","Hi {first_name}, Josh Davis, the Dealer Partner at Capital Jeep, asked me to reach out because we have a few buyers here ready to pay some serious money for your {make} {model}, but they would need to know today if you have any interest. I could also get you up to $20,300 in discounts or interest rates as low as 0% and you could make lease payments as little as $45 a week oac. Can you give us a quick call at 587 200-4787 to let me know? Just reply STOP if you want to unsubscribe. Talk soon!","Schedule","sms","2018-03-22","11:00 AM","2018-03-22","10:00:00","25","15","yes","2018-03-22 08:00:21","yes","294","start");



