How does the system handle duplicates or incorrect phone numbers in the Excel sheet?

How does the system handle duplicates or incorrect phone numbers in the Excel sheet?

When you upload an audience file in MyOperator, the system runs automatic validation checks to ensure only valid contacts are imported. This prevents failed sends, saves credits, and keeps your campaign clean.

🔍 What Gets Removed Automatically

Type of Entry

Action Taken

Example

Duplicate phone numbers

Only the first instance is kept

+91 9876543210 listed twice → second skipped

Invalid numbers

Skipped

98765abc, missing digits

Non-Indian numbers (default)

Excluded unless international sending is enabled

+44 7700000000

Blank / malformed rows

Skipped

Empty phone/name fields

🧪 Example Upload File

Name

Phone Number

Import Result

John Doe

+91 9876543210

âś… Imported

Jane Smith

98765abc

❌ Skipped – invalid format

Rahul

+44 7700000000

❌ Skipped – non-Indian number

(blank)

(blank)

❌ Skipped – empty row

👉 Only John Doe is successfully imported. The rest are excluded with error notes.

⚠️ Notes & Best Practices

  • Default rule: Only +91 numbers are accepted (international sending not yet supported).
  • File hygiene tips:
    • Use international format (e.g., +91XXXXXXXXXX)
    • Remove special characters or spaces in numbers
    • Eliminate duplicates and empty rows before upload
  • Error handling: Use the Download Error Report feature to review rejected entries and fix them before retrying.

âś… Summary

  • The system automatically filters out invalid, duplicate, or non-Indian entries.
  • Only clean and valid records are imported for campaigns.
  • Always pre-check files and review error reports to maximize delivery success.