Online Advertising Blues

Or how to lose half a day in front of a computer.

I am the owner of a small business, Flying M Air, LLC. I do just about everything for the company except maintain the aircraft: schedule flights, preflight the aircraft, fly, take payment from passengers, manage the drug testing program, work with the FAA, meet with clients, negotiate contracts, arrange for special events, hire contract workers, record transactions, handle invoicing and receivables, pay bills, create print marketing materials like business cards and rack cards, etc. I also handle the online presence for the company, including the company website, Facebook, and Twitter.

(You might wonder how I have the skills to do all this stuff. The truth is, I have a BBA in Accounting and lots of business training from college. I also wrote books about computers for 20+ years, including several about building websites and using Twitter. Sadly I never studied helicopter repair.)

Today, I lost half a day to marketing and related online chores that were mind-bogglingly time consuming.

You see, I scheduled an event with a local resort, Cave B Estate Winery & Resort in Quincy, WA. Cave B is one of the destinations I take people on winery tours, although I admit I don’t go there very often. For the same price, folks can go to Tsillan Cellars in Chelan, which they seem to prefer. Cave B has a better restaurant and a more interesting atmosphere in a beautiful place. Tsillan Cellars is also in a beautiful place, but it’s a bit touristy for my taste. I actually don’t care which one I fly to since I can’t drink wine at either one. I just like to fly people to wineries.

But the new manager at Cave B Resort is very eager to get the helicopter onsite as an interesting activity for guests. So we set up a 6-hour event there for Saturday, July 2. I’d land in the field as I usually do and offer 15-minute helicopter tours of the area for $75/person. While that might seem kind of steep, it’s pretty much in line with my usual rates. Besides, the folks who stay at Cave B aren’t exactly cheapskates. (I just looked into booking a room for my upcoming birthday and decided that it was a bit too rich for my blood, at least this year. I think I’ll settle for a spa day.)

Setting up this event required me to complete a bunch of tasks on my computer:

  • Tour Flyer
    I threw together this flyer based on a template in Microsoft Word.

    Create a flyer in PDF format that could be used at the resort to let guests know that tours were available that day. I cheated: I used one of the Templates that came with Word 2011 (which I’m still using on my Mac). I already had pictures; I just had to put in the text and make it fit. It took about 30 minutes to complete and I had to make one change after sending it to Cave B’s manager. They’ll print it out on a color printer and, hopefully, put one in each room on Friday.

  • Use Square‘s item feature to set up an item for the tours so I could easily charge passengers for the flights and sell them online. I’ve been experimenting with online sales lately as a tool to get impulse buyers to buy in advance in certain predetermined time slots. So setting up the item also required me to set up the time slots and then create an inventory feature to prevent me from overselling a time slot. This took another 30 minutes or so. This had to be done before I finished the flyer so I could include the URL in the flyer.
  • Use bit.ly to create a custom short URL for Flying M Air’s online store. No one could remember the regular URL; maybe they can remember bitly.com/FlyingMAir. This took about 5 minutes. Of course, this also had to be done before the flyer was done so the URL could be included.
  • Tour Announcement
    Here’s the top part of the web page I created to announce the special event.

    Create a “blog post” on Flying M Air’s website (which was built with the WordPress CMS) to announce the event, provide details, and include the link for buying tickets. Once the post was published, I had to go back and add a featured image so it would appear in the slideshow of items at the top of the Home page. I also had to add an expiration date so that it would stop appearing as a “special” on the site after July 2 at 5 PM. Doing all this took at least another 30 minutes. My WordPress site is designed to automatically post a link to new items on Twitter for both Flying M Air and my own personal account, so at least I didn’t have to fiddle with Twitter.

  • Create a new event on Facebook for the Cave B Tours. That meant using pretty much the same photo, description, and link I’d put in the flyer in a Facebook form. Because Facebook requires a “Category” for each event and they’re not very creative with the category names, there’s now a “Festival” at Cave B that day. (Sheesh.) This took at least another 20 minutes.
  • Share the event with my friends on Facebook. Why not, right? Five minutes.
  • Post details on Cave B’s Facebook page for the event. I got lazy and put in a screen shot of the flyer. 5 minutes.
  • When I realized that I could probably sell the flight to and from Cave B that I’d have to deadhead for the event, I created a “Be Spontaneous” special offer on Flying M Air’s website, offering up the roundtrip flight for half price: $272.50. That’s less than my cost and a real smoking deal for anyone who wants two great helicopter flights and six hours at Cave B. (I’m thinking lunch, tasting, and a hike.) This took about 30 minutes.
  • I also had to set up an item in Square for this offer so I could make it easy to charge for or sell it online. No special URL was required, but I did have to put the link to the item in Flying M Air’s online store in the special offer post. Twenty minutes.
  • While I was fiddling with my website, I checked the Special Offers category and discovered a whole bunch of expired offers. So I recategorized them as Expired Offers. Then I spent some time adding a subscription form to the Special Offers page and made sure that page appeared in the slider at the top of the Home page. Anyone who subscribes automatically gets new posts by email; this is a great way to learn about special offers as they become available. I know I spent at least an hour on this.

