Social media data tracking for authors in 4 easy steps
“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.”