What are the data requirements for importing statistics tables for QuickAudience - Quick Audience

This topic describes the data requirements for importing statistics 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 statistics table records the statistics about operations performed by users. MaxCompute large width representation example: 2634

Field requirements:

Field Type	Field type	Description
The ID of the user who executes the statement.	Text type, numeric type	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.
Time range	Time	The statistical time is optional. You can set a maximum of one. Generally, it is a date and can be used to aggregate statistics on metric fields based on time.
Dimension field	Text type, numeric type	The field that limits the statistical range of the metric field, such as the city, activity name, and time. Optional. You can specify multiple fields.
Label	Numeric types	That is, statistical data fields, such as clicks, exposure, and clicks in the last three days. The required field. You can specify multiple fields.

Note

You can customize the names of all fields.
The table does not have a primary key. The same user ID can contain multiple records. The statistical time and dimension fields must be used as a separate row if any of the conditions are different.
Support partition table.