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

---

Long Copy Secrets - Keys To Mental Engagement

Master copywriter Robert Collier often used a technique to get... Read More

Year In Review: Top Ten Internet Businesses 2004

The internet boom hit a high mark in 2004. With... Read More

Marketing - All About Focus

Marketing would appear to be the great buzz word of... Read More

Website Marketers Enemy No. 1

There comes a time in your efforts to market your... Read More

Creating Your Internet Marketing Plan

For large corporations, a marketing plan is a huge document... Read More

Networked Markets Are Democratic, Structured Markets Are Republican

Today I was checking out Michelle's A Small Victory. There... Read More

How To Write Effective Safelist Headlines

Your headline is the gateway to your advertisement. It will... Read More

Learn Judo and Beat the Summer Traffic Blues

Did it seem like as the Fourth of July fireworks... Read More

The Seven Tips That Ensure Your Success Online

Whether you are now looking for opportunities to start your... Read More

The Vital Tools To Marketing Success

Special Article Report: Theses Keys Work!Many times over the past... Read More

Online Business Success: Its All Within Your Grasp

Despite any failures or slow starts you may be experiencing... Read More

Creating Your Own Internet Marketing Product through a Home Based Business

There are thousands of marketing tool kits available online for... Read More

Be A Hot Guest

Want to make an impact with your online business in... Read More

FFA Links and Free Classified Ads Dont Work

There are many ways to initiate traffic to your website,... Read More

Online Paid Survey

Basic IdeaAround the world, companies spend over $250 billion dollars... Read More

The Rats Are Winning the Rat Race

There was this great entrepreneur who came up with a... Read More

Seven Reasons Why New Products Fail

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

Its All About The Leads: Publishing to Capture Profits

All online businesses are nothing more than lead capturing machines.... Read More

My Top 7 Favorite Ecommerce Tools

When you make your living on the Internet, you sometimes... Read More

Ive Started My Own Online Business...Now What?

People ask me this question all the time! The "Now... Read More

Internet Marketing - A Leap Of Faith

Do you remember as a child having to do something... Read More

How To Produce The PERFECT Viral Ebook

Viral marketing is probably the number one method for generating... Read More

Six Little Used Online Marketing Strategies

1. Utilize Your KnowledgeDo you have extensive knowledge in a... Read More

How To Make Money Online

Catch the cash on the net?in more ways than one.Thousands... Read More

Offline Marketing for Online Home Based Businesses

When it comes to marketing your web site, most home... Read More

Making Your Money Work For You ? And Not The Other Way Around!

Most people spend their entire lives working hard for someone... Read More

Catapult Your Marketing Success With Joint Ventures

There are many ways to make money on the internet.... Read More

The 2 Best-Kept Secrets Of The Internet

It's a difficult task creating a website that brings you... Read More

10 Killer Ways To Multiply Your Sales

1. When you make your first sale, follow-up with the... Read More

Beginner?s Guide To Free For All Sites (FFAs)

For those of you who don't know what an FFA... Read More

The Easy Days

The easy days are gone when you could build your... Read More

FSBO Upscale Manhattan Co-op -- Only Strongest Offers Entertained

Had I known in 1985 what I know now about... Read More

The Most Profitable Product In The World You Can Ever Sell!

Thank goodness, the most profitable product in the world you... Read More