Known and distinguished manufacturers (like Goal) are turning to big information to mine consumer information to find the most effective ways to attain and retain their consumer base. Why let the big guys have all the fun? if In case you have a listing of your customers’ email addresses that you would be able to get right of entry to your customers’ in my view identifiable information and social profiles. All you need is the FullContact API, NetPeak Checker and some Excel skills.

FullContact’s particular Person API is superb – if In case you have someone’s email tackle, Twitter deal with, Fb ID or cellphone number, you can use FullContact’s Person API to fetch a ton of non-public person information.

If you happen to feed the Person API an email address, it’ll offer you data like:

Final Identify

First Identify

Place

Twitter profile URL

Twitter Bio

Twitter Followers

Twitter Users Adopted

Facebook profile URL

Linkedin Public Profile URL

Google+ profile URL

Google+ Person ID

Google+ Username

Klout score

YouTube person profile URL

A whole lot more.

FullContact is going to respond to two big questions for us:

1) Who are our client’s most influential users?

If we will in finding influencers which might be actively using our client’s product, they may be a natural fit for a model evangelist, spokesperson or content material contributor role.

2) What websites do our client’s users learn and share that we are able to target for content placement

To search out out what our client’s customers are reading/sharing, we can use Richard’s methodology that he presented at MozCon on using Twitter data for in point of fact centered outreach. This will allow us to download all of our customers’ tweets, isolate the URLs they are sharing and construct a list of web sites to target for content placement that we all know our consumer’s customers read and share.

This whole process is so much quicker with the lend a hand of a developer, however not absolutely everyone have get admission to to devs or really feel relaxed working with code – so we’re going to run via how to do this whole process in Excel, developer free.

Q1: What Influencers Use Our Consumer’s Product?

Step 1) Get an export of user emails

It will come from an electronic mail advertising listing or a CRM.

Step 2) Download the FullContact Person Enrichment Excel Template from GitHub

You’re going to wish to enroll in an account to get get right of entry to to their API. The first 250 calls are free, after that, pricing begins at $99 for 25,000 calls a month.

Step three) Enter your API key into the excel sheet and follow the directions in the worksheet

4) Paste a list of emails into the “InputSheet” tab

These are obviously actual electronic mail addresses

 Step 5) Press the “Populate Contacts” button within the first tab of the Excel template

Step 6) Don’t contact anything!

This workbook is the usage of VB to drag in a ton of knowledge, so go catch up on electronic mail for a couple of minutes, maybe grasp a cup of espresso, go have a look at some cat gifs for a few minutes. I regarded up 60 contacts for this situation and it took ~5 minutes.

Bask within the glory of your entire person’s information:

FullContact isn’t going to have info on everyone, their match price is around 60%. Fortunately, you handiest need to pay for an API call if it returns knowledge.

Step 7) Reproduction all Twitter profile URLs for every single user into a new sheet.

Step eight) Use =XpathOnURL on a customers’ Twitter profile URL to pull their listed web site and follower depend

If the URL is in cell A1, right here’s the formulation to scrape a users listed website:

=XPathOnUrl(A1,”//p/span/span/a”)

And here’s the method to scrape the number of Twitter followers:

=XPathOnUrl(A1,”//li[3]/a/strong”)

Step 9) Pull Domain Authority Metrics of Consumer Internet sites

There’s just a few methods you can do this, however I actually like Netpeak Checker, it’s fast and easy to make use of 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 number of VLOOKUPs. The constant knowledge level all the way through all of that is the Twitter profile URL, so match your VLOOKUP off that information level.

Important Notice: NetPeak Checker adds an “http://” to the begining of a URL, the other information we’ve been working with does no longer have “http://”, so when you paste the Netpeak information into a new excel spread sheet, you should definitely take away all cases of “http://” out of your dataset for the VLOOKUP to work correctly.

Now you could have a list of people who are using your product, their e mail, their twitter deal with, their web page and its authority metrics.

From here which you can determine influencers just going off Area Authority and Twitter followers.

Q2: What Websites Are Our Customers Studying and Sharing?

 Step 1) Get Your Users Twitter Handles 

Step 2) Follow Richard’s “How To Use Twitter Knowledge for In reality Targeted Outreach“ Course of using TAGS

Step 3) Analyze what your users are sharing

Here’s a look at domains shared and Area Authority from Twitter customers I have exchanged emails with in the remaining two weeks.

There’s some attention-grabbing finds here and a variety of opportunities for doable content material placements.

If you have a well segmented e-mail marketing list or CRM, that you could smash this down into specific user teams and  create content that appeals particularly to their phase and place it on websites that they’re studying and sharing. It’s a huge chance for retention advertising that in point of fact harnesses the facility of knowledge.

Instance Use Instances:

Have a phase of power customers? – The sites they share regularly would be excellent for a contest

Have a phase of users who’ve signed up to your email publication, but never purchased your product? – A guest publish on a frequently shared web page concerning the fundamentals of your product could be excellent for changing a number of readers and pushing electronic mail subscribers thru your gross sales funnel.

Trying to place a section of content material? – be certain that its a site your consumers actually care about and will see

Have any more use circumstances? Please share them in the comments beneath!

The publish Mining Consumer Information in Excel with the FullContact API seemed first on SEOgadget.