Do you want to contruct a successful online business?

Then beginning using online math and utilize Microsoft Excel.

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

Are you building 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 item 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 build an e-book sale I add it to my Excel sales database. I click on an Excel macro button that automatically re-formats my e-mail sales notification into a record in my e-book sales Excel database.

Over the past year Ive 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 marketing mix to better spend my branding dollars.

3) Finally, men purchase about 70% of my e-books. Women purchase 20% and 10% of purchases are from unknown genders (many people that make use of initials only). Solution? None yet. Women just arent buying my e-book as much as Id like. But if I find a workable copywriter who needs to learn more about Excel Im in business. We might 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 effective tool for tracking not only online advertising profits but all kinds of online selling performance. Build a simple spreadsheet for tracking your weekly profits and then advance to other techniques for measuring online selling performance.

So, thats it for today. I understand that Im just a first year online marketer and have much to learn. But, Im Excelling with Online Marketing and you should too.