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.)
Latest News
Nationwide Credit Card Processing Provider, BankCard USA, Engages ... MarketWatch - "Internet marketing is a large source of revenue for many businesses today," notes Alan Griefer, President of BankCard USA. "Click-fraud is more prevalent ... |
Reply.com Launches World's First Marketplace for Enhanced Clicks(TM) MarketWatch - "We are on a mission to make Internet marketing available to businesses of any size by making it easy and profitable to generated locally-targeted and ... |
Tripology Appoints Internet Marketing and Lead Gen Expert to Board ... PR Web (press release), WA - "His success as an entrepreneur and innovator in the field of online lead generation and internet marketing means he's done this before. ... |
 ABC News | Retailers rejoice: Cyber Monday sales figures rise Los Angeles Times, CA - "All online retailers are doing much more aggressive marketing," said Bernard Luthi, vice president of marketing and merchandising at Newegg, which offered ... Video: Online Retailers See Monday As Black Friday Consumers Benefit from a Frenzy of Around-the-Clock Online Shopping Online Retailers Dangle Free Shipping, Discounts |
Business road warrior opts for Internet marketing to keep family first DeSoto Appeal, TN - Around late April, Stephenson launched an Internet marketing company. Memphis Sudden Values could be coming to an inbox near you. "What I do is help local, ... |
Pontiflex Launches ROI Calculator, Enables Marketers to Easily ... MarketWatch - The calculator empowers online marketers and advertising agencies to proactively assess returns on their marketing dollars. This is useful especially in a ... |
As a Busy Mum of Three, Daniele Launched Her Successful Internet ... PR Web (press release), WA - Daniele started her Business following the Internet Marketing techniques taught in a course. Working from home on an Internet-based business is ideal when ... |
Zeer Announces Formation of Advisory Board MarketWatch - He has spent the bulk of his career in strategic marketing and consulting roles, and has been involved in Internet strategy since the early 1990s. ... |
 Internet Marketing News | Is the internet marketing future mobile? Business Feet, UK - Internet marketing gurus may have to learn how to make their adverts miniature in future, if the latest trends are anything to go by. ... 'Now is the time to address mobile online marketing' |
Social Networking Site Helps Effectively and Easily Build Blogs ... PR Web (press release), WA - Internet marketing through blogs has spread gradually over the years. The relaunch of professional blog hosting and social networking site for internet ... |
Resources
-
Power Profit Marketing
Empowering The Internet Marketing Community With Great Marketing Tools, Manuals & Software
-
35 Products For One LOW Price!
Get 35 Internet Marketing Products For The Price Of One!
-
Make money on the Internet
How to make money on the Internet through Internet Marketing and work from home
-
The Internet Marketing Master Plan!
How To Turn Your Passion or Hobby Into a $100,000 a Year Money Machine on the Internet.
-
The Truth About Internet Marketing.
Discover the astonishing whole truth and nothing but the truth about Internet Marketing!
-
NEW -- Marketing, Internet Marketing, email Marketing, Marketing plan, direct
Marketing, joint vent
Offers Marketing tools, tips, strategies and techniques for Internet, email, direct and joint venture Marketing.
-
The Esuccess Code - A Step By Step Guide.
Newest, Hottest, Most Cutting-Edge Internet Marketing Strategies You Can Use To Earn A Fortune With Little Or No Effort.
-
Internet Business Marketing - Sen Ze's Mini-Encyclopedia Of Low-Cost, High-Profit Internet Business
Discover 19 Top Internet Businesses as practised by Top Internet Marketers and Internet Entrepreneurs from around the world.
-
Internet Marketing - Pro Shop.
Internet Marketing.
-
Web Site Design and Development
Web site design, development, and promotion guide for business and Internet Marketing web sites.