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

In The News:


pen paper and inkwell


cat break through


The Center of Your Internet Business, You

As an Internet entrepreneur your ultimate goal is most certainly... Read More

9 Great Reasons To Help An Internet Marketing Newbie

Zig Ziglar the famous self help guru was once quoted... Read More

Marketing Automation For Small Businesses And Web Entrepreneurs

Many Internet marketers wonder how they spend less time marketing... Read More

How to Choose an Internet Marketing Company

-- Internet Marketing Determines Web Success --Internet marketing is essential... Read More

Why Offline Advertising is So Important for Websites

It is important that anybody with a significant online presence... Read More

Why Have An Internet Marketing Business?

"The Internet Gold Rush is under way" Bill Gates, chairman... Read More

Internet Marketing Help

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

Online Network Marketing 101A - Basic Must Steps to Follow to be a Successful Marketer

This guide is for people who know what network marketing... Read More

Website Promotion With Content Exchanges

Ever hear about an idea that is so simple yet... Read More

Web Marketing: Unusual Tricks Of Internet Marketing Gurus To Attract More Visibility

Do you post to message boards, e-mail discussion lists, classified... Read More

Online Sales: 10 Mind Boggling, Electrifying Tricks To Ignite Your Sales

Do you want to unleash a tsunami of sales at... Read More

4 Ways to Make Money from People Who Are LEAVING Your Site!

Oh no... are people leaving your site without buying?Get used... Read More

Enough With the Upsells Already!

It happened twice during the same week. All I wanted... Read More

The Wisdom Of Giving Away Something For Nothing

If you're new to Internet Business, this might be hard... Read More

To Survey Or Not To Survey

I have learned over the years that when it comes... Read More

Holiday / Vacation Time But What About Your Online Business?

For many of us, it is time to start thinking... Read More

How to Leverage the Internet in MLM

Most people who try to leverage the Internet to build... Read More

Viral Marketing! Are You Missing Out?

Many of you are reading this article because you would... Read More

Making Money from Websites - Common Pitfalls of Beginners and How to Avoid Them

Making money online is really easy to do because the... Read More

Internet Marketing for Dummies!

There are many people every day jumping into the online... Read More

Income Producing Tasks and The Fluff!

Think about everything you can do in your business that... Read More

Now, Even A Monkey Could Easily Accept Online Payments

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

10 Sure-Fire Viral Marketing Strategies To Increase Traffic To Your Website

"Viral Marketing" is giving something away for free and allowing... Read More

Viral Marketing - Use This Free Reminder Service to Go Viral

The busier you are the harder it is to remember... Read More

New Medium, New Rules

Life is thought to have begun on Earth somewhere around... Read More

Dont Tell Me What I Cant Do!

Have you ever watched ABC's hit TV show Lost? My... Read More

How to Make Money Online...Driving your Car.

Here's an alluring income generating strategy, that's widely adopted by... Read More

Strategic Internet Marketing Is Planning

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

3 Services Your Online Business Cant Live Without

It doesn't make any difference if you're promoting your own... Read More

You Gotta Think -- Strategic Internet Marketing!

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

What a Billionaire Balloonist Taught Me About Internet Marketing

Billionaire Richard Branson, the entrepreneur behind the Virgin brand, is... Read More

A World Outside The US

With the exception of myself and a small handful of... Read More

Niche Marketing and Finding Your Way to Profits

If you haven't heard the word 'niche' being batted around... Read More