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
("198","3035","3035","","558072","","","Auto 6-49 #1","0","+15878051052","Hi it\'s Lance with Tower Chrysler. Here\'s the link to play Auto 6/49: www.TowerChryslerAuto6-49.com. $1,000,000 will be shared by people in the area! Call me if you have any question. Reply STOP to unsubscribe. Good luck! :-)","Schedule","sms","2016-07-22","11:30 AM","2016-07-22","10:30:00","300","15","yes","2016-07-22 11:29:59","yes","1196","start"),
("4294","3035","3035","","591765","","","Black Friday","0","+15878014316","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.TowerChryslerBlackFriday.com  Call me with any questions. Reply STOP to unsubscribe. Good luck! :)","Immediate","sms","2017-11-07","12:35:34","2017-11-07","11:35:34","150","15","no","2017-11-07 12:35:34","yes","2151","start"),
("5420","3035","3035","","605508","","","March 2018  FCA 699 SMS","0","+15878014316","Hi {first_name}, Richard Zanetti, the Dealer Principal at Tower Chrysler, asked me to reach out
\nbecause we think we found a way to help you lower the interest rate on your payments. It could
\nbe as low as 0% or make lease payments as little as $45 a week oac. I’m sure that would make
\nyou happy? Give us a quick call at 866 934-9783, and we’ll explain how. Just reply STOP if you
\nwant to unsubscribe. Talk soon","Immediate","sms","2018-03-16","10:34:20","2018-03-16","09:34:20","25","15","yes","2018-03-16 10:34:20","yes","19","start"),
("5599","3035","3035","","606701","","","SMS for Lease/Finance/Warranty Expiry","0","+15878014316","Hi {first_name}, Richard Zanetti, the Dealer Principal at Tower Chrysler, 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 866 934-9783 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:23:35","yes","545","start"),
("6379","3035","3035","","611295","","","Factory Liquidation Event","0","+15878014316","Hey! This is Trevor Carson, General Manager at Tower Chrysler. I want to personally invite you to our Factory Liquidation Event from May 11-19! Our head office has chosen Tower to be their only liquidation centre. Also, you’ll get our new TOWER POWER DEAL which includes 2 years or 4 FREE oil changes along with 4 FREE tire rotations, PLUS a gift from our prize mountain. Reply STOP to unsubscribe. Call me back at 877 895-9739 if you have any questions.","Schedule","sms","2018-05-10","10:00 AM","2018-05-10","09:00:00","50","15","yes","2018-05-10 08:15:09","yes","1036","start");



