Adding Audience Lifecycle Status Tracking Fields

Background

• Audiences currently tracks Audience lifecycle status
• There is no way to know when the lifecycle status was last changed or who changed it

Business Need

• Track the timestamp when an Audience's lifecycle status changes
• Track which user or system process made the lifecycle status change
• Enable reporting and analysis based on status change dates and responsible parties
• Support accountability and audit trail for audience management

Proposed Solution

1. Add two new columns to the Audience table/entity:

   • "Lifecycle Status Updated Date" - timestamp of the last status change
   • "Lifecycle Status Changed By" - identifier of the user or system that made the change

2. Configure both columns to automatically update whenever the lifecycle status field is modified:

   • Date field: current timestamp
   • Changed By field: current user ID or system identifier

3. Make these fields visible in the IU interface alongside the lifecycle status

4. Include these fields in relevant reports, audit logs, and analytics views

Benefits

• Complete audit trail of audience lifecycle changes
• Accountability for status changes
• Ability to measure time spent in each lifecycle stage
• Support for time-based automation and workflows
• Enhanced reporting capabilities
• Ability to follow up with specific users who made changes when questions arise