Sometimes Google really scares me

Given my sudden realization that I am now “middle aged” (although, in terms of lifestage, I’m really still a young adult) I was mildly stunned to see this in today’s analytics results.

This is how people found my blog.

Mediaczar 203A Blog Stats 2014 WordPress

Older single men wanted.

Hmph.

Today, at least, I’m the seventh Google result for that particular search. As it happens, no-one really seems to be doing natural SEO for that particular search. Perhaps there’s a limited market for older single men.

According to NicheBot Classic there are only around 4 searches every day for “single old men” on Google. Google’s own keyword tool suggests that - while there are 74,000 searches for “single men” every month “single older men wanted” isn’t the big keyword. Ah well.

What this site looked like in 1983

Well - screen resolutions were lower back then.

In which I am stunned by the rapid onset of middle age.

I woke up this morning, and realised that I’m suddenly in early middle age. On the bedside table were three sets of prescription pills; something that I have ever only really associated with - you know - old people. I can’t be old. I’m not married, and have no children. I’n my imagination, I’m still just approaching grown-upness. Apparently, like Binkie Huckaback, I am in fact an ageing juvenile.

Despite not being very sporty, or taking great care of myself, I’ve always been fairly fit and strong. I fancifully attribute this to my genetic past; I like to thing that my ancestry is equal part displaced desert tribes and farmers. Whatever the case, despite my none-too-clean-living twenties it seemed that I could do what I liked and never really count the cost.

But today those pills told me that I’m not the man I used to be.

10082008025.jpg

To be fair, things have been creeping up on me for a while. A badly-healed broken collar bone from my early twenties is getting a little arthritic these days. Torn cartiledge in my left knee makes a nasty snapping crackling and popping noise. But nothing, I thought, more than the usual dents and scratches you’d expect; stuff that could be hammered out, and polished over.

But things have begun to change.

About five years ago I was diagnosed with Meniere’s disease: a nasty inner-ear problem which creeps up unexpectedly, and leaves me faint and nauseous with dizziness for a couple of hours; and which often keeps me light-headed and disoriented for days at a time. At the time of diagnosis, I decided that - since there was no actual cure - and the lifestyle changes that the specialist suggested were so seemingly onerous - that I would follow the habit of a lifetime, and simply tough it out.

This seemed to work for a while; but recently I found myself in a New York hotel room scared to move, or eat, or indeed do anything that might bring on another attack. The first real attack came on during a new business pitch, after which I was laid up for four days - missing all the meetings and training sessions that had been scheduled for that trip.

So a month ago, out of a sense of duty to myself and my employers, I went back to the specialist, and actually listened to what she had to say. I still don’t like it very much, but I’m going to give it a go.

I’m on a low-salt diet. I’ve always been a bit of a gourmand; and taking salt out of my diet is quite a challenge. I’m also supposed to be off caffeine and alcohol (although I’m taking the whole alcohol thing a little less seriously than I should.)

To strip even more salt out of my body, I’m taking a course of diuretics. I think I’m taking the same brand as my grandmother. This does not make me feel more manly. Two every morning

Because the diuretics and the diet also leach out potassium, I’m taking potassium replacement pills. Two tablets, three times a day.

The Meniere’s attacks are generally brought on by tiredness and stress. The blue pot contains some diazepam that I got from a hotel doctor in San Francisco after a severe combination of jet lag sleeplessness and what seemed like anxiety attacks. They’re more there for reassurance than anything else.

Insomnia’s been one of those things that bothered me for as long as I can remember. In my twenties and early thirties, I found that this meant that I had longer to work on things or to party. But in my late thirties, it’s a drag; particularly as I travel a bit, which means my body clock’s all screwed up anyway. My GP has prescribed me sleeping tablets - I rarely take them but again - it’s reassuring to know they’re there close at hand.

I’ve been through a bunch of tests as part of this process. The blood tests in particular have highlighted some new and interesting problems. For example, it seems that I have a propensity to gout; yet another pin in the balloon of my gourmandism. I can’t wait for that. Furthermore, I have high levels of the wrong kind of cholesterol; and either I’m an alcoholic (which I’m sure I’d have noticed), or I’m actually dangerously overweight.

