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.)

In The News:


Google News
Updated : Sat, 11 Oct 2008 23:50:53 GMT

Got $700 Billion? Sweat the Details - New York Times


Telegraph.co.uk
Got $700 Billion? Sweat the Details
New York Times - 3 hours ago
The bailout plan gives Henry M. Paulson Jr., the Treasury secretary, three broad choices in buying assets. By ALAN S. BLINDER THE House of Representatives was against the bailout bill before it was for it.
US firms up plan to buy into banks to stem crisis Reuters
Paulson Indicates Need to Purchase Bank Equity `Soon as We Can' Bloomberg
Los Angeles Times - Washington Post - The Miami Herald - International Herald Tribune
all 2,358 news articles

Publ.Date : Sat, 11 Oct 2008 20:39:07 GMT

US space tourist set for blast-off - Reuters


Canada.com
US space tourist set for blast-off
Reuters - 40 minutes ago
By Maria Golovnina BAIKONUR, Kazakhstan (Reuters) - US video game magnate Richard Garriott will blast off into space aboard a Russian spaceship on Sunday watched by his father, a NASA astronaut who went into space at the height of the Cold War.
US space tourist set for launch BBC News
Russian space chief reassures US partners The Associated Press
Times Online - USA Today - Spaceflight Now - RedOrbit
all 287 news articles

Publ.Date : Sat, 11 Oct 2008 23:10:50 GMT

Gay Marriage Is Ruled Legal in Connecticut - New York Times


Boston Globe
Gay Marriage Is Ruled Legal in Connecticut
New York Times - 5 hours ago
In Hartford, Crystal Pretzman of Willimantic, Conn., celebrated the State Supreme Court's decision to legalize same-sex marriage.
Video: Connecticut Court Allows Gay Marriage AssociatedPress
Marriage ruling not the end of debate in Conn. The Associated Press
Newsday - Washington Post - Reuters - NECN
all 1,711 news articles

Publ.Date : Sat, 11 Oct 2008 18:13:08 GMT

World is united to tackle financial crisis, IMF says - MarketWatch


BBC News
World is united to tackle financial crisis, IMF says
MarketWatch - 2 hours ago
By Rex Nutting WASHINGTON (MarketWatch) -- Financial policymakers from 180 nations around the world are united in their resolve to tackle the financial crisis, Youssef Boutros-Ghali, head of the International Monetary Fund's policy committee, ...
G7 nations face going cap in hand to China guardian.co.uk
Finance officials comments at IMF meetings Reuters
AFP - BBC News - Bloomberg - New York Times
all 579 news articles

Publ.Date : Sat, 11 Oct 2008 21:23:46 GMT

YouTube to play full TV episodes with ads - Afterdawn.com


Vancouver Sun
YouTube to play full TV episodes with ads
Afterdawn.com - 2 hours ago
Google has announced that it will begin offering full-length TV episodes through its YouTube platform beginning this week, thanks to a content deal with CBS.
YouTube to Offer TV Shows With Ads Strewn Through New York Times
YouTube beams up Star Trek for long-form video, prominent new ads CNET News
Wall Street Journal - eFluxMedia - Silicon Alley Insider - Bizjournals.com
all 109 news articles

Publ.Date : Sat, 11 Oct 2008 21:13:12 GMT

GOP Officials Hope for Stability From McCain - New York Times


Voice of America
GOP Officials Hope for Stability From McCain
New York Times - 1 hour ago
By ADAM NAGOURNEY and ELISABETH BUMILLER Republican leaders across the country said Saturday that they were worried that Senator John McCain was heading for defeat unless he brought stability to his presidential candidacy and settled on a clear message ...
Antiwar Protestor Disrupts McCain Iowa Rally Washington Post
Obama needs 75 percent turnout in Philadelphia, says Rendell CNN Political Ticker
The Weekly Standard - Summit Daily News - USA Today - WNCT
all 1,087 news articles

Publ.Date : Sat, 11 Oct 2008 22:23:47 GMT

Nobel Peace Prize winner wants jobs for the young - International Herald Tribune


Times Online
Nobel Peace Prize winner wants jobs for the young
International Herald Tribune - 10 hours ago
AP HELSINKI, Finland: Nobel Peace Prize winner Martti Ahtisaari said Saturday that finding jobs for more than 1 billion young people in the Middle East and Asia will be a major challenge to peacebuilding in the next decade.
Video: Ex-Finland President Wins Nobel Peace Prize AssociatedPress
Nobel Finn Wall Street Journal
Voice of America - Times Online - Burlington Hawk Eye
all 1,453 news articles

Publ.Date : Sat, 11 Oct 2008 13:12:07 GMT

RSS to HTML
Increased Website Traffic


PARLOT::Ebooks, Scripts, Websites, and more...

Adsense websites

How To Actually Make Money In Network Marketing

Most people that I know who are, or have been... Read More

Do You Really BELIEVE You Have What It Takes To Make Your Website A Success?

Last week, on a cold, dark Friday night I stood... Read More

At Last, The Real Secret Of Internet Marketing

I am going to share a real secret with you... Read More

Niche Marketing the Right Way!

Niche marketing is hot these days. Membership sites pop up... Read More

Online AD Tracking ? An Ongoing Process

Without tracking, your online advertising is just a shot in... Read More

The Secret to Making More Money in Your Online Business: Lessons From Monopoly

Thousands and thousands of people are striving to make more... Read More

The Google Toolbar & Search Engine Optimization

Like many other useful toolbars out there so is the... Read More

How To Be An Internet Marketing Champion

How bad do you want to make money on the... Read More

Truth and Lies

How low can one get? The number of encounters I... Read More

Is The Internet the Ideal Marketing Medium?

The internet has grown explosively in the ten or so... Read More

Build Your Marketing Muscle

During a saxophone lesson the other day I realized how... Read More

When Internet Marketing Gurus Sell Their Souls

If you're just getting started in Internet Marketing, you may... Read More

How To Make A Lot Of Money On The Internet Doing Nothing

"You can make a lot of money on the Internet... Read More

Online Advertising Sinks into the Abyss!

Back in the ancient days of 1994 when Mark Andreesen... Read More

Generating Sales with Lead Generation and Online Marketing Tools

One of the best projects to undertake as an online... Read More

Think Outside The Box: Home Internet Business Ideas

Imagine never having to leave your home to work. Not... Read More

How SPAM Sells Sex, Greed, and Survival

The unsolicited email people react to most is what yells... Read More

After Fifteen Years Or More Of Frustration With Internet Marketing, I Think Ive Found It!

Hello Internet junkies and friends,Did I mention my frustration with... Read More

Do You Even Realize What Youre Promoting?!

Now, I'm a firm believer in knowing what you're getting... Read More

Two Steps to an Investment-Free Online Empire

If you're like most of us, you're not on a... Read More

7 Quick Marketing Tips To Uplift Your Profits

1. Publish an ezine.Your ezine will help you to stay... Read More

The Worst Internet Marketing Strategy Ever?

Many people are downright frustrated.And when you look at their... Read More

Marketing Objectives for Your Web Site

Do you have marketing objectives for your Web site? With... Read More

You Know Youre Too Ethical When...

Yeah, TOO ethical!? Lately, with some of the issues I've... Read More

Headlines Bring Sales--Where and How to Use Them - Part 2

Headlines are short vital statements to stimulate your potential customers... Read More