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

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!


Twitter: Tools to Use It

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 have to have a presence on Twitter–not post once in awhile about what you just ate for supper.

And it is really difficult to find blocks of time to tweet consistently.  Maybe some can.  For me, that was a major uphill battle.

So I went out and found some tools to help.

One is called Tweetdeck.  I know friends who use it and love it.  So please feel free to check it out.  I don’t use that one much and don’t know the intricacies of how it works and what it can do.  But it is one option.

Then there’s Social Oomph.  Social Oomph costs $30 a month.  The benefit of Social Oomph is being able to “spin” tweets.  Basically you make a post with say 5 tweets in it.  Then you schedule that post to shuffle and run every hour (or two or six or whatever).  SO chooses one of those five and sends it out every hour.  This can be really great if you literally want to set it and forget it.  Also, it will run either indefinitely or for a set amount of time, in case you have a campaign that lasts a week and then you want those tweets taken down.

However, SO can be expensive especially if you are just starting out.

For $6 a month, you can go with Hootsuite, which is the program I learned and the one I’m still using.

You can do Hootsuite for free, but if so, you only get the manual upload, which means pasting each tweet in separately and scheduling a time.  This is almost as time consuming as sitting there sending out individual tweets, with the one exception that you could do them all at once and then leave it be.

If, however, you have $6 a month, I recommend learning to bulk upload through Hootsuite.

I will be the first to admit that it is not an easy process to learn, but once you get it, it will free up many hours of your valuable time.

If you are interested in doing the bulk uploading through HS, here’s how (get out the aspirin!):

Advanced Hootsuite Tweeting (Bulk Upload)

If you have the pro version of Hootsuite ($6 a month), you can do bulk uploading of tweets.

Step 1

Create a new document in Excel.  You will only be using the first two columns.

Column A is the date and time formatted as:  dd/mm/yyyy hh:mm  so that Oct. 9, 2011 at 6:30 a.m. would read 09/10/2011 06:30

The date and time HAVE to be in this form (with all leading zeros intact) or your upload will not work!  I will show you how to do that in a little bit.  And the time has to be in increments of 5.  So 04:15 not 04:18.

If Excel changes this format (and it will try), you will have to click:

The arrow number format section where it usually says “General”

More Number Formats (at the bottom)

Next Click “Custom”

Then in the “Type” box that now says “General,” type this: dd/mm/yyyy hh:mm  (those letters and symbols NOT your date).  Then click “Okay.”


In Cell A2, type this formula:



This means that the date and time in A2 is relative to A1 and will advance 25 minutes.  And advance of 1 hour and 30 minutes would look like this:



Then copy and paste that formula in A3, A4, etc. for as many tweets as you have to schedule.  This prevents you from having to retype in every date and time each time you do a new spreadsheet (as tomorrow your date will change!).

To change the advance of any of the times down the spreadsheet, just click on that cell and replace the time there with the time you want.  So to go from 1:30 minute intervals to 15 minute intervals, you would make it look like this:



Column B is the actual tweet.  Remember, you still only have 140 characters, and Hootsuite will not take any of your upload if even one tweet is too long.  You can use hashtags and @’s, but don’t start a tweet with an @, Excel will not accept it.


Step 2

You are now going to write your tweets.

Open a Word document and write your tweets.  (This sounds like an unnecessary extra step, but later on you will be glad to have this to refer back to.)  When I did this, I listed each book and the corresponding URLs for that book.  For example:


Staci Stallings Amazon
Free Preview Nook


This is for my book COWBOY.  The “Staci Stallings” link is to my bookshelf which gives the Kindle and Nook and in Print links as well as a blurb and pic of the book.

“Amazon” is the direct link to the Kindle version

“Nook” is the direct link to the Nook version

“Free Preview” is the link to Your Book Authors, which gives a free preview of the book.

Then I can mix and match these with the review-blurbs and hashtags like this:

“One of the most gripping contemporary romances I’ve read in the past three years…” COWBOY #99Cents #FreePreview

“From beginning to end, Cowboy is a truly inspiring novel.” COWBOY #99Cents #Kindle #Christian

Now that you have some tweets written (you need about 5 or 6 for your first test run experiment). Copy and paste them into the Excel Spreadsheet with the dates and times ready.

