Show Panel

Setup a Twitter Archive in 5 Minutes Using Zapier

There are plenty of paid services that will help you setup a Twitter archive while also offering twitter monitoring and social listening, but I am going to show you how to set up your own Twitter archive using Google Sheets, Google Calendar and Zapier.

With this method you will be able archive tweets from your Twitter account indefinitely.

Zapier also offers many other powerful integrations between Twitter and Google for expanded archiving of Twitter activity. You can keep a record of tweets from your competitor’s accounts, monitor tweets from a Twitter list or archive tweets from search terms and hash tags. However for this Zap we are just going to cover how to archive your own tweets.

To get started archiving your tweets you’ll need a free Zapier account, a Google Calendar and a fresh Google Sheet to use as your archive.

Archiving Tweets With Google Calendar

If you want to setup a historical record of tweets from your account in a calendar view then just use Zapier’s built in Google Calendar Zap. My only recommendation is that you create a new Google Calendar so you can easily turn on and off the tweets in your calendar view. I named mine “Twitter Archive”.

Screen Shot 2015-06-07 at 1.08.58 PM

In the Zap builder Select Twitter > My Tweet then Google Calendar > New Detailed Event

Screen Shot 2015-06-07 at 1.02.36 PM

Select your linked Twitter account

Screen Shot 2015-06-06 at 2.27.05 PM

Select your linked Google Calendar account

Screen Shot 2015-06-11 at 11.25.50 PM

Skip step 4.

In step 5 make sure to select “Twitter Archive” (or whatever you named your calendar).

Screen Shot 2015-06-07 at 1.11.31 PM

Zapier’s default settings auto-fill such that new tweets will be entered into your calendar as if they were calendar events, with the date that you tweeted as the start and end date of the event. Turn the Zap on and you are ready to go!

Records will be added to your Google Calendar within 15 minutes of sending your next Tweet. It will continue until you turn off the Zap.

Archiving Tweets With Google Sheets

This Zap will archive your tweets into Google Sheets and allow you to sort tweets by date, number of favorites and number of retweets. You can even graph your Tweets if you want to get that nerdy. I prefer this method because you can always transfer Google Sheets data into a Google Calendar.

Before you start you will want to add column titles for the tweet data you want to archive. Zapier will recognize these column titles when you are building the Zap.

For this example I chose to track the tweet text, how many retweets it received, how many favorites it received and when it was tweeted. Your Google Sheets column headers should look like this:

Screen Shot 2015-06-07 at 1.58.47 PM

Now head to the Zap builder and select Twitter > My Tweet on the left and Google Sheets > Create Spreadsheet Row on the right

Screen Shot 2015-06-06 at 2.23.53 PM

Select your linked Twitter account

Screen Shot 2015-06-06 at 2.27.05 PM

Select your linked Google Sheets account

Screen Shot 2015-06-06 at 2.26.11 PM

Skip step 4 regarding filters. We won’t use any filters here.

Step 5 is where you will select what tweet data to track and where to map it to the columns in Google Sheets.

Not sure which Twitter fields to pick? I have put together a special guide for you below.

Notice how the names of the columns from your Gogle Sheet show up as separate rows in Zapier

Screen Shot 2015-06-07 at 2.03.33 PM

Select “Insert Fields” on each row and select the corresponding Twitter field you want to track.

Now just turn on the Zap and you’re done!

Records will be added to the google sheet within 15 minutes of sending your next Tweet. It will continue until you turn the Zap off.

Here is what the records look like in the Google Sheet after Zapier imports them from my Twitter timeline (with some styling added to the column headers).

Screen Shot 2015-06-10 at 11.18.57 PM


BONUS: How to Pick the Right Twitter Field Data

Zapier does its best to make it easy for the common man to integrate with Twitter but there can be a learning curve.

For me it was understanding which Twitter fields corresponded to which information I wanted to track.

For instance, what exactly does “Retweeted Status Truncated” mean and why would I want to use it?

You may recognize this big scary list when you were clicking on “Insert Fields”.

Screen Shot 2015-06-11 at 10.39.52 PM

Not to worry. To help you understand what these fields mean I put together a guide of all the most important Twitter fields in Zapier in easy to understand terms.

Feel free to copy/paste the info from my Google Sheet or take a glance at the screenshot below.


Changing your WordPress Favicon

What is a Favicon? That little tiny picture on the tab at the top of your browser. Customizing this little guy on your WordPress blog is as simple as installing a plugin and uploading a compatible image file.

Screen Shot 2015-06-08 at 9.51.28 PM

^Look! there’s my favicon^

I use the All in One Favicon Plugin by Technotronic and I could’t be happier. The plugin plays well with any theme and can be easily installed in 10 minuets or less. Just upload an image and it works beautifully.

A good favicon is no more complex than a 16×16 pixel .GIF or .ICO of your company logo. It must be legible on a very small scale. For instance here are some great examples of easy to identify favicons from popular websites.

Screen Shot 2015-06-08 at 9.57.45 PM


Screen Shot 2015-06-08 at 9.58.41 PM


Screen Shot 2015-06-08 at 9.59.12 PM


Don’t have an image to use? You will need a 16 x 16 pixel image with the file type of either .GIF or .ICO.  If you are like me you probably didn’t have a 16×16 picture of yourself or your logo just lying around.

That’s why I used Favicon From Pics to create the favicon for

The process is so easy you can do it in 3 steps.

  1. Go to the Favicon From Pics website and follow the easy steps to get a 16×16 pixel .GIF or .ICO.
  2. Install and activate the All in One Favicon Plugin on your WordPress site.
  3. Upload the pic to your WordPress media library then set the pic as your favicon in the plugin’s settings.

That’s it! you are done!

