Online Business Help

  Homes arrow Online Business Help arrow Tuesdays were bad. Now they're up 122%
 Webmaster Tools
 
Base64 Encoding 
Browser Settings 
CSS Coder 
CSS Navigation Menu 
Datetime Converter 
DHTML Tooltip 
Dig Utility 
DNS Utility 
Dropdown Menu 
Fetch Content 
Fetch Header 
Floating Layer 
htaccess Generator 
HTML to PHP 
HTML Encoder 
HTML Entities 
IP Convert 
Meta Tags 
Password Encryption
 
Password Strength
 
Pattern Extractor 
Ping Utility 
Pop-Up Window 
Regex Extractor 
Regex Match 
Scrollbar Color 
Source Viewer 
Syntax Highlighting 
URL Encoding 
Web Safe Colors 
Forums Sitemap 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
ONLINE BUSINESS HELP

Tuesdays were bad. Now they're up 122%
By: Developer Shed
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating:  stars stars stars stars stars / 0
    2004-10-08

    Table of Contents:

    Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     

    SEARCH DEV MECHANIC

    TOOLS YOU CAN USE

    advertisement

    Tuesdays 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.

    1) Keep excellent sales data (by day, by product, by sales price).
    2) Analyze your sales data using Microsoft Excel’s pivot tables to understand what your worst sales day happens to be.
    3) Keep your sales lists and auto responder lists in excellent shape with Excel and a service named 1ShoppingCart.
    4) 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”.


    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 great autoresponders, visit http://1shoppingcart.24by7success.com . Contact Rich at rkraneis@techspectrum.com .
    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 Online Business Help Articles
    More By Developer Shed

       

    ONLINE BUSINESS HELP ARTICLES

    - Social Media: An Analogy
    - Make a Digital Trail for Site Performance
    - Communication is Key Even in SEO
    - Look Past Your Web Analytics Blinders
    - Everything is Marketing
    - How to Be Transparent Online
    - Respecting Customer Privacy in Social Media
    - Testing Your Site For the Holidays
    - Speak Your Customer`s Language
    - Don`t Ignore Social Media
    - Focus on Business Goals, Not the Internet
    - Solve Problems to Make Money Online
    - Offering Coupons Without Alienating Customers
    - Build Relationships to Build Conversions
    - Online Reviews Matter More Than You Think

    Developer Shed Affiliates

     



    © 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap