Database health
Every later check reads fields this section tells you to trust or retire, so it runs first. The counts come from our discovery method.
- Field fill ratesFor every field (Marketo field, HubSpot property, Pardot prospect field), count the records holding a value and note when it was last written. Few values and no recent writes make a field a candidate to retire.
- Duplicate person recordsIn Marketo and Account Engagement, count duplicates by email address, including the same address in different casing, and note which system created each copy. HubSpot keeps one contact per email address, so there, look for the same person under a second address.
- Country and State valuesList the distinct values in each. Several spellings of one place means no trigger campaign, workflow or automation rule is normalising them on create and update.
- The suppression listConfirm it holds all four inputs: hard bounces, global unsubscribes, complaint and spam-trap flags, and the manual do-not-contact lists that legal, HR and sales usually keep in spreadsheets.
- The unsubscribe pathMap the platform’s opt-out field (Unsubscribed, in Marketo) to the CRM opt-out field and any consent fields, and write the mapping down if nobody has.
- Consent evidenceFor each population you mail, find the lawful basis, point of capture, date and where the proof sits. Flag any population without evidence in the platform.