- Go to Information Library > Analysis
- Click "Add an Ad-hoc query"
- In the left-hand pane, browse to and select the "Community Emails Received" field
- In the middle-pane, double-click "Date Sent"
- In the new window that pops up, select “Is” and "Last quarter" (respectively. 'Last Quarter' will cover the suggested prior 90 days)
- Click "OK"
- In the middle pane, double-click "Opened"
- Confirm the values of "Equal to" and "Yes", then click "OK"
- In the middle pane, double-click “Clicked Through”
- Confirm the values of "Equal to" and "Yes", then click "OK"
- In the top right-hand pane under the "include records where" section, select the "Opened" line and click the '(+' button
- With the "Clicked Through" line selected, click the ')+' button
- With the "Clicked Through" line selected, click the ‘or’ button
Your final query window should look like the following:
