In Progress

PHP Email Program

We need a simple CRM created which sends emails periodically based on client time triggers.

The specifications are as follows:

2 types of users, of which there will be multiple of each:

* site admin

* clients

Clients need to be able to log in and manage their database of subscribers (specific to that client), they should be able to export their database at any time, as well as manually add subscribers or import from a csv. The csv import should be flexible to allow for their own data structure which the script will read then ask the user to map the relevant fields to our database. We also need an api to be able to pragmatically add subscribers from other sources for a specific client, with a unique api key for each client.

Clients should be able to create the email triggers through the interface in the structure of either:

* once-off emails: example, at 6 months in program (subscribers who have been subscribed for 6 months, the time options can range from 1 day to 10 years)

* recurring emails: example, every 6 months in program (subscribers who have been subscribed for 6 months, the time options can range from 1 day to 10 years)

When setting up the email triggers they can choose a subject line, the time range as above, as well as input html code for the template body. Both the template body and subject should be able to contain variables specific to each subscriber such as {{name}} to customize automatically when sending. They should also be able to customize the sender/reply-to name/email per email trigger.

A php script to run as a cron job is needed which will be run daily to send all relevant emails for that day which match the time triggers.

The clients should also be able to:

* see an overview of their account at any time to see the number of total subscribers,

* see how many people have opted in/out and opened the emails, and export this information to csv

* see the total number of clicks per day/week/month or a specific time period

* see how many emails have been sent for the day/week/all time or a specific time period.

The admin view should be able to:

* add/suspend clients to the program which we can designate a specific email/password combination

* view totals of emails sent/opened/unsubscribed/clicks per day/week/month/all time/specific period, and per client

* create new fields the clients can use for their subscriber base

* choose for the system to either use the critsend api for sending emails as per: [url removed, login to view] but we must be able to change the login/api credentials if needed; or, we must be able to choose to use custom SMTP settings. We should be able to set system defaults, but also be able to change these settings per client and when setting new clients up.

* add other admin

The system should automatically generate an email footer which can be set by admins which will be generated automatically on each and every email with an unsubscribe link as well as an embedded open tracking code.

The unsubscribe clicks should direct to a page on the script which recognises the email the user is unsubscribing from and automatically unsubscribes them and informs them they have unsubscribed.

Any links in the email should be automatically rewritten to be routed via a click tracking php script as part of the crm which will record who has clicked a link in the email and update the database accordingly then forward the user on. No matter how many times one user clicks a link in the same email it should only be counted as one click.

The users should be able to change their email address and password too.

Session management should be via cookies.

We will be designing the interface layout after development so just very basic text, links, tables etc.. is needed from you and we will handle the pretty interface ourselves.

Skills: HTML, PHP, Website Design

See more: user specifications template, update email template, types of data structure, types data structure, time map template, tables in data structure, system specifications template, subject php, smtp design website, simple map template, set in data structure, set data structure, session php, program in direct, people who need website designing, name of account on website designing, log designing, key data structure, in line program, html program code, how to create website by php, how to create database program, email address management, data structure types, data structure through c

About the Employer:
( 5 reviews ) Hawthorne, Australia

Project ID: #1271178

Awarded to:


hi please check your pmb thanks

$450 AUD in 10 days
(11 Reviews)

6 freelancers are bidding on average $496 for this job


Hello Sir we are well clear with the given requirement, we got PHP/CAKEPHP EXPERTS, Kindly check PMB to see our previous works details Thanks Sajin

$600 AUD in 25 days
(10 Reviews)

Hi, I have gone through the requirement and analyzed it completely for the CRM events. I am presenting my analysis in the attachment. Kindly go through the document and let me know your thoughts. I look forward More

$750 AUD in 30 days
(2 Reviews)

Hi, First of all thanks for posting this type of job for me. I am really interested to do this type of job for you. I can start the job immediately. Thanks, Spacotech

$400 AUD in 15 days
(1 Review)

I had done similar project before too.. Lets discuss more and do it right now.. Thanks

$350 AUD in 12 days
(1 Review)

Hi, I am interested in the project. Kindly send me the details.

$425 AUD in 10 days
(0 Reviews)