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

---

What is the Flavor of Your Website?

When I mention, "flavor", I mean the appeal of the... Read More

Simple Steps to a Great Banner Ad

Everyone is using them now and if you're planning on... Read More

Getting Targeted Traffic by Standing Out In The Crowd

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

Targeted Traffic is More Important than Ever!

In the early days of web development, business owners had... Read More

Internet Marketing Basics

Almost all of the articles on Internet marketing lacks coverage... Read More

Make Your Internet Marketing Easier With Niche Marketing Keywords

If your home based business depends on niche marketing, keywords... Read More

Content, Content, Content.

Read any Internet marketing article, forum or tutorial these days... Read More

A Hitchhikers Guide to the Internet

"Where do you work?""Planet Earth."Sound familiar? No? Well, it should.... Read More

Flat Tires, Slow Leaks, and Online Marketing

Does your online marketing campaign have a flat tire? Or... Read More

Niche Web Sites Do Not Have To Be Small

I've been marketing for a long time now and I... Read More

Do Online Business Ethics Exist?

In the world of online busines something has gone wrong.... Read More

Do You Know the 3 Key Strategies to Using Lead Capture Pages?

Leads are the Life Blood of any Online Home Based... Read More

Using Back Links to Get Top Search Engine Ranking

There are no hidden secrets on how to rank high... Read More

Anatomy of an Online Marketing Failure

Wife: "I'm getting sick of these harrassing bill collectors who... Read More

Niche Marketing - How to Find Your Perfect Niche Market

If you don't find a niche market for the product... Read More

I Too Was An Internet Marketing Junkie!

I spent every waking hour at my computer, looking for... Read More

GoDaddy?s Super Bowl Commercial Success

GoDaddy made a calculated decision to nationally "brand" their name... Read More

Web Success Secret - Overdeliver

A few days back I got an email telling me... Read More

Dealing with Refund Requests ? Internet Marketing

I think we all cringe and dread when we open... Read More

List Building Through Cooperative Partnerships....

This is a little tip I got from Alex Sampson,... Read More

How To Win The Marketing War, Capture Your Prospects Mind

As a marketer you are engaged in a "War" with... Read More

Is Your Web Site Ready For Its Visitors?

There's a great interest among the Internet entrepreneurs about how... Read More

Internet Marketing Help

If you're looking for Internet marketing help you've come to... Read More

7 Incredibly Simple Ways To Profit Wildly From Public Domain Material

If you're in the business of marketing online, a major... Read More

Article Submitting: How To Study A Publisher?s Website

There are many websites that will host your articles on... Read More

Seven Ways to Generate Income From Your Website

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

How To Make Readers Desperately and Uncontrollably Wanting To Buy Your Product

Are you looking for ways of persuading your web site... Read More

10 Ways To Increase Your Ads Efeectiveness

The current climate on the internet is very unfavourable to... Read More

With Todays Internet, Is Banner Advertising Worth Your Time?

A banner exchange program is a network of websites that... Read More

The Worst Internet Marketing Strategy Ever?

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

5 Powerful Tips To Beat The Biggest Problem ALL Marketers Face

I bet you can't tell me... the single biggest problem... Read More

No Marketing, No Promoting, Huge Profits

Internet business opportunities come in many flavors and varieties. Most... Read More

Why You Need To And How To Follow Up Your Visitor Or Customer

The person who comes to your web site seeking products... Read More