Is your feature request related to a problem? Please describe.
The segment calculator currently uses an estimate for the character count of a custom field. However, when values for the custom field are loaded, it's much more accurate to calculate based on those values instead.
Describe the solution you'd like
- When a custom field value isn't filled in yet, use the current estimatation
- Once the value is filled in, use an avg length of the actual value to get the character count
Describe alternatives you've considered
Using the length of the 1st custom field value found (this may be preferred for performance, but it looks like an AVG(LENGTH((custom_fields::json)->>'field')) in prod currently is pretty quick
Is your feature request related to a problem? Please describe.
The segment calculator currently uses an estimate for the character count of a custom field. However, when values for the custom field are loaded, it's much more accurate to calculate based on those values instead.
Describe the solution you'd like
Describe alternatives you've considered
Using the length of the 1st custom field value found (this may be preferred for performance, but it looks like an
AVG(LENGTH((custom_fields::json)->>'field'))in prod currently is pretty quick