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

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!


What’s your marketing scratch game?

Chris Brogan recently mentioned not having a scratch game when it came to pancakes:

_9__Chris_Brogan

I thought this was amusing, because as foods go, pancakes are fascinating. For those folks who aren’t familiar, a pancake is a breakfast bread that’s cooked entirely in a pan or griddle. The recipe for your average pancake goes something like this:

  • 1 cup of flour
  • 1/2 cup of milk
  • 1/4 cup of sugar
  • 1 teaspoon of salt
  • 1 egg
  • 1/4 cup vegetable oil
  • 1 tablespoon baking powder

Mix it all together and then put on a griddle in portions until cooked.

That’s a fairly straightforward recipe, and that’s where most people stop. They get the recipe, they cook the recipe, they eat. There’s an entire world happening beneath the surface, however, something that can up-level your scratch game considerably. The recipe describes the structure, and underneath the structure is the framework. Once you understand the framework, you know what can change and how much flexibility you have to adapt it.

Let’s look at the pancake recipe again.

  • The flour provides nutritional mass, and in the case of wheat flour, it also provides stability via gluten.
  • Milk provides a protein-based liquid transport that helps the leavener work and create gluten when water is exposed to gluten proteins.
  • Egg provides additional structure in the white part, and mixture stability via emulsification with the yolk.
  • Salt and sugar enhance flavor by activating additional neuroreceptors on the tongue.
  • Oil in the recipe provides lubrication and keeps the goods from sticking to the pan. It also creates a more rich sensation on the tongue.
  • Baking powder provides leavening via the release of carbon dioxide. This gives pancakes their "fluffiness".

Now that you understand the framework of what a pancake is and what all of the components do, you also understand what can be changed and how. This is what makes your pancake scratch game powerful For example, you can’t omit the baking powder without providing a different kind of leavening that’s gas-based. If you omit it or substitute it for something scientifically non-equivalent, you’ll cook up bricks rather than light, airy cakes.

You can, if you’re gluten-allergic, substitute the wheat flour for a different kind of flour. Doing so reduces structural stability, so you’d need to increase the amount of egg in order for the pancake to hold together.

You can, if you’re lactose or dairy sensitive, substitute in soy mile or almond milk or any other water-based protein colloidal suspension without needing to change anything else.

Want to reduce or substitute the sugar? Not a problem – in this recipe, it only adds flavor. You could substitute with vanilla extract and a bit of stevia.

Want to add dried fruit or chocolate chips or any other solid additive? Add a bit more egg or flour to provide additional stability.

Want to add a wet flavor of some kind? If it’s water based, substitute out a bit of the milk (such as apple cider). If it’s oil based, substitute out a bit of the oil.

All of this variation comes from understanding the framework of what makes a pancake versus what doesn’t. Once you understand the framework, you can customize and make exactly the kind of pancake you want to make. This makes your scratch game incredibly powerful. You understand the function, and thus you can vary the form; you understand the spirit, and you can adjust the letter.

Unsurprisingly, all of this applies not only to cooking, but also to your marketing. A recipe is nothing more than a tactic. (recall that strategy is the menu) If you just blindly follow marketing recipes without understanding what they do or what the outcome is supposed to look like, then you’ll forever be locked into the same way of doing things, rather than adapting as things change. Your marketing scratch game will be weak, and you’ll have to resort to using other people’s boxed products at a significantly higher cost and questionable ingredients.

For example, let’s say that you found a marketing recipe promoted by a social media expert that said you should follow 25 people a day and reply to anyone who mentions you. What’s the underlying structure? It’s about acquiring audience reach (follows do tends to net follow-backs) and engagement (replying to people sets the perception that you’re actually interacting and not just broadcasting).

Once you know those ingredients and what they do, you know what can change. If you don’t have time to follow people, a promoted account campaign can do the same thing with probably similar results. On the other hand, like the baking powder in the pancake recipe, you can’t substitute anything for engagement. There isn’t a viable substitute for acting like a human being and talking to people.

Take the time to not only acquire marketing recipes, but understand what the framework is that makes them work. That understanding will help you make them far more useful than just blindly following someone else’s experience and hoping it applies to your business as well. Your marketing scratch game will be amazing – and so will your business results.


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!