Updating Received Field via Import

Follow

This article goes over the Allow import of "received" field setting found in the advanced settings of suppression lists & campaigns. With this setting enabled, you can achieve two things. You can update existing leads in a suppression list and force the "received" time to update to the current time. The other option is to have a "received" column in your import which you can use to overwrite the existing "received" time via import add or import update for both suppression lists and campaigns.


PLEASE NOTE:

With regular campaigns this functionality cannot be enabled if at least one lead already exists in the campaign.

With suppression lists, this functionality can be used at any time.

With the setting enabled, the campaign can no longer appear in reports.

 

Step 1 

Ensure you have this box checked on your campaign advanced settings:

Image_2020-03-19_at_11.32.24_AM.png

 

Setting the received date to the current time when updating a suppression list via import.

The tickbox pictured below is only available for suppression lists, not regular campaigns - but you can still update the "received" for regular campaigns as per the example at the bottom.

When you import > update leads into your campaign you will see an additional checkbox:

 

By ticking the box above, any leads which are matched will have their received timestamps updated to the time of import.


Adding new leads to a campaign / suppression list, setting their "received" time to a set value in a CSV column.

 

When importing new leads into the list, you just need to match your file's "received" to the "received" destination field.

 

 

Updating existing leads in a campaign / suppression list, setting the "received" time to a set value in a CSV column.

 

When updating existing leads in a suppression list, you just need to match your file's "received" to the "received" destination field.

 

 

Please note, when updating leads with a set "received" time, do not tick "Update timestamp on match" at the bottom as this will update the "received" to be the current time, as per the first example in this article.

 

The Date format must be: yyyy-mm-dd hh:mm:ss

 

If you have any other questions please feel free to raise a support ticket.

 

Was this article helpful?
0 out of 0 found this helpful

Comments