Quick Audience:Order Summary Data Requirements - Quick Audience

This topic describes the data requirements that you need to import to order summary tables in 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 summary table records order data aggregated by user granularity for nearly N days. Example of MaxCompute large-width representation:

4765

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, push, etc. user_id is the primary key of the table and is required. Set other user IDs based on your business requirements. 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.
Last trading time in last N days	Time	Required field.
Total amount of transactions in recent N days	Numeric types
The number of transactions in the last N days.	Numeric types
Other order attributes	Text, numeric, and time	Optional. Set this parameter based on your business requirements.

Note

You can customize the names of all fields.
user_id is the primary key of the table. Each user_id has only one record.
partition table is not supported.