Neusoft cross border e-commerce warehouse demand specification document

1. Project background

Name of the project ： Neusoft cross border e-commerce warehouse

Proposer of the project ： Team members

developer ： Big data experimental class of Northeastern University （ Ma classmate ）

user ： Enterprise operators

Neusoft's cross-border e-commerce project is a real application case of Neusoft's cross-border e-commerce industry .

The platform , Front end development involves user modules 、 Commodity module ( contain SKU And SPU management )、 The shopping cart 、 Address module, order module and other modules , Realized the home page , Product search and category view , Goods details , Shopping cart and personal center functions and other interfaces , Realize electronic payment , Alibaba cloud deployment .

And the construction of data warehouse , For analytical equipment 、 members 、 goods 、 region 、 Activities and other core themes of e-commerce , By analyzing the data in the data warehouse , It can help enterprises improve their business processes 、 Control the cost 、 Improve product quality, etc .

2. Project objectives

We mainly conduct statistical analysis on users' online behavior data and business operation behavior , Establish a complete system from data collection to result display , To support the business operation of the company to improve the business conversion rate , Improve the operation effect of the company .

3. Project requirements

3.1 Data acquisition platform

3.1.1 Build a user behavior data collection platform

3.1.2 Establishment of business data collection platform

3.2 Data warehouse building （ Dimensional modeling ）

3.3 Report system

3.3.1 Traffic theme

Flow statistics of each channel ： Visitor statistics , The average length of the session , Average number of pages viewed in a session

User path analysis

3.3.2 User themes

User changes ： Statistics of lost users , Statistics of the number of reflux users

User retention rate

Users add active statistics

User behavior funnel analysis

New transaction user statistics ： New orders , Number of new payers

3.3.3 Commodity theme

lately 7/30 Daily repurchase rate of each brand

Statistics of commodity transactions of various brands

Transaction statistics of various categories of commodities

Inventory of shopping carts by category Top10

3.3.4 Transaction subject

Comprehensive transaction statistics

Transaction statistics of each province

3.4 Ad hoc query function

3.5 Metadata management