Donor services at the speed of instant

June 21, 2016June 18, 2016 nickellingerdonor services, donorcentricity, Facebook, social mediaLeave a comment

On June 1, Meeker put out her Internet Trends report, highlighting the evolution of the sector. You can see the full report here. These online reports have key lessons for us as a sector, one of the big ones having to do with customer/donor services.

One of the challenges we have as an industry is delivering timely donor services in the preferred channel of our donor. We have all seen the Facebook exchange that goes something like:

Them: how do I stop you from mailing me?

You: Thank you for letting us know that you would like to stop receiving mail from us or reduce the amount of mail you receive. To do so, please call our free donor help line at 877-DONT-CARE.

There are several problems with this, not the least of which is that your boilerplate sounds like it was written by a robot who desperately wanted to fail the Turing test. But another one is: if they wanted to call you, they would have called you.

Instead, they went on Facebook.

Now you definitely don’t want to feed the trolls excessively. You generally don’t want to do more than two back-and-forths out on Facebook publicly. But there has to be a better way to meet donors’ needs without scaring away other potential donors.

Enter slide 104 of Meeker’s presentation. (I told you it was comprehensive; we read these things so you don’t have to.) She’s led up to this point talking about the growth of messaging with WhatsApp having 1 billion monthly active users, Facebook Messenger having 800 million, and three other messaging platforms having more monthly active users than there are people in the United States.

So on slide 104, she talks about how Hyatt and Rogers Communications launched Facebook Messenger customer service in November and December respectively. Within one month, Hyatt had a 20X increase in the number of messages they received. Rogers Communications’ users report a 65% increase in satisfaction and a 65% decrease in customer complaints.

Now, think about the most common donor interaction people have with your organization. If you have anything under a 50% retention of new donors rate, and chances are you do, along with everyone else in the sector, that most common interactions is:

Someone makes a donation
You talk to them some more and ask for donations again
You don’t hear from that donor again

What is it worth to you to be able to address any questions, doubts, problems, etc., that these donors are having?

Two comments on customer services that you hear over and over are:

For every person who complains, there are X more who were as ticked off, but didn’t complain.
A dissatisfied person who you have the opportunity to satisfy will be a better customer/donor for you than a person you didn’t dissatisfy to begin with.

So instead of hiding your donor service phone number, show it proudly. If a person is online, see if you can do a live chat with them to address their concern. And, yes, if they are on social media, actively solicit and take care of donor concerns, as quickly as you can.

The coming battles for donors will be fought over experiences. What experience can you offer?

Marketing your content

March 17, 2016March 15, 2016 nickellingeracquisition, online, search engine, social mediaLeave a comment

Field of Dreams lied to us. A generation of people were told that if you build it, people will come. A lie by lying liars.

Also, Iowa, while very nice, is theologically not all that close to heaven.

Similarly, we were told a better mousetrap would cause a stampede of purchasers. Yet there’s still the one that threatens to sever a digit every time I try to set it.

This is not to say that quality doesn’t matter. That’s too cynical even for me. But quality content with marketing will beat quality content without marketing just as surely as a Smith and Wesson beats four aces.

So, how do you market your content?

Search engine optimization. If you write your content, then sit down to do your search engine marketing, you’ve already lost. Ideally, you will have already looked through what people are looking for in your category, as we recommended Tuesday. You will have woven those terms and phrases into your content. Now, you have a platform from which to further optimize. Make sure your partners are linking to your content, as link popularity is still a key indicator of quality.

Similarly, I like to go to other people’s content that is related and complementary to my own and comment on the piece, complementing their content and linking to my own. Always practice good etiquette when doing this: you want to make sure you are doing as much to promote the person you are commenting on as you are getting, including linking to them from your own content.

Search engine marketing. If your content is converting well, add it to your Google Grant under all of your relevant search terms. You want to make sure that people who are looking for your type of content are able to find your specific content.

