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 a 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 the 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.
Note: 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 the LAST_CHANGED field. See the 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.
Note: Time in the LAST_CHANGED field is unedited if the user confirms his subscription through the confirmation hyperlink.