Excelling With Online Marketing -

Home
>
Internet Marketing
>
Excelling With Online Marketing

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.

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:

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.marketwatch.com/news/story/Extra-Cash-Holidays-Anytime-With/story.aspx%3Fguid%3D%257B1A073D42-6DC3-45F6-BD71-7DC25C63DC4B%257Dcid=1276911817ei=tKo1SYHWC466M8aKtSUusg=AFQjCNE7XWew2JwrAWZnMduqhRVYf_u7XAExtra Cash for the Holidays or Anytime With the Launch of Diamonds b.../b/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr5 hours ago/nobr/fontbrfont size=-1Bayshore Solutions integrates technology and bInternet marketing/b services to ensure measurable results for clients. For more information about Web site b.../b/fontbrfont size=-1a href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.tmcnet.com/usubmit/-businesses-thrive-amidst-recession-thanks-live-help-/2008/12/02/3827313.htmcid=1276911817ei=tKo1SYHWC466M8aKtSUusg=AFQjCNGLBBxJhezcYROinKarWqwrxytq5gBusinesses Thrive Amidst a Recession Thanks to Live Help/a font size=-1 color=#6f6f6fnobrTMCnet/nobr/font/fontbrfont size=-1a href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.ibtimes.com/prnews/20081202/bayshore-solutions.htmcid=1276911817ei=tKo1SYHWC466M8aKtSUusg=AFQjCNH2fesbEM81pJz6_AlZkqmRQr2XugExtra Cash for the Holidays or Anytime With the Launch of Diamonds b.../b/a font size=-1 color=#6f6f6fnobrInternational Business Times/nobr/font/fontbrfont class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1276911817hl=ennobrall 11 news articles/nobr/a/font/div/font/td/tr/table

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.necn.com/Boston/Business/2008/12/01/Web-tips-Making-a-big-deal/1228137820.htmlcid=1273809014ei=tKo1SYHWC466M8aKtSUusg=AFQjCNFhS_wbQ_-HmJTLYJc5fLwSe91Q4wimg src=http://news.google.com/news?imgefp=eOzJ2P5_PBAJimgurl=www.necn.com/files/2008/12/01/120108_webted_730a.jpg width=80 height=60 alt= border=1brfont size=-2NECN/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.marketwatch.com/news/story/Consumers-Benefit-a-Frenzy-Around/story.aspx%3Fguid%3D%257B3EA6E82C-6D99-450C-B19E-D86692E11361%257Dcid=1273809014ei=tKo1SYHWC466M8aKtSUusg=AFQjCNG2kFKSFsvZs9oCxzsd0crt_3rRKgConsumers Benefit from a Frenzy of Around-the-Clock Online Shopping/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr21 hours ago/nobr/fontbrfont size=-1Additionally, Bath and Body Works added social networking to their bmarketing/b efforts by offering their first online friends and family promotion. b.../b/fontbrfont size=-1a href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.youtube.com/watch%3Fv%3D-0iz1s7QEc4cid=1273809014ei=tKo1SYHWC466M8aKtSUusg=AFQjCNFNrrk77LAFAm1kBAqzOlLOyHxGiwVideo: Online Retailers See Monday As Black Friday/a font size=-1 color=#6f6f6fnobrAssociatedPress/nobr/fontobject width=448 height=356param name=movie value=http://www.youtube.com/v/-0iz1s7QEc4/paramparam name=wmode value=transparent/paramembed src=http://www.youtube.com/v/-0iz1s7QEc4type=application/x-shockwave-flashwmode=transparentwidth=448height=356/embed/objectbr/fontfont size=-1a href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://online.wsj.com/article/SB122817819658170827.html%3Fmod%3Dgooglenews_wsjcid=1273809014ei=tKo1SYHWC466M8aKtSUusg=AFQjCNE9U3zBH3FMFHTi3vSodCPHqoW-iQOnline Retailers Dangle Free Shipping, Discounts/a font size=-1 color=#6f6f6fnobrWall Street Journal/nobr/font/fontbrfont size=-1a href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.ajc.com/services/content/printedition/2008/12/02/cybermonday.htmlcid=1273809014ei=tKo1SYHWC466M8aKtSUusg=AFQjCNFWaooI4yUDIqc577TNm1Tk5CQEtgbINTERNET/b SHOPPING: ‘Cyber Monday’ drives seasonal employment/a font size=-1 color=#6f6f6fnobrAtlanta Journal Constitution/nobr/font/fontbrfont size=-1 class=pa href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://time.com/time/business/article/0,8599,1862938,00.html%3Fimw%3DYcid=1273809014ei=tKo1SYHWC466M8aKtSUusg=AFQjCNGhTsW5BJDPVLcvHXxdsI61jFIW6wnobrTIME/nobr/anbsp;- a href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.mercurynews.com/ci_11115641cid=1273809014ei=tKo1SYHWC466M8aKtSUusg=AFQjCNGmAzCjiX_NsFDqHaZxxbFpIRPUbAnobrSan Jose Mercury News/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1273809014hl=ennobrall 1,279 news articles/nobr/a/font/div/font/td/tr/table

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.clickthrough-marketing.com/PPC-internet-marketing-growth-due-to-reliability,-says-eMarketer/18907861/cid=1276662413ei=tKo1SYHWC466M8aKtSUusg=AFQjCNFbniw9Nfi8QBVIENq9JdXzbIsVeAimg src=http://news.google.com/news?imgefp=d0Wh4iVfSh0Jimgurl=www.clickthrough-marketing.com/clicknews/ai/Laptop_920_18907861_0_0_6000056_300.jpg width=80 height=80 alt= border=1brfont size=-2Internet Marketing News/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.clickthrough-marketing.com/PPC-internet-marketing-growth-due-to-reliability,-says-eMarketer/18907861/cid=1276662413ei=tKo1SYHWC466M8aKtSUusg=AFQjCNFbniw9Nfi8QBVIENq9JdXzbIsVeAPPC binternet marketing/b growth due to reliability, says eMarketer/abrfont size=-1font color=#6f6f6fInternet Marketing News,nbsp;UKnbsp;-/font nobr3 hours ago/nobr/fontbrfont size=-1b.../b advertising in the first half the year, up 28 per cent compared with the same period in 2007, according to figures from the bInternet/b Advertising Bureau./fontbrfont size=-1a href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://blogs.reuters.com/mediafile/2008/12/01/online-ad-spending-outlook-lowered-by-13-billion/cid=1276662413ei=tKo1SYHWC466M8aKtSUusg=AFQjCNFZOhLiLFl1L8nat_a1Fy4_43gIQwOnline ad spending outlook lowered by $1.3 billion/a font size=-1 color=#6f6f6fnobrReuters/nobr/font/fontbrfont size=-1a href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.btobonline.com/apps/pbcs.dll/article%3FAID%3D/20081202/FREE/812029995/1078cid=1276662413ei=tKo1SYHWC466M8aKtSUusg=AFQjCNEFh8Nk9PFH_KfdsGOAaNszC3HekwEMarketer lowers online ad spending productions/a font size=-1 color=#6f6f6fnobrBtoB Magazine/nobr/font/fontbrfont size=-1a href=http://www.citywebshopper.net/articles/includes/redirect.php?url=http://www.digitalresponsemedia.com/news-3-search-engine-marketing-news/lower-online-ad-forecast-sees-ppc-still-showing-high-gr-465.aspxcid=1276662413ei=tKo1SYHWC466M8aKtSUusg=AFQjCNGsnO1z5CwAhMGwa6mTA6b29qoISALower online ad forecast sees PPC still showing high growth/a font size=-1 color=#6f6f6fnobrDigital Response Media/nobr/font/fontbrfont class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1276662413hl=ennobrall 7 news articles/nobr/a/font/div/font/td/tr/table

internet marketing - Google News