e-Commerce Transactions on Jabong.com in April 2015

Sameer Mathur

Data Summary and Visualization

  • An Indian fashion and lifestyle e-commerce portal.

  • Sells apparel, footwear, fashion accessories, beauty products, fragrances, home accessories and other fashion and lifestyle products.

  • Lists over 1000 brands and over 90,000 products.

Data

Dates

  • This data consists of transactions that took place on Jabong.com in April 2015

  • 1-Apr-2015 to 30-Apr-2015

Total Transactions

dim(JabCod.dt)

[1] 448938     45
  • 448938 transactions

Number of Unique Customers

length(unique(JabCod.dt$CustomerID))

[1] 214670
  • 214670 unique Customer ID's

45 Data Columns

colnames(JabCod.dt)

 [1] "OrderItemCode"        "OrderID"              "ReversePickupCode"   
 [4] "OrderDate"            "Weekend"              "Category"            
 [7] "SubCategory"          "Brand"                "MRP"                 
[10] "VendorDiscount"       "WebsiteDiscount"      "FinalTotalPrice"     
[13] "ProductColor"         "ProductSize"          "VATPercent"          
[16] "VAT"                  "CODCharge"            "VendorDiscountAmt"   
[19] "WebsiteDiscountCode"  "WebsiteDiscountAmt"   "CustomerID"          
[22] "COD"                  "ShippingName"         "ShippingCity"        
[25] "ShippingState"        "Metro"                "ShippingPincode"     
[28] "ShippingAddressType"  "ShippingAddressPhone" "BillingName"         
[31] "BillingCity"          "BillingState"         "BillingPincode"      
[34] "BillingAddressType"   "ItemSKUCode"          "VoucherCode"         
[37] "SaleOrderStatus"      "SaleOrderItemStatus"  "ShippingProvider"    
[40] "Dispatch Date"        "ReturnDate"           "ReceiveDate"         
[43] "BundlesDiscount"      "Payment Gateway"      "ActualPayment_Mode"

Customer-related Data Columns



  • CustomerID (unique)

  • ShippingName

  • ShippingCity

  • ShippingState

  • ShippingPincode

  • COD (paid using Cash or Card)



  • ShippingAddressType

  • BillingCity

  • BillingState

  • BillingPincode

  • BillingAddressType

Transaction-related Data Columns

  • OrderItemCode

  • OrderID

  • OrderDate

Product-related Data Columns


  • Category (e.g. Apparels)

  • SubCategory (e.g. Sarees)

  • Brand (e.g. Mohini)

  • (ProductColor , ProductSize if relevant)

Price-related Data Columns


  • MRP (Maximum Retail Price, INR)

  • FinalTotalPrice (Price paid by the customer, inclusive of everything)

  • VAT (a tax)

  • VATPercent (the tax rate)

  • CODCharge (some COD transactions had an extra charge)

Discounts on Jabong

There were two types of periodic discounts.

  • Website Discounts: This refers to discounts offered by the website (i.e. Jabong)

  • Vendor Discounts: 3rd-party vendors sell using the Jabong platform website. Vendor Discounts refer to periodic discounts offered by individual 3rd-party vendors.

  • One or both types of discounts were on periodically on offer.

Promotion-related Data Columns

  • WebsiteDiscount (Yes/No)

  • WebsiteDiscountAmt (in INR)

  • WebsiteDiscountCode Some discounts had a Code associated with them.

Promotion-related Data Columns

  • VendorDiscount (Yes/No)

  • VendorDiscountAmt (in INR)

Other Columns


  • SaleOrderStatus

  • SaleOrderItemStatus

  • ShippingProvider

  • Dispatch Date

  • ReturnDate

  • ReceiveDate


  • BundlesDiscount

  • Payment Gateway

  • ActualPayment_Mode

Summary

9 Categories

[1] "Apparels"      "Footwear"      "Bags"          "Home"         
[5] "Jewellery"     "Accessories"   "Beauty"        "Fragrances"   
[9] "ACTIVE SPORTS"

Transactions across Categories

Transaction Counts


  Accessories ACTIVE SPORTS      Apparels          Bags        Beauty 
         3773            19        391626         12255          8595 
     Footwear    Fragrances          Home     Jewellery 
        15943           799          6036          9892

Transaction Proportions


  Accessories ACTIVE SPORTS      Apparels          Bags        Beauty 
         0.84          0.00         87.23          2.73          1.91 
     Footwear    Fragrances          Home     Jewellery 
         3.55          0.18          1.34          2.20
  • Apparels represented most (87.23%) transactions

Subcategories

  • The 9 Categories had 409 SubCategories
[1] 409

[1] "POLO T-SHIRTS"       "ROUND NECK T-SHIRTS" "KURTAS"             
[4] "ANARKALI"            "TOPS"                "SHIRTS"
  • The 9 Categories included 1034 Brands
[1] 1034

[1] "GRITSTONES"        "FREECULTR EXPRESS" "AKS"              
[4] "MEIRA"             "FABALLEY"          "DELIZE"

Summary


  • 448,939 Jabong transactions from April 2015

  • 214,670 unique customers

  • 9 Categories (Apparels represent 87.1%)

  • 409 Subcatgories; 1034 Brands (long-tail)

  • Pricing: MRP, FinalTotalPrice

  • Promotions: Website / Vendor discounts

  • Payment Method (COD / Electronic)

  • Location (Billing / Shipping info)