Quick Questions for My Techie Readers

I would love help with either or both of these technical questions:

(1) Does anyone know of a way to import html tables into Microsoft Word for Mac keeping the tables intact?

(2) Does anyone have advice regarding whether to switch to Blogger Beta now or wait for the kinks to be ironed out? I have read people raving about it as well as people having problems.

If you have ideas or advice, please leave a comment or email me. Thanks so much!

Technorati Tags: , , , , ,

Search Engine Marketing Fun

Periodically I like to take a look at the search phrases people are using to find my blog. With Google Analytics, I can see the exact words someone used to get to a particular page on my site. Most of the time, the searches are just what you would expect: “social marketing,” “what is social marketing,” “spare change,” various combinations of my name and company, and other phrases that are clearly related to a topic I’ve written about on the blog. Would you believe that one of the most frequent searches the blog turns up on is for information on Jack in the Box commercials? There must be a lot of JITB fans. And apparently there is a movie out called “Spare Change” because there are quite a few searches for that (as well as a Spare Change hip-hop group).

But then there are other more interesting search terms that somehow led people to a random phrase or unrelated topic I included in a post. In these cases, my peeking at the search engine results feels somewhat voyeuristic, like I’m viewing something that the searcher did not intend for another person to see. But since it’s all anonymous, I’m going to share some of the strangest search terms I’ve seen in the past couple of months with you. Apologies if anyone recognizes your own search in there!

Some of them are questions you might never have thought to ask:

  • would Jesus use multimedia [The Sermon on the Mount would have been so much more effective accompanied by PowerPoint.]
  • is it ethical to change name to got milk [What? Someone wants to become “Got Milk” Goldstein?]
  • why the cello squeaks
  • how to make a jack in the box head
  • reasons why you should save your spare change [how about because it’s money?]

Some make me wonder why they think I would have the answer for them:

  • best places to get colonoscopy
  • I want to change my religion
  • should I learn cello or piano
  • how do you say goodbye in Chinese

Some of them are just plain creepy:

  • movie about a sex change at a science fair
  • drug use on the set of bionic woman [Not Lindsay! No!!]
  • rubber hands
  • painted overgrown toenail pictures
  • drinking and driving is fun
  • I change the giant puppets

Some combinations of words are puzzling:

  • the number 24 [is this a dyslexic Douglas Adams fan?]
  • king ding a ling
  • juggling lose weight [the new fitness craze that’s sweeping the nation!]
  • we agree to change spare
  • panhandlers second life [I guess the SL residents that haven’t bought land yet are the new homeless problem]
  • celebrity infant car seats
  • homeless kids fire swallowers [hopefully only in Second Life]
  • yoga fundraising [is that related to Presentation Zen?]
  • change fruit
  • healthy munchies stoners [hey – at least they’ll get their essential vitamins and minerals while they get wasted]

And then there are the painful human dramas:

  • games and activities for a 4 year old with asthma
  • can my son change from being gay by using medicine
  • how to create a flyer for a child with cancer

So what’s the social marketing lesson here? Perhaps that it can be hard to predict exactly how people will find your website or blog, so you need to make sure that your pages/posts have enough relevant words in them to increase the chances that someone looking for your information will find you. And make sure that if someone arrives at a random page on your website, you have enough navigational information — or even suggestions of related content — on each page that they will look around to see what else you have of interest. I’m not a search engine optimization expert, but there are plenty of other blogs and websites that you can look at to get some guidelines. And if any of you with a have some interesting or strange search phrases that you’ve come across on your own site, please share!

Photo credit: wagg66

Technorati Tags: , ,

Sorry, Couldn’t Resist!

Politicians Sweep Midterm Elections

The Onion

Politicians Sweep Midterm Elections

WASHINGTON, DC—Landslide victories for politicians in all 50 states indicate that voters still tend to elect politicians over non-politicians.

WASHINGTON, DC—After months of aggressive campaigning and with nearly 99 percent of ballots counted, politicians were the big winners in Tuesday’s midterm election, taking all 435 seats in the House of Representatives, retaining a majority with 100 out of 100 seats in the Senate, and pushing political candidates to victory in each of the 36 gubernatorial races up for grabs.

While analysts had been predicting a possible sweep for months, and early exit-poll numbers seemed favorable, politicians reportedly exceeded even their own expectations, gaining an impressive 100 percent of the overall national vote.

