Say you have 100,000 email subscribers and 60,000 Facebook fans. You know there’s a big overlap there. But just how big is that overlap? And what’s the total number of unique supporters between your email list and your Facebook fan base?
Thanks to a clever little hack using Facebook’s Power Editor, we now know how to estimate that. (Note: For now, we’re not worrying about people who are on Twitter or Google+ or Pinterest — just your email list and Facebook.)
The way to find this total-unique-supporter number is through “custom audiences.” As we wrote about last year, Facebook’s new targeting tool enables you to send ads to Facebook users based on their email address. By setting up a custom audience, you’re taking your full file of deliverable email addresses and matching them to Facebook accounts set up with those same email addresses.
Facebook won’t tell you which addresses are a match, but you can find out how many are a match — and how many of your email subscribers aren’t already Facebook fans, which is really what we’re looking for.
Here’s how to find it:
1. Export your entire email file and save it as a single plain text column of email addresses in a .txt file.
2. Go to Facebook’s Power Editor, which you can find on the left side menu of your Facebook account’s Ad Manager. The Power Editor is an advanced toolkit for creating bulk ads and managing promotions across accounts. You can learn more about Power Editor here.
Access Power Editor via your Facebook account’s Ad Manager
3. Create a custom audience by selecting the ‘Audiences’ option in the Power Editor’s left side menu. Select ‘Create Audience’ and follow the instructions to upload that .txt file to Facebook. This can take a while to process for large lists. Also, be sure give the audience a unique name you’ll remember.
To go from that number to your total supporter number, it’s simple math:
# of Email-Subscribers-Who-Are-Not-Facebook-Fans
+ # of Facebook Fans
= Total Unique Supporters
Note: Facebook matches email addresses, so it’ll only match to email subscribers who use the exact same email address for their FB profile. Really what you’re getting here is the total number of unique email addresses between your email house file and your Facebook page. But most organizations count unique email addresses as unique supporters anyway, so this should be a useful tool in your arsenal.
Go call your Comms Director — you have a new number of supporters!
Will Facebook start using all the email address we upload this way? Will they use them only for us, or do they become part of the wider Fb market? This could annoy supporters.
Thanks for your question, Ken. When you upload an email list to Facebook, Facebook matches your list with the email addresses Facebook already has. For the email addresses that match, ads are delivered. For email addresses that don’t match, no ads are delivered. Facebook does not keep the remainder of the uploaded list. You can read more about custom audience ads and these privacy concerns on Facebook here:
https://www.facebook.com/help/459892990722543/
When I upload our list of donors to check on overlap with Facebook Likes, the Power Editor only uploads a portion of the list. Is anyone else having this problem? I’ve run this four times now and each time I get a partial upload.
Great trick. Turns out just over half of our email list is on Facebook but there is very little overlap with our Facebook fans.
To figure out how many email subscribers are Facebook fans, I switched to a “promote page” ad type and selected my custom audience and only those who are connected to us.