Recognized and prominent brands (like Target) are turning to big data to mine user information to find the best ways to reach and retain their customer base.
Why let the big guys have all the fun?
If you have a list of your users’ email addresses you can access your users’ personally identifiable information and social profiles. All you need is the FullContact API, NetPeak Checker and some Excel skills.
FullContact’s Person API is amazing – If you have someone’s email address, Twitter handle, Facebook ID or phone number, you can use FullContact’s Person API to fetch a ton of personal user data.
If you feed the Person API an email address, it will give you info like:
Twitter profile URL
Twitter Users Followed
Facebook profile URL
Linkedin Public Profile URL
Google+ profile URL
Google+ User ID
YouTube user profile URL
A whole lot more.
FullContact is going to answer two big questions for us:
1) Who are our client’s most influential users?
If we can find influencers that are actively using our client’s product, they may be a natural fit for a brand evangelist, spokesperson or content contributor role.
2) What websites do our client’s users read and share that we can target for content placement
To find out what our client’s users are reading/sharing, we can use Richard’s methodology that he presented at MozCon on using Twitter data for really targeted outreach. This will allow us to download all of our users’ tweets, isolate the URLs they are sharing and build a list of sites to target for content placement that we know our client’s users read and share.
This whole process is a lot quicker with the help of a developer, but not all of us have access to developers or feel comfortable working with code – so we’re going to run through how to do this whole process in Excel, developer free.
Q1: What Influencers Use Our Client’s Product?
Step 1) Get an export of user emails
This can come from an email marketing list or a CRM.
Step 2) Download the FullContact Person Enrichment Excel Template from GitHub
You’re going to need to sign up for an account to get access to their API. The first 250 calls are free, after that, pricing starts at $99 for 25,000 calls a month.
Step 3) Enter your API key into the excel sheet and follow the instructions in the worksheet
4) Paste a list of emails into the “InputSheet” tab
Step 5) Press the “Populate Contacts” button in the first tab of the Excel template
Step 6) Don’t touch anything!
This workbook is using VB to pull in a ton of information, so go catch up on email for a few minutes, maybe grab a cup of coffee, go look at some cat gifs for a few minutes. I looked up 60 contacts for this example and it took ~5 minutes.
Bask in the glory of all your user’s data:
FullContact isn’t going to have info on everyone, their match rate is around 60%. Thankfully, you only have to pay for an API call if it returns data.
Step 7) Copy all Twitter profile URLs for every single user into a new sheet.
Step 8) Use =XpathOnURL on a users’ Twitter profile URL to pull their listed website and follower count
If the URL is in cell A1, here’s the formula to scrape a users listed website:
And here’s the formula to scrape the number of Twitter followers:
Step 9) Pull Domain Authority Metrics of User Websites
There’s a few ways you can do this, but I really like Netpeak Checker, it’s fast and easy to use and plugs right into the Moz API.
Step 10) VLOOKUP Time
Now you need to get your data into one excel sheet, this is going to require a few VLOOKUPs. The constant data point throughout all of this is the Twitter profile URL, so match your VLOOKUP off that data point.
Important Note: NetPeak Checker adds an “http://” to the beginning of a URL, the other data we’ve been working with does not have “http://”, so when you paste the Netpeak data into a new excel spread sheet, make sure to remove all instances of “http://” from your dataset for the VLOOKUP to work properly.
Now you have a list of people who are using your product, their email, their twitter handle, their website and its authority metrics.
From here you can identify influencers just going off Domain Authority and Twitter followers.
Q2: What Websites Are Our Users Reading and Sharing?
Step 1) Get Your Users Twitter Handles
The Full Contact Excel Sheet doesn’t give you Twitter handles, but it gives you Twitter Profile URLs, so just copy you users’ Twitter Profile URLs into a new column, and use the following find and replace command:
Unfortunately, you can’t use “@” in the replace field, so you will have to add @ to a new cell and concatenate it on to the Twitter user names.
Step 2) Follow Richard’s “How To Use Twitter Data for Really Targeted Outreach” Process using TAGS
Step 3) Analyze what your users are sharing
Here’s a look at domains shared and Domain Authority from Twitter users I have exchanged emails with in the last two weeks.
There’s some interesting finds here and a lot of opportunities for potential content placements.
If you have a well segmented email marketing list or CRM, you can break this down into specific user groups and create content that appeals specifically to their segment and place it on sites that you know they are reading and sharing. It’s a huge opportunity for retention marketing that really harnesses the power of data.
Example Use Cases:
Have a segment of power users? – The sites they share frequently would be perfect for a contest
Have a segment of users who have signed up for your email newsletter, but never purchased your product? – A guest post on a frequently shared site about the basics of your product might be perfect for converting a few readers and pushing email subscribers through your sales funnel.
Trying to place a piece of content? – make sure its a site your customers actually care about and will see
Have any more use cases? Please share them in the comments below!