--- title: Prevent Duplicate Records When Importing Leads Without Email Addresses description: Using Unique Placeholder Emails in Sierra Interactive image: https://www.sierrainteractive.com/wp-content/uploads/2022/07/Website-Preview-V2A.jpg --- [Skip to content](https://help.sierrainteractive.com/helpcenter/prevent-duplicate-records-when-importing-leads-without-email-addresses#main-content) [Contact Support](https://help.sierrainteractive.com/helpcenter/kb-tickets/new?hsLang=en) [![Sierra Interactive logo](https://help.sierrainteractive.com/hs-fs/hubfs/sierra%20interactive%20logo.png?width=250&height=34&name=sierra%20interactive%20logo.png)](https://help.sierrainteractive.com/helpcenter?hsLang=en) - [Sierra CRM Login](https://client.sierrainteractivedev.com/login.aspx?sn=sierrainteractive.com) - [Sierra Support](https://share.hsforms.com/1-PkIvKPkRJ2Oe4iP28LPugcrxj0?__hstc=240356316.ca34a03f98730f420ad639300528f2a2.1764955183725.1783970890126.1783975123568.351&__hssc=240356316.31.1783975123568&__hsfp=3cbed2008eb4c720102b6f72b9dd6767) - [Training & Learning](https://info.sierrainteractive.com/live-training-learning-opportunities) Show submenu for Training & Learning - [Sierra Academy](https://info.sierrainteractive.com/sierra-academy) - [Live Training Sessions](https://help.sierrainteractive.com/helpcenter/join-live-training-sessions-explore-sierra-learning-resources) Show submenu for Live Training Sessions - [Tuesdays 11AM ET](https://us02web.zoom.us/j/81520282538) - [Wednesdays 1:30PM ET](https://us02web.zoom.us/j/84246589732) - [Fridays 3PM ET](https://us02web.zoom.us/j/86964951435) - [Sierra YouTube Channel](https://www.youtube.com/@sierrainteractive/featured) - [Sierra Facebook Mastermind](https://www.facebook.com/groups/sierrainteractive) - [Referral Dashboard](https://www.sierrainteractive.com/customer-referral-dashboard/) - [Operations & Closures](https://info.sierrainteractive.com/sierra-interactive-observed-holidays) - [System Status](https://status.sierrainteractive.com/) Open main navigation Close main navigation - [Sierra CRM Login](https://client.sierrainteractivedev.com/login.aspx?sn=sierrainteractive.com) - [Sierra Support](https://share.hsforms.com/1-PkIvKPkRJ2Oe4iP28LPugcrxj0?__hstc=240356316.ca34a03f98730f420ad639300528f2a2.1764955183725.1783970890126.1783975123568.351&__hssc=240356316.31.1783975123568&__hsfp=3cbed2008eb4c720102b6f72b9dd6767) - [Training & Learning](https://info.sierrainteractive.com/live-training-learning-opportunities) Show submenu for Training & Learning - [Sierra Academy](https://info.sierrainteractive.com/sierra-academy) - [Live Training Sessions](https://help.sierrainteractive.com/helpcenter/join-live-training-sessions-explore-sierra-learning-resources) Show submenu for Live Training Sessions - [Tuesdays 11AM ET](https://us02web.zoom.us/j/81520282538) - [Wednesdays 1:30PM ET](https://us02web.zoom.us/j/84246589732) - [Fridays 3PM ET](https://us02web.zoom.us/j/86964951435) - [Sierra YouTube Channel](https://www.youtube.com/@sierrainteractive/featured) - [Sierra Facebook Mastermind](https://www.facebook.com/groups/sierrainteractive) - [Referral Dashboard](https://www.sierrainteractive.com/customer-referral-dashboard/) - [Operations & Closures](https://info.sierrainteractive.com/sierra-interactive-observed-holidays) - [System Status](https://status.sierrainteractive.com/) - [Contact Support](https://help.sierrainteractive.com/helpcenter/kb-tickets/new) Search Help Center - There are no suggestions because the search field is empty. 1. [Help Center](https://help.sierrainteractive.com/helpcenter?hsLang=en) 2. [Lead Management](https://help.sierrainteractive.com/helpcenter/lead-management?hsLang=en) 3. [Lead Organization & Tagging](https://help.sierrainteractive.com/helpcenter/lead-management?hsLang=en#lead-organization-tagging) July 20, 2026 # Prevent Duplicate Records When Importing Leads Without Email Addresses ## Using Unique Placeholder Emails in Sierra Interactive ### Summary Sierra Interactive utilizes the email address as a unique identifier to maintain the integrity of your database. By ensuring every lead has a distinct email, you prevent duplicate records that often cause reporting discrepancies and follow-up errors. This system allows for reliable tracking of lead activity and ensures your automations trigger correctly for the right person. ### Table of Contents 1. [How Placeholder Emails Work](https://help.sierrainteractive.com/helpcenter/prevent-duplicate-records-when-importing-leads-without-email-addresses#how) 2. [Format Requirements for Placeholders](https://help.sierrainteractive.com/helpcenter/prevent-duplicate-records-when-importing-leads-without-email-addresses#format) 3. [The Lead Import Process](https://help.sierrainteractive.com/helpcenter/prevent-duplicate-records-when-importing-leads-without-email-addresses#process) 4. [Best Practices for Database Health](https://help.sierrainteractive.com/helpcenter/prevent-duplicate-records-when-importing-leads-without-email-addresses#best) 5. [Troubleshooting and FAQ](https://help.sierrainteractive.com/helpcenter/prevent-duplicate-records-when-importing-leads-without-email-addresses#faq) --- ### How Placeholder Emails Work To manage leads from offline events or open houses that lack contact information, you can still bring them into your CRM by using a unique placeholder. To ensure the system accepts the record, assign a unique address that follows a standard email format. These addresses do not need to be real, active inboxes. Their primary purpose is to act as a "shelf space" for the lead's data **until a real email address is obtained**. [Back to Top](https://help.sierrainteractive.com/helpcenter/prevent-duplicate-records-when-importing-leads-without-email-addresses#top) --- ### Format Requirements for Placeholders To ensure a successful upload, placeholder emails must be formatted correctly so the database can recognize and accept them. Proper formatting creates a separate record for each lead and keeps your imports, reporting, and automations accurate.  ⚠️ Each placeholder email must be unique. If two leads share the same “fake” email, the system treats them as the same person and flags a duplicate, which can block new records and misroute activity. - Use a simple pattern to keep emails unique, such as adding the lead’s name, event, or a number (for example, openhouse\_001@example.com, openhouse\_002@example.com). - Before importing, check your email column for duplicates to avoid errors. - Each placeholder email must follow a standard email format and include: - A username or identifier (before “@”) - The “@” symbol - A valid domain and extension (such as .com, .net, or .org) - You can choose any domain, but many teams use a consistent, clearly fake domain (such as @noemail.com or @placeholder.com) so these records are easy to find and manage later. - Approved Examples - johnsmith@noemail.com - lead123@placeholder.com - openhouse\_jane@example.com - These examples use a unique identifier, the “@” symbol, and a valid domain with an appropriate extension, helping the system accept your data and keep your database clean.  [Back to Top](https://help.sierrainteractive.com/helpcenter/prevent-duplicate-records-when-importing-leads-without-email-addresses#top) --- ### The Lead Import Process When you are ready to begin your import, refer to: [*Import Leads into Sierra Using the Lead Import Wizard*](https://help.sierrainteractive.com/helpcenter/import-leads-into-sierra-using-the-lead-import-wizard?hsLang=en)  That article walks you through each step of the process, including how to: - Prepare your CSV file and map columns to the correct Sierra fields - Include placeholder emails alongside real email addresses - Handle duplicates and errors that may appear during the upload - Verify that new leads have been created correctly in your CRM Reviewing the import guide before you upload will help you avoid common formatting issues, reduce failed rows, and ensure your leads enter Sierra cleanly and are ready for routing, follow-up, and automation.  [Back to Top](https://help.sierrainteractive.com/helpcenter/prevent-duplicate-records-when-importing-leads-without-email-addresses#top) --- ### Best Practices for Database Health -  To keep your records organized, use a consistent domain for all placeholder emails, such as @example.com. This makes it simple to filter for and identify these leads when you are ready to replace the placeholder with a valid email address. - Communication Limitations: Placeholder emails support calling and texting, but they cannot receive email messages. Email communication will not be delivered until the lead has a real, functional inbox on file.  [Back to Top](https://help.sierrainteractive.com/helpcenter/prevent-duplicate-records-when-importing-leads-without-email-addresses#top) --- ### Troubleshooting Common Issues - **My upload failed due to duplicate emails**This means two or more leads share the same email address. Update placeholder emails so each lead is unique. - **I accidentally used a real email that isn’t correct**Edit the lead record and replace it with a placeholder email. - **Can emails be sent to placeholder addresses?**No. Placeholder emails are not real inboxes and should not be used for email communication. --- ### FAQs - **Does the placeholder email need to work?**No. It only needs to follow a valid email format. - **Can I use the same placeholder email for multiple leads?**No. Each lead must have a unique email address. - **Why can’t Sierra use phone numbers instead?**Phone numbers are not always unique and may change. Email provides a more reliable system identifier. - **Will this affect texting or calling leads?**No. Placeholder emails do not impact phone or text communication. [Back to Top](https://help.sierrainteractive.com/helpcenter/prevent-duplicate-records-when-importing-leads-without-email-addresses#top) - [Getting Started with Sierra](https://help.sierrainteractive.com/helpcenter/getting-started-with-sierra?hsLang=en#main-content) - [Orientation & Approvals](https://help.sierrainteractive.com/helpcenter/getting-started-with-sierra?hsLang=en#orientation-approvals) - [Activate Your Sierra Dialer](https://help.sierrainteractive.com/helpcenter/getting-started-with-sierra?hsLang=en#activate-your-sierra-dialer) - [CRM Setup](https://help.sierrainteractive.com/helpcenter/getting-started-with-sierra?hsLang=en#crm-setup) - [Connect Your Data](https://help.sierrainteractive.com/helpcenter/getting-started-with-sierra?hsLang=en#connect-your-data) - [Launch Your Website](https://help.sierrainteractive.com/helpcenter/getting-started-with-sierra?hsLang=en#launch-your-website) - [Start Working with Leads](https://help.sierrainteractive.com/helpcenter/getting-started-with-sierra?hsLang=en#start-working-with-leads) - [Enhance Your Site](https://help.sierrainteractive.com/helpcenter/getting-started-with-sierra?hsLang=en#enhance-your-site) - [Video Resource Library](https://help.sierrainteractive.com/helpcenter/video-resource-library?hsLang=en#main-content) - [Webinar Recordings](https://help.sierrainteractive.com/helpcenter/video-resource-library?hsLang=en#webinar-recordings) - [Video FAQ](https://help.sierrainteractive.com/helpcenter/video-resource-library?hsLang=en#video-faq) - [IntelliSearch](https://help.sierrainteractive.com/helpcenter/video-resource-library?hsLang=en#intellisearch) - [Lead Generation & Capture](https://help.sierrainteractive.com/helpcenter/lead-generation-capture?hsLang=en#main-content) - [Sierra Digital Marketing Services](https://help.sierrainteractive.com/helpcenter/lead-generation-capture?hsLang=en#sierra-digital-marketing-services) - [Lead Tracking](https://help.sierrainteractive.com/helpcenter/lead-generation-capture?hsLang=en#lead-tracking) - [Saved Searches & IDX Settings](https://help.sierrainteractive.com/helpcenter/lead-generation-capture?hsLang=en#saved-searches-idx-settings) - [Email Marketing & Automation](https://help.sierrainteractive.com/helpcenter/lead-generation-capture?hsLang=en#email-marketing-automation) - [Lead Capture Tools](https://help.sierrainteractive.com/helpcenter/lead-generation-capture?hsLang=en#lead-capture-tools) - [IntelliSearch](https://help.sierrainteractive.com/helpcenter/lead-generation-capture?hsLang=en#intellisearch) - [Lead Engagement & Nurturing](https://help.sierrainteractive.com/helpcenter/lead-engagement-nurturing?hsLang=en#main-content) - [AI-Assisted Lead Engage](https://help.sierrainteractive.com/helpcenter/lead-engagement-nurturing?hsLang=en#ai-assisted-lead-engage) - [E-Alerts & Market Updates](https://help.sierrainteractive.com/helpcenter/lead-engagement-nurturing?hsLang=en#e-alerts-market-updates) - [Sierra Success Hub](https://help.sierrainteractive.com/helpcenter/lead-engagement-nurturing?hsLang=en#sierra-success-hub) - [Drip Campaigns](https://help.sierrainteractive.com/helpcenter/lead-engagement-nurturing?hsLang=en#drip-campaigns) - [Action Plans & Automations](https://help.sierrainteractive.com/helpcenter/lead-engagement-nurturing?hsLang=en#action-plans-automations) - [Buyer Lead Workflow](https://help.sierrainteractive.com/helpcenter/lead-engagement-nurturing?hsLang=en#buyer-lead-workflow) - [Bulk Actions](https://help.sierrainteractive.com/helpcenter/lead-engagement-nurturing?hsLang=en#bulk-actions) - [Lead Management](https://help.sierrainteractive.com/helpcenter/lead-management?hsLang=en#main-content) - [Lead Organization & Tagging](https://help.sierrainteractive.com/helpcenter/lead-management?hsLang=en#lead-organization-tagging) - [Reporting & Exports](https://help.sierrainteractive.com/helpcenter/lead-management?hsLang=en#reporting-exports) - [Platform Tools](https://help.sierrainteractive.com/helpcenter/lead-management?hsLang=en#platform-tools) - [Lead Routing & Permissions](https://help.sierrainteractive.com/helpcenter/lead-management?hsLang=en#lead-routing-permissions) - [Calling & Dialer Tools](https://help.sierrainteractive.com/helpcenter/lead-management?hsLang=en#calling-dialer-tools) - [Team Management & Accountability](https://help.sierrainteractive.com/helpcenter/lead-management?hsLang=en#team-management-accountability) - [Website Management](https://help.sierrainteractive.com/helpcenter/website-management?hsLang=en#main-content) - [Website Structure & Navigation](https://help.sierrainteractive.com/helpcenter/website-management?hsLang=en#website-structure-navigation) - [AI Visibility & SEO](https://help.sierrainteractive.com/helpcenter/website-management?hsLang=en#ai-visibility-seo) - [Website Pages & Content](https://help.sierrainteractive.com/helpcenter/website-management?hsLang=en#website-pages-content) - [DNS, Branding, & User Experience](https://help.sierrainteractive.com/helpcenter/website-management?hsLang=en#dns-branding-user-experience) - [Analytics](https://help.sierrainteractive.com/helpcenter/website-management?hsLang=en#analytics) - [Support & Account Help](https://help.sierrainteractive.com/helpcenter/support-account-help?hsLang=en#main-content) - [Contact Support](https://help.sierrainteractive.com/helpcenter/support-account-help?hsLang=en#contact-support) - [Billing & Account Changes](https://help.sierrainteractive.com/helpcenter/support-account-help?hsLang=en#billing-account-changes) - [Access & Permissions](https://help.sierrainteractive.com/helpcenter/support-account-help?hsLang=en#access-permissions) - [Industry & MLS Compliance](https://help.sierrainteractive.com/helpcenter/industry-mls-compliance?hsLang=en#main-content) - [NAR](https://help.sierrainteractive.com/helpcenter/industry-mls-compliance?hsLang=en#nar) - [Compliance and Best Practices](https://help.sierrainteractive.com/helpcenter/industry-mls-compliance?hsLang=en#compliance-and-best-practices) - [Integrations & API](https://help.sierrainteractive.com/helpcenter/integrations-api?hsLang=en#main-content) - [Communication Integrations](https://help.sierrainteractive.com/helpcenter/integrations-api?hsLang=en#communication-integrations) - [Marketing Integrations](https://help.sierrainteractive.com/helpcenter/integrations-api?hsLang=en#marketing-integrations) - [CRM Integrations](https://help.sierrainteractive.com/helpcenter/integrations-api?hsLang=en#crm-integrations) - [API & Developer Tools](https://help.sierrainteractive.com/helpcenter/integrations-api?hsLang=en#api-developer-tools) - [Calendar & Appointments](https://help.sierrainteractive.com/helpcenter/integrations-api?hsLang=en#calendar-appointments) [![Sierra Interactive logo](https://help.sierrainteractive.com/hs-fs/hubfs/sierra%20interactive%20logo.png?width=250&height=34&name=sierra%20interactive%20logo.png "Sierra Interactive logo")](https://help.sierrainteractive.com/helpcenter?hsLang=en) 1205 E Washington St #110, Louisville, KY 40206 Copyright © 2025, Sierra Interactive