“It’s a good night to be a politician,” said Todd Akin, an officeholder from Missouri. “The American people have spoken, and they have unanimously declared: ‘We want elected officials to lead this nation.'”

Or, if you prefer something social marketing related:

Americas Cowboys Suffering From Restless Heart Syndrome

The Onion

America’s Cowboys Suffering From Restless Heart Syndrome

ATLANTA, GA—Bouts of wanderlust and deep yearning have led a majority of RHS sufferers to head off in the direction of them twinklin’ stars.

ATLANTA, GA—Officials from the Centers For Disease Control said Monday that preliminary results from a long-term study showed that the vast majority of America’s cowboys suffer from Restless Heart Syndrome, a disorder categorized by deep pangs of yearning, usually following extended, alternating bouts of lethargy and wanderlust.

An Insider’s View of Philip Morris’ Anti-Smoking Campaign

Authors of a study just published by the American Journal of Public Health (available online now and in the Dec. issue of AJPH) say that youth anti-smoking television ads funded by tobacco companies are ineffective, and that the spots intended for parents may even have harmful effects. Among 10th and 12th graders, they say, higher exposure to the parent-targeted ads was associated with lower perceived harm of smoking, stronger approval of smoking, stronger intentions to smoke in the future, and a greater likelihood of having smoked in the past 30 days.

“Of course,” I can hear you saying to yourself, “we all know that Philip Morris is intentionally sabotaging the ad campaign so that it ends up bringing in more future smokers, or at least is just burnishing its reputation with this campaign as window-dressing.” I would have thought so myself. Except that in looking into the campaign, I found out that an old friend and colleague, Cheryl Olson, is on the advisory board for Philip Morris USA’s Youth Smoking Prevention initiative.

Cheryl and I met in grad school, and we have since worked on various projects together, including evaluating tobacco prevention programs. She, along with her husband, psychologist Larry Kutner (who is also the chair of the advisory board), founded and co-direct the Center for Mental Health and Media at the Harvard Medical School. I know that Cheryl is no tobacco industry patsy, and that she would not compromise her integrity if she suspected there were any nefarious strategies behind this campaign.

I got in touch with Cheryl and asked her for her take on the research results that were just published. She, not surprisingly, had a lot to say about why this study is flawed and may just be showing what the researchers wanted to find. I invited her to send me her thoughts to post on the blog, which I’ve reprinted here:

For the past couple of years, I have consulted to Philip Morris USA on smoking cessation and prevention. I had primary responsibility for the content of the QuitAssist cessation guide, and also review and contribute to materials aimed at parents from the Youth Smoking Prevention group.

I work with a group of researchers and clinicians who are affiliated with various universities and hospitals. (We do this work independently from our institutions.) Part of our mandate is to oversee the quality of material content and evaluation, and be vigilant for any unintended negative effects.

Collaborating with a tobacco company can be an awkward and uncomfortable experience for a public health researcher who worked in tobacco control. But since Philip Morris USA is voluntarily committing 100s of millions of dollars to prevention and cessation – going well beyond the requirements of the Master Settlement Agreement – it’s important that a group of independent researchers and clinicians be part of this process to ensure that the resulting materials are honest, research-based, and effective.

My work has included: interviewing parents and former smokers and choosing quotes to use in print and web materials; incorporating research and advice from experts (selected by me) who work with smokers and parents; writing print and web content; and observing focus groups to help formulate and test content (including groups of Spanish speakers with simultaneous translation). I am proud of the brochures and guides I’ve helped develop. Their quality is apparent to anyone who reads them – which may explain why I have received at most a half-dozen phone calls or emails from academics, health workers or reporters asking why I got involved in this.

It is also exciting to be part of a project with such a huge reach. To date, PMUSA has distributed 70 million parent brochures, and hundreds of thousands of QuitAssist guides. The main role of the guide is to encourage smokers to connect with useful government and nonprofit cessation resources; I have heard that the PMUSA web site is the most visited cessation site in the US, and refers more traffic to government web resources than any other source.

I am not involved in developing PMUSA’s TV, radio or magazine ads on smoking cessation or prevention. But I do have some concerns about the article in December’s AJPH. There are some serious flaws in this study’s methodology that make it hard to draw any conclusions about the effects of the ads in question. To describe just two:

