{"id":319,"date":"2013-08-20T14:25:22","date_gmt":"2013-08-20T14:25:22","guid":{"rendered":"http:\/\/seogadget.com\/?p=14172"},"modified":"2014-01-21T18:03:28","modified_gmt":"2014-01-21T18:03:28","slug":"mining-user-data-in-excel-with-the-fullcontact-api","status":"publish","type":"post","link":"https:\/\/www.urlrate.com\/blog\/mining-user-data-in-excel-with-the-fullcontact-api\/","title":{"rendered":"Mining User Data in Excel with the FullContact API"},"content":{"rendered":"

Known and distinguished manufacturers (like Goal<\/a>) are turning to big information to mine consumer information to find the most effective ways to attain and\u00a0retain their consumer base.\u00a0Why let the big guys have all the fun?<\/strong>\u00a0if 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<\/a>, NetPeak Checker<\/a> and some Excel skills.<\/p>\n

\"Full<\/p>\n

FullContact’s particular Person API<\/a> 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<\/strong><\/span> of non-public person information.<\/p>\n

If you happen to feed the Person API an email address, it’ll offer you data like:<\/h6>\n
Final Identify<\/strong><\/pre>\n
First Identify<\/strong><\/pre>\n
Place<\/strong><\/pre>\n
Twitter profile URL<\/strong><\/pre>\n
Twitter Bio<\/strong><\/pre>\n
Twitter Followers<\/strong><\/pre>\n
Twitter Users Adopted<\/strong><\/pre>\n
Facebook profile URL<\/strong><\/pre>\n
Linkedin Public Profile URL<\/strong><\/pre>\n
Google+ profile URL<\/strong><\/pre>\n
Google+ Person ID<\/strong><\/pre>\n
Google+ Username<\/strong><\/pre>\n
Klout score<\/strong><\/pre>\n
YouTube person profile URL<\/strong><\/pre>\n
A whole lot more.\r\n\r\n<\/a><\/span><\/strong><\/pre>\n
FullContact is going to respond to two big questions for us:<\/strong><\/p>\n
1) Who are our client’s most influential users?<\/h2>\n
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\u00a0content material contributor role.<\/p>\n
2) What websites do our client’s users learn and share that we are able to target for content placement<\/h2>\n
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<\/a>. 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.<\/p>\n
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.<\/span><\/strong><\/p>\n
Q1: What Influencers Use Our Consumer’s Product?<\/h1>\n
Step 1) Get an export of user emails<\/h6>\n
It will come from an electronic mail advertising listing or a CRM.<\/p>\n
Step 2) Download the FullContact Person Enrichment Excel Template from GitHub<\/a><\/h6>\n
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.<\/p>\n
Step three) Enter your API key into the excel sheet and follow the directions in the worksheet<\/h6>\n
\"Full_Contact_API_Key_Pic_001\"<\/p>\n
4) Paste a list of emails into the “InputSheet” tab<\/h6>\n
\"Anonymous_email_data_for_full_contact\"<\/p>\n
These are obviously actual electronic mail addresses<\/p>\n<\/div>\n
\u00a0Step 5) Press the “Populate Contacts” button within the first tab of the Excel template<\/h6>\n
\"Generate_contacts_pic\"<\/p>\n
 <\/p>\n
 <\/p>\n
Step\u00a06) Don’t contact anything!<\/h6>\n
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<\/a> for a few minutes. I regarded up 60 contacts for this situation and it took ~5 minutes.<\/p>\n
Bask within the glory of your entire person’s information:<\/span><\/strong><\/p>\n
\"Excel<\/a><\/p>\n
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.<\/p>\n
Step 7) Reproduction all Twitter profile URLs for every single user into a new sheet.<\/h6>\n
\"twitter_profile_URLs\"<\/p>\n
Step eight) Use =XpathOnURL on a customers’ Twitter profile URL to pull their listed web site and follower depend<\/h6>\n
If the URL is in cell A1, right here’s the formulation to scrape a users listed website:<\/p>\n
=XPathOnUrl(A1,”\/\/p\/span\/span\/a”)<\/strong><\/p>\n
And here’s the method to scrape the number of Twitter followers:<\/p>\n
=XPathOnUrl(A1,”\/\/li[3]\/a\/strong”)<\/strong><\/p>\n
\"twitter_data_galor\"<\/p>\n
 <\/p>\n
