Quick Audience:Order Details

Prerequisites

• The order details table is stored in the Computing Source that you configured. For data format, see .

• Make sure that all user ID types in your order details table are in the ID Type List section.

• 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 Details. The Create Order Details page appears.

3. Select the computing source and data table that you want to import.

   You can select a table or a view for the data table.

   • If you select Table, the system automatically identifies whether the table contains time partitions.

     • If the table contains time partitions, select the Time Partition field and enter the format of the partition value. The following figure shows the supported formats.

       Also, choose how you want to update:

       • Incremental update: saves historical data before each update and saves new data in a new partition. You must select whether to pull historical data for the first time and set the number of days for data refresh. The following figure shows the number of days for data refresh.

       • Full update: The historical data is cleared before each update and is not partitioned.

     • If the table does not contain time partitions, you do not need to select them. Full update will be used.

   • If you select a view, you need to manually select whether to include time partitions. The rest of the configuration methods are the same as those for tables. For more information, see the preceding table configuration.

   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

   The table alias set here will be used when selecting order details on the RFM model and other pages.

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 that are mapped to the order information, such as order number, actual payment amount, order time, order source, and order status.

   • Select the fields that are mapped to the order information, such as the order ID, product name, number of purchases, and actual payment amount.

   • 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 to configure the table structure.