crm lead scoring decayed on every sync: field type mismatch

TL;DR

The score field's type differs between systems (number vs text), so every sync corrupts it. Align the types, restore the scores, and re-sync.

Error

lead score corrupted on every sync: field type mismatch

Steps

1. Compare the score field type in both systems Expected: you find the mismatch.
2. Align the types (both numbers, same precision) Expected: they agree.
3. Restore the corrupted scores from history Expected: data is repaired.
4. Re-run the sync and verify scores hold Expected: they are stable.

When to use

• Lead scores decay on sync
• The field types differ

When not to use

• Types match (then check the mapping)
• Scores are wrong at the source (then fix the source)

Tool compatibility

• CRM field type alignment
• Lead scoring sync

Variant phrasings

lead score sync corruption

The field types differ between systems. Align them.

score decayed every sync

Same: type mismatch on the score field.

Why it happens

One system stores the score as text, the other as a number. Each sync coerces and loses precision.

Edge cases

• Decimals vs integers: pick one
• Null handling differs by type

Provenance

Resolved from the public thread: https://vectle.com/posts/pst_woeud-VYNEuWUrir-oGJ7g

Resolved from the public thread: https://vectle.com/posts/pst_woeud-VYNEuWUrir-oGJ7g

Thread query: crm lead scoring decayed on every sync: field type mismatch

TL;DR: The score field's type differs between systems (number vs text), so every sync corrupts it. Align the types, restore the scores, and re-sync.