Quick Audience:Order Summary

Prerequisites

Before you begin, make sure that:

• The order summary table is stored in your configured computing source. For data format requirements, see Order Summary Table Data Requirements.

• All user ID types in your order summary table are registered in the ID Type List of this space. Missing ID types prevent audience filtering from working.

• If the user ID field is AES-encrypted, enter the decryption key in the Organization System Configuration before pushing data or sending marketing messages.

Configure the order summary table

1. Go to Workspace > Configuration Management > Data Import > Data Import > Table Structure Configuration.

2. In the upper-right corner, choose Create Table Configuration > Order Summary. The Create Order Summary page appears.

3. Select the computing source and data table to import.

   If the current account does not have read permission on the selected table, an error message appears. Grant read permissions on the data table to the Quick Audience account in your MaxCompute project. Click Authorize SQL to get the authorization statement, then click Update after authorization is complete.

4. Enter a data table alias.

   Note

   The alias appears when you select this order summary table in the RFM model and other pages.

5. In the quick field selection area, map the required fields. The quick field selection area and the field list below it configure the same fields — changes in one are reflected in the other.

   • Map the Last Consumption Time, Cumulative Consumption Times, and Cumulative Consumption Amount fields to the corresponding RFM dimensions (Recency, Frequency, and Monetary).

   • Select order attribute fields. You can select multiple fields or none.

   • Select one or more User ID fields and set the ID type and encryption method for each. Required for pushing data and sending marketing messages.

6. In the field list, review and adjust each field as needed:

   • Turn off the Import switch for fields that do not need to be imported. Disabled fields are excluded from all applications but can be re-enabled during editing.

   • For fields to import, set the field alias, field type, and field classification. For user ID fields, also set the ID type and encryption method.

7. Click Complete.