Twitter: A Spreadsheet Strategy

August 2, 2012 | No comments yet

Send to Kindle

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!

*~*

“Practical, easy to understand instructions
for success!”

How to Prepare, Launch, and Run

a Successful KDPSelect Free-Day Campaign

(The Indie Author’s Ultimate Guide)

Includes Step-by-Step How to Bulk Upload with Hootsuite!

$4.99

Buy Now!

 

Some of the links in the post above are “affiliate links.” This means if you click on the link and purchase the item, we will receive an affiliate commission. Regardless, we only recommend products or services we believe will add value to our readers.

Share Our Posts

  • Delicious
  • Digg
  • Newsvine
  • RSS
  • StumbleUpon
  • Technorati

Comments

There are no comments on this entry.

Trackbacks

There are no trackbacks on this entry

Add a Comment

*