All Products
Search
Document Center

Analyze data by using the U-DOP+DLA solution

Last Updated: Apr 12, 2021

U-DOP is a data opening platform that Umeng+ provides for developers to open their data and integrate data in private domains. You can use U-DOP to analyze data by performing the following operations: subscribe to analysis templates with one click and perform drag-and-drop operations to generate an analysis report. U-DOP provides U-App statistical details. It also provides multi-theme analysis templates and data packages that you can subscribe to. U-DOP tasks help you gain insights into business information from data. After you obtain the U-App statistical details, you can use the data subscription feature of DLA to query and analyze log data in the statistical details.

Activate the U-DOP+DLA solution

  1. Log on to the Umeng+ data bank console. On the Inactive Services page, click Activate Now in the Data Lake Analytics section.

  2. Enter the account and password that are used to subscribe to data, and click Confirm Authorization.

  3. Bind the Umeng account and an Alibaba Cloud account.

    If you do not have an Alibaba Cloud account, you can create an Alibaba Cloud account and bind it to the Umeng account. If you already have an Alibaba Cloud account, you can directly enter the Alibaba Cloud account and password to bind the two accounts.

  4. Note

    After the Umeng account is bound to the Alibaba Cloud account, you can log on to the Alibaba Cloud account by using the Umeng account. You cannot change accounts after they are bound with each other. Exercise caution when you bind accounts.

    After the accounts are bound, the system prompts you to bind an email address. You can select Bind Now or Bind Later based on your business requirements.

  5. On the Cloud Resource Access Authorization page, click Confirm Authorization to authorize U-DOP to use the RAM role to access DLA.

  6. Purchase and pay for the data transfer plan of DLA. Then, you can use DLA to query and ship data.

Query data

After the solution is activated, you can wait for a period of time and check that U-DOP has automatically created a database named integration_biz_ump_databank for your Alibaba Cloud account. Tables that contain various types of data are saved in this database. You can query data on the Execute page of DLA. The following statement queries log details of an app on January 18, 2021.

select  
    umid, install_channel, app_version, app_key, is_new_install, install_datetime, app_channel,
    install_app_version, carrier, os, os_version, resolution, network_access, device_ip,
    country, province, city, session_start, session_end, session_id, session_duration,
    activity_cnt, is_new_upgrd, pre_channel, pre_app_version, is_new_device, imei, idfa,
    mac, android_id, idfv, open_udid, reg_app_name, device_model, std_device_model, device_brand,
    std_device_brand, provider, puid, is_new_reg, reg_channel, sdk_version, umid_from,
    cli_timestamp, svr_timestamp, log_date_time, oaid
      from
        (select  
    umid, install_channel, app_version, app_key, is_new_install, install_datetime, app_channel,
    install_app_version, carrier, os, os_version, resolution, network_access, device_ip,
    country, province, city, session_start, session_end, session_id, session_duration,
    activity_cnt, is_new_upgrd, pre_channel, pre_app_version, is_new_device, imei, idfa,
    mac, android_id, idfv, open_udid, reg_app_name, device_model, std_device_model, device_brand,
    std_device_brand, provider, puid, is_new_reg, reg_channel, sdk_version, umid_from,
    cli_timestamp, svr_timestamp, log_date_time, oaid
        from dwd_ump_log_uapp_launch_di
        where ds = '20210118'
        and app_key = 'xxxxxx'
        and is_new_install = 1
        order by cli_timestamp desc) a
        group by install_channel,install_app_version,umid;