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