Until recently, weight loss and fitness used to be nothing more cosmetic issues for me. Now they’re a more serious problem. Of course, this makes them much easier to deal with.

I’ve decided that - while I get started at least - I’ll try using this blog as one of the tools to help keep me on track. What was previously merely an intellectual problem has now become personal and subjectively experienced.

Mediaczar blog timeline

I’m obsessed by timelines. I’ve worked on two (unrelated timeline projects for clients) Last year, I worked on a project that (believe it or not) that would have had the identical same brief as dipity. Dipity, however, has launched; and our project didn’t.

Our Social Media Policy

Following a PRCA roundtable this morning to discuss Ofcom’s research into social networking, I’m pleased to share a (very draft) version of our new Social Media Policy.

[edit: the "our" in that sentence means "Porter Novelli's"]

You can see a larger version, and download a copy as a PDF or Word Document over here at Scribd. Alternatively, you can click the “enlarge” button (what the orange arrow’s pointing to in the image below).

Previewing: 201COur Social Media Policy201D

I’d appreciate as much feedback as possible. It would be nice if you’d share what you have to say (whether positive or negative) in the comment stream below. That way others can see what you’ve said, and build on it. If not, I’m happy to receive anonymous comments by email.

I’d like to say a big thanks to Richard Ellis from the PRCA, and Justin Le Patourel and Sam Carter from Ofcom for putting on a wonderful show this morning.

What we can learn from the real evangelists?

This is a description of Billy Graham crusades from an academic study I’ve been reading. I’m interested in how real evangelists work (after all, I use the term often enough when talking to colleagues and clients):

Counselors begin their work after the singing, testimonials, collection and Billy Graham’s sermon, which culminates in the altar call. At the moment of Graham’s invitation to “come forward to Christ.” counselors and choir members begin moving forward to an area usually in front of the speaker’s platform or rostrum. To a naive member of the audience or a television viewer, this movement creates an illusion of a spontaneous and mass response to the invitation. Having been assigned seating in strategic areas of the auditorium or arena and given instructions on the staggered time-sequencing for coming forward, the counselors move forward in such a fashion so as to create the illusion of individuals “flowing” into the center of the arena from all quarters, in a steady outpouring of individual decision. Unless an outsider or observer of these events has been instructed to look for the name tags and ribbons worn by those moving forward it is all too easy to infer from these appearances the “charismatic” impact of Graham and his invitation. These strategies promote the respectability of making a public commitment and represent methods calculated to manipulate the consent of the passive, the uncertain, the wary, and the indecisive.

(from: David L. Altheide and John M. Johnson, Counting Souls: A Study of Counseling at Evangelical Crusades, The Pacific Sociological Review, Vol. 20, No. 3, (Jul., 1977), pp. 323-348)

Momentum

A recent (and criticised) study by Tubemogul on the short shelf life of online video reminded me of some research into views on YouTube videos I did back in 2006. I only looked at about 130 random YouTube videos for the first 20 days of their life cycle, while TubeMogul’s methodology was somewhat more sound (they tracked more than 10K videos for around three months, among other things.)

Here’s the chart from my analysis:
Continue reading ‘What we can learn from the real evangelists?’

Coincidence? I think not

From a comment stream on the FT


Tags:

Sweaty men wanted

I received this today. Anyone interested? I shan’t be going

Dear all,

The Gillette team needs your help. We are looking to recruit 20 men that meet the following criteria:

  • single
  • 25-45 years old
  • takes an active interest in his appearance

Each man, in return for £50 and a Gillette goody bag, would need to come to the London office straight after work on Friday 25th July to take part in an experiment for the evening. In advance of arriving at the office each man will have been using a deodorant sample for a few days (we will confirm nearer the time).

At our office, they will be introduced to psychologist David Moxon and be fitted with heart rate monitors. The first experiment will involve each man presenting for 2 mins on a randomly selected topic.

The men will then travel by underground to a speed dating event (hence they need to be single, and heterosexual I’m afraid).

After the speed dating they are free to go.

The results of this experiment will be used as part of the PR campaign to support the launch of Gillette’s new deodorants in 2009. We will therefore need to ask the men to sign a confidentiality agreement.

