The LinkedIn and Facebook social networking sites allow you to build a network of contacts comprised of your fellow Facebook and LinkedIn users.
Did you know that you can download your connections into a spreadsheet and transfer them to Facebook to create a custom audience? You can actually do this for Twitter ads, as well. I demonstrate it in this video!
This platform has great targeting capabilities on their advertising platform, including the ability to reach users by the groups they are members of. Users that join groups tend to be more active on LinkedIn, meaning that if you’re targeting 100,000 group members you will likely reach more people than by targeting 100,000 people by title, seniority, location, etc. Advertisers can always further qualify group targeting by adding demographic information on top of it.
Both os these social networking sites permit you to create a network of contacts comprised of your fellow Facebook and LinkedIn users. And if you’re interested in inviting your LinkedIn connections to “Like” your Facebook page, there is a solution.
This is a step-by-step guide of how to export your connections, import it into Excel and to create a workable file in a couple of minutes.
1. Exporting LinkedIn contacts
You can export all your contacts to a .cvs file and import this file into Excel.
– Step 1: Go to your LinkedIn homepage and click on the tab ‘Connections‘
– Step 2: Click to ‘Settings’ symbol in the top right corner of the page
– Step 3: Click ‘Export Linkedin Connections’ in the right column on the page
– Step 4: Choose ‘Microsoft Outlook (.CSV file)‘ and click ‘Export’
– Step 5: Save the document
2. Import your exported contacts into a workable Excel file
You can’t save all of the data of your connections, but you will have First Name, Last Name, E-mail address, Company & Job title. This is how you do it:
– Step 1: Open your saved .cvs file in Excel
– Step 2: Go to ‘Data‘ in the tab section and click ‘Text to columns’
– Step 3: Choose ‘Seperated‘, click next, choose ‘Comma‘, click next, choose ‘complete’
– Step 4: Clean up the empty columns and you’re ready!
Now you have a workable file, especially when you apply filters to it. Now you can import this .cvs or .xls file into your database.