Peruttu

Email marketing system

I'd like to have an EMAIL MARKETING SYSTEM.

A need a database in which I can import contact data via an excel sheet.

When an emailaddress already occurs in the system I need that record to be enriched with the newly imported data.

Example:

I have the following in my database:

[name] [email] [hasnewsletter1] [hasnewsletter2] [hasnewsletter3]

john emailaddress true false true

In my excel sheet I have:

[email] [hasnewsletter2]

emailaddress true

After the import I want the new record to be:

[name] [email] [hasnewsletter1] [hasnewsletter2] [hasnewsletter3]

john emailaddress true true true

So NO duplicate emailaddresses will occur in my DB.

The initial columns will be:

sex

firstname

middlename

lastname

email

province

birthdate

newsletter1

newsletter2

newsletter3

newsletter4

newsletter5

On each column I want to be able to filter.

So it must be possible for me to define something like:

give me all records from people older than 30 that live in province x and are a member of newsletter3

After I see this resultset I want to be able to save my filter and give it a good name, e.g. "Newsletter 3 Customers 30+ from province X"

The next step is the creation of the newsletter.

For this I want to be able to define a newsletter title, this is used only internally to identify a certain newsletter, e.g.: Internal newsletter [2009-10-10]: the first company newsletter

I want to be able to define a newsletter subject, this is the subject of the email the customers will receive: e.g. : CompanyX Summer Newsletter

And then I want to select an ealier defined filter (which I saved earlier above). This filter will indicate WHO will receive the newsletter.

The newsletter contents are defined externally in HTML. For the newsletter content I want to have a textfield in which I place the newsletter HTML.

It must be possible to personalize the newsletter to a certain extent:

I want the content editors to be able to send a newsletter like:

Dear Mr John Van Doe,

welcome to this first newsletter.

As you can see this line is generated based on the sex, fistname, middlename and lastname column.

So an editor must be able to type something like:

Dear [Mr/Ms] [firstname] [middlename] [lastname],

welcome to this first newsletter.

Upon sending the email the bracketed tags are replaced with the actual customer data.

How to do this in a friendly way I leave up to you, but I'd like to hear from you beforehand how it will work.

Of course the Mr/Ms word is conditional based on the sex of the customer. Also when the user has no middlename I don't want to have 2 spaces between first and lastname.

After that I want to be able to testrun my newsletter, I fill in an emailaddress and cick 'send testrun'.

As soon as im happy with that I click 'Send newsletter now'.

The newsletter is sent.

On my newsletters I also want some statistics which I can export to Excel:

- What is the openingsrate of the newsletter?

- Which links are clicked on (I imagine something like adding a piece of code to hyperlinks, so that later in Google Analytics I can see where was clicked on)

People must be able to unsubscribe from a newsletter.

Each newsletter contains a link (placed by editor): [url removed, login to view]

There you enter on a page where you have to fill in your emailaddress and then you are unsubscribed (record is NOT deleted) for the newsletterid. So that column becomes false.

Anyone who does this assignment well can count on more business in the future extending this system as well as new assignments.

Screenshots of earlier work, an explanation/screenshots of your proposed solution for my problem will definitely help you in getting this assignment.

Techniques to be used:

.NET

AJAX

MSSQL

Source code must be delivered upon completion.

Taidot: .NET, AJAX, Excel, SQL

Näytä lisää: email already system, net ajax excel, unsubcribe, www marketing, what is marketing, what is an assignment problem, what is analytics, what do marketing people need to do, what does a content editor do, statistics problem, solution to assignment problem, solution of assignment problem, send word now, problem statistics, problem solution assignment, problem of statistics, problem in statistics, problem assignment, problem and statistics, people need an editor, on line marketing com, on-line marketing, on line editors, net marketing business, net for marketing

About the Employer:
( 31 reviews ) Nijmegen, United States

Projektin tunnus: #494422

61 freelanceria on tarjonnut keskimäärin 393 $ tähän työhön

Frankhardy

Hi, Awaiting your word to start the project, regards...Frank

450 $ USD 7 päivässä
(3 arvostelua)
5.5
tamrakar81

hi, please check pm thanks

250 $ USD 5 päivässä
(47 arvostelua)
5.4
nyusofttech

Hi, Please see PMB for more detail... Thanks,

300 $ USD 10 päivässä
(8 arvostelua)
5.0
ashwin86

check pmb for further details

250 $ USD 5 päivässä
(17 arvostelua)
5.0
nmppatel

I have experience developing Emailing Software. I will provide quick & professional service. More details in PM

400 $ USD 5 päivässä
(26 arvostelua)
5.0
EspressoLogic

Please check PMB for more details.

250 $ USD 7 päivässä
(14 arvostelua)
4.9
joebrassi

Hello, see pm.

300 $ USD 15 päivässä
(9 arvostelua)
4.7
locdev

Hi please check PMB Thanks Mikhail

599 $ USD 1 päivässä
(8 arvostelua)
4.6
ranacseruet

I am interested..

600 $ USD 21 päivässä
(15 arvostelua)
4.5
stdhtelkom

please see pm, thanks you.

250 $ USD 12 päivässä
(4 arvostelua)
4.3
shreesoftech

Hi, see the pmb.

350 $ USD 10 päivässä
(13 arvostelua)
3.9
stefanache

I'm ready if you have a cpanel access. My solution based on Ajax+PHP_MySQL. I have a good experence into population evidence

750 $ USD 30 päivässä
(7 arvostelua)
3.6
sohan1

Please check Pm for details

300 $ USD 1 päivässä
(2 arvostelua)
3.3
vivekshrivastava

HI, As per the description given by you is that 1). Your all data will come from your Excell sheet to database. No probelm. 2). Data filteration . No problem. For it either i will provide you interface or repor Lisää

400 $ USD 25 päivässä
(2 arvostelua)
3.0
weblogicsoftware

Hi, please check the pmb for the more details. thanks

250 $ USD 4 päivässä
(2 arvostelua)
2.9
gato

Check portfolio in pm.

500 $ USD 10 päivässä
(1 arvostelu)
2.0
premgaf1

We are ready to work, and we have experience in this field, we are waiting for your reply.

400 $ USD 30 päivässä
(0 arvostelua)
0.0
SpyrosSavvides

Support & Maintenance : $150 for 6 months after project goes to production.

300 $ USD 7 päivässä
(0 arvostelua)
0.0
amaldev1980

Has 4 years of experience in developing applications for mass email marketing campaigns in areas such as ecommerce, real estate,recreational sports etc

550 $ USD 30 päivässä
(0 arvostelua)
0.0
newindiasoft

hi, please check PM for my previous work like this.

500 $ USD 10 päivässä
(0 arvostelua)
0.0