I was just inspecting the data in the nms:address table.
I know that records generated with a status of quarantine are added to this table as a result of an email address hard bouncing (or soft bouncing many times).
What I'm not sure about is the difference between Creation date and Update status columns.
I understand that the creation date is the first time the record is added to the table (e.g. the first time that email address hard bounced).
But what does the update status field indicate?
How is updated? How can it be different from creation date? (in my head I thought once a record bounced and it was added to the table, it gets excludes any recipient records with matching email addresses from future email deliveries - which it is doing - so therefore it cannot bounce again to modify the record in the nms:address table).
Any insight appreciated.
Below is a sample of records with difference update status dates vs creation dates.
The LastModified column is changed for people moving from SoftBounce to either HardBounce (usually after 5 days except if you changed Delivery factory/default values) or Valid (until the nightly cleanup job deletes these lines), and also coming from the ESP (Gmail, Yahoo, etc) feedback look (see Documentation by searching for Feedback_loop, there are several articles) a few hours or day later.
What it is weird in your screenshot, is that update date is approximately one month later.
Might you check your deliveries value for validityDuration element? I wonder if the validity of your deliveries could be 1 month, so every day it could be attempts to send and consecutive updates.
I appreciate that manually changing the record in anyway would update the "Update status" date/time to current date/time - However I am not ever editing records in this table (neither are any other operators)... so there must be a process that causes this, and it is this that i'm looking to understand further.
That makes sense, but my question really is - what process does Adobe Campaign have that would modify the records in this table and thus cause the date to change?
(as it's not a manual edit of records by an operator that is causing the modification)
As I said, in my head I thought once a record bounced and it was added to the table, it excludes any recipient records with matching email addresses from future email deliveries - which it is doing - so therefore it cannot bounce again to modify the record in the nms:address table.
If you will check the schema or form of "nms:address", you can see that the name for the "Update Status" column is "Last Modified" in the schema.
Update date (@lastModified)
So, Creation date basically is the date when the Record Is being inserted for the first time in the "nms:address" schema, whereas , Update Status is the date whenever some modifications are made to that record in the same schema.