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

---

Is Your Web Site Ready For Its Visitors?

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

Do?s and Don?ts for the Internet Marketing Newbie (Part 1)

I, myself, being an internet marketing "newbie" (endearing term used... Read More

Profiting From the Online Business: Tips to Boost Your Sales

Creating a lucrative online business is not an easy task.... Read More

Internet Marketing - A Leap Of Faith

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

How To Make Money Online

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

How To Use Pop-Ups Effectively To Generate More Profits!

What I'm about to explain to you will change to... Read More

To All Internet Marketers - How To Get My Business

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

Dont Baffle Me - Talk to Me

Congratulations, all you Internet marketing people you. You now command... Read More

At Last, A Plain English Guide to Internet Marketing

Have you ever been horrified and intimidated at the convoluted,... Read More

Internet Marketing And Public Speaking: Ten Tips For When The Twain Shall Meet

Internet marketing and public speaking? Not quite ham and eggs,... Read More

Dramatically Boost Your Exposure With A Press Release

Do you have a website but seem puzzled to how... Read More

6 Ways to Guarantee Your Website Will Fail (and how to fix them)

1. Your website is an electronic brochure 2. Can't be... Read More

Internet Profits Revealed: The Simple Philosophy that Works

Why is profiting on the Internet so hard for most... Read More

New Form of Click Fraud Discovered

If you use PPC advertising and are in a highly... Read More

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

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

Marketing Your Web Site

Congratulations! Your Web Site is finished! Now what? Your first... Read More

Strategic Internet Marketing Is Planning

Strategic Internet marketing is a way to define your potential... Read More

The Forbidden Fruit: Marketing Credit Cards Online

A common question and topic of discussion among Internet marketers... Read More

Wealth Is Around The Corner

There are so many simple and achievable ways to make... Read More

Internet Marketing

Is internet marketing something for you? Do you dream about... Read More

Start a Fire Sale! Give Your Faithful Clients Bonuses!

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

Internet Marketing - The Two Faces of FREE

'FREE' is the reason people are successful, and make a... Read More

How You Can Acquire Exclusive Rights To Products; Part 1 of 2

If you have a marketing business, chances are you get... Read More

9 Secrets to Kick Your Internet Marketing Efforts into Overdrive

Let's face it, most of us know the basics of... Read More

Advertising That Yields the Best Results

In today's world, online advertising is KEY to the success... Read More

Get Permission to Earn Income Online for Life

Today, the internet is an excellent media to reach out... Read More

Internet Marketing Success Requires a Business Plan (Part II)

Formal business planning is a process that takes that "great... Read More

When is Spying on Your Competition a Complete Waste of Time?

Your brain screams "Gimme Fast", "Gimme Easy", "Do it for... Read More

10 Marketing Tips for Entrepreneurs

Nothing happens in business until a sale is made. Marketing... Read More

Boost Your Web Site Sales

The following strategies are used every day to boost sales... Read More

Online Marketing Success Formulas?

Quit your job, pack up and restart your life online.... Read More

Now, Even A Monkey Could Easily Accept Online Payments

I just came across this web site called PayDotCom.comAfter reviewing... Read More

The Worst Internet Marketing Strategy Ever?

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