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

---

The Long Sales Letter: Should You Use it In Your Advertising?

If you're a web marketer and you've done your homework,... Read More

Persistence Pays ? Sweet Rewards of Dogged Marketing

No doubt, online marketing is the fastest way to get... Read More

The Most Important Aspect Of Internet Marketing Ever

Hi there,It is still scary to see how many internet... Read More

Internet Marketing - Surviving the First Year

So you've decided to take the leap into deep water... Read More

To All Internet Marketers - How To Get My Business

More and more people are realizing that the Internet offers... Read More

Online Advertising Sinks into the Abyss!

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

Viral Marketing

What is Viral Marketing?"Viral marketing is word of mouth marketing... Read More

The ABCs of Online Customer Support

Want to provide great online customer support? Want to provide... Read More

Shopping Search Engines, The Benefits and Explanations

The Shopping Search Engines are a new breed on the... Read More

Start a Fire Sale! Give Your Faithful Clients Bonuses!

When is the last time you received an unexpected gift?... Read More

The REAL Secret to Building A High-Profit Internet Business

My wife laughs every time she sees me doing it.At... Read More

Make Your Real Estate Website Visible!

So, you've created a Website to highlight your realty services... Read More

Internet Marketing: 10 Blazing Internet Marketing Secrets To Sky-Rocket Your Profits

Your turn to succeed has come.I am happy to offer... Read More

Internet Marketing ? Long Term Strategy

Once your site is up and running, the best method... Read More

Increase Sales: The Secret To Using Offline Advertising To Magnify Your Online Sales

Since the internet happened, and everybody went for the gold... Read More

What to Sell on the Internet?

The phenomenal growth of ecommerce lures more and more people... Read More

Getting Targeted Traffic by Standing Out In The Crowd

Have you ever seen the trading floor in action on... Read More

Seven Ways to Generate Income From Your Website

If you own your own website, there are a variety... Read More

Seven Reasons Why New Products Fail

The most optimistic success rate I have run across for... Read More

When Internet Marketing Gurus Sell Their Souls

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

Internet Marketing Is No Big Secret

You Do Not Need To Be An Internet Marketing Guru... Read More

Six Lesser-Known Online Marketing Ideas

Uniqueness is what separates each business, its services and its... Read More

How To Find Deep Discount Pro Online Marketing Tools

You can't row a boat without an oar or build... Read More

You Gotta Think -- Strategic Internet Marketing!

Have you ever been lost in the woods - wondering... Read More

Online Advertising for Dummies

Whether you are checking your email, shopping on a website... Read More

Take the Direct Route to Internet Gurudom

- Are you tired of chasing down publishers just to... Read More

Internet Marketing: The Secret Magic Of Converting Your Website Visitors To Buyers

It is not enough to set up a website to... Read More

Web Site Marketing Puts Your Own Mark On A Business

The web site marketing you use to promote your Internet... Read More

Candy Jar Marketing

What is one of the main keys to a successful... Read More

The Facts You Should Know About Internet Marketing

I wakeup this morning and see my lovely wife. She... Read More

Guide To Free Advertising

When I first started my internet home business, I realized... Read More

The Most Powerful Niche in the World and How You Can Always Profit from It

There is one piece of software that is always going... Read More

Online Joint Venture Ideas

A joint venture is when two or more businesses join... Read More