Use Case
Sometimes deleted accounts showing up as a part of UM/EO campaign. This happens when a campaign is launched, it creates a snapshot of the point in time data so if an account gets deleted after the campaign is launched, it shows up at step 2 of a user manager or an entitlement owner campaign.
Pre-requisites
Campaign is launched successfully
Applicable Version(s)
All
Solution
To confirm if the accounts were deleted after the launching the campaign, run the below query as analytics
SELECT
campaign.CAMPAIGN_NAME,
certification.CERT_NAME,
accounts.NAME,
accounts.UPDATEDATE,
certification_account.STATUS AS 'POINT_IN_TIME_STATUS',
accounts.STATUS AS 'LIVE_STATUS'
FROM
campaign,
certification,
certification_account_entitlement1_status,
certification_account,
accounts
WHERE
campaign.id = certification.CAMPAIGNKEY
AND certification.CERTKEY = certification_account_entitlement1_status.CERTKEY
AND certification_account_entitlement1_status.CERT_ACCOUNTKEY = certification_account.CERT_ACCOUNTKEY
AND certification_account.ACCOUNTKEY = accounts.ACCOUNTKEY
AND accounts.STATUS = 'SUSPENDED FROM IMPORT SERVICE'
AND campaign.campaign_name = 'ABV_XYZ';
Please note that in the above query, change the campaign name according to your requirement and run the query.
POINT_IN_TIME STATUS will give you the status of that account from the time when campaign was launched and LIVE_STATUS will give you the current status of the account which would be 'SUSPENDED FROM IMPORT SERVICE'
If you see data getting populated with this query, then it will confirm the root cause. If you rerun the campaign then the deleted accounts reported in the query would not show up.
