OpenEMM Technical Support Forum

Posted: **Fri Jun 10, 2011 6:05 pm**

Hello,

We have many recipients with many interests which we would like to talk with them about through an email delivery system. We want to talk about each of their interests separately in the emails and yet we don't want to be viewed as talking too much, or spamming.

Say, for example, we may have more than 30 interesting topics to discus, and would like to send one out a mailing each day for a new topic each day of the month, recurring monthly. And we know that our recipients may have many overlapping interests but we don't want to be sending an email to the same person every day, even if they have an interest that we have not talked to them about yet. We don't want to spam them.

Is there any way to keep track of the last date that the recipient was included in any mailing? For example, if we created a date field in the Profile database such as Date_Last_Contacted, is there any way to update this field automatically with every mailing that is sent out?

Thank very much, have a wonderful day!

Posted: **Fri Jun 10, 2011 6:08 pm**

Have a look at the mailtracking table:

Code: Select all

mailtrack_tbl
-------------
Table description: 
Contains a record for every recipient and every mailing he/she got (big table!).

Column name:        Description: 
mailtrack_id        ID of mailtracking record (auto-generated) 
customer_id         ID of recipient (-> customer_1_tbl.customer_id)
mailing_id          ID of mailing (-> mailing_tbl.mailing_id)
status_id           ID of mailing status (-> maildrop_status_tbl.status_id)
company_id          1 
change_date         Date of last change for this record

Posted: **Mon Jun 13, 2011 3:17 pm**

Thank you very much!

This looks very encouraging, but please tell me,
what conditions must be met in order for a recipient's mailing to be recorded in the mailtrack_tbl table?

We have a couple thousand emails sent but only a few hundred recorded.

Take care!

OpenEMM Technical Support Forum

Keeping track of Recipient mailings

Keeping track of Recipient mailings

Re: Keeping track of Recipient mailings

Re: Keeping track of Recipient mailings