Cellphone Intelligent Auctioning The eBay Cellphone Market Analyzer

1
Cellphone Intelligent AuctioningThe eBay
Cellphone Market Analyzer

• Clement Chen
• Oscar DeIta
• Michael Edwards
• Hsin-min Lu

2
Why eBay for Cell Phones?

• Avoid signing long-term contracts with carriers.
• Avoid paying retail prices.
• Get the latest technology from overseas.

3
Why CIA?

• Research the eBay market prior to buying or
  selling a phone.
• See the Big picture
• Gain a competitive advantage
• Turn higher profits!

4
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

5
How Does CIA Work?

• Statistics
• Data Analysis
• Data Visualization
• CIAs Technical Architecture

6
System Architecture
7
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

8
Time vs. Transaction Quantity
9
Time Trend of Average Price
10
Long-Term Time Trend
System Testing
Nov. 2 End of Month Effect?
11
Transaction vs. Brand
12
Transaction vs. Seller
13
Transaction vs. Location
14
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

15
APIs

• eBay
• Category Retrieval
• Category Listing Retrieval
• Item Retrieval
• Seller Retrieval
• Yahoo
• Yahoo Maps Geocoding API
• Google
• Google Maps API

16
Database

• MySql 4.1
• Connector/Net 1.0.7

17
Innovation

• Statistical analysis of aggregate information
• Visualization of time trends with regard to brand
• Geographic visualization of auction items