List Reports: How IP and Time fields get filled

Last Updated: Jan 10 2018 11:35 am UTC

When you are exporting your email list file, you can see the time and date when a subscriber gave their permission to receive newsletters. Below are the examples of the fields you can find exported file:

 

OPTIN_TIME — when the subscriber has given consent, the time of their subscription will show on this field.

 

  • The user confirmed their subscription by pressing the hyperlink which is made using the #[LIST:RECONFIRM]# merge tag in our template.
  • When the email user has subscribed using platform's web signup form.
  • The user pressed confirmation link in an email sent to him with the "Add one by one" function and platforms user has checked "send confirmation email" checkbox.
  • When the user pressed the confirmation hyperlink in an email sent from platform (you can send a confirmation email to subscribers when adding a new contact in the list using one by one function or by using API function).

OPTIN_IP — when the subscriber has given consent, their IP address will show up on this field.

  • The user confirmed their subscription by pressing the hyperlink which is made using the #[LIST:RECONFIRM]# merge tag in our template.
  • When the email user has subscribed using platform's web signup form.
  • The user pressed confirmation link in an email sent to him with the "Add one by one" function and platforms user has checked "send confirmation email" checkbox.
  • When the user pressed the confirmation hyperlink in an email sent from platform (you can send a confirmation email to subscribers when adding a new contact in the list using one by one function or by using API function).

CONFIRM_TIME — when the subscriber meets the conditions below, this field shows the confirmed time of the subscription:

  • The platform's user added an email to the email list and doesn't yet have the subscription consent in our platform.
  • Time, when email user has pressed "confirm hyperlink" but has already given permission trough subscription form and filled OPTIN_TIME. This is where double opt-in gets filled.

NB! If the email is added to the list manually by using the "Add contact one by one" function or through platforms API, the OPTIN_TIME or the CONFIRM_TIME fields won't be filled. Instead, the time of the subscription will be added in LAST_CHANGED field. See table for visualization.

CONFIRM_IP — in this field, the IP address is saved when these conditions are met:

  • The platform's user added an email to the email list and doesn't yet have the subscription consent in our platform.
  • Time, when email user has pressed "confirm hyperlink" but has already given permission trough subscription form and filled OPTIN_TIME. This is where double opt-in gets filled.

LAST_CHANGED — this field is filled with the time of the subscription when:

  • The user has subscribed through the web signup form, in which case the OPTIN_IP is also filled.
  • when the platform's user has added the email to the email list in the platform, the CONFIRM_IP and CONFIRM_TIME gets filled
  • when the platform's user has edited the subscriber's data like email, name or surname.

NB! Time in the LAST_CHANGED field is unedited if the user confirms his subscription through the confirmation hyperlink.


Was this article helpful?
What can we do to improve articles like this?

Copyrights © Mailigen. 2018 All rights reserved.