Tuesdays Were Bad. Now They're Up 122%.
?>
Download eBooks and Software
 The Lotto Black Book
This Radical Approach To An Online Sales Letter Converts In The 3-5%... We've Never Seen Something Like This Since The Early Days Of 2004-2005 And I'm Sure You Haven't Either... We Convert More Than Our Competition And We Pay Out More... Try It!
How To Create An Iphone Or Ipad Apps And Games Succeed In App Store!
Discover How To Create An Iphone Or Ipad App&game And Hit Pay Dirt With It In The App Store! 60% Commission + Bonus. Awesome Member Area With Full Video Course. All You Need To Know On How To Start App Business With No Programming Skills At All!
Legit Online Jobs
Completely Redesigned For 2012! New Pricing = Higher Conversions And Lower Refunds. 24/7 Support Converts Even More Visitors Into Customers. Visit Http://www.legitonlinejobs.com/affiliates To See How Each Visitor Can Be Worth Well Over $200.
Articles > Online BusinessTuesdays Were Bad. Now They're Up 122%.
by: Richard Kraneis
Tuesdays were bad.
I just checked my sales statistics using Excel and pivot tables (more on that later). Over the first 40 weeks of this 2004, I increased sales for my “bad Tuesdays” by 122%. I used Microsoft Excel to compare the sales for my first 20 weeks over the last 20 weeks. The sales are up 122%.
Do you have a bad sales day that need’s fixing? Here’s my short advice on how to improve your bad sales day.
- Keep excellent sales data (by day, by product, by sales price).
- Analyze your sales data using Microsoft Excel’s pivot tables to understand what your worst sales day happens to be.
- Keep your sales lists and auto responder lists in excellent shape with Excel and a service named 1ShoppingCart.
- Mass email useful information and sales offers on your “bad sales day”.
#1: Keep excellent sales data (by day, by product, by sales price).
However you sell your e-book, software, or service, keep track of the data using something, preferably Excel. I currently use http://www.clickbank.com for my e-book sales and whenever I receive an email sales notice I capture the sale, process it through Excel, and add it to my Excel sales database. Here’s a non-technical translation.
ClickBank sends me an email notice of a sale. I then Edit – Copy the sales information from my email. Then I switch over into Microsoft Excel. I then Edit – Paste my sales data into Excel. Then I format my sales data in Excel so I can use it in my database. Life is good.
#2: Analyze your sales data using Microsoft Excel to understand what your worst sales day happens to be.
Even beginning Excel users have used Data – Sort in Excel to sort things and then count the results of their sorts. Unfortunately, when they count they do so manually. I don’t use that technique; I use an Excel technique called a pivot table.
Explaining a pivot table in one paragraph is too difficult. Let’s just say that Excel pivot tables are like simple databases on steroids. They sort AND THEY COUNT. Great stuff. You must learn them if you are serious about your sales. I can teach you pivot tables with a two page write-up of mine. Even if you hate math, you’ll love Excel pivot tables.
Using Microsoft Excel pivot tables I was able to sort AND COUNT my sales for all days Monday through Sunday. That’s when I discovered that Tuesday was clearly my worst corporate sales day.
#3: Keep your sales lists and auto responder lists in excellent shape with Excel and 1ShoppingCart.
All of my e-book sales are currently stored in my Excel e-book sales spreadsheet. All of my opt-in visitors (1000+ and growing after one month) are kept in a service named 1ShoppingCart. I use 1ShoppingCart for my auto responders and other services. If you are serious about using auto responders effectively (and integrating auto responders with shopping carts) I recommend you click on http://1shoppingcart.24by7success.com .
#4: Mass email useful information and sales offers on your “bad sales day”.
Point #4 is pretty interesting: Send out mass emails with useful information and sales offers on your “bad sales day”. Yesterday, on my "bad sales day", I didn’t send out any sales special. I just sent out a free PDF file with educational Excel information for my customers and visitors. The result? My readers rewarded me with even more purchases.
So to summarize, if you want to change your worst sales day into a good sales day follow this advice. First, keep excellent sales records in a Microsoft Excel spreadsheet. Second, analyze your sales data with Excel so you can identify your worst sales day. Third, keep your sales lists and auto responder lists in great shape with Excel and 1ShoppingCart. Finally, send out useful emails and sales offers on your worst sales day.
Yesterday I set a normal sales day record. It was the best normal sales day ever. Would you care to guess what day it was?
Best wishes from Chicago, IL, USA, for setting records with your “bad sales days”.
Copyright 2004 Richard Kraneis
About The Author
Richard Kraneis is a computer training consultant, e-book author, and online marketer. Online marketing on the Internet reminds him of his favorite hobby, fishing. His e-books at http://www.TheWorldsShortestExcelBook.com can help you analyze and improve your online sales. For integrating your autoresponders with your online sales, visit http://1shoppingcart.24by7success.com.
|
?>
News on Online Business
McGraw University Introduces New Online Business Degree Programs to Match Employers’ Needs
McGraw University adds in new courses to the current business curriculum in order to increase the relevance to the current job market trendsArlington, TX (PRWEB) May 25, 2012 McGraw University, an accredited leading online university that has been known around the world for its improved learning services for working adults has announced that it has introduced fresh courses in its Business and ... Raising Funds for Your Online Business: Show Me the Money!
Tax guru Barbara Weltman explains the options available for obtaining capital for your growing ecommerce business. In Part 1, she discussed the pros and cons of borrowing money (debt) vs. taking in investors (equity) - see Raising Funds for Your Online Business: Debt vs. Equity . Today, she discusses where to look for debt and equity financing and some pitfalls to avoid. A SEO package to help build your online business
What do we offer in websites that improve SEO? Our website packages allow you to feature your business with a customizable webpage built with the latest search engine optimization (SEO) tools. Through these SEO tools, as well as coupons and special deals and premium placement in your local online directory, you can maximize online traffic to your business. Online medical shopping lets users compare fees
The disparity in health-care procedure costs, combined with escalating medical spending and the increasing amount of data available online, has prompted several startups to get into the business of helping Online CRM Provider Really Simple Systems Increases Web CRM Adoption With Intelligent Data Import
LONDON, May 24, 2012 /PRNewswire/ ---Innovative data import solution increases usability and simplicity of online CRM, web CRM and  small business CRM  system-Really Simple Systems http://www.reallysimplesystems.com/ ...
|
