Monday, December 3, 2018

Create a saved search to show the number of bounced campaign email per month.

To create a saved search that will show you the number of bounced  campaign email count per month, follow the steps below:

1. Navigate to Reports > Saved Searches > All Saved Searches > New > Campaign.

2. On the Criteria tab, add the following fields:
Response is any of Failed.

3. Go to the Results tab and add the following column fields:

- Formula Numeric (SUM) | DECODE (to_char({responsedate}, 'MM'), '01' , 1)

- Formula Numeric (SUM) | DECODE (to_char({responsedate}, 'MM'), '02' , 1)

- Formula Numeric (SUM) | DECODE (to_char({responsedate}, 'MM'), '03' , 1)

- Formula Numeric (SUM) | DECODE (to_char({responsedate}, 'MM'), '04' , 1)

- Formula Numeric (SUM) | DECODE (to_char({responsedate}, 'MM'), '05' , 1)

- Formula Numeric (SUM) | DECODE (to_char({responsedate}, 'MM'), '06' , 1)

- Formula Numeric (SUM) | DECODE (to_char({responsedate}, 'MM'), '07' , 1)

- Formula Numeric (SUM) | DECODE (to_char({responsedate}, 'MM'), '08' , 1)

- Formula Numeric (SUM) | DECODE (to_char({responsedate}, 'MM'), '09' , 1)

- Formula Numeric (SUM) | DECODE (to_char({responsedate}, 'MM'), '10' , 1)

- Formula Numeric (SUM) | DECODE (to_char({responsedate}, 'MM'), '11' , 1)

- Formula Numeric (SUM) | DECODE (to_char({responsedate}, 'MM'), '12' , 1)

Please note that each line represents a column for each month. '1' is for January, '2' is for February and so on.You may set your own custom summary label if preferred.

No comments:

Post a Comment