Starting in October 2014, I automated many tweets by scheduling them for the next year. It cost $126. Within 6 months, I’ve increased my Twitter following by 32%, had interactions with many people I’d love to meet in person, and removed myself from the Twitter Treadmill. And now I use Twitter day to day however I like.
Monday through Saturday at 9:21am-ish, you’ll see me tweet out an article that I have actually read with a mention of the author.
It’s part of my ongoing experiment to use social media platforms more sustainably and effectively.
Even though I joined Twitter back in 2009, I never really took to the platform. It seemed too broadcast-oriented with an insular culture where soon people were fighting over Klout scores. It seemed absurd at worst and tedious at best.
I also couldn’t see any huge traffic benefit to investing time when even tweets from my industry’s most influential leaders drive less than 1% click through rates.
It’s sort of like a giant conference. Each session or networking event doesn’t drive a lead or sale, but the people you see, meet, talk about, and talk with all drive success for everyone in the future.
The question though remains – how do you maintain that visibility and make initial connections without draining hours into a platform that you don’t own. In other words, how do you get to meet and spark conversations with people at the conference without sitting through every boring session, standing in every lunch line, and hovering over the coffee table?
For me, that’s where automated tweets of posts that I have read and found useful comes in. Writing custom tweets, searching and tagging author at the end of each article, then posting is productivity death by a thousand cuts. But batch writing, and scheduling the tweets saves time while keeping the benefits of custom tweets.
If your goal is build visibility on Twitter, make connections, build a “sharing safety net” to free your Twitter-self up and save time while doing it, then this strategy is for you.
Automating & Scheduling Twitter for a Year
Step 1 – Gather a list of URLs
You’re going to need a list of URLs that you have read or want to share. I pulled all the links that I shared in the first 100 editions of my newsletter. That source gave me a list of 350+ URLs that I know are high quality.
Depending on your browsing habits, your bookmarks might be a good place to look. I could do an entire post on digging these up, but in the meantime, you can grab my actual final list of 326 tweets here.
Either way, you’ll need a raw list of URLs to share – the larger, the better.
Step 2 – Get article titles
Article titles are going to be the foundation of your actual tweet, and you can quickly get them via Screaming Frog.
– Paste your list of URLs into a .txt file
– Change Screaming Frog to List Mode, upload your file and crawl
– Export your crawl, which will include titles of all your URLs.
Step 3 – Set up your spreadsheet
I use Google Docs, but Microsoft Excel works very well too. Import your CSV export from Screaming Frog.
Clean up the columns so that you have the URL and Title left
Then, go ahead and add columns for “Author Handle”, “Comment”, “Tweet”, “Total Length” and “Adjusted Length”
Aside – you can view and copy my actual spreadsheet here – just click to the Example Sheet tab.
Step 4 – Find the actual author’s handle
This step is essential. It’s difference between just posting links aimlessly to Twitter and connecting with individuals. When I share a link on Twitter, I deliberately mention the author to publicly thank them, solicit feedback, and bring up something in common with them. It’s sort of the whole point.
That said, it is also often very difficult to track down the Twitter handle of the actual author of a specific post. I don’t want to mention the publication or website – that’s too impersonal. I want to mention the actual author, and that takes some digging.
There are some scraping tools that you can use, but in my experience, there’s no universal footprint across the web for article author’s Twitter handle. It’s easier to just get help.
And this task is very straightforward to outsource. And if you’ve never outsourced a task, then this is a great first time task.
I hired 2 people for the project. Norma and Jinnelle in The Philippines found all the author’s Twitter handles in about 2 days. They had some errors, but by comparing their work, I was able to quickly identify any errors and clean up the spreadsheet.
For $26 total cost for both freelancers (and 1 other person who never sent a file in), I had author Twitter handles for 326 URLs.
Place the handles in the Author Handles columns – including the @ sign.
Step 5 – Write a comment for each URL
This step is optional. Especially for articles with short titles, it allows you to build it out a bit. In the Comments column, just write a short comment that fits your voice “insightful piece”, “using this everyday”, etc.
Step 6 – Concatenate tweets in the spreadsheet
Now you can actually create your Tweet. Use the concatenate formula in the Tweet column to combine [Title] + [URL] + “by” + [Author Handle] + [Comment]. Click the image below to enlarge it.
Copy your concatenate formula down, then copy and paste values so that you can edit the cells.
Step 7 – Edit & revise the tweets
Now you need to make sure the tweet comes in under 140 characters. To do that, create a new column that combines [Title] + “by” + [Author Handle] + [Comment] with the concatenate formula. Note that it basically your tweet, minus the URL.
Run the LEN formula against the new column and add 22 to find out the true length of your tweet. Twitter makes all URLs of any length 22 characters. The actual formula for Google Docs will be =SUM(22,LEN(cell#))
Sort the column to see if you have any tweets over 140 characters. If so, edit.
Now, you need to actually read through all your tweets to make sure they work and do a general check over.
Step 8 – Randomize the tweets
Now, you need a way to randomize your tweets so that you don’t post the same type tweet 10 days in a row. This step is not required, but highly recommended if you want to not be annoying, and make your tweets look more natural. There’s a bonus feature in Google Docs that allows you to do this quickly.
In a new column, run the RAND function to generate a random number. Copy and save the values so that each tweet is assigned a random number. Then filter all your columns with that random number column.
Your tweets are now randomized!
If you haven’t already, do a general clean up of your spreadsheet, save a backup, and create a spreadsheet with only your tweets in Column A.
Export as a CSV file.
Step 9 – Purchase a Buffer Awesome Plan
There’s a ton of tweet scheduling tools out on the Internet. But no tool makes this as easy as Buffer.
Go sign up and get an Awesome Account here. It will allow you to schedule more than 5 tweets at a time (up to 200 at once). If you haven’t already, sync up your account with Twitter (it will also work with LinkedIn, Facebook, and Google+ Pages).
Step 10 – Upload via Bulk Buffer
Buffer doesn’t actually have a CSV bulk upload function, but they do have an API which a separate, free service called Bulk Buffer uses.
Go to BulkBuffer.com, click Start Uploading, sync it with your Buffer account, and head to file upload.
Upload your CSV file and select the settings you want. Then go off and leave it for a bit.
Aside – I donated $5 to BulkBuffer for this simple, but solid timesaving app. I recommend doing the same (or more!).
Step 11 – Final Check in Buffer
Once Bulk Buffer is done, then you can go to your Buffer account and see all your queued up tweets! If you have 365 tweets for ready every day – then congratulations, you have automated Twitter for the next year!
Aside – of course, Buffer allows up to 200, so set a reminder to upload the rest midway through the year.
My Experience after 6 Months
I wish that I could say that automating Twitter shares made my followers and traffic skyrocket.
Over ~6 months, my follower count increased +28.6% to 305 from 237. That’s respectable, but along the same trend as before automating. Take note that the extra bump in December came from a giveaway.
Traffic from Twitter to my posts has also been around the same.
However, it has been a worthwhile success in 4 ways:
1. My interactions with actual people on Twitter has skyrocketed. I get a favorite on nearly every tweet I send out. I don’t get click-throughs, but I do get more engagement than I used to – most all from people that I mention.
2. I get to share content that I do appreciate in a fast, effective manner. I easily save hours versus manually clicking and typing a custom tweet. My browsing workflow is really productive (allowing me to curate a newsletter from hundreds of sources every week).
3. I have no cognitive guilt or nagging feeling of social media’s amorphous demand to “share more!” All those demands to “use Twitter more” are gone. I have a baseline of sharing that I’m comfortable with, which allows me to use the platform however I want.
4. I have an actual consistent dataset to analyze and make changes with. Unless I actively tweeted, I never knew if some piece of social media advice was actually true. All the talk of using hashtags, mentioning, best times to share, etc, etc can never be proven if it’s best for your account until you try it out. Batch scheduling & automation allows me to test those assumptions productively and efficiently.
I haven’t actively executed this on Facebook or LinkedIn strategy, but the steps and tools will be the same, and could certainly be worthwhile if that’s where even part of your audience is. For me, that will be the next step with automating/scheduling now that I know how well it can work.
Be sure to actually use Twitter, and know what you want to achieve. Sharing content for the sake of sharing content is not an effective approach.
The whole point is not to disengage, but to allow you to actually engage more with the people you appreciate by batching the actual Tweeting process. Automate the sharing so that you can focus on interactions.
Go find a good source of (preferably timeless) links that you want to share, organize them, find the author’s handle, and automate the shares!