Of course, while I was working on this, I was also taking calls from a potential client (in the U.K., of all places), texting back and forth with photographers that could help me close a deal with her, and writing reminders for the other things I needed to do at my desk: order wall mount display cabinets from Ikea, choose a garage door opener option (after researching the three options), and send out invitations for a outing on my boat the next day. So I wasn’t 100% focused on the tasks at hand.

I was only mildly surprised when I looked up after that last task and saw that it was after 1 PM.

The whole morning was shot. (No wonder I was hungry.)

But this is typical when I sit in front of my computer — and is why I spend a lot less time in front of my computer these days. Business tasks need to be done and I’m the one that has to do them. It’s a fact of life and I’m not complaining. Just trying to point out that marketing a business isn’t as easy as putting up a website and waiting for the phone to ring — especially with so much social media to deal with.

Feeling Overwhelmed?

Join the club.

Lately, I’ve been feeling a bit overwhelmed. It isn’t the first time and it won’t be the last. But it is bothersome — an uncomfortable feeling that makes me question everything about my life.

I’ve made some serious personal decisions recently that are likely to rock my world over the coming months. This is a stressful situation that’s not made any easier by the lack of support by friends and family members. I’m going it alone — as I so often do — and it’s weighing heavily on my mind.

But the feeling of being overwhelmed is primarily due to my workload. As a freelancer, I work when there’s work to do. When there isn’t work to do, I’m usually waiting for or looking for more work. Sometimes I need to make work. Other times, work appears unexpectedly — even when I don’t want it or have time for it. But I have to do it all — to turn down work is to possibly miss out on future work.

Such is the life of a freelancer.

Right now, I’m working on four content creation (writing, video, etc.) projects:

  • Book CoverFinishing up a special iBooks 2 interactive edition of my iBooks Author book. This requires me to record and edit dozens of screencast videos and completely re-layout the book in iBooks Author. The good news: I might be able to finish up today. That is, if Alex the Bird can keep quiet and the landscapers don’t spend much time blowing leaves outside my window. And the neighbor’s dog doesn’t bark nonstop for an hour. Again.
  • Lynda LogoPrepare scripts for a revision of my Twitter Essential Training course on Lynda.com. We’ll be recording this course soon and I want to be fully prepared before I fly out to Lynda to record. And my new producer, wants to see the scripts, too.
  • An aerial photography book. I began writing this last year and have put it aside repeatedly because I need artwork and photos that I can’t produce on my own. I suspect it’ll have to wait until this summer to finish up.
  • A book of helicopter pilot stories. I’m collecting these stories from other pilots and plan to compile them in a book for release later this spring. As I get more and more bogged down with other things, however, the self-imposed deadline keeps slipping. I suspect this will be finished up when I get to Washington, too.