Step 3

Save your Excel spreadsheet as Test Run #1

Make sure your dates and times are at least 10 minutes from now.

Make sure you have only your tweets in Column B and nothing else on the spreadsheet.

Please note:  You can NEVER have a double tweet that is exactly the same as one in the Hootsuite system at one time.  If you have to do several that are close, change the hashtags or move things around.  Tweets that are exactly the same, even a few hours apart will not be accepted until the first one has run and is gone.

To get around this issue, plan to create separate Tweet Templates Spreadsheets, each with different tweets from the others.  For me, I label them A, B, C.   On Monday, I upload A.  Tuesday B.  Wednesday C.  So that on Thursday  can do A again and it doesn’t double up any tweets.

Step 4 (on your second run and beyond; skip this step for your first run)

Replace the date. (On subsequent runs, you will have to replace the date. Skip this step if it is your first time through.)

When you have to change the date and time in Column A to reflect when you want these new tweets to start running, here is how.  Remember, Hootsuite will not run anything less than 10 minutes from when you upload it. Also, the time has to be divisible by 5.  So 4:15, not 4:19.

Put your cursor into A1.

Change the date you want it to be by retyping what is there or by deleting and retyping.

Set the times you want

Everything after A1 is relative.  Remember the formula looks like this:


What this means is that you take the time in A1 and go forward 25 minutes.

If it said (1,25,0), that would be 1 hour, 25 minutes.

THESE MUST BE IN 5 MINUTE INCREMENTS.  Hootsuite will not accept anything else.

Format the date and time if necessary.

Excel is just bizarre on this point, so stick with me, you’re almost there.

For some unknown reason, Excel does not like leading zeros, and Hootsuite doesn’t accept a bulk upload without them.

So look at the dates and times in Column A.  If they are not formatted like this:

dd/mm/yyyy hh:mm

you HAVE to fix them.

To do so, highlight all of Column A.  Go up to Format, and click “More Number Formats.”  Then click Custom.

In the box marked “Type:”  type in:  dd/mm/yyyy hh:mm  (those letters and symbols, not the actual date and time).

This should reformat all of Column A as needed. (And you may have to do this every time… until Excel believes you are serious. Sorry. I’ve found no way around this one!)


Step 5

Finally you are ready to tackle uploading.

First, save the spreadsheet somewhere on your system that you can find it in an Excel Document as Test Run #1.  Save it as a spreadsheet first.

Now resave it as a CSV (comma-separated value).  To do this, simply click Save As.  Scroll to the bottom to “Other formats.”

Now under Save As Type, click that to get the list of other types of files to save it as.  Find “CSV” on the list and click that.

Excel will probably protest twice, but simply click “Yes” each time.


Step 7 (this is it!)

Now go to Hootsuite.

In the Compose box, click the Scheduler and go down to “Try bulk upload.”

This will give you a dialogue box.  In the first Browse box, find the CSV file from your computer.  Select the twitter account you want to upload this to, and click Submit.


At this point, you will have to read and troubleshoot your spreadsheet.  Any problem in red is something that must be fixed before you can upload.  Fix and try again.

Possible issues:

Tweets that are too long. Shorten them.

Column A isn’t formatted correctly or the dates are not in the future.

You have double tweets with previous uploads. Change some part of your tweet and try again.


Fix whatever issues show up and try again.

If Hootsuite simply says it didn’t upload, the problem is you tried to upload the Excel doc rather than the CSV.  Try the CSV.


If all the tweets go through and are scheduled, it will say “You have successfully uploaded X number of tweets.”

If you get that message, do a cartwheel because you’ve mastered something very few ever do!


Some additional notes:

* You can send up to 50 tweets to the bulk uploader at a time.

* You can schedule no more than 200 messages scheduled through uploader at a time, and you cannot duplicate a tweet that is presently scheduled. (Once it runs, you can then reschedule even on the same day.)

* If you sent a tweet yesterday and it’s still in the queue, you cannot duplicate it today.  So I set up three basic spreadsheets A, B, C and I rotate them to avoid this problem.


We’ll talk more about spreadsheets next time!  Good luck!

Twitter: @’s, More hidden gold!

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 on accident.  His/her name is @kindle_promo  This person has a list of over 39,000 and will RT your info if you send it to them.

