Bills are the core data of e-commerce companies and the outcome of a series of marketing and promotional activities. This data contains a lot of valuable information, based on which you can define the user profiles, providing guidelines for future marketing plans. Billing data can also serve as a popularity indicator, providing suggestions for subsequent stocking options.
Billing information are stored as logs in Alibaba Cloud Log Service. Log Service guarantees high-speed queries and SQL statistics, with a computing capability of hundreds of millions of log entries per second. This document explains to mine useful information.
A complete bill containing goods information (the name and price), deal information (final price, payment method, and discount information), and the buyer’s information (membership information) is shown as follows:
__source__: 22.214.171.124 __topic__: bonus_discount: category: men's clothing commodity: ***************** commodity_id: 443 discount: member_discount: member_level: nomember_point: memberid: mobile: pay_transaction_id: 060f0e0d080e0b05060307010c0f0209010e0e010c0a0605000606050b0c0400 pay_with: alipay real_price: 52.0 suggest_price: 52.0
Determine the hot categories.
*|select count(1) as pv ,category group by category limit 100
Determine the hot women’s clothing categories.
category: women's clothing/ladies’ collection | select count(1) as deals , commodity
group by commodity order by deals desc limit 20
Share and turnover: Alipay versus WeChat.
* | select count(1) as deals , pay_with group by pay_with order by deals desc limit 20
* | select sum(real_price) as total_money , pay_with
group by pay_with order by total_money desc limit 20