Social media. Yes, I said yesterday not to create content for social media. I meant that you shouldn’t only be posting things on Facebook or LinkedIn, where the rules and the audience are not your own. But as long as you have friends/connections on these platforms, be sure to post your content here, linking through to your own site and resources.

Other content. As you become an effective content creator, you’ll notice that your podcast promotes your blog, your blog promotes your newsletter, your newsletter has a video in it, and that video asks people to subscribe to your podcast. This is not only natural, but meritorious. If you’ve taken the idea of fractal content creation, your topics will be related to each other enough that you can legitimately say “if you liked this blog post on conflict diamonds, you might also like to download our white paper on the largest offenders.”

One of the underrated ways for getting nonprofit donations is filling a need for your potential donor. If, each day, you are only getting donations from the people who intended to give you money at the beginning of that day, you are missing out on significant opportunities.

Rather, a person will come to your site wanting to see if their spouse has the disease your cause is trying to cure. You will help diagnose the disease. You offer a brochure about dealing with that disease and the person accepts. You email them the brochure. Then, as part of your welcome, you check in with them to see if they need anything else. They look for, and find, specialists in their area. Then, after you’ve helped them get what they need, them making a donation to you seems like the most natural thing in the world.

Your content is its own journey: you want to take people through journeys one step at a time. You can try to plan them, but people will likely choose large parts of it themselves.

To the point we made yesterday, blogs of 400+ posts get more traffic because content supports content. In the publishing world, when an author has a new book (or in the case of James Patterson, ten new books), sales of their previous books increase because more people are discovering the old books. So the best part of content marketing is that your content will help your content succeed.

But we also need to make sure your content helps you reach your goal. We’ll complete our (first) content marketing journey tomorrow, with how to create content that converts. After all, it’s great that content supports content, but someone has to pay the light bill and vacuum out the Internet tubes every so often.

Choosing your content marketing media

March 16, 2016March 15, 2016 nickellingercontent marketing, copywriting, enewsletter, online, podcast, social media, video, white paper, writingLeave a comment

I’m a baaaaad example of content marketing media. I have a face for radio and a voice for print, so you’ll notice there aren’t videos, Webinars or podcasts here yet. I have less than no artistic talent, so infographics are well beyond me (for now; one can always learn). Don’t believe me? Here’s the cover I designed for my book:

I suppose I could do slideshows, but since I started this blog in part to improve my writing, I’ve been a strictly one medium guy.

But you can’t be. There are a whole work of ways to reach an audience today and depending on your mission, some, many, or all of them may work well for you. However, each one takes a toll of time and effort. It is better to be the master of one medium than a jack of all of them.

Blog posts

Advantages:

I would argue that this is the easiest entry point. You need to write a story. That’s it.
A great way of (as I mentioned yesterday) figuring out what your audience(s) is/are interested in.
Can serve as a host and/or a marketing platform for your other content marketing.

Disadvantages:

Difficult to capture an audience. Sure, you can have an awesome weekly newsletter than anyone can sign up for here, but no matter how blatantly you name check it in the middle of a blog post, most people read blog posts individually rather in binge reading.
Need to do it regularly enough that people can expect new content from you.
Need it do it often enough to be successful. Hubspot has some great data here that show that posting 16+ times per month gets you the most traffic:

Furthermore, having 400+ blog posts significantly increases your traffic as well:

Podcasting

Advantages:

Good for when you have two personalities that can play off of each other.
Excellent way to incorporate guest contributors.
A very popular medium right now.

Disadvantages:

Take whatever time you think it will take to edit the audio for your first podcast and multiply it by ten.
Very production-value-dependent. It used to be that people will put up with poor audio quality to get good content. This is less and less true.
Needs to be even more regular than blogging.
Difficult to capture an audience, as you don’t have a record of who subscribes to your podcast.

Video

Advantages:

Great for people with compelling visuals.
You can repurpose existing assets with a little bit of editing and voice over.
Guest appearances become a bit easier; there’s something about a video camera that makes everyone want to be on TV.
YouTube is a valuable quasi-social network that allows you to be discovered by people who might not come to your site.

