Quick Audience:Order Summary

Prerequisites

• The order summary table is stored in the Computing Source that you configured. For data format, see Order Summary Table Data Requirements.

• Make sure that all user ID types in your order summary table are in the ID Type List of this space.

• If the user ID field has been encrypted by AES, enter the key in the Organization System Configuration to decrypt it before pushing or using it.

Procedure

1. Choose 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 that you want to import.

   If the current account does not have the read permission on the table you selected, an error message appears, as shown in the following figure. In the MaxCompute project, grant the read permissions on the data table to the Quick Audience account. Click Authorize SQL in the following figure to obtain the authorization statement. After the authorization is complete, click Update to continue the configuration.

4. Enter a data table alias to set an alias for the data table.

   Note

   When you select an order summary table on a page such as the RFM model, the table alias you set here will be used.

5. In the quick field selection area, perform the following configurations. You can also perform these configurations in the field list below:

   • Select the fields to which the Last Consumption Time, Cumulative Consumption Times, and Cumulative Consumption Amount are mapped.

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

   • Select the User ID field. You can select multiple user IDs. And set the ID type and ID encryption method for the selected user ID field, so that you can push data banks and send marketing messages for the ID.

6. In the field list, perform the following configurations:

   • Turn off the Import switch for fields that do not need to be imported. When disabled, the field cannot participate in any application and can be opened later during editing.

   • Set the field alias, field type, and field classification for the fields to be imported. Set the ID type and ID encryption method for the user ID field.

7. Click Complete.