What are the data requirements for importing order details from QuickAudience - Quick Audience

This topic describes the data requirements for order details to be imported to Quick Audience.

Note

Due to the fact that the Data Source type for storing raw data is MaxCompute, and the Analysis Source type used by Quick Audience is ADB 3.0 or Hologres, in order for data to flow smoothly between the computing and analysis sources, Quick Audience does not support the following data types of MaxCompute: BOOLEAN、CHAR、ARRAY、STRUCT、MAP、BINARY. Please refer to the 2.0 Data Type Version for the MaxCompute data type list.

The order details table records the status, commodity, amount, and other related information of the order. MaxCompute large width representation example:

Field requirements:

Field Type	Field type	Description
The ID of the user who executes the statement.	Text	The user ID can be used for marketing and pushing. Set at least one user ID based on your business needs. You can use all the ID types that are enabled in ID Type Management. You can store only one field of the same ID type. You can save the original user ID or the encrypted user ID. The encryption method supports MD5, SHA256, and AES. Except for the Taobao OUID, the Taobao OUID has been encrypted in a unique way when it is provided to the outside by Taobao. Please keep it as it is. For more information about the ID types and encryption methods supported by each marketing and push channel, see ID Types and Encryption Methods Supported by Each Channel. If you use a user ID of the mobile phone number type, make sure that the mobile phone number format is 11 digits and 86 is not added before the number. Otherwise, it cannot be used for SMS marketing.
The ID of the order.	Text type, numeric type	Required field. The order status also represents the user's behavior in order events, such as (already) placed, (already) paid, (already) completed, (already) canceled, and (already) refunded. You can set multiple fields for order time, which are used to correspond to various order statuses, such as order time, payment time, completion time, cancellation time, and refund time.
Actual payment amount	Numeric types
Order Time	Time
Order Source	Text
The order status.	Text
The item ID.	Text type, numeric type
Product Name	Text
Number of Purchased Pieces	Numeric types
Actual amount paid for goods	Numeric types
Total Order Amount	Numeric types	Optional. Set this parameter based on your business requirements.
Other order attributes	Text, numeric, and time
Category name	Text
Commodity unit price	Numeric types
Total Commodity	Numeric types
Other product attributes	Text, numeric, and time

Note

You can customize the names of all fields.
The table does not have a primary key. When an order contains multiple products or the order status changes, the same order number can have multiple records. If any of the conditions in the order number, order status, and product ID is different, a separate line is required.
Support partition table.