Wednesday, September 2, 2015

Capture Tweets with Alteryx Designer

Alteryx Designer comes with a Twitter Search Connector that allows you to pull tweets using your Twitter Account and App. In this Tutorial, I'll walk you through creating a Twitter App and setting up an Alteryx workflow to pull tweets.

In Alteryx, we'll be creating an initial local repository of tweets.

And then modify the workflow so that new tweets are appended to the initial dataset.
Why append? The Twitter Search Macro allows you to search tweets by given search terms, with location as an optional property. The search will only retrieve tweets from the 7 days previous to the search.

When working in an environment that has an Alteryx Server, you can schedule weekly runs of the workflow to automatically stay on top of your twitter feed. You may also want to consider adding the scheduler license to your desktop, see http://insightsthroughdata.com/how-to-automate-data-refresh-operations-to-tableau-server-with-alteryx/.

Don't feel like building it yourself?

Registering a Twitter App

Getting a Twitter account and creating an app is super easy, just follow the steps below to get going!

Signing up for a Twitter Account

You need a twitter account to create a Twitter App, so therefore if you don't already have one, go to dev.twitter.com.

  • Click Sign-in at the top right.
  • And then Sign up now below the log-in form. 
  • Now sign in using the account you just created.

Creating a Twitter App

In order for Alteryx to pull the data from Twitter you'll need to create an App with your Twitter account.

Make sure you are signed into Twitter, and then go to apps.twitter.com

If this is your first app the page will look something like this...if it's not you might want to just skip to the Alteryx Workflow sections!

          
Click  Create New App



Complete the New App form. 
Don't worry about entering a callback URL, we are configuring Alteryx to use your account to pull the tweets.

Read the develop agreement (and agree) and then click Create Your Twitter App at the bottom.

Getting your consumer key and secret

We're almost done. In order to set up the workflow we need the Key and Secret. If you are following along in order the App Details page is now displayed.
Toggle over to the Keys and Access Tokens tabs.
You should not share your key/secret with anybody else! Leave this page open we'll be using the key and secret in the Alteryx workflow created in the next step.