SMS marketing platform (web-based portal) to be developed using perl/MySQL to send a customised sms message to a list of delivery mobile numbers along with a mailmerge field if necessary. Key features are as follows:
– Deliverables: Perl code, HTML pages, MySQL database/table schemas
– Perl CGI, using HTML::Template to load HTML pages, DBI for MySQL communication
– Ability to create campaign with a name, description, creator, promo code reference
– Ability to upload/enter delivery list of up to 10000 mobile numbers
– Ability to set delivery from field
– Ability to enter specific message (java character counter needed)
– Ability to ‘mailmerge’ an additional data field into the message using an appropriate variable name
– Ability to preview SMS’s before sending
– Low-level send_sms function will be provided (e.g. send_sms($msg, $to, $from));
– All outbound messages to be checked against STOP/unsubscribed list before sending, details + schema for this MySQL will be provided
– Delivery list to be deduped to prevent multiple messages going to the same recipient during the session
– All messages are sent also to a default test list which is maintained separately
– Full logs of all messages sent and timings to be maintained
– Sending a batch is undertaken by a cron job
– Campaign summary stats page + deeper breakdown stats
