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
("991","3861","3861","","566823","","","SMS key to Your Dreams","0","+15874092954","Feeling lucky? PLAY our Key to Your Dreams game and get up to $60,000 in trade-in cash: www.CrosstownKeyToYourDreams.com  If your key opens the door, everything inside the vault
\nis yours to help you make YOUR dreams come true! Reply STOP to unsubscribe. Have a GREAT day :) Robbie","Immediate","sms","2016-10-21","14:24:50","2016-10-21","13:24:50","250","15","yes","2016-10-21 14:24:50","yes","1697","start"),
("1006","3861","3861","","566823","","","SMS Tires","0","+15878020657","WIN YOUR WINTER TIRES => a $1,000 value: www.CrosstownAutoCentreTires.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. Have a GREAT day! Scott","Schedule","sms","2016-10-24","03:30 PM","2016-10-24","14:30:00","300","15","no","2016-10-24 14:31:44","yes","1661","start"),
("1314","3861","3861","","566823","","","SMS BlackF","0","+15878020657","Black Friday last 24 hours Door Crasher Alert – Crash a few doors and get up to $30,000 in Black Friday Trade-in Cash: www.CrosstownBlackFriday.com    + up to 20% OFF the MSRP of select vehicles… that’s crazy! Reply STOP to unsubscribe. Call me if you have questions! Have a GREAT day! Robbie","Schedule","sms","2016-11-29","03:30 PM","2016-11-29","14:30:00","200","15","yes","2016-11-29 15:26:29","yes","1608","start"),
("5424","3861","3861","","605482","","","March 2018  FCA 699 SMS","0","+15878030563","Hi {first_name}, Joe Medina, the Dealer Principal at Crosstown Auto Center, asked me to reach
\nout because we think we found a way to help you lower the interest rate on your payments. It
\ncould be as low as 0% or make lease payments as little as $45 a week oac. I’m sure that would
\nmake you happy? Give us a quick call at 877 391-2342, and we’ll explain how. Just reply STOP if
\nyou want to unsubscribe. Talk soon!","Immediate","sms","2018-03-16","11:06:54","2018-03-16","10:06:54","25","15","yes","2018-03-16 11:06:54","yes","132","start"),
("5595","3861","3861","","606618","","","SMS for Lease/Finance/Warranty Expiry","0","+15878030563","Hi {first_name}, Joe Medina, the Dealer Principal at Crosstown Auto Center, 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 877 391-2342 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:13:40","yes","717","start"),
("5843","3861","3861","","608049","","","Crosstown Auto 15% DIESEL SMS","0","+15878030563","Hi {first_name}, I was talking to Christopher Goodwin our service manager about your vehicle, and he reminded me that we have a unique offer for our diesel customers that could help you save 15% off our diesel services. I told Christopher I would reach out asap to let you know. Give us a call today at 587-200-5440 to lock in this unique offer. Simply reply STOP to unsubscribe from our DIESEL list. Talk soon! :)","Immediate","sms","2018-04-06","11:36:29","2018-04-06","10:36:29","25","15","yes","2018-04-06 11:36:29","yes","332","start"),
("5920","3861","3861","","607938","","","Crosstown Safety SMS","0","+15878030563","Hi{first_name}, I was talking to Christopher Goodwin our service manager at Crosstown Auto Center about your vehicle, and he reminded me about a unique offer we have that could allow you to take advantage of our Full Safety Inspection for only $89,99 instead of the usual $136. I told Christopher I would reach out asap to let you know. Give us a call today at 587-200-5440 to lock your 33% off. Simply reply STOP to unsubscribe from our SAVINGS list. Talk soon! :)","Schedule","sms","2018-04-12","11:00 AM","2018-04-12","10:00:00","25","15","yes","2018-04-11 08:13:38","yes","175","start");



