Home > Social Media > Twitter: A Spreadsheet Strategy

Twitter: A Spreadsheet Strategy

Before we leave the topic of Twitter, I want to touch on two things.

The first is how often to tweet.  When I first hit Twitter, this was not a problem because there are only so many hours in the day.  Then I realized with Hootsuite that I could schedule tweets rapidly over the course of say an hour or so.

Watching both my Twitter feed and my sales, I realized there was a correlation for my stuff with what I tweeted to what I sold.

As I was doing this research, I started learning to bulk upload.  At first I did a spreadsheet a day, which ran from around 6 a.m. to about 10 p.m. and focused on one book, with blog posts thrown in as well.

Then I began helping others with promotions on what they were marketing–a group promoting their books together for example.  I began to understand that tweeting could not be inconsistent.  It needed to be focused and well-thought-out to be effective.

(Let me also throw in here that it makes a difference what your books are about.  Some genres sell better via Twitter than others.  I know one person who has sworn off Twitter because when he posts, his sales go down.  I don’t know why.  I don’t have any explanation for it.  But I’m taking him at his word.  So please understand that I’m telling you what has worked for me.  If it doesn’t work for you, try something else!)

What I eventually got to was having spreadsheets of 50 tweets at a time (the max Hootsuite will let you upload).  They are a mix of posts about my blog, about my books, and about my site ebookromancestories.com

At first I sent them out about 3 an hour.  Then I expanded that to every 15 minutes, then every 10.  I now put out tweets every 5 minutes.  I have about 12 spreadsheets prepared that are a mix of tweets to different landing pages for my things.

Each morning I choose 3 to 4 of them (depending on how many of my 200 I have left).  I reset the dates and times and upload them.

Now that everything is set up, I can do this in about 10 minutes in the morning, and tweets are done for the rest of the day.

Every so often, I write up a new spreadsheet or two just to keep things interesting, but I think the variety in what I’ve got works very well.

Oh, and my followers have increased since doing this too.  So don’t think you are going to chase people off–so long as you literally have 100’s of different tweets to different landing pages and are not sending out the same or almost the same one all day every day!

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: