How to analyze all your 2014 tweets

Twitter’s Analytics tool has never been super forthcoming about all it can do. From its lackluster announcement of a stellar feature to non-obvious ways of getting at your data, it’s a goldmine without a map. As you start looking at the year’s marketing data, you might logically say, hey, can we analyze how we did on Twitter? From the default Analytics interface, the answer might appear to be no. Luckily, there’s a trick to get the answer you need.

First, log into Twitter Analytics by going to ads.twitter.com or analytics.twitter.com, depending on what your account is set up for (if you don’t see anything in one, try the other). Next, go to the Tweet Activity section:

Campaign_overview_-_Twitter_Ads

What you’ll see is the last 28 days of activity and some defaults to choose by month. We want none of that! Instead, use the calendar selector to manually go back to January 1, 2014:

Tweet_Activity_analytics_for_cspenn

You’ll likely see a screen with a few hazy charts and no tweets listed. Don’t worry. Hit the Export Data button:

Tweet_Activity_analytics_for_cspenn 3

Wait for a bit as Twitter thinks about it, then spits out a CSV file. Suddenly, instead of having just the last 28 days of data to work with, you have all of calendar year 2014 and then some:

tweet_activity_metrics__1__csv

According to Twitter’s analytics team head, @buster, Twitter now spits out the last 3,000 or so tweets you’ve made and the stats on them:

Now go apply any of the data analysis methods you’ve learned to the data, mix and mash it up with your web analytics, with your retail point of sale data, with anything else you want. You’re now in the driver’s seat when it comes to your 2014 Twitter data. For example, I did a very quick graph of impressions and saw this, a classic Pareto/powerlaw curve:

Screenshot_11_26_14__7_39_AM

I also checked and found that the median number of times a tweet of mine is seen is roughly 2,000. That sounds like a lot until you consider that I have 78,000 followers, and suddenly it means the average reach of my tweets is about 2.5% of my total audience. Still better than my Facebook Page by an order of magnitude, but put in context, my email newsletter crushes any form of social media. If I was running my personal life and accounts like a business, I’d double down on email instead.

Give this hidden feature on Twitter a try with your own data and see how your 2014 went.


If you enjoyed this, please share it with your network!


Want to read more like this from ? Get daily updates now:


Get my book!

Subscribe to my free newsletter!


The biggest mistake in your 2015 marketing strategy

Old money sign

There’s a mistake lurking in your 2015 marketing plan. It’s a doozy, a real whopper. It’s probably lurking in your plan right now if you’ve made one, and if you haven’t, it’ll be in there when you do.

The mistake is this: 2014. And 2013. And 2012. And so on. The past is what’s in your future marketing plan, and the past is going to hurt you.

Every day, I talk to people, to colleagues, to friends, to clients, and to prospects. Every day, I hear people mention outdated knowledge, knowledge that is now ineffective or outright harmful to your marketing. In years past, it was good advice, but times change.

SEO? SEO became content marketing and public relations.

Social media marketing became content and paid media marketing using social platforms.

PPC became RTB/RTX and programmatic.

The grand strategies haven’t gone anywhere – make great products, market where your audiences are, avoid saying stupid things out loud – but the implementation certainly has. The tactics you’ll use in 2015 will be different than even in 2014.

So how do you keep up? How do you figure out what’s relevant and what’s out of date? Here’s what I do: go old school and subscribe to a few email newsletters to keep up with the changes. If you can make time once per week to read through a handful of emails, you can keep up to speed with everything that’s going on.

Digital Marketing

My colleague Scott Monty publishes the excellent This Week in Digital, which is a must-read.

Content Marketing

Jay Baer’s One Thing is an excellent daily big idea delivered to you.

Social Media

The Social Fresh newsletter rolls out on Tuesdays with what’s new in social media.

Paid Media

Though new, Larry’s Links from Wordstream promises to have lots of good paid media insights.

Search/SEO

Hands down, Search Engine Land has some of the best roundups out there when it comes to SEO, SEM, and local search.

My Newsletter

My Almost Timely newsletter a little more eclectic – it’s a roundup of what I’ve shared each week, broken out by category. Even so, it’s heavy on marketing news, so you’ll still get the goods.

Can you make the time for this handful of marketing newsletters? If so, you’ll drive the past out of your future and always be working with the latest knowledge.


If you enjoyed this, please share it with your network!


Want to read more like this from ? Get daily updates now:


Get my book!

Subscribe to my free newsletter!


Social is as social does

Amidst all the chatter about new social networks and how brands should be interacting with audiences, a simple lesson has been missed, one courtesy of Forrest Gump.

forrestgumpbench

The fictional character’s famous quote, stupid is as stupid does, is one equally applicable to social media: social is as social does.

When marketing managers and directors are looking at numbers, charts, KPIs, and metrics about things like social media engagement, interactions per hour, new followers, etc. and wondering why social media isn’t delivering its fabled results, the answer can usually be found in that aphorism. Social is as social does.

Take a look at this simple chart of a national brand and how many questions on their Facebook Page they don’t answer, as well as the response time:

_Response_Rate___Socialbakers_Engagement_Analytics

Social is as social does. If you’re taking half a day to answer fans’ questions, and answering 1 out of every 6 questions, then don’t be surprised when your social media engagement metrics are in the toilet, when your audience stops talking to you, when people give up because you don’t interact with them.

Being social means doing the basics of human civility, the sort of thing that you tell a four year old.

Say hello and goodbye to people.
Answer questions when you’re asked.
Talk about the other person more than you talk about yourself.
Don’t interrupt other people talking.
You have two ears and one mouth; use them in that proportion.
Be polite.

When marketers say that social is all about “being human”, that’s what we’re talking about: accomplishing the basics of being a functional human being. It’s not magic. It is effort.

The next time you’re looking at your social media marketing metrics and you’re not happy with the results, ask yourself if you’re being as social as your audience wants you to be.

Social is as social does.


If you enjoyed this, please share it with your network!


Want to read more like this from ? Get daily updates now:


Get my book!

Subscribe to my free newsletter!