Disadvantages:

It requires some editing skill and expertise (compared with blogs, which any idiot can write)
A talking head looking into the camera is the most common and most boring possible video. Sometimes it’s necessary, but hopefully you can surpass that.
You may do 100 videos that have almost no views; it may be that 101st that gets an audience.

Infographics

Advantages:

Great way to communicate complex concepts.
Very shareable.
Good adjunct to other content (e.g., if you have a complex white paper and are trying to pitch media, an infographic can help with the pitch to explain to people whose journalism majors did not cover microbiology or environmental sciences or whatever (of course, neither did my poli sci degree, so I can’t talk))
Who doesn’t love a picture?

Disadvantages:

Some infographics are now just numbers with a circle around them or some other gussying up. Steer clear of the infographic if the pictures aren’t going to add value to the story. Sometimes a pie chart is just a pie chart.
Requires graphic design knowledge.
Lacks interactivity and, usually, emotional content. All of the other media can bring you to tears or to donate. Infographics are good for the brain, but usually not good for the heart. And the heart is what donates most of the time.

Quizzes

Advantages:

Fun for the whole family
Very shareable, especially if you make it so that people can be competitive.
Who knows? Someone might learn something.
Can pique interest and encourage someone to learn more.

Disadvantages:

A bit fluffy for content — can’t get deep into an issue (which is probably OK; that’s not why someone takes a quiz)
Doesn’t convert particularly well.

Whitepapers:

Advantages

As mentioned yesterday, they are easy to create from existing content.
Excellent for lead generation, because you can email gate them.
Demonstrates subject mastery, whether justified or not.

Disadvantages:

Can be a bit dry when done poorly
More difficult to incorporate emotional content.

Print:

Advantages:

Not dead
Less competition, because people don’t believe the first bullet
More engaging than online content
Can engage in conversations, rather than dialogues
Can effectively get donations

Disadvantages:

Have to explain to people print isn’t dead
Cost
Less ability to track and capture interactions

And here are a couple I recommend against.

Slideshows: A lot of folks do these. I have to admit, I don’t get it. It’s certainly easy to do, as you have the slideshow in the can already. It’s good for a business audience, who is used to the format, and gets a lot of data out quickly.

However, it requires someone to want to sit through a PowerPoint presentation without the entertaining audio. There’s not usually a good conversion mechanism. And, as you know, the worst live presentations are the ones where people have all of their words on a slide and have to read them off. These are, ironically, the only decent slideshows, because if someone relied on funny images for their original presentation, it won’t read without audio.

For my money, these are better done as a white paper if you have a dry topic (because you can get email addresses) or a video if you have a lively one.

Social media: By this, I mean posting on Facebook or LinkedIn or what-have-you, so that they own your content. Don’t do this. It’s all fine and dandy until someone changes the algorithm or your rules for sharing or your organic reach and your so-called strategy is lost.

Actually, it’s not fine and dandy, because even when things are going well, you are building an audience for that social network, not for yourself or your organization. Social media is a fine place to link, but I wouldn’t want to live there.

So those are the basic media. But once you build it, they won’t necessarily come, so you will need some good marketing strategies for your content marketing. We’ll cover that tomorrow.

It’s time to stop… vanity metrics

March 8, 2016February 24, 2016 nickellingermail, metrics, online, social media, social proof, statistics1 Comment

I’m writing this during the South Carolina Republican primary. The votes haven’t started being counted yet, but I know who is going to win. Because I know that Ben Carson has 35% of the Facebook likes among GOP contenders in the state; Trump is second at 25%. Thus, Carson will get approximately 35% of the vote.

What? Doesn’t it work that way? Facebook likes aren’t a reliable indicator of support, donations, interest, or almost anything else?

The bitter truth: Facebook likes are a vanity metric. They have little to do with your ultimate goal of constituent acquisition, donor conversion, and world domination, yet people will still ask what that number is. And when they hear it, they will nod, say that that’s a good number, and ask what we can do to increase it.

That’s when a tiny little part of you dies.

