Salesforce Certified Marketing Cloud Engagement Administrator free question 10 / 10 · Domain 5: Maintenance
An administrator wants one year of subscriber status changes (such as Normal to Unsub) from the Tracking Extract StatusChanges file. Which statement matches the StatusChanges article?
- The file comes out in Excel format only, and can't be output as CSV or TAB
- Only data from the most recent six months is available, so one year can't be extracted
- One year of data can be extracted, and the date and time of each change is included
- Status changes aren't recorded, so compare the Subscribers files instead
Show the answer and explanation
Answer: B
Why this is correct
The article says the StatusChanges file shows instances of change in a subscriber's status, and that only data from the most recent six months is available. The output formats are CSV and TAB. The columns include the status before and after the change (OldStatus, NewStatus) and the date and time of the change (DateChanged), with status values Normal, Held, Unsub, and Deleted.
Why the other options are wrong
"One year of data can be extracted, and the date and time of each change is included" … The article says only data from the most recent six months is available, so a year can't be extracted.
"Status changes aren't recorded, so compare the Subscribers files instead" … The article says the StatusChanges file shows instances of change in a subscriber's status, so changes are recorded.
"The file comes out in Excel format only, and can't be output as CSV or TAB" … The article gives the output formats as CSV and TAB.
Key point
The SubscriberKey column holds the same value as the email address by default. The extract contains records of status changes.