Content / help / marketing .. concise-view << previous next >>

SITENAME Marketing

The main marketing process is emailing. To launch an emailing campaign, you need to collect names with email addresses. These email addresses corresponding to prospect names will generally be stored on a mySQL table. Our emailing strategy allows for these name/email address pairs to be picked up from any part of the mySQL database, using an SQL select query , which is defined as part of the mailing list.

Separation of mailing content from mailing list

We have two separate table. One defines the actual email content and which list of addresses to use, the other defines the list of addresses. This table join allows email the sender to select which list of email addresses to use.

An understanding of the database tables is generally useful. Even if only to give you a rough idea of the kind of information that is stored and used to produce emails.u

The Biscuits Email marketing DB Tables

et_mailing (Stores the content of the email)

id int(12) NO PRI  auto_increment 
subject varchar(255) NO    
content text NO    
mailing_list int(12) NO    

The first table is et_mailing. This table stores the actual content of the email that may be sent to everyone listed to receive it. The control over actual sending of this content and the number of times it is sent is not stored in this table. This table is only a way of bundling the content of the mailing.


id int(12) NO PRI  auto_increment 
name varchar(255) NO    
select_query varchar(100) NO    

Mailing lists are defined on the table et_mailing_lists This is the table that lists all the recipients of any particular top level table, storing general information about this mailing.

Note: Each mailing has a stored SQL query that must return the values:
  1. Name
  2. email address
Click on show all Mailings to see the SQL queries which select these name and address values. They may come from anywhere on the database.

Information from this table

  1. The list of email addresses to send to (via a selection from a table containing these addresses)
  2. The email content, in the form of html containing mail merge style database information along with the main content. Eg: Dear @firstname, ....
  3. Information about when the mailing was sent. (The information about who recieved the email or who opened the email is not stored here but is found from analytics information gained from magic pixels and links that were sent with the email.

Mailing lists define a list of recipients. They can be a SQL statement that retrieves the list of recipients. A mailing must have a mailing list attached to it before it is sent. To attach this mailing list to a mailing, update mailing


id int(12) NO PRI  auto_increment 
name varchar(150) NO    
email varchar(255) NO MUL   
label varchar(255) NO    
timestamp int(12) NO    
deleted tinyint(1) NO    

Mailing lists can be selected from any SQL query, but this table provides a general table to store subscribers names and email addresses in. You can insert an email subscription form into any pages using the $buttons class

Subscription Code Example

subscribe echo $buttons->makeButton(array('name' => 'subscribe', 'onsubmit' => "biSubscribe('wordties');", 'class' => 'far-right'));

String Tokens

These string tokens will be replaced with recipient information.

&name &email

Further Development Considerations

  1. What about reply addresses? Can we have SITENAME addresses?

iBiscuits LOGO