Hi,

Can you give more details on which version of Pega Marketing are you on ? 

Here is the initial thoughts on your questions:

1) List of campaigns that are to be executed daily - did you explore the "Marketing Calendar" functionality from the Pega Marketing portal ?   this should give you this details OOTB

2) Suspending recurring campaigns when our customer base is not refreshed - Given the BLOB in the tables, its not advised to directly modify the work tables. 

   This would break other processing in un expected ways. There are few variations you can possibly do this - but unfortunately that would mean taking over rules - 

    you need to contact product support on this requirement, otherwise if you take over rules, you might face upgrade issues in the future. 

    You should also see in the organization if you could manage this through better back end processes. For example - why would the customer refresh fail ? 

    can't that be made more fool proof than fixing the campaign side of it ? 

3) Notify user when a recurring campaign failed - This should be already happening OOTB - are you seeing issues ? There should be an email sent to the operator that scheduled 

   the campaign. Is that not enough and you need more than that ? 

4) Notifying user of the completion of campaign - when a program wraps up you should also see notifications I think - if you need a little better control look at PostExecuteProgramRunExt 

   activity (supported from PM 7.31) - there are precautions of using post processing - read the history of the rule for more documentation on that.

5) Notifying user when all emails or SMS are sent in a campaign - the email and SMS are asynchronous processing from the campaign execution and common for all campaigns running in parallel. 

   

   The tables should have a batch class column that corresponds with the campaign run class - 

   but any sort of table level trigger on these will kill performance of the app server and database. As these are very high volume tables.

   You will have to re-visit this with the business stakeholders on what degree of reporting you need here - you can possibly just run external reports to group by based on the columns which I mentioned to give summary of the pending queue. 

   There are backlog items to expose this to the administrators in future releases. 

Thanks for the fast respond,

Can you give more details on which version of Pega Marketing are you on ? 

Pega Platform: 7.3, Pega Marketing 7.22

1) List of campaigns that are to be executed daily - 
did you explore the "Marketing Calendar" functionality from the Pega Marketing portal ?  
 this should give you this details OOTB

Thanks, I am not aware of this function. I will explore it.

2) Suspending recurring campaigns when our customer base is not refreshed - 
    Given the BLOB in the tables, its not advised to directly modify the work tables. 
   This would break other processing in un expected ways. There are few variations you can 
   possibly do this - but unfortunately that would mean taking over rules - 
   
   you need to contact product support on this requirement, otherwise if you take over rules, 
   you might face upgrade issues in the future. 
   
   You should also see in the organization if you could manage this through better 
   back end processes. For example - why would the customer refresh fail ? 
   can't that be made more fool proof than fixing the campaign side of it ? 

At times, there are source system maintenance, network maintenance, etc, that caused the daily refreshing not to complete on time. When the campaign run occurred when the customer database is not refresh/during the refresh, we are not extracting the correct base.

That is why we need to suspend the campaign so that we will not encounter any issues with the campaign.

3) Notify user when a recurring campaign failed - 
   This should be already happening OOTB - are you seeing issues ? 
   There should be an email sent to the operator that scheduled 
   the campaign. Is that not enough and you need more than that ? 

I am not aware of this. May I know where and how can I configure it?

4) Notifying user of the completion of campaign - 
   when a program wraps up you should also see notifications I think - 
   if you need a little better control look at PostExecuteProgramRunExt 
   activity (supported from PM 7.31) - there are precautions of using post processing - 
   read the history of the rule for more documentation on that.

I will explore this, it may not be available in PM 7.30

5) Notifying user when all emails or SMS are sent in a campaign - 
   the email and SMS are asynchronous processing from the campaign execution and 
   common for all campaigns running in parallel. 

   The tables should have a batch class column that corresponds with the campaign run class - 
   but any sort of table level trigger on these will kill performance of the app server and database. As these are very high volume tables.
   You will have to re-visit this with the business stakeholders on what degree of reporting 
   you need here - you can possibly just run external reports to group by based on the columns 
   which I mentioned to give summary of the pending queue. 

I am aware of this. However, our environment requires to have such a dependency. E.g. We only blast out SMS upon total completion of sending emails. Therefore, it is crucial for us to know that every email/SMS has been sent out (at least reach the SMTP or SMSC) before we proceed with the next step.

Is the external report available in Pega? Or we have to develop ourselves?

   There are backlog items to expose this to the administrators in future releases. 

Are you able to advise what are the backlog items?

Regards.