How to Create Facebook Custom Audiences
from Facebook Group Members
Get Facebook Group Member Data + LinkedIn URLs + Private Emails
Ever felt that you want to reach out to members that belong to a certain Facebook Groups with ads?
It has been tricky to achieve this before – now it is easier and I will walk you through the process.
Let’s go through the requirements first.
- LinkedIn Premium account – in order to speed up the process and reduce the risk of getting the account temporarily logged out. (35 $ / month, free for 1 month)
- Grouply Full account – if you want more than 500 members from each group. (97 $ / year)
- Phantombuster account – Free. (Free tier is enough for this growth hack)
- Dux-Soup Pro account – In order to visit more than 150 members per day. (12.5 $ / month, 1 Month Free!)
2. Extract Group Members with Grouply
Use Grouply to get member data from Facebook groups.
With the FULL plan you’ll unlimited groups and unlimited members.
Grouply will give you the following:
– First name
– Last name
– Company name (for those profiles that has this data)
– Work position (for those profiles that has this data)
– Profile URL
– Group URL
Extract the a CSV file.
3. Prepare the Grouply results file for Phantombuster
In order to prepare for the LinkedIn URL scraping with Phantombuster we are going to clean up the data a bit.
Open up the Grouply results file in Google Sheets.
Then select firstName, lastName, and company columns.
3.1. Concatenate First Name, Last Name and Company Name
Now set up a new document with the combination of First Name, Last Name and Company Name in one column.
Use the concatenate function to merge two or more columns together.
=CONCATENATE(B2,” “, C2)
So just copy the string above and paste it into where you want the three of them together, in the picture below we have concatenated the columns into column A.
4. Use Phantombuster to Get LinkedIn URLs
Go to Phantombuster and sign up for a FREE account.
4.1 Set up a new Agent
Use Phantombuster’s LinkedIn Profile URL finder
Under the configure agent you will have an option to put in your Google Sheet’s URL and which column to use.
4.4 Updating settings
During the process Phantombuster scrapes Google and after a while the IP will get blocked, so set the number of retries to 10 to keep the script running.
Also set the Execution time limit to the max value of 300 minutes.
You might need to come back and check the progress once in awhile.
Remember to press “Save” in the bottom of the page.
4.5 Launch the scraper!
Phantombuster will just fill the first empty column in the sheet with results.
When the agent is finished you will find your result file under “Files”, select “Output”, refresh the feed and click “Download”.
This will give you a .CSV file that you can upload in Google Sheets to easy filter out the results.
5. Prepare the data for Dux-Soup
Now when we have scraped all the LinkedIn URLs we are going to sort the results using the “filter” function in Google sheets.
We only want the rows that include “linkedin.com/in” (profile URLs), in case we got other results from the scraping, it happens occasionally.
What is neat is that we got around 90% hit rate between complete Grouply data and LinkedIn Profile URLs.
You also need to have a separate Column for First Name and Last Name.
In order to get a full name into two columns you need to select the column and select:
Data -> “Split text to columns…” -> Separator “Space”
5.1 Dux- Soup Revisit Template
Now make a copy of the DuxSoupRevisitTemplate and save it on your Google Drive / Computer.
Then copy all the Profile URLs, First Name, and Last Name into this spreadsheet.
Next step is to save this file as a .CSV-file, that Dux-Soup uses.
Go to “File” -> “Download as” -> “Comma-separated values (.csv)”.
5.2 Visit the Dux store!
After you have purchased Dux-Soup Pro you shall head to the dux-store to enable the 1-1 private email exchange.
Either you exchange your current LinkedIn connections, or you buy point for cash.
If you have a lot of connections I would recommend you to trade in the connections you have – your points will be saved to your account and you can use them later.
5.3 Converting connections to Dux points
For every connection you have you will get 1 point that can be used to get private emails.
If you don’t have that many connections on LinkedIn – check out this guide on how to add thousands of contacts quickly.
5.4 Open the revisit CSV in Dux-Soup
Next step is to sign into LinkedIn and after that you click the Dux-Soup icon in the toolbar and select “Revisit Data”.
After you have uploaded the list and it looks like the image to the right.
Then select ‘Visit Profiles‘ from the Dux-Soup menu.
Now the magic begins, this will take a while and it is important that you have a Premium LinkedIn account (will be able to visit 500 profiles a day), otherwise you will be logged out.
When you start the visiting robot you will get the question if you want to spend your points in order to look for email addresses from contacts in the list you just uploaded.
Then just press OK.
5.6 Fetching Emails!
Now the robot will visit the profiles one by one and store information about each profile, including their private email, if it is possible to find.
Sometimes it happens that the robot stops then just need to start it again.
Also make sure that your computer doesn’t fall asleep. If you are using a Mac you can use a little tool called Caffeine that prevents the computer to fall asleep.
5.7 Downloading Emails!
Open up the Dux-Soup extension by clicking the icon in the browser bar. Then click “Download Data”.
After that, select “Visit Data”.
You will now download a .CSV-file full with details about the members, including emails for the connections you found.
6. Create a Facebook Custom Audience
Now it’s time to create the long awaited Custom Audiences!
Upload the dux-visit-data file to Google Sheets to clean up the data.
Select the First Name, Last Name, and Email columns from the original sheet and paste them into a new sheet.
After you have a sheet with there columns, select “File” -> “Download as” -> “Comma-separated values”.
6.1 Uploading to Facebook Ad Manager
Now you select Customer File, even though your data is not from customers, this is the option we have to work with.
6.2 Finalizing the Custom Audience
Either you create an ad right away for this audience, or you can create a lookalike audience that is based on the interests of the members you just uploaded.
Now we are done.