If you uploaded a CRM file to Loop and found that it did not match any data, consider the following key factors:
1. File Format and Processing Considerations
File Format: Your file must be in
.csvformat. It can contain raw (unhashed) data or hashed data (SHA-256 or SHA-512).Automatic Hashing: If your data is not hashed, Loop will automatically apply hashing before processing.
Processing Time: The matching process is fast. After uploading, click "Reload" in the segment view to check the updated status.
2. Data Formatting Guidelines
To ensure a successful match, follow these specific data formatting rules:
Mobile Ad IDs (MAIDs)
Must be uploaded in raw format (not hashed).
Emails
If uploaded unhashed, all emails must be in lowercase.
✅ Correct:
[email protected]❌ Incorrect:
[email protected]
National Identifiers (e.g., DNI, SSN, etc.)
Only numbers are allowed.
Remove any special characters (e.g., dots, dashes, spaces).
✅ Correct:
34848988❌ Incorrect:
34.848.988
Saving CSVs with national identifiers:
If using Microsoft Excel or Google Sheets, even if numbers appear correctly in the spreadsheet, verify that the file format preserves them as raw numerical data when exported as
.csv.
Phone Numbers
Format:
(Country Code)(Area Code without 0)(Phone Number)Do not include extra digits or special characters.
✅ Correct Examples:
Argentina:
541151190123Peru:
51900480292
❌ Incorrect Examples:
5491134829888(Incorrect for Argentina; the9should be removed)✅ Corrected:
541134829888
3. Common Issues That May Prevent Matches
Missing Required Fields:
If an identifier is uploaded without specifying its type (e.g., email, phone, MAID), the system may reject the record.
❌ Incorrect:
✅ Corrected:
ml_raw [email protected]
4. Market-Specific Data Availability
Depending on the country or dataset, available matching data may be limited.
If your uploaded file is correctly formatted but returns a low match rate, it might be due to low market coverage.
5. How to Verify If Your Upload Was Processed Correctly
Check the Segment Status:
Click on the three-dot menu (⁝) next to your segment and select "View" to review the details.
Key Insights Available in the Segment View:
Total data rows processed
Accepted lines vs. rejected lines
Match percentage
This section helps confirm whether your data was properly ingested or if corrections are needed.
By following these guidelines, you can ensure a higher match rate when uploading CRM files in Loop. If the issue persists, review your data formatting or contact support for further assistance.