Database design

effectMail is a simple and
low-cost web base self-service software solution for those who are new to email marketing.
Introduction to effectMail
Setting Up an effectMail Account
Start with effectMail free account by creating a username and a secure password.
effectMail does not let you start with a paid account right away as it wants to make
sure the account is correctly set up and not used for spam. The system takes the spam
concerns seriously, so you must activate your account by clicking on the link in
confirmation email. effectMail also requires a valid company name, phone number
and URL for your website, if you do not have those details, you can still setup an
account by calling effectMail sales team.
Multi-user account
effectMail provides multi-user account facility for premium customers. A multiple
account enables multiple users to login to the same account in order to do the job
according to their permission level. This means that it is possible to maintain a single
account for your entire marketing team. The account owner can add as many users as
he wants and limit what permissions each of them has. You can choose role for each
user: account manager, marketing executive, marketing assistant, etc… or create a
customized permission.
effectMail

Email Marketing Packages
effectMail has a very attractive pricing strategy. Many small businesses will pick up
effectMail because it provides professional email marketing services for free. The free
plan lets you send 500 emails per month to less than 100 subscribers. This works if you
have a fairly small subscriber list. If you email your subscribers more frequently, then
you will outgrow this plan. The monthly paid plans let you send unlimited emails and
the pricing varies by the number of subscribers. The lowest subscription plan begins
at £20 per month for up to 500 subscribers. Pricing then rises to £30 per month for up
to 1,000 subscribers and £40 per month for up to 2000 subscribers. You can enter the
number of estimated subscribers on the handy calculator available on the website to
get an exact price.
Creating a Subscriber List
Upload email contacts by using a Microsoft Excel or CSV file, or by manually adding
them one at a time. If you have a very large subscriber list, effectMail technical support
team can help uploading those contacts to the system through a special backend tool
and this service will be free for the lists contain more than 20,000 contacts.
Setting up a Campaign
When you first log in, you will be prompted to create your first campaign. The
effectMail self-service email builder includes over a dozen of predesigned templates
to choose; you can customize them with your own images, links, and texts. You can
drag and drop elements such as images, spacers, texts, videos, and social buttons, and
customize the colour and style of each. Also can easily delete an unwanted element
by clicking on it, which reveals a trash icon. You can adjust font style, size, and colour
too. Also can preview your email on both desktop and mobile, so you can get a sense
of how it looks like on different platforms and devices.
Once you have finished building, you can then preview the campaign. Finally, you need
to select your email list (subscriber list) to which you would like to send your email.
Before you send the campaign out, you can send a test email to make sure there are
no errors. You can either send the campaign right away or schedule it for another date.
When you hit Send button, you will see a pop-up message with an overview of the
campaign, with the number of contacts, subject, From name, and From email, so you
can do one last check. When your campaign is delivered to all the recipients,
effectMail will send you a confirmation email.
Tracking a Campaign
effectMail has a special email tracking mechanism, so you can easily see subscriber
activity. In-depth analytics data is available for you as soon as you send out your email
campaign. The campaign status page shows the standard information about your
campaign such as number of opens, clicks, unsubscribes, forwards, and bounces
statistics.

client require your knowledge and expertise to design, implement and test a database system.
You will provide a report detailing your suggested schema and advice. You will also provide
your SQL statements with appropriate comments and a full backup of your database schema
and example content.