What is the purpose for some of the mailwizz DB fields?

Discussion in 'Common issues' started by imeow, Apr 3, 2017.

  1. imeow

    imeow Member

    Joined:
    Mar 2, 2017
    Messages:
    62
    Likes Received:
    14
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    Greetings!

    I would like to know the purpose for some fields. Because I am feeling myself that I am not using MailWizz as effective as I can use it. :)

    campaign_delivery_log table -> email_message_id, retries, max_retries, processed, delivery_confirmed
    campaign_bounce_log
    table -> processed
    campaign_forward_friend
    table (what is this for?)
    campaign_option table -> regular_open_unopen_action, regular_open_unopen_campaign_id
    campaign_temporary_source
    (what is this for?)
    delivery_server table -> must_confirm_delivery, max_connection_messages
     
  2. twisted1919

    twisted1919 Administrator Staff Member

    Joined:
    Dec 27, 2014
    Messages:
    10,477
    Likes Received:
    2,440
    @imeow - good questions :D
    email_message_id - we store a unique hash for each message we sent out so we can easily identify messages when processing bounces/complaints/etc for services that don't return the full headers we send. Amazon SES is such service for which we're using that column.
    retries - we used to retry sending a failed message, and this would keep the track of the retries.
    max_retries - maximum number of retries we were allowed to do before we give up.
    processed - this is a yes/no flag set from command like by the logs processor to mark a message as processed so that we don't process it multiple times.
    delivery_confirmed - some services will send notifications if the delivery was indeed okay, so we use this as a flag.

    Same as the processed column from above.

    We record the forward-to-a-friend here. If you insert [FORWARD_FRIEND_URL] tag in your email content, whomever clicks it, will reach a page where he can forward that campaign to a friend. We record this action in this table.

    This is used so that we know what action to take when a campaign with certain id is opened.

    It's the table that holds the list ids when they are merged for sending to multiple lists.

    must_confirm_delivery - this is used together with delivery_confirmed from #1 so that we know if we should wait for confirmation or not.
    max_connection_messages - max. number of messages we will push using a single smtp connection. When the number is reached, we close the connection and open a new one.

    Hope it makes sense.
     
    imeow and frm.mwz like this.

Share This Page