So, in our Things To Stop Doing, we have vanity metrics. These metrics may make you feel good. They may be easy to measure. And some of them may feel like a victory. But they bring you little closer to your goals. We are creatures of finite capacity and time, so the act of measuring them, talking about them, or (worst of all) striving for them drains from things that actually matter.

Facebook likes and Twitter followers are probably some of the better-known vanity metrics. But they are far from the only ones. And while some of these are partly useful (e.g., Facebook likes is an indicator of a warm lead repository for marketing on the platform), there’s almost always a better measure.

Because it always comes back to what your goals are. Usually, that goal is to get people to take an action. Your metrics should be close to that action or the action itself.

Without further ado, some metrics to stop measuring.

Web site visits. Yes, really. This is for a couple of reasons:

Not all visitors are quality visitors. If you’ve been using Web site visits as a useful metric, and wish to depress yourself, go to Google Analytics (or your comparable platform) and see how long visitors spend on your site. Generally, you’ll find that half or more of your users are on your site for more than 30 seconds. Are 30 seconds long enough for people to take the action you want them to take on your site? Not usually (except for email subscribes).
Not all visitors are created equal. Let’s say you find that people coming to your site looking for a particular advocacy action sign up for emails 10% of the time; those who come looking for information about a disease sign up 5% of the time; those who look for top-line statistics sign up 1% of the time. Which of these is the most valuable visitor?
This isn’t a trick question. You would rather have one person looking for advocacy actions than nine people looking for stats. Except that the metric of Web site visits lumps them all into one big, not-very-useful bucket.

These are both symptoms of the larger problem, which is that if you had to choose between two million visitors, of whom 1% convert, and one million visitors, of whom 3% convert, you’d choose the latter. Thus, potential replacements for this metrics are visits to particular pages on the Website where you have a good idea of the conversion rates, weighted Web traffic, and (most simply) conversions.

Mail acquisition volume. You get the question a lot – how many pieces are we sending in acquisition? Is it more or less than last year? And it’s not a bad estimate as to a few different things about a mail program: are they committed to investing in mail donors? Is the program growing or shrinking? What are their acquisition costs?

But from a practical perspective, all of these things could be better answered by the number of donors acquired (and even better by a weighted average of newly acquired donors’ projected lifetime values, estimated from initiation amount and historical second gift and longer-term amounts, but that’s tougher). A good rule of thumb is:

Never measure a metric that someone could easily game with a counterproductive action.

And you can do that with mail acquisition volume by going on a spending spree. Of course, you can also do that with donors acquired, but it will spike your cost per donor acquired, which you are hopefully pairing with the number of donors acquired like we recommend in our pairing metrics post.

Time on site. You notice that people are only spending an average of 1:30 on your Web site, so you do a redesign to make your site and content stickier. Congratulations – you got your time on site up to 2:00!

Someone else notices that people are spending 2:00 on your Web site. They work to streamline content, make it faster loading, and give people bite-sized information rather than downloading PDFs and such. Congratulations – you got your time on site down to 1:30!

Therein lies the problem with time on site – whatever movement it makes is framed as positive when it could be random noise. Or worse. Your sticky site may just be slower loading and your bite-sized content may just be decreasing conversion.

So another rule of good metrics:

Only measure metrics where movement in a direction can be viewed as good or bad, not either/both.

Here again, conversions are the thing to measure. You want people to spend the right amount of time on your site, able to get what they want and get on with their lives. That Goldilocks zone is probably different for different people.

Email list size. While you totally want to promote this in social proof (like we talked about with McDonalds trying to get cows to surrender), you actually likely want to be measuring a better metrics of active email subscribers, along the lines of people who have opened an email from you in the past six months. These are the people you are really trying to reach with your messaging.

When you remove metrics like these from your reporting or, at least, downplay them, you will have fewer conversions with your bosses that ask you to focus on things that don’t matter. That’s a win for them and a win for you.