6 Facts Every Rookie Podcaster Should Know

For those that have never produced a podcast before here are 6 facts every rookie podcaster should know before they get started.

1: You Don’t Need an iPod to Listen to a Podcast

The podcast publishing model has changed drastically since Apple coined the term. That being said Apple iTunes is still a huge player in the podcast publishing model. I would say about 80% of podcast downloads still happen on iTunes but even then you don’t have to be an iPhone user to get access. Anyone with the free iTunes software (available on Mac and PC) can start using podcasts right now.

More recently podcasts have exploded onto other publishing platforms for even wider distribution. Stitcher Radio is quickly becoming a podcast leader and they publish hundreds of new podcasts every week. Media hosting providers like PodBean, Libsyn, Blubrry and PodOmatic focus specifically on podcast publishing as a service allowing thousands of podcasters across the globe to stream their audio recordings on their websites. Soundcloud is even pivoting from music to more of a podcasting model, and they have a gorgeous embeddable audio player. You may not realize this but YouTube is also a popular place to publish a podcast. To put it simply you aren’t just speaking to the iPhone user anymore. Anyone with internet access can listen to a podcast.

2: Producing a Podcast is Essentially Free and Publishing is Cheap

Radio shows like Howard Stern and Rush Limbaugh have huge budgets and six figure studio setups to produce their shows. Don’t be fooled. You need none of that. Many podcasts are produced with incredibly modest technology. Technically all you need is the built-in microphone on your computer. If you want even just a little better audio quality you can get a Blue Yeti for a small investment. That being said, don’t let the equipment be a hurdle to starting your podcast, it’s negligible.

You may want to edit your podcast to remove any unwanted sounds like “um’s” and “uh’s”, add an intro and outro or get rid of awkward fumbling with technology at the beginning and ends of the recording. All of these artifacts can be easily edited in and out of your recording with basic audio editing software. iMovie has enough firepower to edit any audio track and there are plenty of free editors out there for download. Just google around.

Look into the publishing platforms mentioned above. I would start with Soundcloud. It’s free.

3: You Need to Build a Community Online AND Offline

Don’t expect hundreds of people to start rushing to your podcast as soon as you publish an episode. You have to get the word out just like anything else, and the best way to market anything is still in person. Go to local networking events, conferences and meetups and proudly announce your podcast to everyone you meet. This is in addition to regular updates on your newsletter, blog and social media outlets. Never stop talking about and mentioning your podcast.

One of the beauties of a podcast is that it’s mobile. Do some live recordings at industry dinners and schedule time for a round of quick interviews with other experts at a live event. They will likely let you record them so long as you send them a free copy of the podcast. Also ask them to distribute it do their own audiences. It’s a great way to leverage their networks rather than building your own from scratch.

4: It’s OK to Ask for the A-Lister’s Interview

Don’t let your meager audience stop you from catching those big fish. You will be surprised who will say yes to a podcast interview. Authors of new books, public speakers, business owners, internet moguls. All these people are either trying to sell something or they love to hear themselves talk. If given an opportunity to market their product to another network they will.

Try to time your ask at critical junctures in their career if possible. Did they just launch a book? Do a TED talk? Receive an award? Giving them an opportunity to talk about their latest big win is a great way to get an easy “Yes”. Although it may be intimidating, the worst thing that could happen is that they say no.

5: Promote and Market your Podcast in Multiple Outlets

Always post the podcast in as many places as you can. Of course it will on iTunes or Soundcloud first, but make sure it’s on your website, social media and email blast. Also, the only way to make a podcast searchable by Google is to transcribe it into text. Take the time to do this and post the transcription on your blog, or you can have Rev do it for you for $1 a minute. You will attract organic search traffic and now they have an option to either read or listen to your podcast. Then, each new podcast becomes a new page of content.

Add the link to your podcast on your email signature and business card so that every email you send you market your podcast. Mention it on Facebook and Twitter on a regular basis (use Bit.Ly to track link clicks). Register your podcast with various podcast directories – there are at least 50 directories if you do a few Google searches.

If you are serious you can even do a PPC campaign and write a press release for your podcast.

6: SEO Optimize your Podcast’s Name and Description

Use Google Keyword Planner to find out the best keywords to include in your title and meta description. Don’t just go with what sounds good, go with what people are actually searching for online. Do this same thing for the description of each podcast and be sure to include names of your guests, where they work and other “hooks” that might draw people into your content. Also think about categorizing your content in more than one place in iTunes. For instance a business podcast could live in “Business > Business News” as well as “Business > Management & Marketing”. iTunes allows up to two categories.

Don’t Forget…

The most important thing to remember is to just do it no matter what. Don’t let technology or lack of experience stop you from putting the thing out there. Imperfect action is better than no action at all.

Hope this helps!

How Noah Kagen got Big Time Bloggers to Care About App Sumo

App Sumo founder Noah Kagen came up with this painfully obvious PR tactic: ask the bloggers what they want to write about, then give it to them on a sliver platter.

Knowing that he needed to get the word out in a serious way during the infancy of his new business he couldn’t afford to wait for them to find him; so he went out and gave them the content they wanted to write about by asking them one simple question: “What are your favorite apps?”
The bloggers told Noah. Noah went and put a deal together for those apps. The bloggers wrote about the deal. The bloggers benefited from the deal (KEY Point…). People heard and bought the apps. Noah sold a sumo-load of apps.

It seems so simple I feel like I should write more…this can’t be it…is it?

Yup, that’s it.

App Sumo distributes web applications by hooking up app publishers and web geeks – kind of like groupons for web apps. As you know there a million and one web app software companies out there and they all want to sell to the same web geeks. App Sumo helps.

Tags: , , , , , ,