5 Time-Saving Tips For Your Social Media Analytics

5 Time-Saving Tips For Your Social Media Analytics Lucy Hitz Blogger Extraordinaire Simply Measured

Feelin’ the need for speed? Find yourself saying things like, “Never enough time in the day,” “I’ll try to squeeze it in,” and “The faster the better”? You’re not alone.

Social media is a particularly fast-paced and rapidly-evolving sphere, since it centers around a wide variety of people receiving and reacting to content—all in real time. When it comes to analyzing your social media data, cutting down on the time you spend carrying out mundane “monkey” analysis tasks frees hours and headspace for planning upcoming strategy around your findings and crafting killer presentations to showcase what you’ve discovered. A lot of brands have great ideas—but it’s the one who develops and posts first that gains the recognition and reaps the rewards. I chatted with three of our finest account managers, Lauren Berry, Kristin Eide, and Megan Montplaisir, to discover the shortcuts their customers love and why folks like Laura Sandberg at Edelman are saying, “With one click, Simply Measured turned my eight hours of reporting into one.”

#1 – Sync your data benchmarking with your business calendar.

Nearing the end of a financial quarter? Have a big meeting with the boss to justify Facebook ad spend? Need a monthly check-in for  a specific campaign, but have too much on your plate to remember already? Free your mind and never go to a meeting empty-handed again with a scheduled report. Whether you set up a recurring report—easy to do in 40 seconds or less, as shown in the screencast belowor a one-time report, you’ll get an email (I like to call it a “push in the right direction”) on whichever day(s) you choose, reminding you that your report is ready.

Pro time-savvy tip: Schedule your report for a week before your presentation or meeting to give yourself time to consider your game plan with the data in full view.

#2 – Do it all in Excel.

Senior Account Manager Kristin Eide here at Simply Measured says that the one of the biggest “Ah-ha!’ moments her customers experience is the frustration-eradicating glory of interacting directly with raw data in their Excel files. Instead of having to toggle between browser tabs, spending hours scanning Twitter and Facebook feeds for individual mentions, brands save an enormous amount of time by downloading reports directly into Excel—where they have everything they need to get the information they want. For instance, this is what you see when you download a Twitter Activity Report:

Screen Shot 2014-03-26 at 2.17.20 PM

But the information gets richer with each tab you explore. Analyze activity by time, manually adjusting as needed, on the “Tables” tab. Look at each individual tweet on the “Data” tab, along with all correlating information. Check out the keyword’s retweeted tweets, or the geographical breakdown. No new screens to open, no new docs to create—everything in one place.

Pro time-savvy tip: If you download a report and realize that you need to narrow your date range or change your keywords to receive a proper representation of what’s been going on, don’t fret. No need to run a brand new report. As long as the date range you want to see in your charts and graphs falls between the originally selected date range, or the keywords are mentioned in the Excel document, you can input your desired information directly into the “Charts” tab so that your visuals suit your needs.

#3 – Speed up your slide-making.

Put together presentations more quickly by exporting your report directly from the web to PowerPoint. Add slides in between which offer an interpretation of the data through your own lens, or easily switch and swap graphs and charts within the presentations for a more customized feel. See how it works: 

Pro time-savvy tip: Choose your brand’s custom theme (logo and colors) when prompted to make the PowerPoint export process truly seamless and painless.

Screen Shot 2014-03-26 at 2.54.09 PM

 

#4 – Combine to save time.

Ask Senior Account Manager Lauren Berry that age-old question—what do customers want?—and she’s quick to answer: all of their channel data in one place. “Previously they may have been pulling from multiple platforms and compiling,” she told me. “Now they can run a Complete Social Snapshot and have all of their channel data included.” The CSS gives a solid, easy-to-scan overview, and immediately answers the next logical question—what’s my audience growth look like on each channel?

Screen Shot 2014-03-27 at 9.24.45 AM

 

Then the CSS takes it to the next level, explaining my audience engagement and growth rate by breaking down my brand posts over each channel.

But what were people actually saying? 

Screen Shot 2014-03-27 at 9.30.19 AM

 

And what types of posts drove engagement on each channel? 

Screen Shot 2014-03-27 at 9.33.03 AM

 

And finally, the raw data and big-picture numbers for sharing with my team.

Screen Shot 2014-03-27 at 9.34.27 AM

Every channel and every bit of available data on how my brand’s posts are performing, all in one place. It doesn’t get more efficient than that.

#5 –  Set influencer alerts.

Know who’s talking about you without having to keep your own ear perpetually glued to the street. Sure, you can run an Influencer Report—but who’s got time for that? Set an alert on your keyword of choice and you’ll be emailed when someone with a Klout Score greater than [fill in the blank] mentions it, or when someone with a Twitter follower count greater than [fill in the blank] mentions it, or when [fill in the blank] himself mentions it—or all the above. Decide what your priorities are, and forget about it until you’re notified. There’s enough on your mind.

Screen Shot 2014-03-26 at 5.14.50 PM

Pro time-savvy tip: Account Manager Megan Montplaisir tells us that the “Mentioned ___% more hour over hour than it was the previous 24 hours” alert is a great way to get wind of a PR crisis extra early. There’s nothing more valuable than nipping customer dissatisfaction in the bud. Get on board with a complimentary 14-day trial to free up time and enable true innovation.

Lucy Hitz

I’m the Content Marketing Manager here at Simply Measured. I manage our blog, produce longform content, head our co-marketing initiatives, and host the Simply Social podcast, among a few other things. I love yoga, The X-Files, peaty scotch, hiking, and poetry. If I were a social media channel, I’d want to be Instagram, but I think I’m Twitter.