I should mention that I am trying to build my active weekly newsletter subscribers. Right now, we have an open rate of 70% and click-through rates of 20%+, so it seems (so far) to be content that people are enjoying (or morbidly curious about). So I’m hoping you will join here and let me know what you think.

The science of slacktivism

January 26, 2016January 23, 2016 nickellingeradvocacy, Facebook, research, science, slacktivism, social mediaLeave a comment

Online advocacy has a bad name. Specifically: slacktivism (or clicktivism). Seth Meyers put the prevailing opinion into funny words on SNL:

“Look, if you make a Facebook page we will “like” it—it’s the least we can do.
But it’s also the most we can do.”

This frames the debate well. Some think that online activism is a prelude to future action — a way people signal they are interested in your cause and are working to do more. Others think it is a way for people (and here they will often say Millennials — check out my posts from a couple weeks ago as to why this is bull) to feel good about themselves while doing very little.

So what does science say?

I’ll give you the TL;DR version now: campaigns that are good help future action; campaigns that suck don’t.

OK, perhaps that wasn’t all that satisfying. But you wanted to read about the science anyway, right?

There are three interesting studies on this that I wanted to highlight. The first is from Lee and Hsieh here. They found that people who signed a petition were more likely to donate to a related nonprofit afterward. This makes sense given what we know about the importance of consistency in persuasion.

The more interesting part of the study is that they also found that people who didn’t take the advocacy action were more likely donate to another unrelated nonprofit thereafter. They call this moral balancing. The idea is that people feel a bit guilty that they didn’t take a pro-social action, so they want to balance this with an unrelated prosocial action. I’m not sure yet what practical effect this has (unless I can rent a list of another nonprofit’s non-petition signers), but it’s interesting and it shows that people perceive an online petition as a positive thing that they generally should be doing.

The second study I would recommend is from Kristofferson, White, and Peloza. They come right to the question of whether a token action leads to greater action in the future with five different studies. My favorite, and the easiest to explain, is one where had three groups: one who were given a poppy to wear in honor of veterans, one who were given that same poppy in an envelope so it would be for private support, and one who were given nothing. At the end of the hallway, the groups were asked to donate. Those who showed private support (poppy in the envelope) gave an average of $.86, public supporters gave $.34, and the control gave $.15. They further refined this study in other ways and found that generally, people who gave private support were more likely to support in the future; people who gave public support were either no more likely or less likely to support the cause than those who did nothing.

The third study, from Lewis, Gray, and Meierhenrich, found similarly — that Facebook activism (perhaps because it is public) doesn’t often translate to any further activity. Looking at a Save Darfur campaign, 99.7% of people did not make a donation and 72.2% didn’t recruit anyone else. Of those who donated, 95% did only once and of those who recruited, 45% recruited only one other person. Hardly a sustainable effort. The authors hypothesize that this is because Facebook is full of both strong and weak social ties, so you want to advertise your best self to this group.

However, there was a committed group of people on Facebook: it was just very small. The top one percent of advocates made the 80-20 rule turn away in shame, responsible as they were for 63% of membership recruitment and 47% of donations. The study also found that recruits were more likely to donate and donors more like to recruit. So once you got someone over a very high threshold, some people would work wonders, but these were unicorns in a world of horses.

So here are the implications that I see for advocacy campaigns:

Do them. A properly run advocacy campaign can increase the likelihood that someone will donate and take other actions for your organization.
Make them private. Public petitions appear to satisfy a person’s desire to manage their reputation, so they were less willing to take other actions.
By extension, don’t do them on social networks. Not only are they not public, but you do not have the easy wherewithal to communicate with them to get the first gift or convert to other activities.
Make the ask. It can be as easy as having an ask for the donation on the confirmation page or receipt for a petition. Folks who take private actions want to help and are in a mindset of helping. I personally have seen advocacy campaigns with a soft ask after taking the petition raise more money than a hard ask to a full list. Crazy, but true.

Hopefully, this has given you the data to incorporate advocacy into your campaigns the right way. For the rest of the week, I’ll be talking about how to incorporate in the mail, acquiring online advocates, and converting advocates to donors.