So a tweet with an @ would look something like this:

“Maggie and Keith have deep wounds from painful childhood experiences” DEEP IN THE HEART #KindleFire @kindle_promo


You can also send it directly to them by putting the @ at the beginning of the tweet.

Generally speaking, I try to thank my @’s as much as possible for their help.  For awhile (through my free days), I used these people quite often.  Since my free days, I have kind of backed off–just not wanting to be annoying.  However, they are good as gold so treat them that way.

Here is a list of some of my @’s:











It is helpful to follow them before you start sending them things and make sure your genre fits what they RT.  But this is a great way to broaden your reach on Twitter.

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

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:




Basically anything you put a # before until the next space is a hashtag, and they are endless.




Some hashtags are shortened to stand for other things:  #GNFA (Grace & Faith Authors) #LI (Love Inspired) #tworship (Twitter worship).  Others are words mashed together:  #amreading #amwriting #currentlyreading

They might look weird, but these little tags are Twitter gold!


Because they get your twitter post on lists that are read by many people who are NOT your followers.

For example, a person can search for #amreading and read all of the posts with that hashtag in it.  And yes, people do that.

They search things like #bookgiveaway and #greatbooks A LOT.

So you want to learn to use these and use them well.

You can put hashtags at the end of your tweet:

“I fell in love with these characters.”  COMING UNDONE #Bookreviews #reviews #Amazonlikes #Amazon #Christian #fiction

Or incorporate them:

So #blessed that my #reviewers are loving DEEP IN THE HEART! You ALL ROCK! #Amazon #Kindle #Amazon #faith #read

But not using hashtags will hamstring your campaign.  You want to get your info to as many people as possible, and hashtags let you do that at the expense of a few characters.

One caveat we’ve learned is that on the lists, there are TWO different lists.  For example, if you will go to Twitter and search #amreading you will notice that there is a Top and an All button at the Top.

“Top” tweets are decided based on some algorithm that combines how many times you’ve tweeted to that list and how many people have clicked on your links.  And you want to be on the Top list because THAT’S the one that people who don’t know will be given.  So choose a couple of hashtags and work them until you get on that Top list.

You will be glad you put the effort into it.

Here are some hashtags to get you started:

Generic Book Hashtags



































Amazon Book Hashtags












BN Book Hashtags







Christian Hashtags










































Free Kindle Hashtags














#RETWEET if you love #FreeKindle #Christian #ebooks like COMING UNDONE





















Young Adult books hashtags












Miscellaneous Hashtags




Twitter Posts: How to Write Them

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 in Seattle and then something about book marketing.

Think of it as scanning headlines.  You survey the headlines quickly and you decide if you want to follow any of the links (read more into the story) or not.

You can also have conversations and even group chats via Twitter.

But the basic idea is that you can follow people, and they can tell you what’s going on in 140-characters or less.

So how to entice people to follow YOU?  That’s the #1 issue on Twitter.

Remember Push & Pull marketing?  Let’s start there.

You really don’t want all of your tweets to be ads for your books.  So you need to give people other landing pages that will guide them gently TO your books.  Even as some of your tweets should take readers right to your buy pages.

I’ve heard people who are scared of posting about their books, but from what I’ve learned if you do it right, those who WANT to know about your books will outnumber those who think you should never post about your books.  So it’s a balancing act (that I’ll give you more help navigating in the next post).

For now, how to write a Twitter post (or how to understand one).

Your posts should have:





The hook gets people’s attention.  Which would you read further:   Afraid of change? Don’t be! Here’s how to embrace it!    OR…  Here is an article on how to cope with change…

Good hooks will get you noticed.

Info:  You need to give the reader SOMETHING as to what your content will contain.  For me, most of the time this is the name of the article or the book I’m tweeting about.

Link:  If you don’t give them a way to follow you to your content, they won’t.  Give them a link!

Hashtags:  This is a Twitter secret we will talk about next time.  For now, these are those goofy looking things with the # sign in front.  Like #ammarketing #reading #greatbooks  For now, know you need to learn how to use these.  Next time we’ll talk about how.

Here are some of my tweets for you to dissect.  Write some of your own and get started:


A lot can change in 10 years… REUNION #cleanreadsbookclub #NookBook #Christian #GoodReads

