Why Your Ad-Platform Match Rate Is Low
8apps Team ·
The upload worked, the audience is tiny. Work through these causes in order – most low match rates are one formatting mistake, found in under ten minutes.
#customer match
6 articles
Format Phone Numbers to E.164 in Google Sheets
8apps Team ·
E.164 is the format ad platforms and APIs expect – and the one spreadsheets quietly destroy. Here's how to get +6591234567 out of whatever your column holds now.
Prepare a Google Ads Customer Match List in Sheets
8apps Team ·
The upload succeeds either way – the match rate is what fails. Here's the Sheets-to-Customer-Match workflow with Google's own formatting rules at each step.
Hash Email Addresses Correctly in Google Sheets
8apps Team ·
Email hashing fails on casing, invisible spaces and Gmail's dot rules – not on the hash. The normalisation order that makes digests actually match, platform by platform.
Salted vs Unsalted Hashes for Audience Uploads
8apps Team ·
Security guides say always salt your hashes. Ad platforms can't match salted data. Both are right – here's the difference, and what it means for how you handle upload files.
How to Hash Phone Numbers and Emails in Google Sheets
8apps Team ·
Sheets has no built-in SHA-256 function. Here is how to hash a customer list properly - and why the same phone number needs two different hashes for Google Ads and Meta.