If you’d like a weekly digest of these and other topics, please sign up for the weekly newsletter here. It’s short and has a couple of features that aren’t included on the blog for subscribers only.

Understanding and using Facebook’s algorithm

January 8, 2016January 8, 2016 nickellingeracquisition, addressable media, advertising, conversion, CPC, cultivation, Facebook, online, social mediaLeave a comment

Facebook is the nexus of a lot of debate as to how best to incorporate social media into other marketing efforts. My argument will be there is a twofold Facebook strategy: 1) using organic content to engage your superfans and 2) using addressable media to reach everyone else.

500 million users. How quaint.

Like Google, the base of the Facebook algorithm (EdgeRank) is fairly easy:

Affinity: How close the person creating the content is to the person receiving it.
Weight: How much the post has been interacted with it, with deeper interactions counting more
Time decay: How long it has been since it has been posted.

These interactions are multiplied together and summed, roughly.

Like Google, however, it has been altered over time significantly. There are now significant machine learning components baked in that help with spam detection and bias toward quality content. Additionally, now users can prioritize their News Feeds themselves. Finally, because of the sheer amount of content available, the organic reach of an average post is single digit percentages or below, meaning that if you have 100,000 likes, maybe 2,000 people will see your average post.

The implications of this base algorithms are stark:

Organic reach on Facebook is for the people who really love you. Many people think of Facebook as a new constituent acquisition system. However, people who come in dry will almost never see your posts.
Consequently, only things that connect with your core will have any broader distribution. Think of who is in the top two percent of your constituents: employees, top volunteers, board members, and that may be about it. If those people don’t give the post weight, no one outside of this group will see it.
What you have done for them lately has outsized weight. Research into Facebook interactions shows that Facebook gives outsized weight to what a person as interacted with in their last 50 interactions.
Facebook is not for logorrhea like Twitter. Think of your posts as a currency you spend each time. If your post gets above average interactions, you will move your average up and interact with more people; if not, your reach will lose. Posting too many times (which varies from organization to organization) will diminish your audience as average reach will decline). Additionally, all of the things you have to post for organizational reasons (e.g., sponsor thank yous) are spending your audience and you have to assess how much you are willing to spend to fulfill those objectives.
This all adds up to the uber-rule: Facebook is for things your core supporters will interact with quickly. If they don’t, it won’t reach your more distant supporters and it will lessen the likelihood that your next post will reach them as well.
It also relates to the second uber-rule: because Facebook can change its algorithm as it wishes, you should not build your house on rented land. The best thing you can do with your interactions is to direct them to your site, to engage your content and sign up for your list.

This all sounds a bit dire, so I should also highlight how to reach the other 98%(ish) of your Facebook audience as well as some of your non-Facebook audience on Facebook: addressable media.

Facebook allows you to upload a list of your supporters and target advertising to them specifically whether or not they are current Facebook likers of you. You can learn more about this on my CPC ads post here. This also goes into lookalike audiences, a way of getting people who aren’t who you talk to currently, but look a lot like them, a nifty acquisition trick. Since organic reach won’t get you to these loosely and non-affiliated people, this is the only way to achieve that reach. And, since it is cost-per-click, you can control your investment and your results.

But like discussed above, these campaigns should be to build your relationship to people outside of Facebook. For the same reason companies advertising on CBS don’t work to build a greater relationship to CBS, but rather to the advertising companies, your advertising on Facebook shouldn’t be aimed at getting Mark Zuckerberg et al more friends — they have over a billion of them already.

Semi-advanced direct marketing Excel statistics

November 6, 2015November 5, 2015 nickellingerblog, Excel, Facebook, social media, statisticsLeave a comment

In addition to not being a database, Excel is also not a statistics package. If you are going to do anything advanced, I highly recommend R. The programming language, not the John-Cleese-played Q replacement in The World is not Enough and Die Another Day.

Cheer up! Yes, it’s a lesser part in lesser Bond movies.
You, John Cleese, are still an international treasure.

