User Manager Campaign expiry Email Notification

[GeSaviynt]

Hi Team,

Can you please suggest a approach for below 'usecase', because it's not possible to achieve from configuration.

Once campaign expires, automatically send the escalation emails as such

1 day after expiration -> Email reviewer and CC reviewer's manager
2day after expiration -> Email reviewer and CC reviewer's manager, reviewer's manager's manager
3 day after expiration -> Email reviewer and CC reviewer's manager, reviewer's manager's manager, reviewer's manager's manager's manager
4 day after expiration -> Email reviewer and CC reviewer's manager, reviewer's manager's manager, reviewer's manager's manager's manager, reviewer's manager's manager's manager's manager.

Thank you in advance

Geeta

[Saathvik]

You may have to use analytics report to notify after expiry. Build an SQL query to identify such expired campaigns and the send email using analytics

[GeSaviynt]

Thank you Saathvik.

Do you have any Sample query?

Thanks

Geeta

[dgandhi]

By default , there is only 1 placeholder for sending email notification on campaign expiry.

To achieve your use case , you can develop custom jar solution and send email notification based on your business requirement.

If you want the same OOTB in product then raise enhancement request in ideas portal.