Data Import Quick Start

Prerequisites

• You have purchased Quick Audience with your Alibaba Cloud account. This account automatically becomes an organization administrator and can use the default workspace as a workspace administrator. You can also create other workspaces and set other users as workspace administrators. For more information, see Organization and Workspace Management.

• You have purchased MaxCompute. You have also purchased AnalyticDB for MySQL 3.0 or Hologres.

• You have prepared a user tag table as described in User Tag Table Requirements and stored it in MaxCompute.

1. Add compute and analysis sources

Data sources in Quick Audience are divided into compute sources and analysis sources:

• Compute source: A compute source stores raw data tables and is used for ID Mapping. The ID Mapping process integrates user IDs and tags within the workspace and assigns a Quick Audience ID (QAID) to each user. Each workspace requires one compute source. MaxCompute is the only supported type.

  To add a MaxCompute compute source, see Compute Source.

• Analysis source: After the compute source processes and integrates user data, the results are synced to the analysis source. User IDs and tags are retrieved from the analysis source when needed. Each workspace requires one analysis source. Supported types are AnalyticDB for MySQL 3.0 (ADB 3.0) and Hologres.

  To add a Hologres or ADB 3.0 analysis source, see Analysis Source Configuration.

2. Set user ID types

• For a list of default user ID types supported by Quick Audience, see ID Types.

• If the ID type in your data table is not supported, you can add a custom ID type. For more information, see Add a Custom ID.

3. Set user properties

Quick Audience builds a user property system from a user tag table. Tag values in the table provide the actual values for user properties. When you configure the table schema, you specify which tags map to user properties. These properties receive their values when the user tag table is imported.

If your user tag table contains tags that can serve as user properties, configure them before importing the table:

• The system provides several preset user properties. For more information, see the User Properties list.

• You can also define custom user properties as needed. For more information, see Custom User Properties.

4. Import the data table

After you configure the compute and analysis sources, you can import data tables from the compute source into Quick Audience. During import, the compute source identifies users, integrates their IDs and tags, and assigns a Quick Audience ID (QAID) to each user. The results are then synced to the analysis source.

Quick Audience supports various data table types. The following example uses a user tag table, which stores user IDs, properties, and other tags. You can also import user behavior tables, statistical tables, order detail tables, and order summary tables. For more information, see Data Import.

Importing a data table involves two main steps: configuring the table schema and creating a scheduling task.

1. Configure the table schema:

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

   2. In the upper-right corner, click New Table Configuration and select User Tag. The New User Tag Configuration page appears.

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

   4. Set the table alias, user identity, user identity type, tag name, tag mapping, tag type, ID type, ID encryption method, tag category, and tag description. Click Done to finish configuring the table schema.

      For more information, see User Tag Import.

      

2. Create a scheduling task:

   1. Go to Workspace > Configuration Management > Data Access Management > Data Import > Scheduling Tasks.

   2. In the upper-right corner, click New Scheduling Task.

   3. In the dialog box that appears, enter a task name and select the alias of the data table that you just configured.

   4. Select a scheduling frequency.

      • Manual Scheduling: The task must be triggered manually after it is created.

      • Daily Scheduling and Hourly Scheduling: Set an execution period. The task runs at the specified time within the period.

      • Trigger-based Scheduling: A scheduling request is sent through an API. This is more complex. For more information, see Create a Trigger-based Scheduling Task.

   5. Click Save to create the task.

      The system begins to import the data table at the scheduled time. You can then use the imported user data for insight analysis.

      For more information, see Scheduling Tasks.