Upload Up and Schedule to 350 Posts in a Csv File
How to schedule tweets is one of the top questions I'thou asked.
Your own best time to tweet volition vary by your business type, target audition, and time zone.
But if you lot have a global market – what then?
Your best bet is to tweet effectually the clock to catch your followers in all fourth dimension zones.
You've asked, and then – here's how I schedule my tweets!
How to Schedule Tweets Around the Clock
I no longer use or recommend Hootsuite. The tool I currently recommend for bulk uploading of tweets from a .csv file is SmarterQueue.
I apologize that this post needs to be updated! The info is non current.
Take SmarterQueue for a free trial run and meet how you love the ease of bulk uploads!
Disclosure: I'm an affiliate for SmarterQueue and may earn a committee if you purchase after clicking my link.
It gives you the adequacy to "majority upload" upward to 350 scheduled letters at one time. This is an incredible time saver – worth well more than the small cost.
If y'all use it to schedule tweets merely, you could upload 350 tweets in one spreadsheet! (As long as you had naught already scheduled). Notwithstanding, I prefer to keep a collection of smaller files that I can pick and choose when to reuse, and layer over one some other.
I've created several Excel files of "link tweets" – tweets that share links to my blog posts or social media hubs. I decided on a maximum of 64 tweets per file, because that's every bit many equally I can see on my monitor at one time! 😉 I schedule these link tweets to become out on odd numbered hours, around the clock.
Add More than Tweets From Your Favorite Bloggers
Later, I manually schedule the even-numbered hours of 4am to 6pm Pacific with links to my most contempo posts, plus those of other terrific bloggers in my niche. This is my programme – if I don't fill up upwards all the slots, I don't stress well-nigh information technology. I know I've already got a expert presence from my majority upload!
Majority Schedule Quotes & Tips, Too
I've as well fabricated several Excel files with quotes by theme. Some are general (motivational, inspiring), some niche related (creativity, design), some time-specific (freedom quotes for Independence Day, eco quotes for Globe Twenty-four hour period, famous birthdays). I prepare these to become out on the one-half hour, every 4 hours. So these "layer over" my link tweets.
Another file you might want to create: helpful tips relevant to your niche.
If you don't take this much content yet, just space your tweets out more, until you have more blog posts, quotes, and tips collected.
Yous can commencement with tweeting 3 times a 24-hour interval until you accept enough for every iii hours, every other hour, and mayhap eventually hourly. Dan Zarella discovered that the optimum number of tweets per mean solar day is 23! More tweets = more new followers.
This is a bit of work to ready up – merely once you lot take these files set up, you can modify the dates and times in a couple minutes – really! – and exist ready for another couple weeks. And there's no reason non to reuse practiced quotes and tips, or links to good, evergreen content – it's highly unlikely that the aforementioned follower will be on Twitter at the exact fourth dimension to catch these tweets a second time. And even if they do – maybe they'll run across it at simply the time they demand it!
How to Bulk Schedule Tweets
You lot'll create a .csv file in either Excel, Google Docs, Text Edit, or Text Wrangler. Here are the specifics:
- Creating a .csv File with Excel.
- Creating a .csv File with Google Docs Spreadsheet.
- Creating a .csv File with TextEdit.
- Creating a .csv File with TextWrangler.
Now, in the HootSuite dashboard:
1. Click the newspaper airplane (Publisher) icon on the left-aligned launch menu.
ii. Click Schedule in Majority.
3. Upload your bulk schedule
- Click Cull File, locate your bulk schedule file, then click Open.
- Click to select a engagement format. Be certain to select the aforementioned date format as the one used to create your majority schedule.
- Click to select social profile(s) to post the messages, and then clickSubmit.
If you're serious nearly tweeting, I recommend you lot give SmarterQueue a try. And so let me know what yous think of information technology!
Bank check out my tweet schedule on Twitter! If nosotros're not connected yet, follow me here.
What do you think of my tweeting schedule? Tell me in the comments.
If you found some skillful tips here, tweet out this post! Help your followers larn how to schedule tweets.
Source: https://louisem.com/3693/how-to-schedule-tweets
0 Response to "Upload Up and Schedule to 350 Posts in a Csv File"
Post a Comment