Tuesdays we are
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 needs fixing? Heres 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 Excels 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 accomadation
named 1ShoppingCart.
- Mass electronic mail
useful data
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 e mail sales notice I capture the sale, process it through Excel, and add it to my Excel sales database. Heres a non-technical translation.
ClickBank sends me an e-mail notice of a sale. I then Edit Copy the sales knowledge from my e-mail. 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 make use of
it in my database. Life is great.
#2: Analyze your sales data using Microsoft Excel to understand what your worst sales day happens to be.
Even initial
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 dont use that technique; I utilize an Excel technique called a pivot table.
Explaining a pivot table in one paragraph is too difficult. Lets 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 may teach you pivot tables with a two page write-up of mine. Even if you hate math, youll love Excel pivot tables.
Using Microsoft Excel pivot tables I was able to sort AND COUNT my sales for all days Monday through Sunday. Thats 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 make use of
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 understanding and sales offers on your bad sales day.
Point #4 is pretty interesting: Send out mass emails with useful understanding and sales offers on your bad sales day. Yesterday, on my "bad sales day", I didnt send out any sales special. I just sent out a costless PDF document
with educational Excel data
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 workable sales day follow this advice. First, keep excellent sales records in a Microsoft Excel spreadsheet. Second, analyze your sales data with Excel so you might
identify your worst sales day. Third, keep your sales lists and auto responder lists in grand 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.