1) The “Talk, They’ll Listen” campaign that supposedly harmed children (the one aimed at parents) is based on an estimated exposure to an average of 1.13 thirty-second ads over a four-month period. Let’s take a closer look at this measure of ad exposure.

According to the recent Kaiser Family Foundation national survey, kids between the ages of 8-18 spend an average of 3 hours and 4 minutes per day watching broadcast television. Let’s call it three hours for simplicity’s sake.

There are 122 days in a 4-month period. So kids watch an average of 366 hours or 21,960 minutes of television in a 4-month period. A parent-oriented commercial lasts 30-seconds – or 1/43,920 of their viewing time. If they see 1.13 parent-oriented commercials in 4 months, that means that the commercials comprise 0.000026 (twenty-six one-millionths) of their television viewing content and time. Does it make sense to assume that such an extremely rare event would have the levels of influence on behaviors and attitudes that the authors claim? Based on this exposure issue alone, it’s hard to take the article seriously.

2) The authors should have used a 99% confidence interval (not 95%) with such a big data set [n=103,172]. That is a standard approach to avoid getting significant results just due to a large sample size. The use of 95% CIs raises questions about the odds ratios.

This is pretty disappointing. It’s hard not to think that the authors were determined to find something negative to say. The dramatic statements in the abstract are hedged a lot in the actual paper text, but the abstract is all that many researchers – and most journalists – will read.

This could have been an opportunity to get some useful lessons that could be applied to future media campaigns, and to model state-of-the-art methods for evaluating media-based behavior change materials – methods that could be used by academics and industry alike.

Among other things, it’s too bad that the authors lumped together ads aimed at youth from two companies that used very different approaches. This doesn’t tell us anything about what aspects might have been particularly helpful or harmful.

Given their well-documented past behavior, tobacco companies (and their anti-smoking media materials) must receive ongoing scrutiny from the public health community. But that shouldn’t mean checking our common sense at the door.

Cheryl raises several important points. As much as many of us would like to pillory the tobacco industry, we can’t let that cloud our desire for the truth (as best we can find it statistically). When you see (or do) research that confirms your preconceptions, you still need to look at it critically and make sure that you are not letting your assumptions guide your conclusions.

Thanks to Cheryl for taking the time to share her valuable perspective. I would love to see research on whether parents who have seen the ads and read PMUSA’s materials have spoken with their children about not smoking and whether their kids are less likely to smoke as a result. But even if that part of the campaign were found to be effective, I have a feeling there are many who would not believe it in any case.

Technorati Tags: , , , , ,

Real Disaster Preparedness in a Virtual World

An anonymous commenter on my recent post on the CDC in Second Life directed me to the Idaho Bioterrorism Awareness and Preparedness Program’s Play2Train project.  This space provides a virtual training environment for emergency response professionals.  They have a town set up where they can role play various disaster scenarios complete with victims, as well as a hospital with exercise machines, an isolation ward and a surgery room.  They have also created a machinima video depicting the various stages of smallpox, and a simulation to help teach lung sound auscultation (a fancy way of saying “listening to the lungs with a stethoscope”).  What a great way of doing this type of training in a low-cost way but with a big impact.

Technorati Tags: ,

A Beautiful Blog

Can a blog be beautiful? Absolutely, and especially if it’s Ashley Cecil’s The Painting Journalist blog.  Ashley got in touch with me to let me know about the blog, which is a combination of art and function.  As she describes it:
Welcome to the marriage of painting and social activism. I’ve been creating art ever since discovering that my mom’s Chanel lipstick made a great oil pastel. Through formal art education and years of professional experience, the adult version of this vocation has evolved into my own job title, “painting journalist.” I’m addressing philanthropic issues utilizing painting as my medium of communication. Much like a photojournalist, I travel to locations/events of cultural interest and capture them, only with my brush.

Ashley sells the artwork that she features on the site, and a portion of the proceeds are donated to nonprofits that are related to the topic of the painting.

Ashley’s description and sketches of the aftermath of a murder in her neighborhood is especially compelling to read and view.  She is incredibly talented. If your organization is looking for a piece of art to auction off, or if you would just like to decorate your home or office with artwork that is more than just a pretty picture, take a look at her site.

Technorati Tags: , ,