Internet Marketing icon

Excelling With Online Marketing


Do you want to build a successful online business?

Then start using online math and use Microsoft Excel.

I've written an e-book this year that sells at a profit. In fact, I've written 2 e-books that sell at a profit (I'm thankful to all my Internet friends who have helped me.). I can't imagine anyone selling anything on the Internet without using Excel to keep score on profits and performance.

Are you making a profit or running at a loss? A plain old Excel spreadsheet (or Lotus) will get the job done for you. Are their any trends in profits (or losses) for your online venture? Excel graphs make it easy to see (and sometimes predict) trends.

When you started your venture, how did you estimate the demand for your product on the Internet? I did research on Overture to predict the volume of my Google paid click impressions. Using Excel was a key part of that process.

Whenever I make an e-book sale I add it to my Excel sales database. I click on an Excel macro button that automatically re-formats my email sales notification into a record in my e-book sales Excel database.

Over the past year I've used a powerful Excel technique called a pivot table to analyze my e-book sales database. This is what I learned about my e-book sales:

1)Tuesday was my slowest e-book sales day. I corrected the sales problem by mass mailing offers on Tuesdays. Tuesdays are better now.

2)My e-books have sold in over 37 countries. But 90% of my sales came from just 5 countries. Solution? I adjusted my advertising mix to better spend my advertising dollars.

3)Finally, men purchase about 70% of my e-books. Women purchase 20% and 10% of purchases are from unknown genders (people that use initials only). Solution? None yet. Women just aren't buying my e-book as much as I'd like. But if I find a great copywriter who needs to learn more about Excel I'm in business. We can trade.

Would you like to find an unexpected ally for "Excelling with Online Marketing"? Just check your personal computer. If you have Excel (or Lotus) than you already have a great tool for tracking not only online marketing profits but all kinds of online marketing performance. Build a simple spreadsheet for tracking your weekly profits and then advance to other techniques for measuring online marketing performance.

So, that's it for today. I know that I'm just a first year online marketer and have much to learn. But, I'm "Excelling" with Online Marketing and you should too.

Copyright 2004 Richard Kraneis

About The Author

Richard Kraneis is a computer training consultant, e-book author, and an aspiring online marketer. Online marketing on the Internet reminds him of his favorite hobby, fishing. His website is www.TheWorldsShortestExcelBook.com. You can reach him at rich@TheWorldsShortestExcelBook.com. (He's looking for a great, up and coming copywriter for future projects.)


MORE RESOURCES:

Health Tip: Factors That May Aggravate Acne in Women
U.S. News & World Report
(HealthDay News) -- Acne, the most common skin disease, is not a dangerous condition. But it can lead to permanent scarring. Changes in hormone levels ...
Health Tip: Factors That May Aggravate Acne in WomenNewsday (subscription)

all 3 news articles »


Acne Unveils 'Transvestite and Cross-Dressing' Collection
TIME
Acne, the Stockholm-based fashion house known for its high-end denim, has released a collection of shirts meant to merge high fashion and gender-bending. ...



New York Daily News

Acne Launches Transvestite Shirt Collection (PHOTOS)
Huffington Post (blog)
Swedish label Acne, in conjunction with Candy magazine, has launched a collection of three shirts aimed specifically at cross-dressers and transvestites, ...
He/She's got the look: Swedish clothing line ACNE launches shirts aimed at ...New York Daily News
Acne launches range for transvestitesThe Vine
Acne launches a new transexual collectionwallpaper.com
Gawker (blog) -The Local.se
all 6 news articles »


Fashion Week Staff Picks
New York Times
And the DJ Jacques Renault will be at the Acne party at Fashion's Night Out to satiate my second guiltiest pleasure (after Popeye's): disco.” Friday, Sept. ...



Medicis Announces New Patent for SOLODYN(R)
MarketWatch (press release)
The new patent, entitled "Minocycline Oral Dosage Forms for the Treatment of Acne," relates to the use of dosage forms of SOLODYN which provide ...

and more »


PR Web (press release)

New, Exclusive Strength: Tretin-X® 0.0375%(tretinoin) Cream
PR Web (press release)
New strength offers a JUST RIGHT approach for acne patients. Triax Pharmaceuticals, LLC announced today the approval of a new, topical retinoid with an ...

and more »


Fridge fixins for a fabulous face
Marist College The Circle
Spas and salons offer facials that make your skin softer, reduce acne, make pores appear smaller, get rid of blackheads and more. ...



Fashion line aims for androgyny
UPI.com
Fashion label Acne said it teamed with Candy Magazine, a publication dedicated to transvestism, transexuality, cross dressing and androgyny, ...

and more »


Seven Surprising Uses for Baking Soda
GOOD (blog)
Let us be clear: Baking soda is not going to permanently cure your acne or turn back the cruel hand of time. But if you're looking to detoxify your body and ...



The FADER (blog)

Acne Blurs the Gender Binary with a Transsexual Collection
The FADER (blog)
Leave it to Acne to shake things up a bit. In conjunction with Candy, a zine that celebrates transsexuality, they've released this gender-neutral collection ...


Google News

home | site map
© 2009