Direct Mail Step 1 - Database

NAME

SYNOPSIS

DESCRIPTION

Test list ( sed_directmail_test )

• email
• lg

Lists ( sed_directmail_list )

• description
• list

Email to be sent ( sed_directmail_transmit )

• uid_status
• uid_list
• unsub

Campaigns Templates ( sed_directmail_templates )

• template_name
• html
• txt

Tracking ( sed_directmail_track )

• uid_status
• uid_user
• sn_cdate
• url
• operation
• email
• agent
• ip
• cookie
• os
• osver
• browser
• browserver
• country_code
• region
• region_name
• city

Statistics ( sed_directmail_stats )

• sn_cdate
• nb_email
• username
• uid_campaign
• uid_status
• nb_mail_double
• nb_email_unsub

Status ( sed_directmail_status )

• texte
• ck
• segmentation_by_language
• template
• list
• name
• status
• sn_cdate
• sn_mdate
• uid_campaign
• pid
• nb_email
• estime
• result_file
• errorfile
• total
• start
• bounceto
• date
• format
• mailform
• mailtest
• mailtestto
• nbmailtest
• replyto
• selectby
• subject
• time
• username
• nb_email_double
• nb_email_transit
• nb_email_unsub
• job
• asap
• format_texte

Unsubscribe ( sed_directmail_unsub )

• email
• all_list
• list

Mail Campaigns ( sed_directmail_campaign )

• ck
• segmentation_by_language
• template
• list
• name
• subject
• mailform
• format
• mailtest
• mailtestto
• nbmailtest
• asap
• date
• time
• replyto
• bounceto
• selectby
• format_text

EXAMPLES

AUTHOR

Written by Chantal Ste-Marie, <chantal.ste.marie@sednove.com>