Sync Errors from bad State/Country Picklist Values
This one hurts just thinking about. Salesforce is VERY specific when it comes to correct state and country values and Pardot… well, not so much.
You surely know the pain of trying to match all of the variations of spelled out, abbreviated and “what the heck is that” state and countries values to Salesforce’s clean, strict list. This is actually the very first use case we solved with the Prospect Updater. You maintain a list of various spellings and abbreviations for states and countries (don’t worry, we have a big list you can start from) and Prospect Updater will check your database frequently for bad values and will replace them, automatically.
This, combined with the form handler data cleaning, can almost ensure that you never have to deal with this sync error again.