Home / Ideas & Insights / Blog / How To Bulk-Schedule Tweets Like A Digital Agency

How To Bulk-Schedule Tweets Like A Digital Agency

Hootsuite is very handy for scheduling tweets in advance!

It’s free to schedule them one by one – but the bulk scheduling option in the premium ($9.99/month) version really takes some of the legwork out ofsocial media marketing.

However, bulk scheduling can be slightly tricky if you’re new to Hootsuite. There’s a lot of contradictory advice out there.

So here’s the Intergage digital marketing agency guide to bulk scheduling….

For the purposes of this exercise, we’ll assume you want to schedule tweets as part of your Twitter marketing (but it’s also handy for LinkedIn, Google+ and using Facebook for business.

Step 1 – First you need to get or upgrade to a premium Hootsuite account ($9.99/month)

It’s free for the first 30 days so give it a go.

Step 2 – Creating Your Bulk Scheduling Spreadsheet

This is the bit that usually gets people cursing their PC but it doesn’t have to be painful.
Your spreadsheet needs to be:

  • three columns – one for the date and time, one for the tweet, one for any links to be shared
  • saved in comma delimited format (you will need commas after each date in the date column and after each tweet)

Important Tip: Your Excel spreadsheet will automatically load three worksheets as a default (tabbed as Sheet1, Sheet2, Sheet3) when you create a new file. Delete the Sheet2 and Sheet3 tabs otherwise your CSV (comma delimited) file will not save properly.

During the saving process, you may see a dialogue box that says “…example.csv may contain features that are not compatible with CSV (comma delimited). Do you want to keep the workbook in this format?” Simply click the ‘Yes’ button.

Step 3 – Editing Your Spreadsheet File

Don’t worry about giving your columns headers. Just add your first date to cell A1, your first tweet to cell B1 and the link you want to share with that tweet to cell C1 (then repeat the process for each successive row).

Time-saving Tip: Are you adding tweets on successive days? Simply enter the date in one cell then drag the little square in the bottom right-hand corner of the cell down the column to add successive dates.

Important Tip: Get the date format right. Highlight your dates, right click on them and select Format Cells. Choose Custom and choose dd/mm/yyyy/ hh:mm. Your dates/times should follow this example – 01/09/2012 09:30:00, (don’t forget the space between date and time and that all-important comma at the end!)

Cell-Formatingaug12

Get the times right. As far as Hootsuite is concerned, you can schedule tweet times only in five-minute increments, ie 09:00, 09:05, 09:10: 09:15 or 21:00, 21:05, 21:10: 21:15 etc.

Write your tweets. They must be 140 characters or fewer. Leave more room if you’re adding a link. (I keep my tweets short – below 100 characters if possible. Shorter tweets tend to be more likely to be retweeted).

Handy Tip: In theory you should add a comma after each tweet in order for the bulk uploading from the comma delimited spreadsheet. But in reality it’s not necessary. It will work without them – and the upload process will automatically insert a dash between the last word of your tweet and the start of the URL you are sharing. If need be, you can edit tweets in the Hootsuite interface by clicking on the pencil/edit icon that appears at the end of each tweet when you highlight it – but you’ll have to edit the tweets one by one.

You don’t need to put the tweets in “quote marks”. Some people will tell you that you do but you don’t. If you do, your tweets will still appear but they will appear in quotes.

Add the links. Just paste them in. You won’t need commas after the links.

Step 4 – Uploading The Tweets To Hootsuite

Log in to Hootsuite.

  • Make sure you have added the social profile you want to use to publish your updates (for this example, we are using a Twitter profile)
  • Log in and click on the Publisher button (the paper plane icon)
  • Click the Schedule In Bulk button.
  • Click Browse and select the csv file with your tweets.
  • Choose the social media profile you wish to update (in this case Twitter).
  • Click the Submit button.
  • You should see a mint green dialogue box that says: “Successfully scheduled messages”.

Still having problems? If you’re an Intergage client, simply contact your Account Manager.

If you’re not an Intergage client, contact our Marketing Manager Emma Barrow and discover all the great help you could be getting!

Back to ListingPreviousNext

Comments

No posts found, be the first!

[b]Bold Text[/b]
[i]Italic Text[/i]
[u]Underline Text[/u]
[size=12]Sized Text[/size]
[color=red]Coloured Text[/color]
[quote]'Quote Text'[/quote]
[url]http://example.com[/url] or [url=http://example.com]Example[/url]
[img]http://example.com/image.png[/img]
[list][*] Point one [*] Point two[/list]

Copyright © 2016 Intergage Ltd  |  All Rights Reserved  |  Registered in England  |  Company No. 03989761  |  VAT No. 754 8431 12