Guide Index

  • Getting Started
    1. Account Login and Overview
    2. Setting Up Your Mailing lists
    3. Integrating With Your Website
    4. Importing Email Addresses
    5. Sending Your First Campaign
  • Advanced List Functions
    1. List Settings
    2. Custom Fields
    3. Auto Responders
    4. List Segmentation
    5. MySQL Database Sync
    6. Subscription Behaviors
    7. Subscription Forms
    8. Website Integration
    9. Suppression Lists
  • Advanced Subscriber Management
    1. Add Subscribers Copy/Paste
    2. Add Subscribers File Upload
    3. Add Subscribers MySQL
    4. Browse Subscribers
    5. Delete Subscribers
    6. Export Subscribers
  • Advanced Campaign Management
    1. Creating New Campaigns
      1. Using HTML Code
      2. Template Gallery
      3. Previous Campaigns
      4. Using a Web URL
    2. Google Analytics
    3. Using A/B split testing
    4. Campaign Attachments
    5. Personalizing your email
    6. Email Content Analysis
    7. Campaign Preview
  • Email Templates
    1. Managing Tags
    2. Sub-Client Accounts
  • Statistical Data Analysis
    1. List Statistics
    2. Campaign Statistics
  • Adding Subscribers using external MySQL Database(s)

    add subscribers

    This screen will help you choose the method you wish to use for adding new subscribers - for this example we will use the "External MySQL Database" method.

    add subs mysq

    Step 1

    import mysql

    Host Address
    Enter the host address for your external MySQL database Port
    Define the MySQL Port number in case if its not running on a standard port 3306 Username
    Enter the username for accessing the mysql database Password
    Enter the password Database
    Enter the name of the database SQL Query
    Enter the SQL query in order to select the records from the database

    Step 2

    map fields

    Match the subscriber fields

    Here you will need to map the fields within your system with the import data fields. If you have custom fields within your mailing list they will be displayed in the drop down.

    You should always map the email address field with the email address within import data.

    There is an option to ignore certain fields as well if you do not wish to import them.

    Import Settings

    If you are going to import new subscribers to the list always select "Don't add to suppression list" option.

    If you are importing subscribers to suppression list global or list based then select the appropriate option

    Update subscriber information of duplicates with import data
    Enable this option so that when you import the data for the subscribers which are duplicate or subscribers already within the mailing list then their information will be updated with the new imported information.
    Do not send opt-in confirmation email, subscribe immediately
    If this option is ticked the system will not send the opt-in confirmation email and will just subscribe the subscriber immediately to the mailing list
    Trigger auto responders, subscription behaviors, web services and update statistics
    If you enable this option the system will trigger auto responders, subscription behaviors and web services actions related to the mailing list you are importing your subscribers to.

    Once the options are populated click on the "Next" button to proceed to the import results step. The result screen will give you the details about the import process completion.

    import complete


    next topic Browse Subscribers