Twitter: A Spreadsheet Strategy

Default thumbnail.

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.

Read More

Twitter: Tools to Use It

Default thumbnail.

July 31, 2012 | No comments yet

Now that we’ve learned to write tweets for Twitter, it’s time to take it to the next level. Obviously if you have a life, the last thing you want to do is sit for hours sending out tweets.  Worse, I think as an intermediate effort, I don’t think Twitter is very effective.  You…

Read More

Twitter: @’s, More hidden gold!

Default thumbnail.

July 26, 2012 | No comments yet

Last time we talked about hashtags.  This time I’ve got more Twitter Gold for you.  I call these the @’s. The idea of the @’s is that these are people on Twitter who will graciously distribute your information to their lists if you send them the information. I discovered one such angel quite…

Read More

Twitter: Hashtags, What They Are, How to Use Them

Default thumbnail.

July 24, 2012 | 5 Comments

We have now come to one of the most well-kept “secrets” of really leveraging Twitter.  They are called hashtags, and they look like this: #greatbooks #money #hope Basically anything you put a # before until the next space is a hashtag, and they are endless. #MakingMoneyFromHome #TakeYourKidtoWorkDay #TreesAreLovely Some hashtags are shortened to…

Read More

Twitter Posts: How to Write Them

Default thumbnail.

July 19, 2012 | No comments yet

Let’s talk a little about the “language barrier” on Twitter. The idea of Twitter is that you can follow a TON of information from different sources if it’s all comprised in 140-characters or less.  So you can read the latest about the big fire that’s in the news and something about the temperature…

Read More

Twitter: The Basics

Default thumbnail.

July 17, 2012 | 2 Comments

Along with Facebook, I resisted Twitter like the plague.  Last year at this time, I thought people who tweeted were a little on the crazy side.  Well, I guess I’ve joined the crazies because I love Twitter, and it is, by far, my favorite way to market. However, it wasn’t a one-jump to…

Read More