Why are there discrepancies in the number of contacts between the widget previews in Social Good Software and the actual contacts synced to Constant Contact?

The discrepancies occur due to duplicate rows generated in Altru. When querying various output fields, the same contact may appear multiple times. Social Good Software only pulls one email address per contact into Constant Contact, resulting in a smaller number of contacts in Constant Contact compared to the query results. The records marked with triangle icons in the duplicates list are identified as duplicates and are not sent to Constant Contact; only the original records are added.