Make the most out of where you are! MAXIMIZE YOUR STATE #reader #blogpost #myWANA #RT

When you read “Christian fiction at its best!” it’s a #NuggetofJoy COWBOY “Wow!” #Christian #LovedIt #Amazon #Kindle

Twitter: The Basics

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 be here thing for me.  My enjoyment of Twitter began as hate and loathing.

Simply put:  I just didn’t get it.  I didn’t understand it.  There was what appeared to be a separate language going on over there.  It took spending time on the medium for several days straight and then some help from my FB groupies before I came to appreciate Twitter.

The first thing you need to know is that on Twitter, you can “follow” people, and people will “follow” you back.  So say I wanted to follow Stephen King, I would search for him and if I could find him, I would click “Follow.”  I would be “following” 1 person.

Good so far, right?


Now, people can also follow you.  When you start, you will probably follow people who are your friends or professional acquaintances.  Some of those will want to follow you back.  At first I followed everyone who followed me, but I learned you need to use discretion for a couple of reasons.

#1  Not everyone is worth following.  I have made a rule for myself that if someone tweets profanity at me (even in a retweet from someone else), I unfollow them.  I don’t have time nor the patience to put up with that.  I don’t need the trash in my life.  So if they can’t keep it clean and positive, they don’t get a place in my day.

#2  Some people tweet relentlessly about their one thing–their cause, their program, their book.  After I’ve read a tweet about how “Winnable” this program is 15 times, I’m out of there.

#3  Twitter won’t tell you this until you get to the magic 2,000 number–but if when you reach it, you are following more people than are following you, you can’t follow anymore.  Until your followers catch up with your followings, you are stuck.  So just reciprocating follows to increase your followers count won’t work forever.


Stick close the next week because I’ll show you how to reach MANY more people than your basic followers, but for now, this is a good place to start.  If you’re not on Twitter, sign up (with your writing name as your @… don’t sign up as @PenBaby unless you write under that name.  Why?  Because you are building a brand, and if you build a @PenBaby brand on Twitter, that won’t transfer to anyone knowing who you are or catching on your writing name when they go to Amazon!).

Once you’re sign up, play around a little.  Follow some people.  Get a feel for the language.  We’ll talk more next time.

Facebook: Connections are Key

In my experience,here is the key benefit of being on Facebook where marketing is concerned:  the connections you can make!

I have been on email loops of writers almost since such a thing was possible, but they have many cons that Facebook fixes.  So today I want to focus on Facebook Groups–groups of people coming together to discuss and help each other out.

There are different types of groups:  some groups have what amounts to a page.  On those groups, you can post, but your post will not show up as a post.  It will be confined to the side as “Other People Said.”  These, from what I have seen, are the less beneficial types.

Then there are Groups.  Groups can be public, private, or secret.

Public Groups info goes out on all newsfeeds and can be seen by everyone.

Private Groups the info goes out on newsfeeds but can only be seen by members of the group.

Secret Groups the info only goes out in the group, not to anyone else.  Also, you have to be inputted into the member list by someone else–you can’t directly ask to be put into the group.

I am the member of several groups, and the founder of the one I started, “Grace & Faith Authors.”  This group has been the key in marketing the way I do now, and I don’t think we could do what we do without doing it on Facebook.

For one thing, you can see pics of each person.  That makes it far more personal than an email loop where it might take a long time to learn names.

In our group, you can post a question and in an hour have tons of opinions and an avalanche of good advice by people in the trenches with you.  For our group, we also post prayer requests and even personal issues that we’re needing help with.  Not every group is like that, so be careful.

However, our group was founded upon the principle of helping one another PROMOTE, so we are constantly sending out ways to do that.  We have a daily “Tweet doc” where any author who wants to participate can post a few tweets with the understanding that they then tweet out the others on the doc.  It works very well and gets the information out much farther than a member’s own Twitter feed.

Moreover, you make friends in the group very easily just by participating, so when you have something to promote, others are far more willing because they see you as a friend.

Also, the amount I have learned in that group has been invaluable.  I’ve learned about covers and KDP. I’ve refined how I tweet and how I Facebook.

So the right group can make a TON of difference.  For me, that ability to connect has been the key value in Facebook from a marketing perspective.