Bug: Wrong stats on campaigns list page

[crayolakat]

Describe the bug
On the campaigns list page, the "Unassigned" and "Needs Response" stats show the wrong values, or no value at all sometimes. Unable to reproduce at will but it happens to certain campaigns on our production site which is deployed on AWS Lambda and uses Redis.

Expected behavior
Numbers should be accurate. The "Unassigned" value for a campaign should correspond to the following SQL:

SELECT COUNT(*)
FROM campaign_contact cc
WHERE cc.campaign_id = <campaign_id> AND cc.assignment_id IS NULL;

The "Needs Response" value for a campaign should correspond to the following SQL:

SELECT COUNT(*)
FROM campaign_contact cc
WHERE cc.campaign_id = <campaign_id> AND cc.is_opted_out = 'false' AND cc.message_status = 'needsResponse';

Screenshots

Platform:

• OS: macOS
• Browser: Chrome
• Desktop
• Version: 106.0.5249.61

Additional context
These "Unassigned" and "Needs Response" counts are stored in Redis and calculated when certain actions are taken. I believe somewhere along the way, the calculations are going wrong or aren't happening at all. I also think the "Needs Response" count isn't excluding opt-outs