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