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

    • Third Party MySQL Database Sync

    This section will deal with the data synchronization tools available on the system. This tool will help you to keep your data synchronized to a 3rd party MySQL database.

    If for instance there are several systems within your corporate structure such as ERP or CRM solutions you may need to keep your Email Marketing data in sync with these other systems so that you can easily implement any required list synchronization procedures.

    list syncronization

    List Synchronization

    Status
    You can use this drop down to enable and disable the synchronization.
    Frequency
    You can define the frequency to sync your data to the third party database using the following options.
    (1) Every hour
    (2) Every month
    (3) Every week
    (4) Every day
    Host Address
    Host address of your third party database where you will be syncing your system subscriber data.
    Port
    You can leave it 3306 which is a default mysql port but if there is any custom port you can change it anytime.
    Username
    Enter the username you use to connect to this database
    Password
    Enter the corresponding password for the username you specified.
    Name of the database
    Name of the database you wish to create the list synchronization with.
    SQL Query
    SQL Query which can select the necessary database tables and columns for synchronization of the list data.

    Once all the options are populated the synchronization will be created. If there is an error it will be displayed on the screen.

    mysql sync

     

    next topic Subscription / Un-Subscription Behaviors