Cellphone Intelligent Auctioning The eBay Cellphone Market Analyzer by yaoyufang

VIEWS: 5 PAGES: 17

									Cellphone Intelligent Auctioning
The eBay Cellphone Market Analyzer


        Clement Chen
        Oscar DeIta
        Michael Edwards
        Hsin-min Lu




November 29, 2005     CIA: Cellphone Intelligent Auctioning   1
Why eBay for Cell Phones?
• Avoid signing long-term contracts with
  carriers.

• Avoid paying retail prices.

• Get the latest technology from
  overseas.


November 29, 2005   CIA: Cellphone Intelligent Auctioning   2
Why CIA?
• Research the eBay market prior to
  buying or selling a phone.

• See the “Big picture”

• Gain a competitive advantage

• Turn higher profits!
November 29, 2005   CIA: Cellphone Intelligent Auctioning   3
What Does CIA Do?
• For Sellers
     – How many cellphones are on the market
     – Listing of current competitors
• For Buyers
     – Average price over a time period for a
       specific brand
     – Geographic location of cellphones up for
       bid


November 29, 2005   CIA: Cellphone Intelligent Auctioning   4
How Does CIA Work?
• Statistics

• Data Analysis

• Data Visualization

• CIA’s Technical Architecture

November 29, 2005   CIA: Cellphone Intelligent Auctioning   5
System Architecture

Standalone                                            Web Server /
                      MySql DB
Application                                          Web Application   Client’s Browser
                    Item’s Listing
    C#                                                 ASP.NET




eBay API             Yahoo API                         Google API




November 29, 2005        CIA: Cellphone Intelligent Auctioning                    6
Analysis
• Transaction Price and Quantity with respect to
    – Time
          • Identify week day effect, weekend effect, holiday effect, and
            long term trend of transaction records
    – Brand
          • Identify average transaction price for a particular brand
          • Identify the market share of different cell phone brands
    – Seller
          • Identify potential competitors, and secret of success
    – Location
          • Identify possible relation between transaction and location
• Constraint
    – No buyer information available for transactions
    – Location information is not complete
    – Time span is not long enough to identify systemic “week day
      effect” or “weekend effect”

November 29, 2005          CIA: Cellphone Intelligent Auctioning            7
Time vs. Transaction Quantity




November 29, 2005   CIA: Cellphone Intelligent Auctioning   8
Time Trend of Average Price




November 29, 2005   CIA: Cellphone Intelligent Auctioning   9
Long-Term Time Trend




        System Testing     Nov. 2
                           End of Month Effect?
November 29, 2005        CIA: Cellphone Intelligent Auctioning   10
Transaction vs. Brand
                          Average
Cellphone Brand                                Quantity      Market Value
                          Price
Motorola                        $112.48             1351         $151,960.48
Nokia                             $70.45             548          $38,606.60
Samsung                           $78.94             368          $29,049.92
PalmOne/Handspring              $199.62              127          $25,351.74
LG/Touchpoint                     $75.57             331          $25,013.67
Other                           $136.10              137          $18,645.70
Sony Ericsson                   $104.24              123          $12,821.52
Audiovox                          $76.87             122           $9,378.14

November 29, 2005    CIA: Cellphone Intelligent Auctioning                  11
Transaction vs. Seller




November 29, 2005   CIA: Cellphone Intelligent Auctioning   12
Transaction vs. Location




November 29, 2005   CIA: Cellphone Intelligent Auctioning   13
User Interface
• Web application written in ASP.NET

• Color scheme borrowed from eBay to
  create a visual association

• Anywhere in three clicks, and interface
  set up to be as simple as possible


November 29, 2005   CIA: Cellphone Intelligent Auctioning   14
APIs
• eBay
     – Category Retrieval
     – Category Listing Retrieval
     – Item Retrieval
     – Seller Retrieval
• Yahoo
     – Yahoo Maps – Geocoding API
• Google
     – Google Maps API

November 29, 2005   CIA: Cellphone Intelligent Auctioning   15
  Database
• MySql 4.1
                             Item                                            SellerList
     Category
                      PK    ItemID                                      PK,FK1    ItemID
PK   CategoryID
                                                                        PK,FK2    EBayID
                      FK1   CategoryID
     Level
                            Title
     Name
                            Description
     ParentID
                            Price
     Leaf
                            BINPrice
                            BidCount                                           eBayUser
                                                      ItemCellPhone
      Listing               HighBidder
                                                                        PK   EBayID
                            StartTime               PK,FK1     ItemID
PK,FK1    ItemID            EndTime
                                                                             SellerLevel
                            Quantity                           Brand
          Active                                                             FeedbackScore
                            QuantitySold
                                                                             PositiveFeedback
                            Location
                                                                             NegativeFeedback

• Connector/Net 1.0.7


  November 29, 2005          CIA: Cellphone Intelligent Auctioning                         16
Innovation
• Statistical analysis of aggregate
  information

• Visualization of time trends with regard
  to brand

• Geographic visualization of auction
  items

November 29, 2005   CIA: Cellphone Intelligent Auctioning   17

								
To top