Note: You are viewing an old version of this page. View the current version.

EMAIL CAMPAIGN MANAGER DESCRIPTION

  • Email Manager Back-end Component

    1. Manages Email Campaigns internally
    2. Requests email tokens from the front-end (PHP) website.
    3. Delivers emails to addresses with with thankyou and optout tokens, taking note of bounces.
    4. Updates shared database (SQLite, Pgsql?) for the front-end to be able to display campaign status

  • Email Manager Front-end Component

    1. written in PHP, uses shared database to update user(s) on campaign status, progress, bounces, opt-outs, etc.
    2. Uses kohana Web/MVC framework.
    3. Requests Campaign information (create, delete, start, stop, etc.)

Database Schema

  • Tables

    1. Campaigns
    2. Processed
    3. Returned
    4. OptOuts?
    5. Cache

Tables

  • Campaigns

    1. id
    2. name
    3. status
    4. created_on
    5. updated_on

  • Processed

    1. id
    2. idnum
    3. status
    4. timestamp

  • Returned

    1. id
    2. group
    3. status
    4. timestamp

  • OptOuts?

    1. id
    2. idnum
    3. reason
    4. timestamp

  • Cache

    1. idnum
    2. first
    3. middle
    4. last
    5. address
    6. city
    7. state
    8. zip
    9. entered
    10. submttd
    11. uid