Of course, with Mac OS X Mountain Lion announced, I know what I’ll be doing first when I get to Washington: Revising my Mac OS X Lion book for the new version of the OS. Oh, yeah — and then there’s the videos and Websites I’ve been asked to create for a handful of winemakers up there.

It’s not just writing work and the occasional helicopter flight that’s stacked up before me. It’s all the paperwork that goes with it.

I have two separate businesses, each with their own bank accounts and accounting records. I don’t have an accountant — hell, I am an accountant; my BBA is in accounting. To hire an accountant would be silly, since I could do that work myself and save a bunch of money. So I do. Or I try to. Often, it just stacks up, waiting for me to get to. I haven’t balanced a bank account in several months. And I’m only partially switched from Quicken (since it no longer works in the current version of Mac OS) to iBank (which I really don’t like). It’ll take days to sort out the accounting mess I face when I get around to it.

And then comes tax time. What a freaking nightmare that is.

And then my annual migration back to Washington. That’s a logistics issue. Find someone to fly up to Washington with me to help cover the flight costs. Do the flight. Catch a commercial flight back to Arizona. Pack the RV, get the truck ready. (Did I mention that I might have to buy a new truck this year, too? And take delivery before the end of April?) Make the 1200-mile drive to the Wenatchee area. Retrieve the helicopter from wherever I left it in Washington. Get my contracts set up for summer work.

Of course, that’s if there is summer work. My clients never want to sign up until after the last frost. There’s a chance I might get to Washington with the helicopter and a frost will wipe out the cherry crop. No need for my services then. Ready to fly but no clients. How do you think this possibility affects my stress levels?

On the flip side, there might be too much work for me to take on by myself. Then I have to scramble and find people who are willing to put their life on hold for 3-6 weeks and wait around for the rain in Washington. I’ve already started collecting possible candidate phone numbers. None of them are happy that they’ll have to wait until May to know whether there might be work for them.

Before I leave Arizona, however, I do have to pack up everything I own that’s in our Phoenix condo in case it’s rented or sold while I’m gone. That’s a whole office full of stuff, as well as clothes and other personal effects. Hell, I haven’t had enough time to unpack the boxes that brought some of this stuff here.

And I did mention that I have to travel to Lynda.com for a week to record a course, right?

And there is the possibility of a very big client needing to fly with me in late March or early April, before I go to Washington. Unfortunately, they can’t pin down a date. Once they do, if I’m not available, I’ll lose that job — and it’s not the kind of job I want to lose.

Along the way, I need to start seriously considering where I’m going to live and what I’m going to do when my work in Washington is done this year. I’ve been wanting to relocate for years. I’m sick of Wickenburg’s small-mindedness and the bullshit politics and greed that have ruined the town. Phoenix is no gem, either — except on February days like yesterday when the temperature hovers in the high 70s and there’s not a cloud in the sky. The personal decisions I’ve made recently give me a good opportunity to make the change. Unfortunately, I don’t know where I want to live. I’m leaning toward Oregon — perhaps in the Portland area — but who knows?

So with all this on my plate and on my mind is it any wonder that I’m feeling a bit overwhelmed?

But this is typical in my life — and in the life of most hardworking freelancers and business owners. Things don’t get done by themselves. And if things aren’t done, I start feeling it in the bank account. I don’t know about you, but I like to pay my bills on time and eat.

Guess I’d better get back to work.

How NOT to Provide Instructions to Your Web Developer

Hint: Embedding images in a Microsoft Word file is never a good idea.

WheelsYears ago, I received a flyer in the mailn about a replacement for my helicopter’s stock ground handling wheels. For those of you who don’t know, you move a helicopter around on the ground by attaching wheels that lift the skids off the ground so you can push it. The stock wheels on my helicopter — then an R22 — were too small for me to clear the runners for my hangar door. These larger wheels — called “Big Wheels” — would give me the extra clearance I needed to get over the lip.

