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

Order summary tables that you import into Quick Audience must meet specific data type and field requirements.

Note

Because the MaxCompute data source type for storing raw data is MaxCompute and the Analysis Source type used by Quick Audience is ADB 3.0 or Hologres, Quick Audience does not support the following MaxCompute data types: BOOLEAN, CHAR, ARRAY, STRUCT, MAP, and BINARY. For the complete MaxCompute data type list, see 2.0 Data Type Version.

The order summary table records order data aggregated at the user level over the last N days. The following figure shows an example of a MaxCompute wide table:

4765

Field requirements:

Field Type	Field type	Description
User ID	Text	User IDs are used for marketing and push operations. user_id is the primary key and is required. Configure other user IDs based on your business requirements. All ID types enabled in ID Type Management are available. Only one field per ID type can be stored. You can store either the original or encrypted user ID. Supported encryption methods include MD5, SHA256, and AES. Exception: Taobao OUIDs are already encrypted by Taobao before distribution. Do not re-encrypt them. For 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 mobile phone number as the user ID, the number must be 11 digits without the 86 country code prefix. 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
Number of transactions in the last N days	Numeric types
Other order attributes	Text, numeric, and time	Optional. Configure based on your business requirements.

Note

All field names are customizable.
user_id is the primary key of the table. Each user_id has only one record.
Partitioned tables are not supported.