Step 9) Pull Domain Authority Metrics of Consumer Internet sites<\/h6>\n
There’s just a few methods you can do this, however I actually like Netpeak Checker<\/a>, it’s fast and easy to make use of and plugs right into the Moz API.<\/p>\n
\"Netpeak_Screenshot\"<\/p>\n
Step 10) VLOOKUP Time<\/h6>\n
Now you need to get your data into one excel sheet, this is going to require a number of VLOOKUPs<\/a>. The constant knowledge level all the way through all of that is the Twitter profile URL, so match your VLOOKUP off that information level.<\/p>\n
Important Notice:<\/strong> 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.<\/p>\n
\"Full_data_set_001\"<\/p>\n
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.<\/p>\n
From here which you can determine influencers just going off Area Authority and Twitter followers.<\/strong><\/p>\n
Q2: What Websites Are Our Customers Studying and Sharing?<\/h1>\n
\u00a0Step 1) Get Your Users Twitter Handles\u00a0<\/span><\/h6>\n
The Full Contact Excel Sheet doesn’t offer you Twitter handles, but it surely provides you Twitter Profile URLs, so simply copy you users’ \u00a0Twitter Profile URLs into a new column, and use the next to find and exchange command:<\/div>\n
\"find<\/div>\n
Unfortunately, that you can’t use “@” within the change field, so you will have to add @ to a brand new cell and concatenate it on to the Twitter user names.<\/div>\n
Step 2) Follow Richard’s “How To Use Twitter Knowledge for In reality Targeted Outreach<\/a>“\u00a0Course of using TAGS<\/a><\/h6>\n
Step 3) Analyze what your users are sharing<\/h6>\n
Here’s a look at domains shared and Area Authority from Twitter customers I have exchanged emails with in the remaining two weeks.<\/p>\n
\"List_of_sites_my_users_are_sharing\"<\/p>\n
There’s some attention-grabbing finds here and a variety of opportunities for doable content material placements.<\/p>\n
If you have a well segmented e-mail marketing list or CRM, that you could smash this down into specific user teams and \u00a0create 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.<\/p>\n
Instance Use Instances:<\/strong><\/p>\n
Have a phase of power customers?<\/strong> – The sites they share regularly would be excellent for a contest<\/p>\n
Have a phase of users who’ve signed up to your email publication, but never purchased your product?<\/strong> – 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.<\/p>\n
Trying to place a section of content material?<\/strong> – be certain that its a site your consumers actually care about and will see<\/p>\n
Have any more use circumstances? Please share them in the comments beneath!<\/h6>\n
The publish Mining Consumer Information in Excel with the FullContact API<\/a> seemed first on SEOgadget<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 […]<\/p>\n
The post Mining User Data in Excel with the FullContact API<\/a> appeared first on SEOgadget<\/a>.<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[72,85,70],"class_list":["post-319","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-content-marketing","tag-excel","tag-guides"],"_links":{"self":[{"href":"https:\/\/www.urlrate.com\/blog\/wp-json\/wp\/v2\/posts\/319","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.urlrate.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.urlrate.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.urlrate.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.urlrate.com\/blog\/wp-json\/wp\/v2\/comments?post=319"}],"version-history":[{"count":2,"href":"https:\/\/www.urlrate.com\/blog\/wp-json\/wp\/v2\/posts\/319\/revisions"}],"predecessor-version":[{"id":590,"href":"https:\/\/www.urlrate.com\/blog\/wp-json\/wp\/v2\/posts\/319\/revisions\/590"}],"wp:attachment":[{"href":"https:\/\/www.urlrate.com\/blog\/wp-json\/wp\/v2\/media?parent=319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.urlrate.com\/blog\/wp-json\/wp\/v2\/categories?post=319"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.urlrate.com\/blog\/wp-json\/wp\/v2\/tags?post=319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}