Excelling with Online Marketing
by Richard Kraneis
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.
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.)
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
More Website Marketing Articles
More By Developer Shed