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 internet marketing and the potential for it saturated? I... Read More
There is a firestorm of negative press regarding LookSmart's recent... Read More
By writing articles you can send targeted traffic to your... Read More
The following strategies are used every day to boost sales... Read More
I've got a confession to make... I have been into... Read More
I've been marketing for a long time now and I... Read More
Once you have figured out your what your focus should... Read More
Are you thinking about starting an online business? Have you... Read More
Just yesterday a colleague of mine, whom I'll call "Sandy,"... Read More
Gasp! Choke! Gag! That's how people react when you tell... Read More
More and more people are realizing that the Internet offers... Read More
If your online sales have taken a dip lately, your... Read More
Find a niche; pick a niche, niche markets will make... Read More
The other day I had an appointment to meet with... Read More
The best way I know of to multiply your online... Read More
How do you start a business on the net? Well,... Read More
Thirty years ago, I sold information via small classified ads... Read More
Do you want to join the well known gurus like... Read More
While reviewing site stats, I noticed 18 foreign countries as... Read More
If you've got a web site then one of your... Read More
Hold a discount sale on your web site. Use the... Read More
Congratulations! Your Web Site is finished! Now what? Your first... Read More
The Digital Object Identifier otherwise known as the DOI is... Read More
There are no hidden secrets on how to rank high... Read More
A Internet marketing plan provides you with a way to... Read More
Often times on message boards you'll see several reps from... Read More
And you are so proud of it. You have no... Read More
Internet has become indispensable in our lives. It has become... Read More
After years of gut wrenching work and stress the home... Read More
To market successfully you must incorporate the Internet into your... Read More
Do you want me to tell you the truth or... Read More
The number one concern for Internet sales is your marketing... Read More
As an online marketer, there are many tools available to... Read More
Yes, I admit it - I hate asking for referrals... Read More
Copyright 2005 Javier SalcesVisitor conversion is a challenge faced by... Read More
Viral Marketing and Communications, Buzz Marketing, and Word of MouthMeans... Read More
Many of us learn from the Gurus that we should... Read More
Business thrives on competition.You've to be aware of your competition... Read More
Why is profiting on the Internet so hard for most... Read More
Here I will explain precisely how to advertise effectively, including:1.... Read More
On Wednesday, the first day of June, I received the... Read More
"It's a labor of love." That's how I've always described... Read More
A joint venture is when two or more businesses join... Read More
Copyright 2005 Richard KeirIn a recent article I talked about... Read More
Everyday I talk with people who want to get started... Read More
There are many people in the world who feel stuck... Read More
Marketing would appear to be the great buzz word of... Read More
OK, you've been bustin' your butt trying to make money... Read More
We all do it I guess: give something away for... Read More
Many of you are reading this article because you would... Read More
|
|