Documentation

How to export quarantines per country in Campaign Standard

Last update: Mon Jun 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

This article explains how to link quarantines to profiles in Adobe Campaign Standard.

Description description

Environment

Adobe Campaign Standard

Issue/Symptoms

How can you export quarantines per country?

Resolution resolution

  • Quarantines are in table NmsAddressStatus

    • They are linked to the last delivery but not to any profile.
    • They contain the “normalized” recipient address (e.g., lower case for email / + prefix for mobile phone).

  • There are 2 options to link them to profiles:

  1. Join to profile via the address field on the AddressStatus and Email/mobilePhone on the profile.

    • This would not return those records where the address is not normalized on the profile level.

  2. Join to profile via looking up all delivery logs (they also contain normalized recipient address).

    • This would only return data for the last 6 months and nothing for older hard bounces.
    • This would return profiles where the recipient address has been changed/corrected already.

recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f