Social media data tracking for authors in 4 easy steps

By Laura Laing

Sometimes social media can feel like a shot in the dark. Is anyone listening? Are status updates and tweets helping with book sales? Tracking your promotional statistics and book sales can help you uncover a brilliant social media plan—by determining what’s working and what’s not.

And spreadsheets are the perfect medium. Here’s how you can harness the power of spreadsheets to wrangle your social media book promotion plan.

Step 1: Choose your stats

You can use this process to track any statistics, but since we’re looking the relationship between social media efforts and book sales, here’s a good list:

• Facebook: likes and shares
• Twitter: retweets and favorites
• Google+: +1s and shares

You’ll also want to track your book’s sales.

Step 2: Build your spreadsheet

In case you’ve never used a spreadsheet before, let me start with a simple explanation. Spreadsheets are very much like tables with rows and columns. But there’s one big difference: In a spreadsheet, you can include formulas that will automatically calculate a value you need.

First, let’s look at the columns and rows. Rows run horizontally, while columns run vertically. All of the rows must be related to one another, while all of the columns have their own relationship.

In this scenario, you’re tracking social media stats and book sales by date. In the spreadsheet below, I’ve assigned dates to the rows and the media stats and book sales to the columns. (If you wanted, you could switch it.)

Step 3: Track your data

Each of the little boxes in the spreadsheet is called a cell. It’s important to notice that each cell belongs to one row and one column. So, if you check your Facebook likes for status updates written the week of March 1, the number 15 goes in the cell that corresponds with the “Facebook status updates” column and the “March 1” row.

You should also track book sales each week, in a separate column. (I’ve skipped a column so that I can easily see which are social media stats and which are book sales.)

If you’re more advanced with spreadsheets, you can also add formulas that will automatically calculate when you add new data. In this way, you can include running totals in your spreadsheet, like this:

For more information about including formulas in a spreadsheet, read my article, “Spreadsheets 101: How to Use Formulas.”

Step 4: Analyze your results

Now that you’ve got all of your data, what does it mean? First, you can begin to notice trends. Based on this data, it seems that Google+ is where you’d want to put your best efforts. (That’s where you’re getting your most interaction.) In addition, when a Facebook status update is performing well, it does well on Twitter and Google+. And there is clearly a correlation between social media interaction and book sales.

You can dig even deeper with these stats. First, look at the tweets and status updates that did not perform as well as others. What could you do to up their success? Also, consider how your other promotional and marketing efforts might have affected social media interactivity—and therefore book sales. For example, if you spoke at a live event on January 22 and sold 10 books there, your spike in book sales that week had nothing to do with social media.

In fact, this data is merely a window into a much richer understanding of how well your publicity and marketing efforts are doing—but it’s a terrific place to start. And as you continue tracking these stats, you will discover other statistics that can help you hone in on your best promotional endeavors ever!

What are you tracking or monitoring so that you can measure the effectiveness of your book marketing?

5 book marketing lessons from an author who is getting royalty checks

By Laura Laing

So let’s get one thing straight from the beginning. I wrote a book about math. Yes, math. And I’m proud to say that sales are churning along, and I’ve gotten some great media attention. In fact, I’ve discovered a quirky little niche, writing articles about math, giving interviews about math education. Who knew?

If a book about math can sell, you’ll have no trouble making the most of sexier topics, say caring for your elderly parents or a science fiction novel featuring the microscopic inhabitants of Pluto who are pissed off at its downgrade to dwarf planet.

In the year since Math for Grownups first hit the bookshelves, my professional life has completely changed. And it’s fair to say I’ve learned a few a few things along the way.

1. Go in for the long haul. 

Old-timers tell me that before Amazon and the internet, a book’s success was determined within two months of its birthday. That’s because brick-and-mortar bookstores handled all sales and publishers took care of all promotion.

Those days are over.

I’ll be promoting Math for Grownups until it goes out of print—and then I might very well take back my rights, have it republished and go for another round. These days, sales don’t end and neither does book promotion.

Because of that, you’ve got to pace yourself. Come up with a doable plan that won’t put you six feet under within three months. Be very realistic about the number of hours in a day you have to devote to this project, and then give it all you’ve got.

2. Make the most of your publisher’s publicist. 

Even though your book could conceivably be on the shelves for the next 100 years, your publisher isn’t going to offer you undivided attention, even if your name is Malcolm Gladwell.

First off, be nice to your publicist. This person is handling several titles at the same time, so don’t expect it to be all about you. But second, milk that relationship for all it’s worth.

I sent my publicist weekly reports detailing the promotion I did and media mentions I received. These reports included guest posts for other blogs, interviews and reviews. In return, she sent out copies (for reviews and blog contest prizes), handled most of the press inquiries and pitched me to the major media outlets.

My goal was to be the easiest author she worked with, so that I was front-of-mind when she wondered whom she should pitch next.

3. Invest in promotion.

These days, you need a blog, headshot and more. Don’t skimp. When I developed my blog, www.mathforgrownups.com, I ponied up for a dedicated URL and a great designer. When I held my book launch at a local bookstore, I sprang for cookies and iced tea from a fantastic local café.

You want to look like a professional? Act like one.

You can also make your promotion work double duty. My web designer recommends me when his clients need writing. The café owner did a Math at Work Monday interview with me for my blog and promoted my book launch in her café.

4. Stay on message.

Mine was simple: Math doesn’t have to be your BFF, but you do have to get along in public. Once you have that message, find the different angles and make sure that everything you do circles back.

The worst day of my book promotion was last fall, when USA Weekend unexpectedly ran a piece about everyday math—based completely on my book. Should have been the best day, right? Problem was the poor writer got the math wrong. Readers noticed. And they blamed me.

I posted a comment to the web version of the story, explaining that the math is right in my book. Then I started promoting the heck of out of the story. Already, Huffington Post had blogged about it, and it was mentioned in Daily Kos and the Columbia Journal Review’s blog.

When I wrote my own blog post, I chose my message carefully: We all—even fancy reporters at USA Weekend—make math mistakes, and sometimes those mistakes are scary and public. But the world doesn’t end.

In the end, the error played beautifully into my own message: Math is hard, and it’s worth it to get it right. The story became a great example of why my book is important.

5. Don’t be afraid to fail.

You will make mistakes in your book promotion. You will miss opportunities.  You will get tired and take a break. And all of that is a-okay. Take some risks and cut yourself some slack if things not working out.

It’s just a book, not world peace (unless your book is a solution to world peace). Plenty of other people out there have much harder jobs than ours. And if you don’t take the risk, you’ll never know what could have happened.

What lessons did you learn while promoting your book? Please share them by commenting!

If you’re ready to learn how to promote your book, actually use what you learn, and get all of your “how do I do it?” questions answered, join us for the next Book Publicity 101: How to Build Book Buzz e-course June 4-29, 2012.