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
("4079","4098","4098","","569394","","","Quest for Trades","0","+15068042731","As a current customer of Moncton Chrysler, you’ve been automatically approved for your Certificate of Eligibility to our $500,000 Quest for Trades fund. Get it here: www.MonctonQuestForTrades.com  FCA is also adding up to $14,500 in discounts plus you could enjoy 0% up to 84 mths o.a.c. on select 2017 new models. Reply STOP to unsubscribe. Call us if you have any questions!","Immediate","sms","2017-09-22","11:33:47","2017-09-22","08:33:47","150","15","yes","2017-09-22 11:33:47","yes","3207","start"),
("4258","4098","4098","","569394","","","SMS Winter Tires 2017","0","+15068042731","WIN YOUR WINTER TIRES => a $500 value: www.MonctonWinterTires.com  Simply let us quote you our best price and you will be automatically entered in the draw to win… it’s that easy! Watch the video or call us if you have any question. Reply STOP to unsubscribe. Good luck! :)","Immediate","sms","2017-11-01","16:28:57","2017-11-01","12:28:57","300","15","yes","2017-11-01 16:28:57","yes","3007","start"),
("4960","4098","4098","","601884","","","SMS promo payback event","0","+15065035691","As a preferred customer, you have been selected to attend our payback event!  Our records indicate you are currently driving a vehicle that entitles you to a refund of your last three payments upon the purchase of a new vehicle all on us!  Register today at https://www.monctonchrysler.com/promo/payback-event.htm and you will be entered for a chance to win $25,000! Reply STOP to unsubscribe. See you soon!!! ;)","Immediate","sms","2018-02-09","11:04:18","2018-02-09","07:04:18","25","15","yes","2018-02-09 11:04:18","yes","157","start"),
("5001","4098","4098","","602209","","","PayBack event","0","+15065035691","As a preferred customer, you have been selected to attend our payback event!  Our records indicate you are currently driving a vehicle that entitles you to a refund of your last three payments upon the purchase of a new vehicle all on us!  Register today at https://www.monctonchrysler.com/promo/payback-event.htm and you will be entered for a chance to win $25,000! Reply STOP to unsubscribe. See you soon!!! ;)","Schedule","sms","2018-02-15","11:00 AM","2018-02-15","07:00:00","25","15","yes","2018-02-14 15:18:09","yes","154","start"),
("5102","4098","4098","","602886","","","Payback event","0","+15065035691","As a preferred customer, you have been selected to attend our payback event!  Our records indicate you are currently driving a vehicle that entitles you to a refund of your last three payments upon the purchase of a new vehicle all on us!  Register today at https://www.monctonchrysler.com/promo/payback-event.htm and you will be entered for a chance to win $25,000! Reply STOP to unsubscribe. See you soon!!! ;)","Immediate","sms","2018-02-22","11:48:03","2018-02-22","07:48:03","25","15","yes","2018-02-22 11:48:03","yes","98","start"),
("5415","4098","4098","","605498","","","March 2018  FCA 699 SMS","0","+15065035691","Hi {first_name}, Trevor Carson, the Dealer Principal at Moncton 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 949-4497, and we’ll explain how. Just reply STOP if you
\nwant to unsubscribe. Talk soon!","Immediate","sms","2018-03-16","13:12:29","2018-03-16","09:12:29","25","30","yes","2018-03-16 13:12:29","yes","69","start"),
("5581","4098","4098","","606666","","","SMS for Lease/Finance/Warranty Expiry","0","+15065035691","Hi {first_name}, Trevor Carson, the Dealer Principal at Moncton 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 949-4497 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","07:00:00","25","15","yes","2018-03-22 10:33:49","yes","466","start");



