To create a Saved Search that shows users the number of sent Campaign Email count per month, follow the steps below:
1. Navigate to Reports > Saved Searches > All Saved Searches > New > Select Campaign.
2. Enter Search Title.
3. On the Criteria tab, add the following field:
- Response is Sent.
4. Navigate to Results tab and add the following column fields:
- Field: Formula Numeric | Summary Type: Sum | Formula: DECODE (to_char({responsedate}, 'MM'), '01' , 1)
- Field: Formula Numeric | Summary Type: Sum | Formula: DECODE (to_char({responsedate}, 'MM'), '02' , 1)
- Field: Formula Numeric | Summary Type: Sum | Formula: DECODE (to_char({responsedate}, 'MM'), '03' , 1)
- Field: Formula Numeric | Summary Type: Sum | Formula: DECODE (to_char({responsedate}, 'MM'), '04' , 1)
- Field: Formula Numeric | Summary Type: Sum | Formula: DECODE (to_char({responsedate}, 'MM'), '05' , 1)
- Field: Formula Numeric | Summary Type: Sum | Formula: DECODE (to_char({responsedate}, 'MM'), '06' , 1)
- Field: Formula Numeric | Summary Type: Sum | Formula: DECODE (to_char({responsedate}, 'MM'), '07' , 1)
- Field: Formula Numeric | Summary Type: Sum | Formula: DECODE (to_char({responsedate}, 'MM'), '08' , 1)
- Field: Formula Numeric | Summary Type: Sum | Formula: DECODE (to_char({responsedate}, 'MM'), '09' , 1)
- Field: Formula Numeric | Summary Type: Sum | Formula: DECODE (to_char({responsedate}, 'MM'), '10' , 1)
- Field: Formula Numeric | Summary Type: Sum | Formula: DECODE (to_char({responsedate}, 'MM'), '11' , 1)
- Field: Formula Numeric | Summary Type: Sum | Formula: DECODE (to_char({responsedate}, 'MM'), '12' , 1)
5. Click Save & Run.
Note: Each line represents a column for each month. \
1 is for January
2 is for February and so on.
Users may set own custom summary label if preferred.
No comments:
Post a Comment