Connection Campaigns not honoring Number of Days Between Connection

[mikedotmundy]

Description

When trying to create a new Connection Campaign, I noticed in both our production (v13.6) and dev (v14.0) instances that the Number of Days Between Connection setting is not functioning properly.

What I found is that a person will not be included in the Connection Campaign if they have had a Connection Request completed within that Opportunity in the past (even if it was completed outside the value in the Number of Days Between Connection field.)

In my testing, I have the value of Number of Days Between Connection set to "30". People with a Connection Request completed past that 30 day mark were still not included in the Campaign.

However, setting the Number of Days Between Connection value to a lower value, such as 1, 2, 3, 4, etc, then the correct number of people have a Connection Request created for them.

I was unable to duplicate this on the demo site because of the need to have "Connected" Connection Requests in the past.

In order to test this, here is what I did.

1. Used the same DataView for both Connection Campaigns listed in the next 2 steps.
2. Created a Connection Campaign in a Connection Opportunity we use regularly. Several people in the DataView have had requests completed in the past within this Opportunity (outside 30 days).
3. Created a second Connection Campaign in a different Connection Opportunity where no one in the DataView has ever had a request created for them.

This is the DataView used in both Connection Campaigns:

Both Connection Campaigns have the same value for Number of Days Between Connection -- "30"

This is now a screenshot of the Campaign List block.

• The first Campaign called "bus test" is the Opportunity that no one in the DataView has ever been a part of. You will see 19 people are pending, the same amount as the DataView. (This is correct).
• The second Campaign called "staff" is the Opportunity where several people in the DataView have had Connection Requests before, however it was far outside the 30 day value in the Number of Days Between Connection field. Only 10 people are included. All 19 should have been included (because all 19 are outside the 30 day value in the Number of Days Between Connection field.)

I happen to be one of the people who, from the second Campaign, have had a Connection Request created for myself. As you can see from the screenshot below, the request was Connected/Completed in May 2021 (over a year ago).

So, I should have been included in the campaign and had a new request created for myself, because I was outside the 30 day value in the Number of Days Between Connection field.

This was a rather difficult one for me to write up and explain so if you need me to do further explaining or testing, please let me know.

Expected behavior:

Number of Days Between Connection work properly.

Actual behavior:

Number of Days Between Connection not working properly.

Versions

• Rock Version: [v13.6, v14.0]
• Client Culture Setting: [en-US]