注册一亩三分地论坛,查看更多干货!
您需要 登录 才可以下载或查看附件。没有帐号?注册账号 
x
Description
Circle is one of the top US Apps for people to buy and sell second-hand products (just like Marketplace). On the platform, if you are interested in a product, you could click ‘send message’ to sellers. One message sent could be counted as one listing interaction (LI).
Programming
/* Brief info
Table Name: listing_interaction
+------------------+-------------+---------------------------------------+
| column | data_type | description |
+------------------+-------------+---------------------------------------+
| buyer_id | BIGINT | ID of person who wanted to buy |
| seller_id | BIGINT | ID of person who created listings |
| date | STRING | Date of the MLI |
| product_id | BIGINT | Each product has a unique ID |. From 1point 3acres bbs
| li | BIGINT | Total Listing interaction between buyer& seller |
+-----------------+---------------+---------------------------------------+
SAMPLE ROWS
buyer_id | seller_id | date | product_id | li
123 | 456 | 2019-01-01 | 4325 | 7
032 | 789 | 2019-01-01 | 9395 | 3
456 | 032 | 2019-01-01 | 0879 | 1
*/. From 1point 3acres bbs
/* Brief info
Table Name: dim_all_product
+-----------------+---------------+---------------------------------------+
| column | data_type | description |
+-----------------+---------------+---------------------------------------+
. | product_id | BIGINT | Unique ID of product |
| category | BIGINT | the category the product belongs to. I.e. Vehicles / Home |
| create_date | STRING | date the seller create the product listing |
| country | STRING | predicted country of the listing |
+-----------------+---------------+---------------------------------------+
SAMPLE ROWS
product_id | category | date | create_date | country
123 | Vehicle | 2019-01-01 | 2018-12-21 | US
032 | Home | 2019-01-01 | 2018-11-01 | CA
456 | Housing | 2019-01-01 | 2018-12-15 | UK
*/.1point3acres
|