Please could you send me the contact details of men you think would be interested in doing this, or give them my contact details to get in touch.

Many thanks

Susie

how to: perform free Facebook audience research

Facebook provides a free, useful way to interrogate its database of users. This can be invaluable whether you’re actually thinking about planning a campaign on Facebook, you’re looking for some quick-and-dirty audience research, or you just need some corroborative detail.

So where’s this tool? It’s all part of Facebook’s Social Ads platform. Here’s how you do it.

Step 1

Facebook audience research step 1.0

Go to http://www.facebook.com/ads/create/. You don’t need a Facebook account to do this.

The page may look a little different if you’re already logged in, or if you’ve created something using the platform in the past.

acebook audience research step 1.1

Type in any URL. It doesn’t matter.

Step 2

Facebook audience research step 2.0

Now this is where it really gets interesting. Play around with the various drop-downs and check boxes. How many Australians aged 25-30 have registered accounts with Facebook? How many of these work for the Macquarie Group?

Or ask Facebook how many of its UK users enjoy peanut butter?

Facebook people who like peanut butter enough to tell their friends

If you have a Facebook account yourself, you’ll know that there are lots of places in your profile where you can answer questions.

So for example, it’s perfectly possible to dig around and find out what portion of the Facebook audience say, likes peanut butter enough to feel that it’s important that they tell their friends.

Or which age group most (publicly) enjoys Curb Your Enthusiasm.

UK Facebook users who enjoy \

Caveat 1

Facebook users who live in London

We’ve seen that (at May 6, 2008) there were around 9.7 m registered UK accounts aged 18+ (or approximately 16% of the total 2006 UK population). But - of course, we can be more granular than that, and look at specific cities. For example, we can see that there are around 2.5 m users based in London.

Facebook Londoners who are male

Of these users, 788 K are male. This should raise a few suspicions, because at first glance one might infer that the remainder (2.5 m - 788 K = 1.7 m) of the users are female. This would mean that (in London, at least) female users of Facebook outnumber male users two to one.

But when we add women into the mix, we see that women and men combined account for only 1.7 m Facebook accounts in London.

What gender are the remaining 900 k (2.6 m - 1.7 m) users?

Facebook can only tell you what its users have shared. If they have chosen not to share their age, gender, location, etc. you can’t see it. Double check your numbers, and bear in mind that the more granular you get, the more room there is for error.

Caveat 2

18 and 19 year olds who like peanut butter enough to tell their Facebook friends

It appears that there are around 140 people aged between 18 and 19 on Facebook who like peanut butter enough to tell their Facebook friends.

18 year olds who like peanut butter enough to tell their Facebook friends

Breaking it down a little further, we see that 40 of these are aged 18.

19 year olds who like peanut butter enough to tell their Facebook friends

And 140 of them are aged 19.

Adding those numbers together, that’s 160 peanut butter lovers aged 18-19 , not the 140 peanut butter lovers we saw in the first run.

Running the exercise again confirms that twenty new peanut butter lovers haven’t suddenly signed on in the past five minutes.

There’s clearly some kind of rounding error. It seems that Facebook rounds to the nearest twenty. Bear this in mind that these estimates are intended for the purposes of estimating advertising audiences.

how to: create alternate row-shading in Excel

Why would I want to do this?

I think it’s easier to scan along lines if you colour alternate rows, particularly when you print out your sheets. Gridlines are somehow a little disorienting. You may not find this, and you may prefer the big black borders approach. But if you don’t, read on.

What’s wrong with the way I do it?

Well, if you’re doing it by hand, you’re going to run into two problems.

  • Depending on how many rows you want to shade, it can take a long time.
  • When you delete or add cells, you can throw off the whole thing, and have to start again

These are sufficiently irritating that it’s worth sharing this approach.

More to the point, I wanted to test out some new screen capture software (

Select all the cells you want to change. I usually select all. On the Format menu, click Conditional Formatting. Under Condition 1, select Formula Is. In the data entry box, type =MOD(ROW(),2)=1. Click the Format button. In the Format Cells dialog box, click the Patterns tab. Select a light-blue color, and then click OK. In the Conditional Formatting dialog box, click OK.


Alternate row shading in Excel