RY_OPENMAIL_LOG, RY_EXP_EM_LOG and RY_FREQUE_QUE - How do these tables get populated
Hi,
I was looking into the logic of the Interactive Report process (RY_DIALOG_IR App Engine) in CRM 9.1 to see where the values are coming from. I noticed that for expired emails, it's getting the data from RY_EXP_EM_LOG, for queued email it's getting from RY_FREQUE_QUE and for open/re-opened emails, it's getting from RY_OPENMAIL_LOG.
Our records RY_EXP_EM_LOG and RY_FREQUE_QUE don't have any data. When are these two populated?
For RY_OPENMAIL_LOG, is there a cut off of the calculation or is it perpetual, i.e. will CRM keep track of open/re-open rate for all the emails sent forever?