Trouble is, I didn’t want to spend $450 on a set of wheels, sight unseen.

So I offered the manufacturer a free Web site in exchange for the wheels. Being a guy who wasn’t particularly Internet savvy, he said yes. And thus began our relationship.

In the ten or so years since then, Walt has given me numerous items of ground handling equipment to test out. Some of it I really liked — like the Big Wheels that he gave me for my R22 and, later, for my R44. Others, not so much — the original tow bar design, for example, wasn’t quite beefy enough to tow my R44 from my hangar to my departure area some distance away at the airport. But it was all great quality stuff that I was pleased to have the opportunity to use and show off. In exchange, Walt got a respectable-looking website, first coded in HTML and then upgraded as a WordPress-based CMS. Lots of pictures — some of which I’d taken with my helicopter as model; the one above is an example. (Yes, my first helicopter had white skids).

The only thing that kind of bugged me over the years was the way Walt requested updates to the site. He’d sometimes send random photos with notes. Sometimes I’d make a requested change and then he’d respond with another change to the same page. I’d get bursts of email messages from him with new content. It got to the point that I’d usually wait a week or two after hearing from him to make sure there wasn’t anything else on the way. That led to me forgetting to take care of things for him and him politely reminding me and me finally getting it done.

Please understand that I don’t mind updating his site periodically. It’s not as if he does it every month — or even every year. It really isn’t (or should’t be) much work. And I use the wheels regularly. I don’t feel as if I’ve done enough work to cover the cost of them yet. After all, it isn’t as if I created some super spectacular custom solution for him. It’s not as if I spent weeks of my life developing and maintaining his site. And he really is a nice man who makes a great product.

About a month or so ago, I got an email message from Walt’s wife. (I didn’t even know he was married.) She wanted to know the best way to request changes. I told her to put them all into one email message.

The email messages started arriving a while later. Note that I used the plural form of the word message. I was busy with other things — a book, travel, etc. — and I didn’t take a look at them right away. She emailed me to confirm that I’d received them. I said I had and would get to it as soon as I could. She waited another week and then sent another email with a note saying that she’d put all the changes in one document, as I’d requested.

Attached was a Word document.

And then I looked at the other email messages. They all included Word documents, too.

I don’t recall asking for a Word document and I know damn well I never told her to embed the images in a Word document. There are few things as painful to me (or likely to anyone else) than removing more than 50 images from a Word document file.

EditsBut what’s worse is that she created it with Word tables and used notes inside the table cells to indicate which images to keep and which ones to remove.

Yes, that’s right — she also sent me images I already had. Images that were on the website.

And did I mention that the images were all different sizes and resolutions and proportions? They look the same here because she resized and cropped them in Word. But they’re all over the map when it comes to size and some of them are as tiny as 2-1/2 inches wide at 72 dpi. This is supposed to replace images that were at least 6 inches wide at 72 dpi. Do you know what they look like when I try to scale them up?

But it’s the inconsistent use of little down-pointing arrows and the positions of the images that I’m struggling with. Is she pointing to a replacement or the one I’m supposed to delete?

Understand that she didn’t reproduce the page the way it appears on the website. She didn’t label them the way they are on the website. From what she’s sent, it’s not even clear whether she’s introducing new products, removing old products, or just playing a really mean joke on me.

Don’t get me wrong. I like Walt and I love his Big Wheels. (Seriously: if you have to pull an R22 or R44 or R66 around, these are the wheels you need.) He’s a nice person and his wife seems very nice, too. It’s extremely difficult, however, to get the job done with what they sent. And not to scream in frustration.

I know they’re doing the best they can. But I also know that this could easily be a post in Clients from Hell.

So now I’m waiting for her to get back to me with more information and possibly some newer, larger photos so I can finish up, take a deep breath, and go have a martini.

Do you understand now why I don’t do websites for other people anymore?