How to export your prospect in a CSV file?
From a list
Select either specific prospects or all the prospects from your list.
Click on "Export" in the options bar that appears.
Confirm the export by clicking on "Export," or edit the email address where the CSV will be sent before confirming.
From a campaign
Select all the prospects from your campaign.
Click on "Export" in the options bar.
Confirm by clicking on "Export."
💡 Good to know
You can use filters to select specific prospects from your campaign before exporting them to in a CSV file.
What data is exported?
When exporting your prospect lists to CSV, the following data is included:
First Name: Ophélie
Last Name: Farache
Occupation: Customer Success Officer & Partnerships Manager @ Waalaxy
Company: Waalaxy
Company URL: https://www.linkedin.com/company/waalaxyautomation/
Location: Montpellier, Occitanie, France
Email: ophelie.farache@waapi.fr
Dropcontact Email: (Empty if not available)
Phone Numbers: (Empty if not available)
Prospect List: Waalaxy members - 2nd
Premium: No
Job Seeker: No
Profile Status: Connected
Message Sent: Yes
Message Replied: Yes
Email Sent: Yes
Email Replied: No
Connected At: 2020-09-14
First Message At: 2021-08-25
Tags:
💡 Good to know
If certain data is not available, the corresponding cell will be left empty.
How to automate the export process?
Your prospect data can be automatically sent to your CRM or webhook when certain triggers in a campaign are met.
There are two types of automation:
Action on reply: Data is sent when the prospect responds. This option is available for campaigns that generate responses, such as LinkedIn messages, emails, and invitation notes.
To set it up, go to "Edit my campaign" > "CRM Sync on reply." For more details, see the tutorial article.
The CRM Sync step: Some special campaigns include a step dedicated to sending data for any prospect who passes through it, regardless of response. This is useful for retrieving more data, such as emails found with the Email Finder + CRM sync sequence.
Find these sequences under "Start a campaign" > "Browse sequences" > "Filter" > "CRM Sync."
FAQ 👇🤓
Why didn't I receive my CSV file in my mailbox?
Your mailbox may have identified the export as spam. Some providers exclude emails with attachments from unknown senders or those over a certain file size.
Check your spam folder. If the file is not there, try using a different email address for the export.
Why does my file display accents and characters in coded form?
Accents and special characters may appear incorrectly due to the default opening format in your version of Excel.
To open the CSV correctly, use the "," separator and ensure the file is opened in UTF-8 encoding. You can find a tutorial for this process.
Alternatively, consider using Google Sheets, which handles these characters well and is free to use.
Which JSON file will my webhook retrieve?
{
"distance": "DISTANCE_1;DISTANCE_2;DISTANCE_3",
"status": "connected;pending;not_connected",
"connectedAt": ";;",
"publicIdentifier": "johndoe;mariaphenix;brucemclean",
"firstName": "John;Maria;Bruce",
"lastName": "Doe;Phenix;Mclean",
"occupation": "Sales manager at Netflix;UI designer at Facebook;Ex software engineer at Google, i'm looking for a new job !",
"profilePicture": ";;",
"influencer": "true;false;false",
"jobSeeker": "false;false;true",
"openlink": "true;true;false",
"premium": "false;true;false",
"profileUrl": "https://linkedin.com/in/johndoe;https://linkedin.com/in/mariaphenix;https://linkedin.com/in/brucemclean",
"region": "Paris;New-York;London",
"birthday": "1/8;;",
"address": ";;",
"company": "Netflix;Facebook;",
"email": "john.doe@gmail.com;;",
"phoneNumbers": "mobile:0787123476-fixe:0389076542;;"
}