Anyway, stats in Excel. We’ll start with correlations, as they can give us some insight into blog and Facebook traffic and interactions.

Wait, you argue – Facebook is not direct marketing. First, yes, you are correct. Second, no, you are wrong; there is a way that you can use Facebook as a direct marketer. I’ll talk about this more when I do a whole social media week (don’t worry, folks, I promise to spend time deflating the hype and hopefully producing things you can print out and get to board members and say “See? Let’s put money in places where it will make money!”). Third, because Facebook has limited value (but not zero) as a direct marketing vehicle, you can test things on there to see how they resonate with your audience. Granted, your Facebook audience and direct mail audience will probably be fairly dissimilar, but your online audience is probably similar to your Facebook audience. And what you are looking for is what makes compelling online content for you. So this is a way to make Facebook your testing ground before you put it on to a real platform (i.e., your Web site, your emails).

I’m going to demonstrate this on this blog’s stats because I have the data available. However, I’ve also done this with Facebook posts very successful. The prep work you will have to do for either blog posts or Facebook posts is to record your outcomes (view, likes, shares, and/or comments), to code the subject matter of each post, and to put in any other variables like day of the week that may be relevant. Here’s my version of this:

I have my blog posts on the left and the various factors on the right (and there are more tags, but I need to cut it off at some point to display it. Yes, I have a blog post that has zero views. If you would like to break the seal on a blog post about why we do segmentation, it’s here; I’m sure it would appreciate a visit.

I then went through this and deleted tags that only applied to a single post. Then I ran a correlation for each individual variable to page views. The correlation function looks like

=CORREL($B2:$B20,I2:I20)

And is expressed from 1 to -1.

Here’s what that looks like. Let’s look at the days of the week first, because there appears to be an effect here — Monday content has been king, with a strong correlation to page views. It will be interesting going forward to see in the long term whether that is the nature of the content (I’ve been trying to put introduction content on Mondays and get progressively more involved throughout the week) or that people are more interested in reading blog posts on Mondays. Nevertheless, I can probably do a better job of setting up the rest of the week as must-see content, since Tuesday, Wednesday, and Thursday are all a bit negative.

Images tend to correlate well to views as well, probably because they show better in social media. I’d been noticing this from just a glance as well, so you will probably be seeing more images here in the weeks to come. They will also be less boring images, since some of the lower performers were images of equations and Excel sheets. It is not coincidence that the tallest Python led this blog post.

And it looks like cultivation and multichannel efforts are winning while conversion, lifetime value, and personalization are not as strong, with negative correlations to page views. I won’t be acting on this immediately, but keeping an eye on it. And I do have a multichannel week planned in the near future, so we’ll be able to test whether that’s an artifact in the data.

However, you might notice that the reason cultivation is ranked so highly is that it is in the two top performing posts, which are Monday posts. Is it the topic or the day that made those strong? For this, you need regression.

Normally, you wouldn’t do this after only 20 blog posts. We are not going to be able to draw any statistically significant conclusions, but I do want to show you how it’s done.

Go to Data > Data Analysis > Regression
Select the range from your outcome variable as your Y range and the range of the independent variables you want to test in the X range like so:
Hit OK. You’ll get something that looks like this. In my case, it’s a really, really bad regression:

Yuck. The things you would normally be looking for are:

in R-squared, you are looking for as close to 1 as possible. One would mean your model is totally predictive. Zero means it predicts nothing at all.
In P-value per variable, you are looking for less than .05. That would show if there is a statistically significant relationship between any of the variables and your output. In this case, there isn’t and we can pretty much throw out the whole thing.
If there is a relationship, you want to look at the coefficient for two things:
- Is it positive or negative? Positive is good things; negative is bad things.
- How big is the relationship? In this one, if these were significant, it would be a bad idea to post about personalization again, as posting about it reducing views by 7. But it isn’t significant, so I’m not yet worried.

Hope this helps you with the stats side of Excel. Tune in next week, when we look at some of the things that Excel is actually good at.