Pick the right export method
- Salesforce Reports (UI directly) — for < 50,000 rows. The simplest.
- Data Loader (official desktop app) — for < 5 million rows. Recommended for most cases.
- Bulk API + script — for volumes > 5M or automated exports. For tech profiles.
This article covers the Reports method (the most accessible). For the others, see our detailed Salesforce integration article.
Step 1 — Create a Salesforce Report
- Salesforce → Reports tab → New Report
- Pick the type: Contacts & Accounts (or Leads depending on what you're enriching)
- Click Continue
Step 2 — Configure the columns
Add these columns from the Outline panel on the left:
- Contact ID (or Lead ID) — reconciliation key, mandatory
- First Name, Last Name
- Title (current role)
- Account Name (company)
- LinkedIn URL if you have a custom field
Add filters if needed: for example, "Last Activity Date" < 6 months ago to surface only inactive contacts.
Step 3 — Export to CSV
- Save the report (disk icon)
- Click Export (top right)
- Pick Details Only (not Formatted Report, which adds headers)
- Format: Comma Delimited (.csv) with UTF-8 encoding
- Click Export — the file downloads directly
Step 4 — Import into Ovalead
- Ovalead → New job
- Drag-and-drop the CSV
- Verify that
linkedin_urlis correctly mapped. If Salesforce doesn't have a LinkedIn field, Ovalead falls back to a name + company search (less precise) - Check Also enrich the company if desired
- Run the scan
Step 5 — Get the result and re-import
When the scan finishes, export the Ovalead CSV. To re-import into Salesforce:
- Salesforce → Setup → Data Import Wizard (Lightning) or Data Loader (legacy)
- Type: Update existing records
- Match on Contact ID (or Lead ID)
- Map the
trace_*columns to your custom fields - Run the import — Salesforce updates without creating duplicates
Tip — create 4 Ovalead custom fields in Salesforce
Before re-importing, create these fields on the Contact (and/or Lead) object:
trace_last_scan(Date)trace_status(Picklist: updated, job_changed, email_invalid, not_found)trace_email_score(Number 0-100)trace_job_changed(Checkbox)
These fields become your native Salesforce filters and let you automate via Workflow Rules: e.g. "If trace_job_changed = true, create a Task for the AE."
