Report/Query on Number of People Responding to Alerts in a Given Timeframe

Liz Pomper

Hello,

We need to find a way to either report or query on the number of people who have responded to at least 1 alert in a given timeframe. For instance, the number of people who responded to at least one alert between the dates of July 1, 2009 and April 30, 2010.

I can find the total number of actions taken by running an Alert Summary Report on all campaigns and filtering by date, but we are also interested in the number of unique individuals who have taken action.

Has anyone discovered how to do this?

Thanks so much for your help.

Liz

Director of Online Outreach

National Audubon Society

Mathew Grimm

I use one of the engagement factor fields, but that provides the rolling number of actions since the number-of-days-back that you specify. Trying to think about if I know a way to do it for two arbitrary dates...

Mathew

Noah Cooper

What you'd have to do is use the Constituent Interactions Count report in ReportWriter. You'd want to include the Alert Response column, and then specify a filter with your date range.

Mathew Grimm

Noah Cooper:

What you'd have to do is use the Constituent Interactions Count report in ReportWriter. You'd want to include the Alert Response column, and then specify a filter with your date range.

Which date range field am I specifying the dates for?

Liz Pomper

Noah Cooper:

What you'd have to do is use the Constituent Interactions Count report in ReportWriter. You'd want to include the Alert Response column, and then specify a filter with your date range.

What you'd have to do is use the Constituent Interactions Count report 
in ReportWriter. You'd want to include the Alert Response column, and 
then specify a filter with your date range. 

I am stuck at the "Configure Filters" page. I do not see where to specify a filter with my date range. The only filter with dates is "Creation Time," but that is the creation time of the constituent's record.

Is there a filter on interaction time, specifically advocacy interaction?

Noah Cooper

Mathew Grimm:

Which date range field am I specifying the dates for?

Doh, I confused myself looking at two different reports -- you'd actually want to use the Interaction Details report, and then you can filter on Interaction Creation Date. The Interaction Details report will give you one row per interaction of the given type, so this is really most useful for the use case described here, which is identifying all constituents with at least 1 alert response in the date range. If you're instead trying to, say, get all constituents who have taken more than 3 alerts, you'd have to do some Excel magic.

Liz Pomper

Noah Cooper:

Doh, I confused myself looking at two different reports -- you'd actually want to use the Interaction Details report, and then you can filter on Interaction Creation Date. The Interaction Details report will give you one row per interaction of the given type, so this is really most useful for the use case described here, which is identifying all constituents with at least 1 alert response in the date range. If you're instead trying to, say, get all constituents who have taken more than 3 alerts, you'd have to do some Excel magic.

Alas, the date range can only be 31 days in this report, so we wouldn't be able to look at interactions quarter by quarter, for instance.

I guess we could download month by month and then manipulate in Excel, but I am pretty surprised there is not an easy way to get this basic information (how many constituents took action in Quarter 1 of Year 2010)?

Thanks for your help in exploring different possibilities!

Noah Cooper

Liz Pomper:

Alas, the date range can only be 31 days in this report, so we wouldn't be able to look at interactions quarter by quarter, for instance.

I guess we could download month by month and then manipulate in Excel, but I am pretty surprised there is not an easy way to get this basic information (how many constituents took action in Quarter 1 of Year 2010)?

Thanks for your help in exploring different possibilities!

True, you would have to run the report one month at a time. You shouldn't need to manipulate in Excel at all, though, you'd just need to combine the report for all 3 months in the Quarter.

Liz Pomper

Noah Cooper:

True, you would have to run the report one month at a time. You shouldn't need to manipulate in Excel at all, though, you'd just need to combine the report for all 3 months in the Quarter.

Wouldn't that give us every advocacy participation, though? So if Constituent X participates in 3 advocacy campaigns in January, 2 in February, and 3 in March, I'd have to manipulate in Excel so that Constituent X only shows up once, to get a count of how many individuals participated at least once.

Noah Cooper

Liz Pomper:

Wouldn't that give us every advocacy participation, though? So if Constituent X participates in 3 advocacy campaigns in January, 2 in February, and 3 in March, I'd have to manipulate in Excel so that Constituent X only shows up once, to get a count of how many individuals participated at least once.

You could:

1) If you have Office 2007, just click the "Remove Duplicates" button and voila, or,

2) Take the combined file and do a group upload into Convio, since it doesn't matter if the same constituent appears in a group upload more than once. This would allow you to do further segmentation on the list, too.

Mathew Grimm

Liz Pomper:

What you'd have to do is use the Constituent Interactions Count report 
in ReportWriter. You'd want to include the Alert Response column, and 
then specify a filter with your date range. 

I am stuck at the "Configure Filters" page. I do not see where to specify a filter with my date range. The only filter with dates is "Creation Time," but that is the creation time of the constituent's record.

Is there a filter on interaction time, specifically advocacy interaction?

Just noticed in the "Advocacy Dashboard" there is a "Number of Constituents Taking Action" value for a timeframe of your choosing.