From 3 Days to 1 Hour:
The Alteryx Fuzzy Match Pivot.

The Marketing Attribution Business Challenge

Marketing spend only works if you can prove it works. We discovered a significant gap in our attribution data: thousands of orders—both from call-in centers and online portals—were failing to link to active marketing offers. The major culprit was our direct mail initiatives, specifically high-volume catalogs.

The breakdown occurred due to Dirty Data in company records. In a manual entry environment, a single entity like 3M might be recorded as MMM, Minnesota Mining and Manufacturing, or 3-M Co. Because names were captured inconsistently across databases, the system couldn’t recognize that a catalog recipient and a purchaser were the same entity, creating a wall between marketing investment and revenue credit.

Implementing the Double Metaphone Algorithm

To tear down this wall, we developed an automated “Fuzzy Match” engine in Alteryx Designer using a three-stage normalization and matching process.

Standard matching looks for identical spelling; we looked for identical sounds. Double Metaphone is a phonetic algorithm that reduces company names to their core sounds. By generating phonetic keys, we matched “Minnesota Mining” to its shorthand variants, ensuring data captured over the phone matched the original catalog mailing list—regardless of the scribe’s spelling.

The Result: More Marketing, Less Data Analysis

This shift allowed the team to spend more time marketing and less time analyzing data. Reclaiming these hours meant high-value assets were finally freed to focus on creative strategy and campaign optimization rather than manual spreadsheet reconciliation.