Author Topic: threshold for away mailings  (Read 803 times)

Offline Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 951
  • Karma: 42
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
threshold for away mailings
« on: May 19, 2010, 09:30:54 am »
Hello people,

Any reason why the bounce threshold for away is 3 before a contact is put on hold?  That seems a bit quick to me.  I would say that 10 is a more sensible level given that, as far as I know, this isn't really a bounce.

or how about setting it at 'infinity', given that this isn't actually a bounce?

Michael

Offline Piotr Szotkowski

  • Administrator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 55
Re: threshold for away mailings
« Reply #1 on: May 31, 2010, 10:41:32 am »
Any reason why the bounce threshold for away is 3 before a contact is put on hold?

I think it might’ve been conservative thinking (if we have a 10k mailing and 2k people are away three times, we’d rather not burden ourselves with mailing them), but I agree it doesn’t make much sense to me.

Quote
or how about setting it at 'infinity', given that this isn't actually a bounce?

Patches welcome (I think ‘infinity’ handling will need a code fix). :) The default table contents are in xml/templates/civicrm_data.tpl.

Offline Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 951
  • Karma: 42
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: threshold for away mailings
« Reply #2 on: June 24, 2010, 10:18:48 am »
Hey, this forum thread turned into an issue with patch :) http://issues.civicrm.org/jira/browse/CRM-6405

30 seems like a decent approximation to infinity in this case.

Although (and I don't know the answer to this because I'm ignorant of the bounce processing calculation) is there a time limit set when calculating whether a contact reaches the bounce processing threshold?  i.e. is it '30 bounces in the past [time period]' or '30 bounces (ever)'.  If it is the latter, then it is conceivable that someone could reach this limit within a year or so, depending on how much they were away.

Interested to hear thoughts on this...

Michael

Offline Piotr Szotkowski

  • Administrator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 55
Re: threshold for away mailings
« Reply #3 on: June 24, 2010, 11:33:03 am »
Hey, this forum thread turned into an issue with patch :) http://issues.civicrm.org/jira/browse/CRM-6405

This is exactly the thing we want to encourage; thanks for leading the way, Michael!

Quote
30 seems like a decent approximation to infinity in this case.

civicrm_mailing_bounce_type.hold_threshold is an UNSIGNED INT(10), so for ‘true’ ∞ you might want to go with 4294967295. ;)

Quote
Although (and I don't know the answer to this because I'm ignorant of the bounce processing calculation) is there a time limit set when calculating whether a contact reaches the bounce processing threshold?

Yeah, it’s actually set on a per-recipient basis and held in civicrm_email.reset_date; I think the date is, um, reset on every successful delivery.

Offline Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 951
  • Karma: 42
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: threshold for away mailings
« Reply #4 on: June 24, 2010, 11:58:28 am »
So then I think that 30 is probably a decent threshold.  Because if you receive 30 consecutive I am out of the office notices, then we should put them on hold IMO.

Not sure whether submitting a patch that adds a single character is actually worth submitting as a patch, but hey it's a start :)

Offline Piotr Szotkowski

  • Administrator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 55
Re: threshold for away mailings
« Reply #5 on: June 25, 2010, 05:39:34 am »
So then I think that 30 is probably a decent threshold.  Because if you receive 30 consecutive I am out of the office notices, then we should put them on hold IMO.

Agreed.

Quote
Not sure whether submitting a patch that adds a single character is actually worth submitting as a patch, but hey it's a start :)

No, you have it backwards – the smallest patch that actually fixes an issue is the most welcome. Great work. :)

Offline Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 951
  • Karma: 42
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: threshold for away mailings
« Reply #6 on: July 01, 2010, 04:18:16 am »
Any way you can work out if I get the prize for smallest patch ever?  I am guessing I am probably joint winner with a few others.  Perhaps a special prize for me given that my character was a '0'?

Offline Piotr Szotkowski

  • Administrator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 55
Re: threshold for away mailings
« Reply #7 on: July 01, 2010, 01:59:11 pm »
Any way you can work out if I get the prize for smallest patch ever?  I am guessing I am probably joint winner with a few others.  Perhaps a special prize for me given that my character was a '0'?

Oh, definitely; I think a couple¹ of drinks should be a good start towards a proper prize. (As we can’t do deliveries, you surely agree that it’s only reasonable for you to come for your prize to Warsaw.)

¹ hm, maybe the number should we somehow related to the patch itself…